ETL Developer IV

ETL Developer IV
Chicago, Illinois, 60606 (Hybrid - 3 days in office, 2 days remote)
6-Month Contract with Potential Extension
Pay Range: $60-$65/HR

About the Role
Our Fortune 500 client, a leader in the Airlines domain services industry, is looking for ETL Developer to join their client support team in Chicago, Illinois. This role is ideal for candidates with experience in Python, Complex SQL, AWS - Glue, RDS & Big Data Processing who are eager to work in a fast-paced, high-volume setting.

Top 5 Skill sets

• Python or PySpark
• Complex SQL Development debugging optimization
• AWS - Glue Step Functions
• 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

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 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 architect's 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 work with business process area owners.
• Implement industry best practices code and configuration for production and non-production environments in a 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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.