Datastage Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, ITBMS Inc., is seeking the following. Apply via Dice today!Role - ETL Datastage Developer / Lead / ArchitectLocation - Chicago, IL(Oniste)Note - Looking for Datastage Developer with experience in ETL and OracleJob DescripitionKnowledge of IBM Infosphere DataStage ETL is requiredKnowledge 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 tablesUnderstanding of dimensional data modeling - star schema and snowflake schemaExtensive experience in creating jobs, routines and sequences to create end to end ETL framework in DataStageExperienced in maintaining DataStage code version using Github/Microsoft Azure Knowledge of code migration and production deployment using automated migration processExperienced in performance tuning DataStage ETL processes using appropriate data partitioning algorithms Must have extensive Knowledge of Unix/Linux Commands and shell scriptingKnowledge on scheduling tools like Control-M.Knowledge on Azure DevOps and Agile methodology.Knowledge on Apache KafkaNice to have some knowledge on Service now and ITSM concepts. Understanding of enterprise architecture patterns and best practicesExcellent Oral And Written Communication Skills Are RequiredAnalytical and problem solving skillsA positive goal orientated attitude with a focus on service deliveryMandatory skills:DataStageOracleStored Procedures