Data Modeler

Coforge is hiring Data Modeler for Greater Noida / Pune locations

Experience Range- 5- 10yrs

Notice Period- Immediate to 30 days only

The Data Modeler will be responsible for translating business requirements into conceptual, logical / canonical and physical data models. The Data Modeler will model ODS, Staging Area and Data Warehouse models for on-prem and cloud-base tech stack.

Responsibilities include :

Facilitate requirements elicitation and modeling sessions including use of interview, document analysis, workshops etc.

Collaborate with the architect and technical lead on the solution design

Model BI Solutions including operational data stores, Staging Areas and Normalized / Dimensional Data Warehouse

Participate in data definition and data management reviews

Define and design data integration interfaces

Work with the database administrator to create physical database designs

Provide guidance and partner with project management, development and QA teams by applying knowledge of database design

Assist with the development and enforcement of data modeling standards

Establish and maintain processes to support and grow data modeling practices

REQUIRED SKILLS

3+ years of experience using data modeling tools such as Erwin or ER Studio, or Rational or other similar modeling tools

5+ years of SQL experience

Strong knowledge of Relational and Dimensional data modeling concepts

An in-depth understanding of the Data Life Cycle, data modeling concept and principles

Must have an in-depth experience of at least one major cloud based DB Tech stack e.g. Postgres, Redshift, Azure SQL Server and so on.

Experience with storing metadata / data dictionaries within formal modeling tool

Strong Experience working on large volume databases

Experience working in complex projects with multi-tier architecture

Proficient in Data-Management concepts, practices and procedures

Working experience with at least one data integration technologies such as Glue, ADF, Python, Informatica, SSIS and so on.

Strong Business Acumen highly preferable

Demonstrated ability to influence critical business outcomes in a matrix based, global environment

Excellent communication skills in both formal and informal settings

Familiarity with Insurance domain preferred