What are the responsibilities and job description for the AWS Redshift ETL Developer position at Infosys?
Job Description:
⦁ 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 Skills :
• 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 Skills :
• Scripting: Strong scripting abilities in Python or UNIX shell for file processing and automation