Description

You will design and maintain data warehouse architectures and end-to-end ETL processes using Ab Initio.

This role is on-site.

Responsibilities

• Build and optimize high-performance SQL queries, database procedures, and functions for data loading and integration.
• Develop ETL processes to extract, transform, and load data from disparate sources into consumable formats for analytics.
• Implement efficient batch processing for high-volume transaction groups and manage data quality, profiling, and cleansing workflows.
• Design stream systems to discover, integrate, and ingest machine-produced data in real-time.

Required Skills

• 7+ years of experience with Ab Initio.
• Advanced SQL for complex data loading and integration.
• Strong UNIX and shell scripting capabilities.
• Experience with Autosys for automated job execution.
• Deep understanding of ETL concepts, including 3NF, dimensional modeling, fact loads, and surrogate keys.
• Proficiency in data comparison across tables and managing joins.
• Degree in any graduate field.

Preferred Skills

• Experience with AWS cloud environments.
• Python programming skills.

Key Skills

Education

Any Graduate