17 Nov
|
Cognizant
|
Kolkata
Job description:
Strong 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.- Robust 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 (Kolkata)
🏢 Cognizant
📍 Kolkata