Description

You will build and maintain ETL solutions using IBM InfoSphere DataStage to support the Dealer Datamart.

This role is on-site.

Responsibilities

• Develop and support DataStage ETL jobs for simplified Dealer Datamart construction.
• Load complex data from multiple regions and applications into a unified datamart.
• Collaborate with Product Owners and managers to deliver high-value ETL features using Agile.
• Migrate mainframe ETL processes to DataStage and create new datamart components.
• Analyze datamart models to identify Extract, Transform, and Load requirements.

Required Skills

• 7+ years of ETL development and integration experience.
• Expertise with IBM InfoSphere DataStage v11.5 or v11.7.
• Strong SQL and database experience with complex queries.
• Proficiency in Linux/Unix Shell scripting and file management.
• Experience with AutoSys job scheduling.
• Bachelor's degree in Information Technology or a related discipline.

Preferred Skills

• Experience with Oracle, DB2/SQL, FTP, and Connect Direct.
• Knowledge of mainframe tools including COBOL, JCL, and CA7.
• Experience with Java and API development.

Key Skills

Education

Any Graduate