Description

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

Responsibilities

• Design and develop advanced Ab Initio graphs and ConductIT plans.
• 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.
• Develop and optimize ETL processes to handle large data volumes efficiently.

Required Skills

• 5+ years of experience in ETL development and data warehousing.
• Strong hands-on experience with Ab Initio tools, including GDE, CoOp, PSETS, PDL Programming, ConductIT, Meta Programming, and Generic Graphs.
• Experience implementing Ab Initio parallel processing techniques.
• Strong knowledge of relational databases such as 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.

Key Skills

Education

Bachelor's degree