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
  •  ...Job Description Job Description RSNA is seeking a SQL Server ETL Developer to build and support the data solutions that power reporting, analytics, and decision-making across the organization. Working primarily with SQL Server, T-SQL, and SSIS , you’ll design... 
    Suggested
    H1b
    Remote work
    Weekend work
    Afternoon shift

    Radiological Society of North America

    Oak Brook, IL
    6 days ago
  •  ...Description The Senior Oracle integration Cloud (OIC) Middleware, ETL, EBS Integration Specialist is responsible for designing,...  ...integrations for Financials, Procurement, AR/AP, and custom modules. • Develop transformation mappings (XSLT/JSON/XML) and apply error-handling... 
    Suggested
    Interim role

    Expert In Recruitment Solutions

    Chicago, IL
    21 days ago
  •  ...DataStage Developer Location: Chicago IL Start Date: ASAP We need only FTE profiles, no contract please. Do not submit H1B profiles. Job Description ~5+ years of experience in DataStage development – parallel and server edition ~ Oracle – SQL, PL/SQL... 
    Suggested
    Contract work
    H1b
    Immediate start

    United IT

    Chicago, IL
    4 days ago
  •  ...About the job ETL DEVELOPER ETL DEVELOPER REQUIRES: ~10+ years of experience in Enterprise Application Integration and software development. ~5+ years of hands-on experience with Oracle Integration Cloud (OIC). ~ Strong experience with Oracle Fusion... 
    Suggested

    Global Channel Management

    Chicago, IL
    2 days ago
  •  ...Purple Drive ETL Developer Share Chicago, IL PDT - 10143 6-8 Overview: Bachelor's or master's with 3+ experience in Computer Science, Engineering, Math or another quantitative field. 3+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring... 
    Suggested

    Purple Drive

    Chicago, IL
    2 days 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
    24 days ago
  • $65 - $70 per hour

     ...Data Engineering with 8+ years of IT experience in designing, developing, and implementing scalable enterprise applications and data integration...  ...using Python and .NET technologies. · Build and maintain ETL pipelines and data integration solutions using AWS Glue. ·... 
    Contract work

    Long Finch Technologies

    Chicago, IL
    2 hours ago
  • $65 - $68 per hour

     ...# Home # Search Jobs # Job Description Oracle developer Contract: Chicago, Illinois, US Salary Range: 65.00 - 68...  ...forward to speaking with you! Job Requirement Oracle ETL PL/SQL Database Reach Out to a Recruiter... 
    Hourly pay
    Contract work
    Temporary work

    Collabera

    Chicago, IL
    1 day ago
  •  ...driving a major transformation across Capital One. What You’ll Do:  Lead a portfolio of diverse technology projects and a team of developers with deep experience in distributed microservices, and full stack systems to create solutions that help meet regulatory needs for... 
    Full time
    Internship

    Capital One

    Chicago, IL
    1 day ago
  • $160k - $185k

     ...supports it, including scripts for custom extract, transform, load (ETL) work with a security focus for data flow. Detection and...  ...teams on guardrails. Comfortable operating inside developer workflows, including pull request and code review, branching strategies... 

    The Aspen Group

    Chicago, IL
    a month ago
  • $70 - $80 per hour

     ...improve pipeline performance. Key Responsibilities Design, build, and maintain production ETL pipelines that extract, transform, and integrate large datasets. Develop data processing workflows using Python and Apache Spark. Write and optimize complex SQL... 
    H1b
    3 days per week

    The Planet Group

    Chicago, IL
    13 days ago
  • $179.4k - $204.7k

     ...driving a major transformation across Capital One. What You’ll Do:  Lead a portfolio of diverse technology projects and a team of developers with deep experience in distributed microservices, and full stack systems to create solutions that help meet regulatory needs for... 
    Full time
    Part time
    Internship
    H1b
    Local area

    Capital One

    Chicago, IL
    1 day ago
  • $111k - $152k

    This role is responsible for developing and managing cloud storage solutions, building data pipelines, automating processes using Python...  ...maintains data engineering solutions including data pipelines, ETL/ELT processes, and analytics components using Python or Java for... 
    Work experience placement
    Work at office

    TIAA

    Chicago, IL
    2 days ago
  •  ...features Must Haves: At least 7-8+ years of experience as a Java/J2EE Developer. Refactoring/modernizing backend application using Spring (...  ...Amazon Aurora MySQL). 2+ years of experience using Talend as an ETL tool. Talend is an ETL tool that provides solutions for data... 
    Relocation

    thehivecareers.co

    Chicago, IL
    4 days ago
  •  ...4 days onsite in Berwyn, PAOur client seeks a Java engineer to develop and enhance investment servicing applications. The role will focus...  ..., and data integration. The team values clean code, reliable ETL, and collaboration with operations to support asset management workflows... 
    Hourly pay
    Contract work
    Local area

    Eliassen Group

    Berwyn, IL
    3 days ago
  •  ...Job DescriptionJob DescriptionRole: Salesforce Developer (24002-1) Duration: 6-12 Months Contract Location: Chicago, IL- Remote VISA Preference...  ...and dashboardsExperience using Apex Data Loader (or other ETL tools like Informatica or Boomi or Cast Iron or Mulesoft)Experience... 
    Contract work
    Work experience placement
    Remote work

    Cardinal Integrated Technologies Inc

    Chicago, IL
    3 days ago
  •  ...Overview DecisionPoint seeks a Senior Data/ETL Engineer to sustain SQL Server Integration Services (SSIS), develop approved integrations, and maintain reliable data pipelines supporting the USMEPCOM ENLIST program. This position will implement raw, standardized... 
    Contract work
    For contractors
    Local area
    Remote work

    Decisionpoint Corporation

    Chicago, IL
    4 days ago
  •  ...Description Job Summary: We are seeking a highly motivated Senior SQL Developer with strong technical and analytical skills. Experience in...  ...hands-on SQL, VBScript, and JavaScript experience. Experience with ETL, SSIS packages, and workflow/automation tools. Proficiency with... 

    Macpower Digital Assets Edge Private Limited

    Chicago, IL
    3 days ago
  •  ...Overview DecisionPoint seeks a Journeyman Data/ETL Engineer to develop and maintain extract, transform, and load workflows supporting the USMEPCOM ENLIST program. This position will sustain SQL Server Integration Services (SSIS), build approved integrations, and... 
    Contract work
    For contractors
    Local area
    Remote work

    Decisionpoint Corporation

    Chicago, IL
    4 days ago
  •  ...driving a major transformation across Capital One. What You’ll Do:  Lead a portfolio of diverse technology projects and a team of developers with deep experience in distributed microservices, and full stack systems to create solutions that help meet regulatory needs for... 
    Full time
    Internship

    Capital One

    Chicago, IL
    1 day ago
  •  ...a client in Chicago, IL that is seeking a Python & AI Solutions Developer. Position Summary: We are seeking an experienced Temporary...  ...Qualifications: * Experience developing Alteryx workflows and ETL processes * Experience with Power BI, dashboard modernization,... 
    Hourly pay
    Contract work
    Temporary work

    Kforce Technology Staffing

    Chicago, IL
    16 hours ago
  •  ...documentation and deliverables· Good communication skills. Ability to liason with AbbVie IT / business on a regular basisOracle(Pl/SQL + ETL) Additional InformationAll your information will be kept confidential according to EEO guidelines.SummaryFunction: Information... 

    EROS Technologies

    Chicago, IL
    16 hours ago
  • Company DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing...  ...development and business keenness.Job DescriptionJob Tile : ETL DEVELOPERLocation : Oak Brook, IL, United StatesFULLTIME Must... 
    Temporary work
    Casual work
    Work at office
    Worldwide

    USM Systems

    Oak Brook, IL
    16 hours ago
  • $117.5k - $172.35k

     ...Technology group. The Senior Salesforce Software Engineer designs, develops, and supports scalable Salesforce solutions that enable Sales,...  ...enterprise integration concepts, including APIs, middleware, ETL and data pipelines, event-driven patterns, identity and access controls... 
    Work experience placement
    Work at office
    Flexible hours

    Morningstar

    Chicago, IL
    2 days ago
  • $60 - $65 per hour

     ...now or in the future. TOP 3 Must Haves ~7+ years Oracle DB Developer ~ PLSQL (not financials or reporting) ~ Informatica – exp pulling...  ...different programming/scripting languages (e.g. python) and ETL tools (e.g. Informatica) Experience with Data Analysis and... 

    Apolis

    Chicago, IL
    21 days ago
  • $185k - $225k

     ...efficient. Your Core Responsibilities: Own the operational health of the Performance Team's data platform Monitor and maintain ETLs and data pipelines for correctness, timeliness, and stability Design and maintain data quality checks, reports, and alerting... 
    Permanent employment
    Full time

    IMC

    Chicago, IL
    4 days ago
  •  ...Overview DecisionPoint seeks a Senior Data and BI Developer to design, build, and maintain data models, metadata, ETL processes, warehouse components, dashboards, reports, and visualizations supporting the USMEPCOM ENLIST program. This position will connect data... 
    Contract work
    For contractors
    Local area
    Remote work

    Decisionpoint Corporation

    Chicago, IL
    4 days ago
  • $200k - $220k

     ...Full Stack Developer Location: Chicago, IL area — Hybrid / regular in-person collaboration preferred Company Overview: OpenBrand is...  ...modernization, including VM consolidation, Elasticsearch migrations, ETL modernization, or workflow-orchestration conversions.... 
    Full time
    Immediate start
    Flexible hours

    Openbrand

    Chicago, IL
    1 day ago
  • $63.14k - $118.14k

     ...Enforce development standards, best practices, and governance. • Develop backend applications using Java, Spring Boot, and Microservices...  ...integration experience with REST APIs, SOAP Services, FTP/SFTP, ETL Pipelines, and Kafka. • Experience supporting enterprise... 
    Full time
    Local area

    Capgemini

    Chicago, IL
    22 days ago
  • $250k

     ...incenting collaboration and mutual respect. At Jump, research outcomes drive more than superior risk adjusted returns. We design, develop, and deploy technologies that change our world, fund start-ups across industries, and partner with leading global research organizations... 
    Full time
    Work experience placement
    Internship
    Visa sponsorship
    Work visa

    Jump Trading

    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!