Description

Design and implement ETL processes for large datasets across Oracle, SQL Server, and flat files, translating business requirements into technical data lake and warehouse solutions.

This role is on-site.

Responsibilities

• Design development schemas for data feeds, data lakes, and warehouses using dimensional modeling (Star Schema, Fact, and Dimension tables).
• Develop and implement Informatica ETL jobs for data extraction, parsing, and transformation.
• Test, debug, and troubleshoot ETL processes, Oracle objects, and data pipelines.
• Schedule and monitor Informatica jobs across development, testing, and production environments.
• Support data analytics and visualization initiatives.

Required Skills

• Informatica ETL development and implementation.
• Dimensional data modeling, including Star Schema, Fact, and Dimension tables.
• Physical and logical data modeling.
• Experience with heterogeneous source systems including Oracle, SQL Server, and Flat Files.
• Data extraction and parsing of large, disparate datasets.
• Data analytics and visualization support.
• Bachelor's in Computer Science or equivalent.

Key Skills

Education

Bachelor's in Computer Science or Equivalent APP