Description

You will design and maintain data models for relational databases, cloud environments, and AI/ML use cases. You will own the ETL processes that transform disparate source data into data warehouses and marts.

Responsibilities

• Design application-supporting data models using relational modeling, medallion architecture, and cloud methodologies.
• Develop and maintain complex PL/SQL, SQL, and data marts based on business requirements.
• Execute ETL processes to transform source data into target stores using Oracle Database 19c and Oracle Data Integrator.
• Create and maintain analytical models to ensure data literacy and usability for business users.
• Provide knowledge transfer to ITSB team members and stakeholders, ensuring they can take ownership of created models.

Required Skills

• At least five (5) years of experience in Pension, Health Insurance, Customer Service, or Finance domains.
• At least five (5) years of experience performing ETL tasks to integrate disparate source data into data warehouses or marts.
• At least three (3) years of experience with data integration projects using Oracle Database 19c and Oracle Data Integrator or similar ETL tools.
• Strong proficiency in interpreting requirements and developing complex PL/SQL and SQL.
• Experience with Erwin Data Modeler for designing and maintaining data models.
• Proficiency in Power BI for modeling data for visualization and analytics.

Key Skills

Education

Any Gradute