Consultant - Client-ETL Developer

Date:  11 Mar 2025
Location: 

Regus at 200 S Wacker, Suite 3, Illinois, United States, Digital En

Country/Region:  Un
Category: 

OBJECTIVE OF ROLE

Job Title: ETL Developer III

Location: Chicago, IL

Duration: Long-Term

Job Description:

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

Job Summary:

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

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.

QUALIFICATION

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.

ABILITIES

ABOUT US

IGT Solutions (IGT) is committed to simplifying complex customer interactions while delivering a seamless experience. It provides integrated BPM, Technology and Digital Services & Solutions for clients across industries. IGT Solutions is a next-gen customer experience (CX) company, defining and delivering transformative experiences for the global and most innovative brands using digital technologies. With the combination of Digital and Human Intelligence, IGT becomes the preferred partner for managing (end-to-end) CX journeys across Travel and Hi-tech industries.

Established in 1998, with 100% focus on customer experience, IGT employs more than 20,000+ customer experience and technology specialists providing services to 75+ marquee customers globally. IGT’s global footprint consists of 23 delivery centers in China, Philippines, Malaysia, India, UAE, Romania, Indonesia, Spain, Colombia and the USA

EQUAL OPPORTUNITY DISCLAIMER

It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.

ADDRESS & LOCATION

United States, Illinois, Regus at 200 S Wacker, Suite 3100, Chicago, IL 60606, United States