15 Nov
|
Cognizant
|
Bengaluru
15 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.
- Strong 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