3–6 yrsGurugramOn-siteDirect career pageEst. 14–24 LPA
Posted 12h ago
Reach people at Fidelity International
People at this company you can reach
Log in to see who works here
Create a free account or log in to see the people at Fidelity International you could write to:
- Recruiters & HR
- People in this function
- Work addresses
Your match
Against your primary resume
Log in to see your match score
Create a free account or log in to unlock your CV match score across:
- Role fit
- Experience
- Industry relevance
Protocol Intelligence
How competitive this role is
Competition
Background fit
Strictness
Log in to see why each signal reads the way it does.
Job description
Structured overview of role & requirements
About This Role
- Design and maintain logical/physical data models and Snowflake schemas for client servicing, reporting, sales and investment operations data.
- Support migration of the legacy Oracle Client Reporting Database to Snowflake by defining source-to-target mappings, SQL transformations, reconciliation checks and validation requirements.
- Specify and document certified data products, including schemas, data dictionaries, lineage and consumer contracts; help enforce data standards, PII classification and access controls.
Minimum Requirements
- Work Experience Required: 3–6 years in data modeling, data architecture or senior data engineering in an enterprise data warehouse environment.
- Strong practical Snowflake knowledge and advanced SQL skills; experience with a relational database such as Oracle, PostgreSQL or SQL Server.
- Understanding of dimensional and relational data warehousing methods, plus experience creating source-to-target mappings and participating in large-scale database migrations.
- Familiarity with data modeling tools and Git.
Ideal Candidate Profile
- Has hands-on enterprise data warehouse experience and can translate business data definitions into production-ready schemas, mappings and SQL transformations.
- Best suited to a migration-focused environment, with experience validating data accuracy and documenting lineage, rules and data product interfaces.
- Can work across architecture, engineering and downstream reporting consumers while developing under senior architectural mentorship.