Description

You will own the ETL and BI processes, managing data integration workflows and environment administration.

This role is on-site.

Responsibilities

• Extract, transform, and integrate data using IBM InfoSphere DataStage Designer and PL/SQL.
• Configure and administer the DataStage environment, including access control, security auditing, and user session management.
• Create logical and physical data models using CA Erwin.
• Execute data migration and perform unit, integration, system, load, and stress testing.

Required Skills

• 2+ years of experience in a data warehousing role.
• IBM InfoSphere and DataStage.
• IBM Cognos.
• CA Erwin for data modeling.
• UML and XML.
• HP Quality Center for testing.
• DB2 and Teradata databases.
• Oracle SQL Loader.
• Master’s degree in Computer Science, Information Technology, Engineering, or a related field.

Preferred Skills

• Experience with OLAP, OLTP, Star Schema, and Snowflake architectures.

Key Skills

Education

Master’s degree