About the role
Experience: 4 to 7 Years
Location: Banglore
JD:
The Right Candidate
- Intermediate level (4 to 6 years) data modeling experience
- Knowledge of BFSI domain and Wealth Management business
- Critical thinking ability, Strong problem-solving capacity
- Good written and verbal communication skills.
- Experience in working with larger agile teams, fleet and squads
Required Experience:
Primary skills:
- Database design and Data Modeling experience
- Strong with SQL with hands-on using Data Modeling tools like Power designer or Erwin
- Experience in any one of the Database like Teradata, SQL Server, Hadoop Hive, Snowflake etc
- Understand and translate business needs into data models supporting strategic solutions.
- Create and maintain conceptual, logical and physical data models along with corresponding metadata.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Recommend opportunities for reuse of data models in new environments.
- Perform reverse engineering of physical data models from disparate databases and SQL scripts.
- Evaluate data models and physical databases for variances and discrepancies.
- Validate business data objects for accuracy and completeness.
- Analyze data-related system integration challenges and propose appropriate solutions.
- Develop data models according to company standards.
- Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
- Review modifications to existing software to improve efficiency and performance.
- Examine new application design and recommend corrections as required
Secondary skills:
- Good to have – Python & Power BI hands-on experience.
- Unix Scripting