ETL Developer 16559

ZealHire Inc.; Chicago (IL); Hybrid; USD 120,000 - 160,000; Full time

Job summary

ZealHire Inc. is seeking an ETL Developer to design, build, test, and maintain data extraction, loading, and transformation pipelines across diverse systems.

The role emphasizes leading ETL design, deploying scalable backend services on AWS, and collaborating with architects, engineers, and product owners to deliver robust data processing solutions.

Qualifications

• 6+ years experience with ETL tools for data cleansing, profiling, transforming and scheduling workflows.
• Expert level SQL: writing, debugging and optimizing queries.
• 3–4 years of programming with Python or PySpark/Glue.
• Knowledge of Big Data processing patterns and AWS analytics services.

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 for efficient technical solutions.
• Maintain ETL schedules and compliance.
• Develop and maintain standards for ETL code and project lifecycle.

Skills

ETL development

SQL proficiency

Python / PySpark

Big data processing

CI/CD & IaC

Tools

AWS Glue

S3

Redshift

Lambda

Step Functions

RDS Aurora/MySQL

Apache Iceberg

CloudWatch

EventBridge

SQS

SNS

CloudFormation / Terraform

Job description

USC/GCNeed LinkedIn, VISA DLHybrid Chicago- Locals

Top 5 Skill sets

• Complex coding in Python or PySpark development experience is a must
• SQL Development, debugging, optimization
• AWS - Glue, Step Functions, Event Bridges
• Knowledge of inner working of Databases – like AWS RDS MySQL
• 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

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.
• CI/CD & IaC experience - Harness, developing/maintaining YAML/CloudFormation scripts
• Self-starter, responsible, professional and accountable.
• A ‘finisher’, seeing a project or task through to completion despite challenges.

$000,000 – $000,000 Salary range is not shown on the candidate portal