Senior Informatica ETL Engineer - AWS, Hybrid

System One, Inc.; Knoxville (TN); Hybrid; USD 110,000 - 150,000; Full time

Job summary

System One, Inc. seeks a Senior Informatica ETL Developer (AWS) to join our Hybrid team across multiple locations. You will collaborate with data engineering and operations to optimize data workflows and production support processes.

The role requires 7+ years in ETL or data engineering, strong Informatica PowerCenter and IDMC skills, and hands-on AWS experience (EMR, Glue, Redshift, S3). Proficiency in Python and SQL, and experience with data warehouses are essential.

Qualifications

• 7+ years of experience in ETL development or data engineering with Informatica PowerCenter
• Experience with Informatica IDMC
• Hands-on experience with AWS services (EMR, ECS, Glue, Redshift, S3, SNS, SQS, Lambda, CloudWatch)
• Strong Python and SQL skills including Redshift, PostgreSQL, or Oracle
• Experience supporting data warehouses and large-scale data pipelines
• Docker experience; familiarity with Autosys or MWAA
• Ability to troubleshoot production issues and communicate clearly in a team and solo setting
• Experience in Agile teams and sprint ceremonies
• Bachelor's degree in Computer Science, Engineering, or related field preferred

Responsibilities

• Work with data engineering and operations teams
• Help manage workflow orchestration
• Participate in on-call rotation for production support

Skills

ETL development

Data engineering

Python

SQL

Agile

Communication

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

Informatica PowerCenter

Informatica IDMC

AWS (EMR, ECS, Glue, Redshift, S3, SNS, SQS, Lambda, CloudWatch)

Docker

Autosys or MWAA

Redshift/PostgreSQL/Oracle

Job description

System One, Inc. seeks a Senior Informatica ETL Developer (AWS) to join our Hybrid team across multiple locations. You will collaborate with data engineering and operations to optimize data workflows and production support processes.

The role requires 7+ years in ETL or data engineering, strong Informatica PowerCenter and IDMC skills, and hands-on AWS experience (EMR, Glue, Redshift, S3). Proficiency in Python and SQL, and experience with data warehouses are essential.