AWS Redshift ETL Developer

Responsibilities 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 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 #J-18808-Ljbffr Infosys