Cigniti - Chicago, IL
posted 3 months ago
The ETL DataStage Developer position is a long-term, onsite role based in Chicago, IL. The primary responsibility of this role is to implement an ETL DataStage framework that facilitates incremental data loading while ensuring robust error handling and a basic audit framework. The developer will be expected to read and understand existing Oracle stored procedures (SPs) for reverse engineering purposes, which is crucial for maintaining and enhancing the data processing workflows. In this role, the developer will perform Oracle Data Definition Language (DDL) and Data Manipulation Language (DML) activities, handling simple to medium complexity queries. The position requires proficiency in using various DataStage components such as Change Data Capture (CDC) stages, join stages, lookup stages, and Oracle source and target stage connectors to develop effective ETL jobs. A significant part of the job involves creating DataStage jobs, including both sequencers and parallel jobs, to facilitate the copying of over 100 tables from production to non-production Oracle databases. The developer will also be responsible for independently developing and testing ETL jobs, ensuring that they align with the requirements outlined in the project documentation. The ideal candidate will possess a strong skill set in DataStage, Oracle, and PL/SQL, with the ability to reverse engineer when necessary. Familiarity with Control-M Scheduler is considered a beneficial addition to the skill set, although it is not mandatory.