Description

Lead the migration of on-premise data assets to cloud data warehouses. Own the design and implementation of ETL and ELT pipelines using IBM DataStage, Informatica, and modern cloud tools.

Responsibilities

• Analyze and build ETL data assets using IBM DataStage and Informatica with on-premise databases like Netezza.
• Migrate data assets to cloud platforms (AWS S3, Snowflake) and build ELT transformations using DBT and Python.
• Create and manage data pipelines supporting CI/CD processes.
• Collaborate with project and business analysts to define technical requirements, including logical and physical data modeling.
• Develop, test, and debug data applications using IBM InfoSphere Data Stage and Quality Stage on a Linux Grid environment.

Required Skills

• 10+ years of experience in data engineering and ETL development.
• Strong proficiency with IBM InfoSphere DataStage, Quality Stage, and Informatica.
• Experience with cloud data warehouses, specifically Snowflake and AWS S3.
• Hands-on experience with ELT transformations using DBT and Python.
• Knowledge of CI/CD pipeline management and Linux Grid environments.
• Ability to perform logical and physical data modeling.
• Familiarity with scheduling tools and control mechanisms.

Preferred Skills

• Experience with Netezza and other on-premise database systems.
• Background in migrating legacy systems to cloud-native architectures.

Key Skills

Education

Any Gradute