Job Description :
1. Experience in Insurance Finance domain data modelling Build data models, data catalog and metadata management.
2. As data modeler drive the data modeling effort for Cloud migration.
3. Need to interface with business users, Source SMEs and identify all the data elements and the rules required.
4. Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
5. Will be responsible for creating optimized logical and physical data models using best practices to ensure high data quality and reduced redundancy.
6. Responsible for providing the data mapping dictionary from source to target on a timely manner.
7. Determines database structural requirements by analysing client operations, applications, and programming reviewing objectives with clients
8. Analyse data-related system integration challenges and propose appropriate solutions.
9. Need to work with Source SMEs, DW Architect, Cloud SME and ETL developers and facilitate the overall initiative.
Mandatory Skills
1. 10 years of strong experience in DWH design and Data Modeling including on AWSGCP
2. Deep knowledge in RDBMS concepts and SQL
3. Should have worked on Data modeling tools like ERWIN, Visio
4. Work experience on AWSGCP cloud projects
5. Should possess in-depth knowledge of SQL Programming, Performance Tuning of complex queries
6. Work experience in ETL development and design