ETL Datastage Developer Job at Purple Drive, Chicago, IL

ajJ4YzBxc0F2SzBYeFh0SjdVbVloYnky
  • Purple Drive
  • Chicago, IL

Job Description

Overview:

Knowledge of IBM Infosphere DataStage ETL is required

Knowledge on building and supporting ETL Code using Infosphere DataStage to load enterprise data warehouses using relational database (Oracle, DB2, Sybase) applying transformations and business rules as defined in requirements is a MUST.

Knowledge of oracle SQL and PL/SQL (cursors, triggers, packages, stored procedures)

Knowledge in integrating data from multiple sources- MQ, Solace, XML, Excel files, unstructured data and loading them into staging/warehouse tables

Understanding of dimensional data modeling - star schema and snowflake schema

Extensive experience in creating jobs, routines and sequences to create end to end ETL framework in DataStage

Experienced in maintaining DataStage code version using Github/Microsoft Azure Knowledge of code migration and production deployment using automated migration process

Experienced in performance tuning DataStage ETL processes using appropriate data partitioning algorithms

Must have extensive Knowledge of Unix/Linux Commands and shell scripting

Knowledge on scheduling tools like Control-M.

Knowledge on Azure DevOps and Agile methodology.

Knowledge on Apache Kafka

Nice to have some knowledge on Service now and ITSM concepts. Understanding of enterprise architecture patterns and best practices

Excellent oral and written communication skills are required

Analytical and problem solving skills

A positive goal orientated attitude with a focus on service delivery

Knowledge of IBM Infosphere DataStage ETL is required

Knowledge on building and supporting ETL Code using Infosphere DataStage to load enterprise data warehouses using relational database (Oracle, DB2, Sybase)

Knowledge of oracle SQL and PL/SQL (cursors, triggers, packages, stored procedures)

Must have extensive Knowledge of Unix/Linux Commands and shell scripting

Job Tags

Similar Jobs

Pyramid Global Hospitality

Front Desk Supervisor - Marriott Hotel Job at Pyramid Global Hospitality

 ...site wellness programs, local discounts, and employee rates on hotel stays. In addition, Pyramid Global Hospitality is committed to...  ...is committed to creating exceptional guest experiences. The Marriott Phoenix Chandler, located in Chandler- a Southeast suburb of Phoenix... 

O'Hara Corporation

Seasonal Dockmaster Job at O'Hara Corporation

Journeys End Marina has an opening for a Dockmaster for the upcoming 2026 season. The position will run from April-October and is responsible for managing dock crew, organizing schedules, tracking reservations and general customer service.Strong communication and computer... 

Porthouston

Director State Government Relations Job at Porthouston

 ...approximately 15% travel to Houston, Texas to support business needs and in-person collaboration.**Position Summary:**The Director of State Government Relations serves as Port Houstons senior strategist and principal representative for state-level legislative and executive... 

CGI Technologies and Solutions, Inc.

Passport Data Clerk III Job at CGI Technologies and Solutions, Inc.

 ...limited to, the following: Prepare and mail envelopes with correct passport and corresponding supporting documents. Box and archive files for storage purposes Interface with Passport applicants at Agency/Center information and will-call counters: o At the... 

Lib's Grill

Catering Delivery Driver Job at Lib's Grill

 ...Who We Are At Libs Catering, we believe in \ Good People Serving Good Food to Other Good People .\ Our mission is to create personalized...  ...we call the \Cherries on Cakes.\ The Role As a Delivery Driver, you are a vital brand representative. You arent just moving...