ETL Developer

• Strong experience in design and implement data pipelines
• Strong PL/SQL and SQL skills in relational database environment
• Strong Unix shell scripting skills
• Create and review technical design documents, understand how the design will be used in the code development process, and facilitate meetings to design, troubleshoot, and execute projects
• Participate in walkthrough reviews of technical specifications, programs, code, and unit test plans
• Plan design/implementation activities, ensure technical solution quality, provide third-level support for various technologies, and drive technical platform evolution and improvements
• Present technical topics at regular team meetings and manage low-level planning of work packages
• Estimate activities/tasks required to perform design, coding, and unit testing
• Excellent interpersonal and highly developed communication skills (verbal and written)
• Ensure ETL pipelines are produced with the highest quality standards, metadata and validated for completeness and accuracy
• Work closely with development teams to learn about needs, current processes and to promote best practices.
• Knowledge of the Software Development Life Cycle (SDLC) - Agile, Waterfall, and Iterative methods
• Working knowledge GitHub, CI/CD Pipeline

Must Have:

• 5+ years of experience working in complex and time-sensitive development environment
• Extensive hands-on experience in ETL data-stage / Informatica
• Extensive hands-on complex SQL experience (MSSQL Server, Teradata)
• Extensive experience in creating stored procedure and Unix shell scripting
• Support at-scale testing to enable simulations, UAT and reporting