What are the responsibilities and job description for the Informatica workflow Tester position at Infinite Computer Solutions?
Skill : Informatica ETL Tester
Location : Berkeley Heights, NJ(Onsite)
No of position : 5
We are seeking a highly skilled and detail-oriented Senior ETL Tester with expertise in Informatica IDMC testing, SQL, Snowflake (or similar RDBMS), and Control-M job scheduling. The ideal candidate will be responsible for validating ETL processes, ensuring data integrity, and supporting end-to-end testing of data pipelines in a dynamic and fast-paced environment.
Key Responsibilities :
- Develop, execute, and maintain test plans, test cases, and test scripts for ETL processes using Informatica (IDMC).
- Validate data transformations, mappings, and workflows against business requirements and technical specifications.
- Write, execute, and debug SQL queries to verify data accuracy and integrity across various databases, including Snowflake or other RDBMS.
- Perform data validation testing to ensure accuracy, completeness, and compliance with requirements.
- Schedule, monitor, and execute ETL jobs using Control-M, ensuring job dependencies and timing requirements are met.
- Collaborate with data engineers, developers, and analysts to identify and resolve ETL and data quality issues.
- Perform root cause analysis on data discrepancies and provide recommendations for improvements.
- Document testing processes, results, and defects while ensuring proper traceability and audit readiness.
Required Qualifications :