Job Description:

We are seeking a strong ETL Tester with extensive experience in SQL and ETL Testing in large data warehouses. The ideal candidate will possess advanced SQL skills, including complex PL/SQL coding capabilities, and will have a solid background in working with ETL tools and data integration processes.

Key Responsibilities:

• Conduct ETL testing in large data warehouses, ensuring data integrity and accuracy throughout the ETL process.
• Independently write and execute test cases based on Source to Target Data Requirements (DDR).
• Collaborate with team members to understand the scope of work, clarify requirements, and escalate issues or delays to appropriate leads.
• Perform complex SQL queries and develop advanced PL/SQL scripts for testing purposes.
• Navigate and work with flat files and assist in User Acceptance Testing (UAT).
• Utilize Control-M and PowerCenter for ETL job scheduling and data integration tasks.

Core Requirements:

• 7-8 years of experience in SQL and ETL testing in large data warehouse environments.
• Proficient in Informatica IDMC and Snowflake.
• Strong understanding of Unix operating systems and scripting.
• Hands-on experience with Control-M or PowerCenter.
• Excellent communication skills and ability to work independently in a remote environment.