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 3 days 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
3 days ago
SQL Developer (SSIS, SSRS, ETL) Remote___ Fulltime FTE
...SQL Developer (SSIS, SSRS, ETL)Location: Remote (EST Hours)Fulltime Permanent FTETech Stack: SQL Server Developer, T-SQL, SSIS, SSRS, ETL Pipelines, Performance OptimizationMandatory requirement:10-12+ Years of overall IT Experience.Strong SQL Developer for SQL Server...
Suggested
Permanent employment
Full time
Remote work
AceStack LLC
Chicago, IL
1 hour 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
1 hour 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-...
Suggested
Samprasoft
Chicago, IL
4 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...
Suggested
Cloud Analytics Technologies LLC
Chicago, IL
5 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
7 hours ago
ETL Developer
...to work!!!Project Overview: Looking for an experienced Snowflake developer responsible for enhancing and supporting data ingest/egress... ...Expertise in design/development in Snowflake on AzureExperience in ETL tools like SnowSQL from design/development and implementing data...
For contractors
Perfict Global, Inc.
Chicago, IL
5 days 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
4 days ago
ETL Developer
...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...
Long term contract
Work experience placement
Flexible hours
Apex Informatics
Chicago, IL
2 days ago
ETL Developer
...ETL Developer Job Position: ETL Developer (SSIS & SQL) Location: 300 S Riverside Plaza (Travel to Beloit, Wisconsin 10-20%, Chicago Office primary location) Start Date: ASAP Contract: 12 months with potential for 24 months Program Overview: The Agility...
Contract work
Work at office
Immediate start
Software Technology Inc
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
4 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
3 days ago
ETL Developer
...Purple DriveETL Developer Share Chicago, IL PDT - 10143 6-8Overview: Bachelor's or master's with 3+ experience in Computer Science, Engineering... ...another quantitative field. 3+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related...
Purple Drive
Chicago, IL
1 day ago
ETL Datastage Developer
...Purple DriveETL Datastage Developer Share Contractual Chicago, ILOverview: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...
Purple Drive
Chicago, IL
1 day 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
1 hour 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
4 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
4 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
6 days 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
7 hours ago
SQL Developer
...Job Title: SQL Developer Location: Chicago, Illinois, United States Job Mode: Hybrid Summary: Seeking a highly motivated individual... ...and Javascript experience - 8+ years. • Experience in ETL and SSIS packages and workflow/automation creation. • Experience...
campus4tech
Chicago, IL
4 days ago
Lead Cloud Engineer
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...
Full time
Work at office
Teachers Insurance and Annuity Association
Chicago, IL
2 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
7 hours ago
Salesforce Developer
$100k - $175k
....com implementationProvide hands-on expert level assistance to developers for technical issuesDemonstrate technical thought leadershipLearning... ...Oracle Knowledge of Integrations, 3rd party integration tools, ETL with Salesforce Preferred Qualifications (nice to have but not...
Work at office
Remote work
Visa sponsorship
Work visa
Flexible hours
CapTech
Chicago, IL
4 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
4 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
3 days ago
Senior C#/SQL Software Engineer
...sponsorship. The initial focus will be modernizing the company’s ETL environment while building .NET 8 microservices for business-... ..., REST APIs, and microservices using C# and .NET 8 Develop complex T-SQL queries, stored procedures, functions, and views...
Remote work
Shift work
Gables Search Group
Chicago, IL
a month 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
3 days 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
4 days ago
Application Admin/Data Support Engineer
$60 - $70 per hour
...production-bound changes when applicable. - Collaborate closely with BI developers, data engineers, and business stakeholders to ensure platform... ...and platform migrations. Understanding of data integration and ETL processes. Healthcare industry experience. Familiarity with...
Permanent employment
Contract work
Temporary work
Remote work
TEKsystems
Chicago, IL
4 days 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
1 day ago

Do you want to receive more vacancies?

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