ETL Developer

3B Staffing LLC

Chicago, IL

Project Name:

FareWorks Initially till end of the year with possibility to extend. Not guaranteed at this moment.

Top 5 Skill sets

1. Python or PySpark
2.Complex SQL Development debugging optimization
3.AWS - Glue Step Functions
4.Knowledge of inner working of Databases - like AWS RDS MySQL
5. Big Data Processing

Nice to have skills or certifications:

Experience as a lead for decent sized ETL team
Experience with Apache Iceberg
Observability tools like Dynatrace or DataDog

Preferred Hours of wor k: 8

need to be flexible to support/troubleshoot issues during odd hours in case of incidents Must be Chicago location at this point we go to office every Tue/Wed alternate week but may change in future No travel at this time.
Interview Process: How many interviews do you anticipate? 3 interviews
Please do not send any candidate who does not have an extensive experience in building ETL jobs and not hands on coder for large data set in an enterprise setup.

Job Summary:

An ETL developer needs to design build test and maintain systems that extract load and transform data from multiple different systems.

Primary Responsibilities:

Leads Designs implements deploys and optimizes backend ETL services.
Support a massive scale enterprise data solution using AWS data and analytics services.
Analyze and interpret complex data and related systems and provides the efficient technical solutions.
Provide support to ETL schedule and maintain compliance to same. -
Develop and maintain standards to ETL codes and maintain an effective project life cycle on all ETL processes.
Coordinate with cross functional teams like architects platform engineers other developers and product owners to build data processing procedures.
Perform root cause analysis on production issues and perform routine monitoring on databases and provide support to ETL environments.
Help create functional specifications technical designs and working with business process area owners.
Implement industry best practices code and configuration for production and non-production environments in an highly automated environment.
Provides technical advice effort estimate impact analysis.
Provides timely project status and issue reporting to management.

Qualifications :

6 years experience using ETL tools to perform data cleansing data profiling transforming and scheduling various workflows.
Expert level proficiency with writing debugging and optimizing SQL. - 3-4 years programming experience using Python or PySpark/Glue required.
Knowledge of common design patterns models and architecture used in Big Data processing.
3-4 years' experience with AWS services such as Glue S3 Redshift Lambda Step Functions RDS Aurora/MySQL Apache Iceberg CloudWatch SNS SQS EventBridge.
Capable of troubleshooting common database issues familiarity with observability tools.
Self-starter responsible professional and accountable.
A finisher seeing a project or task through to completion despite challenges.

Apply

Vacancy posted 1 day ago

Similar jobs that could be interesting for youBased on the ETL 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
1 day ago
Hybrid Data Platform Engineer II | ML Tools & ETL
...engineering best practices. You'll collaborate with analytics leadership and engineers across EW on architectural enhancements, improve ETL and cluster computing, and support risk management to protect data integrity. Hybrid roles available in major cities. #J-18808-...
Suggested
Early Warning Services
Chicago, IL
5 days ago
Remote Oracle Data Integrator ETL Developer
...Remote Oracle Data Integrator ETL Developer About the job Remote Oracle Data Integrator ETL Developer Remote Oracle Data Integrator ETL Developer needs 5 years data warehousing development, implementation and support experience ~3 years Oracle Data Integrator(ODI...
Suggested
Remote work
Global Channel Management, Inc
Chicago, IL
20 hours 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. LLC
Chicago, IL
6 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:...
Suggested
Hourly pay
Permanent employment
Contract work
Local area
Cloud Hybrid Technologies, LLC
Chicago, IL
2 days ago
ETL Developer/Administrator
...ETL Developer/AdministratorIndividuals in the category are expected to have experience working with AWS ETL tools with multiple RDBMS environments on multiple platforms. ETL Developer/Administrator will support ETL processes and tools, which may include commercial off-...
Samprasoft
Chicago, IL
3 days ago
ETL / AWS Software Engineer
...Summary TITLE - ETL / AWS Software Engineer (F2F Interview) Job Description Client is seeking a highly experienced Software... ...environments to the AWS Cloud. This position requires a hands-on developer who can build new ETL solutions if necessary, thoroughly understand...
Cloud Analytics Technologies LLC
Chicago, IL
9 days ago
Ab Initio ETL Developer
...Job TitleHands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including GDE... ....Prepare for code review, test case reviews, and ensure code developed meets the requirements.Ensure quality, standards, version control...
Samprasoft
Chicago, IL
3 days ago
ETL Developer
...the Central U.S., Illinois, or Midwest region are preferred. Travel: Position Summary We are seeking an experienced MDM ETL Specialist / Developer to provide hands-on technical development, support, and delivery for Master Data Management (MDM) services supporting a large...
Remote work
MSR Technology Group
Chicago, IL
14 hours ago
ETL Developer
...SSIS ETL DeveloperDuration: 12 Months Location: Chicago, IL (100% Remote)Key Skills: SSIS, ETL, Snowflake, API, AWSMust Have:10+... ...SSISDemonstrated experience in leading teams and projectsExperience in developing automated testing procedures in the ETL spaceProficiency in...
Remote work
Javen Technologies
Chicago, IL
3 days ago
ETL Developer
...Datawarehouse / ETL DeveloperLocation: Downtown Chicago, IL (Hybrid)Duration: 12 Months plus contractRate: DOEWe are looking for someone... ...productionizedHelp address issues through dev pipeline.Once developed/productionized support issue, consult with team and provide solutionDocument...
Local area
Georgia IT Inc
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
2 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
2 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
a month 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
4 days ago
Python Full Stack Developer - Lift & Shift Migration
$82k - $123k
Python Full Stack Developer - Lift & Shift Migration Lead II - Software EngineeringWho We Are:Born digital, UST transforms lives through the... ...applications and scripts in Python · Experience with batch/ETL processing patterns — scheduling, error handling, retries, idempotency...
Full time
Temporary work
Part time
Work at office
Local area
Remote work
Flexible hours
Shift work
UST Global
Chicago, IL
2 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
8 hours ago
Oracle PL/SQL Developer
...expertise in performance tuning of SQL queries, PL/SQL scripts, and ETL workflows2-3 years of Shell/Python Scripting experiencePreferred... .../programming languagesDay-to-Day ResponsibilitiesDesign and develop Oracle PL/SQL procedures, functions, triggers, and packagesBuild...
Artech
Chicago, IL
3 days ago
IT - .net/C# Developer - Senior
...FIX messaging, market data APIs, and trade order management systems (OMS) Control-M (job scheduling) Exposure to Informatica or other ETL tools SonarQube or Veracode for code quality/security Knowledge of Splunk (monitoring/log analysis) Experience with cloud...
Mindlance
Chicago, IL
3 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
1 day 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
1 day 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
2 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
4 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
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
2 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
1 day 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
8 hours ago
ETL Data Conversion Analyst
...optimization. 5+ years of experience designing and implementing ETL pipelines using SQL Server Integration Services (SSIS) and ETL... ...database platform deployment/administration. 4+ years of experience developing automation and application components using Microsoft .NET...
Permanent employment
Contract work
Local area
Cloud Analytics Technologies, LLC
Chicago, IL
4 days 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
1 day ago
ETL & Database Developer: Build Scalable Data Solutions
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
3 days ago

Do you want to receive more vacancies?

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