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

Apply

Vacancy posted 5 days ago

Similar jobs that could be interesting for youBased on the ETL Datastage Developer in Chicago, IL vacancy

Senior SQL & ETL Lead Developer
$122k - $178k
Chubb Benefits is seeking a Senior SQL & ETL Lead Developer to join our fast-paced, high energy, growing company. We are proud of our tradition of success in the insurance industry of over 100 years. Come join our team of hard-working, talented professionals!Job Description...
Suggested
Work at office
Local area
Chubb
Chicago, IL
2 days ago
Remote Oracle Data Integrator ETL Developer
$55 - $56 per hour
...Remote Oracle Data Integrator ETL DeveloperChicago, Illinois, United States$ 55.00 - 56.00 (US Dollar)Remote Oracle Data Integrator ETL Developer needs 5 years data warehousing development, implementation and support experienceRemote Oracle Data Integrator ETL Developer...
Suggested
Remote work
Global Channel Management
Chicago, IL
3 days ago
Data Engineer - Azure ETL & Analytics Platform
...Management (HSAM) is seeking a Data Engineer to design, build, and maintain scalable data pipelines and data platforms. The role focuses on ETL, data architecture, and analytics infrastructure to support data-driven decision making. The ideal candidate will have 5+ years in...
Suggested
Harrison Street Asset Management
Chicago, IL
4 days ago
Senior Data Engineer ETL, Azure Fabric & Tableau
...pipelines, data platforms, and analytics infrastructure. You will transform data for analysts and data scientists, implement scalable ETL, and ensure data quality and security across the Enterprise Data Platform. The role requires expertise in Azure services, Fabric, SQL...
Suggested
Harrison Street
Chicago, IL
5 days ago
Airline ETL Developer Azure Data Factory & MySQL
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
2 days ago
ETL Developer (Azure Data Factory & MYSQL)- airline industry
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:...
Hourly pay
Permanent employment
Contract work
Local area
Blockchain Technologies Corp.
Chicago, IL
2 days ago
ETL Developer
...ETL DeveloperJob Location: Chicago, IL (Remote Project) Job Type: 12+ Months ContractDescription: ETL Developer with below skills:Must have: Spark, JavaNice to have: Scala, DockerAdditional Details:Candidate must be in EST or CST Only.About Us: InterSources Inc, a Certified...
Remote work
InterSources
Chicago, IL
3 days ago
ETL Developer
...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
2 days ago
ETL Developer
...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
1 day ago
ETL Developer
...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
5 days ago
Snr. Developer Oracle(Pl/SQL + ETL)
...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
3 days ago
ETL DEVELOPER - Must be US Citizen or Green Card holder
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
3 days ago
Datastage Developer Onsite Chicago, 12-Month Contract
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
5 days ago
ETL DEVELOPER
...Job Description Job Description 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 Cloud...
Globalchannelmanagement
Chicago, IL
19 days ago
Lead Oracle Engineer
$130k - $200k
...the platforms the firm depends on.Key Responsibilities:Design, develop, and maintain advanced Oracle APEX applications supporting Finance... ..., and long-term maintainability.Maintain and enhance ETL and data pipelines processes that support APEX application, reporting...
Full time
Shift work
Houlihan Lokey
Chicago, IL
13 hours ago
Locals or Nearby Only Urgent Need Datastage Developer
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
3 days ago
Sr Data Platform Engineer
$122k - $183k
...unifying IAM roles, active directory syncs, and row/column-level access controls. · Pipeline & Code Migration: Refactor and migrate legacy ETL/ELT pipelines, Spark workflows, and orchestration routines to point to the new unified tenant. · Cost & Asset Optimization: Identify...
Full time
Temporary work
Part time
Work at office
Local area
Remote work
Flexible hours
UST Global
Chicago, IL
1 day ago
Senior Software Engineer
$112.9k - $188.1k
...processing, probabilistic matching algorithms, ETL batch jobs, and performing end user... ...users. You Will Build applications and develop product design solutions in partnership with... ...and practices, with a focus on IBM DataStage and Apache Airflow, including platform administration...
Full time
Work at office
Local area
Worldwide
2 days per week
W.W. Grainger
Chicago, IL
2 days ago
SQL DEVELOPER
...About the job SQL DEVELOPER We are seeking an experienced SQL Developer to join our growing team. As a SQL Developer, you will be... ...with SQL Server, MySQL, and/or Oracle databases - Proficiency in ETL processes and tools - Familiarity with data warehousing...
Vigorcare Pediatric Services
Chicago, IL
5 days ago
Actimize Lead Full-stack Engineer
$77k - $154k
...INFRA, AML-STAR-FINCEN-SAR, AML-CDD, UDM. Must be an expert in developing applications and services using Java Springboot/Springbatch. Must... ...Customization using ActOne Designer, Plugin implementation, ETL development using AIS (Actimize Modeler), Application installation...
Full time
Work experience placement
Work at office
Remote work
Work from home
Flexible hours
The Huntington National Bank
Chicago, IL
2 days ago
Salesforce Developer
...architectureProduce low level design documents & own up specific modules.Develop custom code for salesforce.com application.Strong expertise in... ...API is a must.Strong expertise on working with various ETL looks like Informatica, Pervasive, Dell Boomi, and Data Stage.Develop...
Permanent employment
H1b
Sonsoft
Chicago, IL
3 days ago
Lead Business Intelligence Engineer
...Storage, Azure Databricks, SQL Server, SSIS, SSAS, SSRS, and Power BI.Develop and maintain relationships with key stakeholders, including... ...Intelligence and Analytics consumption.Strong understanding of ETL processes and data pipelines, and experience developing them.Experience...
Follett Corporation
Westchester, IL
2 days ago
Staff Software Engineer, Data Platform
$195k - $257.5k
...OS for the internet. Enterprises, financial institutions, and developers use Circle to power trusted, internet-scale financial innovation... ...the core Data warehouse platform, data ingestion and processing, ETL/ELT pipelines orchestration platform, data cataloging, data...
Contract work
Remote work
Flexible hours
Circle
Chicago, IL
3 days ago
Senior Salesforce Developer
$114.1k - $167.35k
..., Revenue Cloud, Agentforce and custom code.The Role:The Senior Developer’s primary role is to lead the technical development work in the... ...with integration architecture third-party integration tools and ETL (Such as Informatica) with SalesforceAdvanced knowledge of platform...
Full time
Temporary work
Work at office
Worldwide
Flexible hours
Morningstar
Chicago, IL
2 days ago
Sr. Software Engineer (Data & Application Engineer)
$111.61k - $131.3k
...lifecycle and DevOps principles.Essential Responsibilities:Design,develop,test,deploy,... ...scaleenvironments.Expertisewithrelationaldatabases,datamodeling,ETL/ELTprocesses,datatransformation,anddataqualitymanagement.Hands-onexperiencewithCI...
Full time
Work experience placement
Local area
3 days per week
US Bank
Chicago, IL
3 days ago
Lead SQL Developer
...to understand requirements and support application, work with Developers, Business Analyst and QE team to ensure quality solution delivery... ...reconciliation, and reporting processes. Experience in ETL and SSIS packages and workflow/automation creation. Experience...
Night shift
Holistic Partners, Inc
Chicago, IL
56 minutes ago
Salesforce Financial Services Cloud Solution Architect
...globally and in North America, we are committed to growing and developing our Salesforce talent, offering continued growth opportunities,... ...integration architecture as well as third-party integration tools and ETL (Such as Mulesoft, Informatica, Jitterbit etc. ) with [8]...
Temporary work
Local area
Slalom
Chicago, IL
3 days ago
AWS Cloud Architect
$134k - $201k
...This role owns the end-to-end target-state design for a complex application landscape that includes Liferay, SiteCore, PingFederate, ETL jobs, and Angular/Node.js applications — and works hands-on with DevOps practices to get workloads safely into production on AWS.The...
Full time
Temporary work
Part time
Work at office
Local area
Remote work
Flexible hours
Shift work
UST Global
Chicago, IL
1 day ago
Lead Software Engineer - Markets, Java, AWS, Spring Boot, Terraform
...of the firm’s business objectives.Job responsibilitiesDesigns, 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 financial...
JP Morgan Chase
Chicago, IL
2 days ago
Senior Backend Software Engineer
$165k - $195k
...stable API contracts. This person will work closely with frontend developers, product managers, data teams, and business stakeholders to... ...automated testing, and developer workflows ~ Develop and maintain ETL and data migration processes when needed, especially for...
Remote job
Full time
Temporary work
Site Technologies
Chicago, IL
1 day ago

Do you want to receive more vacancies?

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