> Markdown version of [/jobs/ext/1403636-aws-redshift-etl-developer](https://www.wearedevelopers.com/jobs/ext/1403636-aws-redshift-etl-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# AWS Redshift ETL Developer

- **Company:** Infosys
- **Location:** Charlotte, NC, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Query Performance, Airflow, Amazon Web Services, Software Applications, Software Bug Management, Code Review, Extract Transform Load (ETL), Data Mapping, Data Transformation, Database Queries, File Systems, Python (Programming Language), Unix Shell, Performance Tuning, Systems Development Life Cycle, SQL Stored Procedures, Systems Integration, Strategies of Testing, Encapsulation (Networking), Scripting, Reliability of Systems
- **Published:** July 23, 2026
- **Apply:** https://sjobs.brassring.com/TGnewUI/Search/home/HomeWithPreLoad?partnerid=25633&siteid=5439&PageType=JobDetails&jobid=2248426

## About the Role

A collaborative spirit and excellent communication skills.
The ability to handle end to end SDLC phases from requirement gathering to implementation.
A knack for translating complex requirements into actionable development tasks.
A passion for design and hands-on coding experience
A proactive approach to testing, troubleshooting, and refining our applications.
The ability to work with cross-functional teams and do software integration., * Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

 * This position may require relocation and/or travel to work/project location.
 * Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply. Infosys is unable to provide immigration sponsorship for this role now or in the future.

## Description

In the assigned Job Role of Technology Consultant 2, your Area Of Responsibility will be as below:

Contribute to the requirements elicitation process by documenting assigned parts of business requirements, in line with guidance provided
Facilitate software application design discussions, and document design decisions to guide the technical team towards building software solutions
Participate in coding and integrate new features or updates into existing applications, with a focus on maintaining system stability
Conduct code reviews, do changes to the codebase and maintain code repositories
Implement test strategies, analyse results, and coordinate bug fixes to uphold the software quality standards
Develop user training programs, documentation, and support frameworks to ensure a smooth transition to new software applications
Actively participate in resolving production issues and recommend preventive strategies to enhance system reliability
Maintain detailed records of code, testing techniques, and support activities to enrich the knowledge base and assist other similar projects, * Pipeline Development: Designing and maintaining ETL/ELT pipelines to integrate data from diverse sources like Amazon S3, RDS, or external APIs into Redshift.

 * Data Transformation: Utilize Redshift Stored Procedure to Extract Load and transform data.
 * Logic Encapsulation: Writing Redshift Stored Procedures (using PL/pgSQL) to group multiple SQL statements into a single unit, ensuring they succeed or fail as an atomic transaction.
 * Orchestration: Automate workflows using AWS Step Functions or Amazon MWAA (Airflow).
 * Performance Tuning: Optimize Redshift query performance through appropriate distribution styles, sort keys, and compression.
 * Maintenance & Documentation: Support, troubleshoot, and document ETL workflows, including data mapping, transformation rules, and technical designs.

Preferred Skill and Experience

 * Scripting: Strong scripting abilities in Python or UNIX shell for file processing and automation.


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Old tools, new tricks](https://www.wearedevelopers.com/videos/1916-old-tools-new-tricks)
- [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Diagnostic Tooling: How to get insights from your .NET services hosted in Kubernetes containers?](https://www.wearedevelopers.com/videos/100188-diagnostic-tooling-how-to-get-insights-from-your-net-services-hosted-in-kubernetes-containers)
- [Intermediate Bitcoin Script](https://www.wearedevelopers.com/videos/25-intermediate-bitcoin-script)

## Related Articles

- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)