16 Nov
|
Cognizant
|
Bengaluru
16 Nov
Cognizant
Bengaluru
Job highlights
Expert in data warehousing concepts and dimensional modeling with advanced SQL and erwin Data Modeler skills
Design and review data models, source-to-target mappings, and support validation and issue resolution with engineering teams
Job description
Robust knowledge of data warehousing: dimensional modeling, facts and dimensions, slowly changing dimensions (SCD types), grain, normalization, denormalization and historical data handling.
Hands-on experience designing conceptual, logical and physical models, including source-aligned and curated data product models, in line with enterprise architecture standards.
Expert-level erwin Data Modeler proficiency, including logical-to-physical alignment, model comparison, versioning and change impact analysis. ER/Studio experience is an advantage.
Advanced SQL: joins, CTEs, window functions, profiling,
mapping validation and reconciliation queries.
Experience creating and reviewing source-to-target mappings (STTMs) and data dictionaries, covering transformation rules, keys, relationships, data types and business definitions.
Solid understanding of metadata, lineage, data quality, master/reference data, naming conventions and governance processes.
Experience with relational databases such as Oracle, SQL Server or MySQL. Exposure to AWS Redshift, RDS/Aurora, S3, Glue and Athena is preferred.
Ability to support metric and milestone configuration validation, query associations and documentation, and resolve design issues with engineering and testing teams
📌 Software Developer Bengaluru
🏢 Cognizant
📍 Bengaluru