Description

Design and implement ETL processes for large, disparate datasets across Oracle, SQL Server, and flat files. Build high-bandwidth services and data pipelines to identify data problems early. Translate business requirements into technical implementations for data lakes and warehouses.

Responsibilities

• Design development schemas for data feeds, ETL feeds, Data Lakes, and Data Warehouses using dimensional modeling (Star Schema, Fact, and Dimension tables).
• Develop and implement Informatica ETL jobs for data extraction, parsing, and massaging.
• Test, debug, and troubleshoot ETL and 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.
• ETL job scheduling and monitoring in production environments.
• Bachelor's in Computer Science or equivalent.

Key Skills

Education

Bachelor's in Computer Science or Equivalent APP