Description

You will design, develop, and maintain complex ETL workflows using Ab Initio.

This role is on-site.

Responsibilities

• Design and develop advanced Ab Initio graphs, ConductIT plans, and meta programming components.
• Develop and maintain complex Linux wrapper scripts to support ETL workflows.
• Execute SQL queries against relational databases including Greenplum, Oracle, DB2, or PostgreSQL.
• Monitor daily ETL loads, troubleshoot failures, and implement resolutions.
• Optimize ETL processes to handle large data volumes efficiently using parallel processing techniques.

Required Skills

• 5+ years of experience in ETL development and data warehousing.
• Strong hands-on experience with Ab Initio tools (GDE, CoOp, PSETS, PDL, ConductIT, Meta Programming, Generic Graphs).
• Strong knowledge of relational databases (Oracle, DB2, PostgreSQL, or Greenplum).
• Proficiency in UNIX/Linux shell scripting.
• Experience with version control systems such as EME and Git.
• Strong understanding of data warehousing concepts, data modeling, and advanced SQL.
• Experience working in Agile development environments.

Preferred Skills

• Bachelor's degree in Computer Science or related field.
• Experience with AWS data services.

Key Skills

Education

Bachelor's degree