Architect - Data Modeling (10-14 yrs)

Job Description :

- 10+ years of experience in Data space.

- Decent SQL knowledge

- Able to suggest modeling approaches for a given problem.

- Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server)

- Real-time experience working in OLAP & OLTP database models (Dimensional models).

- Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling. Also, on any ETL tool, Data

- Use the Data Modelling tool to create appropriate data models

- Create and maintain the Source to Target Data Mapping document that includes documentation of all entities, attributes

- Contribute to building data warehouse & data marts (on Cloud) while performing data profiling and quality analysis.

- Use version control to maintain versions of data models.

- Collaborate with Data Engineers to design and develop data extraction and integration code modules.

- Partner with the data engineers & testing practitioners to strategize ingestion logic, consumption patterns & testing.

- Ideate to design & develop the next-gen data platform by collaborating with cross-functional stakeholders.

- Work with the client to define, establish and implement the right modelling approach as per the requirement

- Help define the standards and best practices

- Involve in monitoring the project progress to keep the leadership teams informed on the milestones, impediments, etc.

- Coach team members, and review code artifacts.

- Contribute to proposals and RFPs