Software Developer (Bengaluru)

Software Developer (Bengaluru)

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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: software developer (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: software developer (bengaluru) / bengaluru