ETL DataStage Developer

7 days ago

Chicago, IL, United States HCL Global Systems Full time

+8 years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred)
• 5+ years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects
• experience in software development life cycle
• experience in DW/BI related technologies and tools - MUST
• experience in Project life cycle activities on DW/BI development and maintenance projects
• experience in Design and Architecture review
• Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs-Knowledge of data loading techniques using Datastage
• Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages etc
• Using Datastage Director for running and monitoring the jobs.
• Created Datastage sequences to run the batch jobs.
• Knowledge Best Practices in Datastage, Performance improvements, implementing CDC, UDFs

  • ETL Datastage Developer

    2 weeks ago

    Chicago, IL, United States Purple Drive Full time

    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,...

  • DataStage Developer

    5 days ago

    Chicago, IL, United States Syntricate Technologies Full time

    Required Skills: Datastage lead and senior developers should have very good experience in Datastage, PL/SQL and Unix Demostrable experience as a Datastage developer Experience in ETL tools such as Informatica, Oracle ETL Knowledge of data modeling, database design and the warehousing ecosystem. Testing and troubleshooting problems in ETL system...

  • DataStage Developer

    7 days ago

    Chicago, IL, United States Syntricate Technologies Full time

    Required Skills: Datastage lead and senior developers should have very good experience in Datastage, PL/SQL and Unix Demostrable experience as a Datastage developer Experience in ETL tools such as Informatica, Oracle ETL Knowledge of data modeling, database design and the warehousing ecosystem. Testing and troubleshooting problems in ETL system...

  • DataStage Developer

    20 hours ago

    Chicago, IL, United States Syntricate Technologies Full time

    Required Skills: Datastage lead and senior developers should have very good experience in Datastage, PL/SQL and Unix Demostrable experience as a Datastage developer Experience in ETL tools such as Informatica, Oracle ETL Knowledge of data modeling, database design and the warehousing ecosystem. Testing and troubleshooting problems in ETL system...

  • Lead DataStage Developer

    5 days ago

    Chicago, IL, United States Syntricate Technologies Full time

    Only local to Illinois Job Title : Lead DataStage Developer Location: Chicago, IL Duration : Contract Job Description: DataStage lead and senior developers should have very good experience in DataStage, PL/SQL and Unix Demonstrable experience as a DataStage developer Experience in ETL tools such as Informatica, Oracle ETL Knowledge of...

  • DataStage Developer/ Admin

    1 week ago

    Chicago, IL, United States Syntricate Technologies Full time

    Required Skills: 10 years of experience in DataStage administration and Development Ability to manage new project/assignment and should manage effectively. Lead the design and implementation of data warehousing solutions to support business intelligence and analytics needs. Oversee the development and maintenance of ETL processes to ensure efficient...

  • DataStage Developer/ Admin

    5 days ago

    Chicago, IL, United States Syntricate Technologies Full time

    Required Skills: 10 years of experience in DataStage administration and Development Ability to manage new project/assignment and should manage effectively. Lead the design and implementation of data warehousing solutions to support business intelligence and analytics needs. Oversee the development and maintenance of ETL processes to ensure efficient...

  • DataStage Developer/ Admin

    1 week ago

    Chicago, IL, United States Syntricate Technologies Full time

    Required Skills: 10 years of experience in DataStage administration and Development Ability to manage new project/assignment and should manage effectively. Lead the design and implementation of data warehousing solutions to support business intelligence and analytics needs. Oversee the development and maintenance of ETL processes to ensure efficient...

  • ETL Developer

    1 week ago

    Chicago, IL, United States Apex Informatics Full time

    Position - ETL DEVELOPER Please send Full Legal Name, LinkedIn, Location, Contact Details, C2C rate, and work authorization status with each submittal. Client: Northern Trust Location: Hybrid Chicago 3x a week onsite Interview Mode: Virtual Type: Long term contract (potential CTH) Work authorization: Cannot work with OPT or CPT • Application Support...

  • ETL Developer

    13 hours ago

    Chicago, IL, United States Apex Informatics Full time

    Position - ETL DEVELOPER Please send Full Legal Name, LinkedIn, Location, Contact Details, C2C rate, and work authorization status with each submittal. Client: Northern Trust Location: Hybrid Chicago 3x a week onsite Interview Mode: Virtual Type: Long term contract (potential CTH) Work authorization: Cannot work with OPT or CPT • Application Support...