ETL / AWS Software Engineer

MACHINE LEARNING TECHNOLOGIES LLC; Chicago (IL); On-site; USD 96,000 - 165,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC is seeking an experienced Software Engineer to lead the migration of ETL jobs from on-prem to AWS. You will build ETL solutions, understand existing jobs, and guide the team on data quality, compliance, and production support.

Strong knowledge of DataStage/Informatica, Python, and AWS is required across a broad data analytics stack. The role involves orchestration of ETL processes, development of scalable cloud-based data pipelines, and collaboration with data

Qualifications

• More than 8 years of experience in ETL development, data warehousing, AWS cloud services, and API development.
• Comprehensive proficiency in AWS services with data integration, transformation, and loading.
• Scripting expertise including DataStage/Informatica, Shell, Perl, and Python.
• API development with REST and SOAP.
• AWS ecosystem skills (Glue, Step Functions, Airflow, Lambda, S3, EC2, Redshift, Aurora).
• Experience with Git/Bitbucket, Jenkins pipelines, and CI/CD.
• Proven data analysis/validation using Excel, Python, Tableau is advantageous.
• Familiarity with automotive industry data-warehousing concepts and agile methods.

Responsibilities

• Lead migration of ETL jobs and on-premises databases to AWS Cloud.
• Build new ETL solutions as needed and document data flows and mappings.
• Design and implement ETL Glue PySpark processes for Redshift and Aurora PostgreSQL.
• Develop full-stack capabilities and APIs as required by projects.
• Analyze data quality, validate data, and ensure regulatory compliance.
• Automate ETL processes and orchestrate workflows across hybrid environments.
• Provide production support, monitoring, troubleshooting, and issue resolution.
• Create comprehensive documentation for processes, data mappings, and APIs.

Skills

ETL development

Data warehousing

AWS cloud services

API development

CI/CD

Agile

Data analysis

Education

Bachelor's degree in Computer Science, Information Technology, or a related field

Tools

DataStage

Informatica

Korn Shell

Python

Perl

REST

SOAP

SQL

Git/Bitbucket

Jenkins

Airflow

AWS Glue

Lambda

S3

Aurora

Redshift

EC2

Step Functions

DB2 on AIX

Job description

Job Overview

• Job ID: J52989
• Job Title: ETL / AWS Software Engineer
• Location: Chicago, IL
• Duration: 24 Months + Extension
• Hourly Rate: Depending on Experience (DOE)
• Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD
• Client: To Be Discussed Later
• Employment Type: W-2, 1099, C2C

Job Description

Client is seeking a highly experienced Software Development Engineer to lead and support the migration of ETL jobs and databases from on-premises environments to the AWS Cloud. This position requires a hands-on developer who can build new ETL solutions if necessary, thoroughly understand all existing on-premises ETL jobs, and serve as an expert to guide the team. Key responsibilities include job execution, data validation, ensuring data quality, and adherence to data compliance and business rules. The role also encompasses understanding AWS infrastructure-as-code, developing ETL solutions to replicate on-premises processes in the cloud, orchestrating and validating jobs, and providing comprehensive production support. Candidates must possess technical development expertise and a strong background in data analytics.

Responsibilities

• Leverage development experience with DataStage or Informatica, Korn Shell, Python, and Perl scripting on Unix/Linux platforms.
• Be able to design, develop, and implement ETL Glue PySpark processes to extract, transform, and load data from various sources into AWS cloud-based data warehouses and data lakes, specifically Redshift and Aurora PostgreSQL.
• Be able to develop scalable and efficient full-stack applications, including both front-end and back-end components or APIs, as required.
• Conduct business analysis and perform data analysis/ validation to minimize errors and inconsistencies, extract meaningful insights, and support business decision-making throughout the software development lifecycle.
• Collaborate closely with data analysts, data architects, and other team members to analyze source data, enhance data accuracy and integrity, implement data reporting, and understand data and application requirements to deliver effective solutions.
• Automate and orchestrate ETL processes, applications, and APIs to optimize performance and scalability across both on-premises and cloud environments.
• Proactively provide production support, including monitoring, troubleshooting, and resolving issues for ETL processes, configurations, and data integrity.
• Develop comprehensive documentation covering overall processes, data mappings, data flows, APIs, application code, and support procedures.
• Perform impact analysis and effectively communicate technical processes and concepts to larger audiences.
• Ensure data and application security and compliance with all relevant data protection regulations.
• Participate in code reviews, adhere to best practices, and provide constructive feedback to peers.
• Stay up to date with the latest industry trends and best practices in the areas of ETL development, full-stack development, data analysis, and cloud technologies.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• More than 8 years of experience in ETL development, data warehousing, AWS cloud services, and API development.
• Comprehensive proficiency in all AWS services with a strong understanding of data integration, transformation, and loading processes.
• Expertise in scripting languages, including DataStage or Informatica, Shell scripting, Perl, and Python.
• Experience with API development and frameworks such as REST and SOAP.
• Advanced skills utilizing the AWS cloud platform and services, including AWS Glue, Step Functions, Airflow DAGS, Lambda, S3, EC2, and others.
• Proficiency in SQL with both on-premises relational databases (such as DB2 on AIX) and AWS databases (such as Amazon RDS, Amazon Aurora PostgreSQL, and Redshift).
• Experience with version control tools like Git or Bitbucket.
• Familiarity with implementing Jenkins pipelines and CI/CD processes.
• Demonstrated experience in data analysis/ validation, utilizing tools such as Excel, Python, and Tableau.
• AWS certifications and expertise in AI/ML are advantageous.
• Familiarity with automotive industry knowledge, data-warehousing concepts, and adherence to developer best practices.
• Experience working within Agile development methodologies.

Equal Opportunity Employer

MACHINE LEARNING TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. MACHINE LEARNING TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will MACHINE LEARNING TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.