AWS Redshift ETL Engineer: Data Pipelines & Orchestration

Infosys; Charlotte (NC); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Disability insurance

Health reimbursement accounts

Insurance (various)

401(k) plan

Job summary

Infosys in the United States is seeking a Technology Consultant 2 to contribute to requirements elicitation, design discussions, and coding across an AI-first data platform stack. You will document design decisions, review code, and maintain ETL/ELT pipelines into Redshift using PL/pgSQL, with orchestration via AWS Step Functions or Airflow.

You will also optimize Redshift performance, maintain documentation, and develop training materials for smooth deployment and production support.

Qualifications

• Bachelor's degree or foreign equivalent is required.
• Relocation and/or travel may be required for the role.
• Candidates authorized to work in the United States without employer sponsorship are welcome.

Responsibilities

• Contribute to requirements elicitation by documenting assigned parts of business requirements.
• Facilitate software design discussions and document design decisions for the technical team.
• Participate in coding and integrate new features with focus on stability.
• Conduct code reviews and maintain code repositories.
• Implement test strategies, analyse results, and coordinate bug fixes.
• Develop user training programs, documentation, and support frameworks.
• Resolve production issues and recommend preventive strategies for reliability.
• Maintain detailed records of code, tests, and support activities.

Skills

ETL/ELT pipelines

Redshift SPs (PL/pgSQL)

AWS Step Functions

Redshift performance tuning

Documentation & maintenance

Python/UNIX shell scripting

Education

Bachelor’s degree or foreign equivalent

Tools

AWS Step Functions

Amazon MWAA (Airflow)

Job description

Infosys in the United States is seeking a Technology Consultant 2 to contribute to requirements elicitation, design discussions, and coding across an AI-first data platform stack. You will document design decisions, review code, and maintain ETL/ELT pipelines into Redshift using PL/pgSQL, with orchestration via AWS Step Functions or Airflow.

You will also optimize Redshift performance, maintain documentation, and develop training materials for smooth deployment and production support.