ETL Tester
Role description
We are looking for a highly technical ETL Tester who comes from a development background and has experience meeting with users, business units and data modeling teams to craft and assemble technical designs for solutions to be implemented. This person will be interacting with both technical and non-technical audiences within an Informatica PowerCenter ETL development environments while providing Production support and defining dataflows.
Job Duties:
· Analyze existing ETL processes, data slows and models to write and create test cases while understanding the business requirement or the downstream process requirements.
· Take source to target DDR and write Test Cases independently while serving as technical liaison between teams regarding new system implementations, development, integration, and changes while collaborating with management to design technical solution.
· Navigate through Flat Files, assist in UAT Testing while understanding the scope of the work and ask clarifications and escalate to the right leads in case of issues/delays.
· Test, debug, and document system and application programs within Informatica PowerCenter solution implementation and support in collaboration with Data Mapper and Data Modeler to test the dataflow and enhance the ETL to fulfill the requirement.
· Prepare test cases and documentation based on functional and technical requirements ensuring adherence to best practices for developing PowerCenter solutions are followed.
· Review functional and technical specifications prepared by vendors.
· Review test scope, test approach/strategies, manage defects closing during the SIT and UAT.
· Liaise with infrastructure team on nonproduction and production infrastructure and environments and other teams involved.
· Provide support in Production for Informatica PowerCenter v8 and up, and fix production defects.
Education & Requirements:
· Bachelor’s Degree is required
· 3+ years’ Informatica PowerCenter ETL testing experience within large data warehouses
· Experience with working on Oracle, SQL Server, PL/SQL and Informatica ETLs is required
· Strong understanding of Control-M Scheduling, Datawarehouse architectural patterns, and batch processes is a must
· Previous experience with Snowflake
· Strong experience of UNIX operating system
Plus:
• Previous experience in banking/financial sectors is a plus