Description

You will design and develop ETL processes and data integration workflows within a data warehouse environment.

Responsibilities

• Design and develop complex ETL processes using Ab Initio.
• Implement data integration solutions on Hadoop platforms.
• Write and optimize SQL queries for high performance.
• Manage data movement and integration across OLTP and OLAP data models.

Required Skills

• 10+ years of IT experience, specifically within Data Integration and Data Warehousing.
• 5+ years of dedicated ETL design and development experience using Ab Initio.
• 1-2 years of data integration project experience on Hadoop, preferably Cloudera.
• Working knowledge of HDFS, Hive, and Impala.
• Strong proficiency in SQL and query optimization.
• Solid understanding of OLTP and OLAP data models and warehouse fundamentals.
• Any Graduate degree.

Preferred Skills

• Experience with Ab Initio Change Data Capture (CDC) in an ETL setting.
• Working knowledge of AWS services.

Key Skills

Education

Any Graduate