Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

ETL Datastage Developer

Purple Drive

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
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the ETL Datastage Developer in Chicago, IL vacancy
  • The developer’s typical duties includes but not limited to designing and building data warehouses, designing ETL processes and procedures using tools such as IBM InfoSphere, performing...  ...hands‑on experience in using IBM DataStage Understand DataStage clustering architecture... 
    Suggested

    OPULENTSOFT LLC

    Chicago, IL
    4 days ago
  •  ...years of IT experience, with a focus on design and building data warehouses, and hands-on experience with IBM DataStage and SQL. Duties include developing ETL processes, performing data analysis, and collaborating with developers to ensure data quality. Strong communication... 
    Suggested

    OPULENTSOFT LLC

    Chicago, IL
    3 days ago
  •  ...enterprise data modernization initiative. This role involves designing, developing, and optimizing cloud-based data solutions to support decision-...  ...transformation. Candidates should have strong experience in ETL/ELT pipeline development and be comfortable in Agile... 
    Suggested

    Intellias Inc

    Chicago, IL
    3 days ago
  • ETL Developer (Azure Data Factory & MYSQL)- airline industry Location: Chicago,IL Duration: 17Months + Extension Hourly Rate: Depending on Experience (DOE) Work Authorization: Role: ETL Developer (Azure Data Factory & MYSQL)- airline industry Location: Chicago IL Mode:... 
    Suggested
    Hourly pay
    Permanent employment
    Contract work
    Local area

    Cloud Hybrid Technologies, LLC

    Chicago, IL
    20 days ago
  • A technology firm in Chicago is seeking an experienced ETL Developer with a strong background in Azure Data Factory and MySQL. The position requires 6+ years of experience in both Azure Data Factory and MySQL, focusing on developing ETL processes for the airline industry... 
    Suggested
    Hourly pay
    Contract work

    Blockchain Technologies Corp.

    Chicago, IL
    4 days ago
  • $120k - $170k

     ...Pepper Locke LLP is seeking a Senior Data Engineer to analyze and integrate data into finance applications. The role includes developing ETL processes, maintaining a centralized data lake, and crafting Power BI dashboards for data analysis. Qualified candidates will have... 

    Troutman Pepper Locke LLP

    Chicago, IL
    3 days ago
  • $160.56k - $178.5k

    ESRhealthcare and EXEC STAFF RECRUITERS are looking for an ETL/Data Architect to work in Mettawa, IL. The role involves defining development standards for ETL/Data Warehousing and leading full lifecycle projects. Candidates should have 4 years of experience as a data architect... 

    ESRhealthcare and EXEC STAFF RECRUITERS

    Chicago, IL
    3 days ago
  •  ...or certifications: Experience as a lead for decent sized ETL team Experience with Apache Iceberg Observability tools...  ...data set in an enterprise setup. Job Summary: ~ An ETL developer needs to design build test and maintain systems that extract... 
    Odd job
    Work at office
    Flexible hours

    3B Staffing LLC

    Chicago, IL
    4 days ago
  •  ...Hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including GDE,...  ...implementation of DW BI projects, especially in data warehouse and mart developments Knowledge and experience with full SDLC lifecycle.... 

    United IT Solutions

    Chicago, IL
    3 days ago
  •  ...ETL Developer Job Location: Chicago, IL (Remote Project) Job Type: 12+ Months Contract Description: ETL Developer with below skills: Must have: Spark, Java Nice to have: Scala, Docker Additional Details: ~ Candidate must be in EST or CST Only.... 
    Contract work
    Remote work

    InterSources

    Chicago, IL
    2 days ago
  •  ...else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today. Responsibilities: The Sr. ETL Developer will support Barrow Wise's Chicago Public Schools (CPS) project and perform the following duties: Maintain and manage the... 
    Remote work

    Barrow Wise Consulting, LLC

    Chicago, IL
    1 day ago
  •  ...Summary TITLE - ETL / AWS Software Engineer (F2F Interview) Job Description Client...  ...Cloud. This position requires a hands-on developer who can build new ETL solutions if...  ...Leverage development experience with DataStage or Informatica, Korn Shell, Python, and Perl... 

    Cloud Analytics Technologies LLC

    Chicago, IL
    3 days ago
  • A growing IT system integrator is urgently seeking a Datastage Developer for a 12-month contract in Chicago, IL. The ideal candidate will have strong expertise in Datastage 11.5 and SQL Server 2010, along with Unix scripting skills. This position requires candidates to... 
    Contract work
    Local area

    USM

    Chicago, IL
    2 days ago
  • A consulting firm is seeking a Sr. ETL Developer to maintain and enhance a Chicago Public Schools project. The ideal candidate will have over 10 years of experience in Data Warehousing and ETL tools (e.g., SSIS). Responsibilities include managing the Data Warehouse, creating... 
    Remote job

    EmergencyMD

    Chicago, IL
    5 days ago
  • Locals or Nearby Only Urgent Need Datastage Developer Contract USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA. We offer world... 
    Contract work
    Local area
    Immediate start
    Worldwide

    USM

    Chicago, IL
    5 days ago
  •  ...firm's business objectives. Job responsibilities Designs, develops, and troubleshoots creative software solutions, thinking beyond...  ...stacks (React, Angular, etc.) Builds and optimizes data models, ETL/ELT processes, and integration frameworks for large-scale... 

    J.P. Morgan

    Chicago, IL
    5 days ago
  •  ...Expertise in performance tuning of SQL queries, PL/SQL scripts, and ETL workflows ~2-3 years of Shell/Python Scripting experience...  ...languages Day-to-Day Responsibilities Design and develop Oracle PL/SQL procedures, functions, triggers, and packages... 
    Immediate start

    Artech

    Chicago, IL
    3 days ago
  • $120k - $140k

     ...in .NET (C#, ASP.NET, .NET Core, Web API), Angular, SQL Server, ETL (SSIS/Azure Data Factory), and CI/CD pipelines for full stack application development. Roles & Responsibilities • Design, develop, test, deliver, and debug software applications aligned with business... 

    Tata Consultancy Services

    Chicago, IL
    2 days ago
  • A leading IT staffing firm is seeking a skilled professional for software and database programming. The role involves the maintenance and user support of software tools, development of maintainable solutions, and collaboration with cross-functional teams. The ideal candidate...

    Collabera

    Chicago, IL
    1 day ago
  • $120k - $130k

     ...Assist with development, maintenance and utilization of scripts (e.g., Python, Ruby, etc.) to support custom extract, transform load (ETL) tools with a security focus for data flow. Attend regular technical project and implementation meetings, and serve as the... 
    Local area

    The Aspen Group

    Chicago, IL
    5 days ago
  •  ...About the job Full Stack Java Developer Role Description: Title: Full Stack Java Developer Location: Chicago,...  ...(Amazon Aurora MySQL) 2+ years' experience using Talend as an ETL tool. oTalend is an ETL tool that provides solutions for data... 
    Relocation

    The Hive Careers Ltd

    Chicago, IL
    2 days ago
  • Cambay is seeking an experienced ODI Developer in Chicago, IL. The role requires 6+ years of experience in large enterprise Data Warehouse/ETL environments. Responsibilities include developing ETL designs and maintaining Oracle Data Integrator implementations. The ideal... 
    Full time

    Cambay

    Chicago, IL
    3 days ago
  •  ...Senior Salesforce Developer Location: Chicago, IL (Hybrid) Employment Type: Full-Time Overview A financial services...  ..., and third-party applications. Support middleware and ETL processes used for data synchronization and migration. DevOps... 
    Full time

    Artius Solutions

    Chicago, IL
    3 days ago
  •  ...as a technical lead or project lead for medium-to-large integration efforts. Provide guidance and mentorship to less-experienced developers. • Production Support: Respond to system performance events or failures with urgency. Implement "preventive" code improvements... 
    Temporary work

    AllSTEM Connections

    Chicago, IL
    1 day ago
  • Job Title Interview: Video Visa: All apart from H1B and CPT This is Onsite from Day-1. Description: Job Description: 8+ years of experience Strong hands on experience in Talend (Studio, TMC) and SQL (MS SQL Server & Oracle) Must be proficient on SQL concepts and ...
    H1b

    ShiftCode Analytics

    Chicago, IL
    1 day ago
  • $91.53k - $156.5k

     ...role will involve collaborating with cross-functional teams to develop and deploy end-to-end solutions that improve data availability,...  ...pipelines to support data extraction, transformation, and loading (ETL) processes using technologies such as Databricks, Snowflake, and... 
    Full time
    Contract work
    Part time
    Internship
    Local area

    Paycor

    Chicago, IL
    4 days ago
  • $103.45k - $129.36k

     ...for you. The Wounded Warrior Project (WWP) Senior Salesforce Developer designs, develops, and implements scalable Salesforce solutions,...  ...quality management using tools such as Data Loader or similar ETL solutions. Three years of experience working with software... 
    Temporary work
    Work at office
    Work from home
    Flexible hours
    Shift work

    Wounded Warrior Project

    Chicago, IL
    3 days ago
  • $90.4k - $150.7k

     ...Senior Salesforce Developer The Senior Salesforce Developer with over five years of extensive hands-on experience will deliver scalable...  ...maintaining REST and SOAP APIs, middleware-based integrations, ETL processes, and AppExchange solutions to connect Salesforce with... 
    Work at office

    FHLBank Chicago

    Chicago, IL
    4 days ago
  •  ...term contract Key Responsibilities: Design, develop, and implement data platform solutions using Azure Data Factory...  ...Storage, and Snowflake. Review and analyse existing on-premises ETL processes developed in SSIS and T-SQL. Perform data... 
    Long term contract
    Remote work

    E-Solutions

    Chicago, IL
    3 days ago
  • $133k - $166k

     ...working with emerging AI and automation technologies • Solid understanding of application and data integrations, including APIs, ETL, and data pipelines • Hands on experience with Microsoft SQL, Linux environments, REST APIs, and PowerShell scripting • Exceptional... 
    Worldwide
    Flexible hours

    Kirkland & Ellis

    Chicago, IL
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to ETL Datastage Developer. Be the first to apply!