Description
You will design and implement data models across various DBMS platforms to support data warehouse, BI, and big data applications.
Responsibilities
- Design data models for relational, dimensional, and hybrid patterns.
- Create and extend data models across Oracle, SQL Server, DB2, Snowflake, Teradata, and NoSQL platforms.
- Identify and resolve data model performance issues to optimize database functionality.
- Document and communicate data model designs and standards to ensure organizational interoperability.
- Explain complex data integration, extraction, transformation, and load (ETL) processes.
Required Skills
- 5+ years of experience in data modeling and database management.
- Proficiency with modeling tools such as Erwin, ER Studio, Toad DM, or Power Designer.
- Expertise in generating complex SQL queries.
- Fluency in Python, SQL, and Unix.
- Experience with version control and metadata management using Git or Liquibase.
- Hands-on experience with Snowflake, Teradata, DB2, and NoSQL.
- Ability to work within Agile environments using Lean, Kanban, or Scrum.
- Any Graduate degree.
Preferred Skills
- Experience in the Insurance and Financial domains.