AWS Redshift ETL Developer

Infosys; Charlotte (NC); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

Long-term/Short-term Disability

Health and Dependent Care Reim burse.

401(k) plan

Paid holidays and PTO

Job summary

Infosys is seeking a Technology Consultant 2 in the CMT unit to drive data and analytics initiatives, focusing on ETL/ELT pipelines and Redshift development. The role involves collaboration across teams to deliver scalable data solutions for telecom, media, and technology clients.

You will participate in end-to-end SDLC activities, including design discussions, coding, testing, and documentation, ensuring reliability and performance of applications.

Qualifications

• Bachelor’s degree or foreign equivalent; may substitute 3 years of experience for each year of education.
• Relocation and/or travel to work/project location may be required.
• US work authorization without visa sponsorship is allowed; Infosys cannot sponsor now or in the future.

Responsibilities

• Document assigned parts of business requirements and support elicitation.
• Facilitate software design discussions and document decisions for developers.
• Code and integrate new features, maintaining system stability.
• Conduct code reviews and maintain code repositories.
• Implement test strategies and coordinate bug fixes.
• Develop user training, documentation, and support frameworks.

Skills

ETL/ELT pipelines

Redshift stored procedures

SQL optimization

Python scripting

AWS Step Functions

Airflow

Education

Bachelor’s degree or foreign equivalent

Tools

Redshift

S3

RDS

AWS

Job description

Overview

The Infosys Communications, Media, and Technology (CMT) unit is a dynamic and innovative division dedicated to driving digital transformation and growth for clients in the telecommunications, media, and technology sectors. Our vision is to become the strategic and trusted partner for our clients by enabling their digital transformation and growth. We achieve this by leading technological changes. Join us to be part of a team that leverages deep industry insights and strategic leadership to deliver innovation-led transformation through digital, cloud, and AI-first solutions.We are committed to building and nurturing a high-impact partner ecosystem and driving long-term, strategic client relationships.

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

Your Contribution To The Team

• 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.

Required Skill And Experience

• 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.

Additional Required Qualifications

• 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.

Benefits

Along with competitive pay, as a full-time Infosys employee you are also eligible for the following benefits:

• Medical/Dental/Vision/Life Insurance
• Long-term/Short-term Disability
• Health and Dependent Care Reimbursement Accounts
• Insurance (Accident, Critical Illness , Hospital Indemnity, Legal)
• 401(k) plan and contributions dependent on salary level
• Paid holidays plus Paid Time Off

About Us

Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

EEO

Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.