Job Description :
Job Description
Responsibilities:
Expert in data governance, multidimensional data modeling, such as star schemas, snowflakes, normalized and de-normalized models, handling slow-changing dimensions/attributes
Understand and translate business needs into data models supporting long-term solutions.
Work with the Application Development teams to implement data strategies, build dataflows and develop conceptual data models
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
Optimize and update logical and physical data models to support new and existing projects.
Qualifications:
Design logical and physical models across multiple Data Warehouses
Strong experience in SSIS.
Organize working sessions with business operations team to understand sources of data and expected output.
1-2 years of experience in database technologies, data design and performance optimization for large OLAP & Data Warehouse solutions.
Expert in relational and dimensional structures for large (multi-terabyte) operational, analytical, warehouse and BI systems
Skilled in data profiling, business domain modeling, logical data modeling, physical relational data modeling and design
Strong skills in Entity Relationship Modeling (ERWin modeling software preferred)
Excellent written and verbal communication skills with strong relationship building skills
Ability to work in a large, complex business and technical environment
Experience with Insurance domain preferable
Experience with Erwin or similar data modeling tool
Strong Oracle/SQL expertise

Client : cognizant