Description

Design and implement data integration workflows to move data from various sources into SQL Server-based data warehouses.

This role is on-site.

Responsibilities

• Design and manage IBM DataStage jobs, stages, and sequences using Designer, Director, and Administrator.
• Develop and optimize SQL queries for efficient data extraction and loading within SQL Server.
• Implement data models using star and snowflake schemas to support reporting and analytics.
• Tune ETL processes and transformation logic to minimize processing time and improve performance.

Required Skills

• 4+ years of experience in ETL development.
• Expertise in IBM DataStage (Designer, Director, Administrator).
• Proficiency in Microsoft SQL Server and writing complex SQL queries.
• Strong understanding of ETL concepts and data integration.
• Experience with data modeling techniques (star schema, snowflake schema).
• Knowledge of AWS.

Preferred Skills

• Bachelor's degree in a relevant technical field.

Key Skills

Education

Bachelor's degree