Role Description:
We are looking for a detail-oriented QA Test Engineer with a strong background in ETL, batch job processes, and data warehousing. This role is responsible for ensuring the quality, stability, and efficiency of batch job workflows, ETL pipelines, and related data management processes in a legacy environment. The ideal candidate will have experience with QA methodologies for batch processes, Informatica, PL/SQL development, SQL Server, and data warehousing concepts. The engineer will also be responsible for automating testing processes and ensuring data accuracy across various stages of the ETL pipeline.
Key Responsibilities:
Design, implement, and execute QA testing strategies for ETL processes and batch jobs, ensuring data accuracy and process reliability.
Develop and run test cases for PL/SQL scripts, SQL queries, and Informatica workflows, focusing on data integrity and performance.
Automate test cases for ETL jobs using relevant testing frameworks and tools.
Monitor and validate batch job performance, identifying issues or bottlenecks in legacy systems.
Collaborate with developers to troubleshoot and resolve issues related to ETL job failures, data inconsistencies, or batch process breakdowns.
Perform root cause analysis and regression testing for reported issues, applying corrective actions to ensure no recurrence.
Ensure proper documentation of test cases, results, and issue resolution processes.
Work closely with database administrators to ensure data workflows are maintained with optimal efficiency.
Required Skills and Experience:
At-least 5+ years of hands-on experience with ETL frameworks, specifically Informatica.
Proficiency in SQL Server and PL/SQL scripting.
Strong understanding of data warehousing concepts and ETL pipelines.
Experience in testing, monitoring, and debugging batch jobs in a legacy environment.
Familiarity with QA methodologies, including automation of test cases for ETL jobs and data pipelines.
Strong problem-solving and analytical skills for debugging and improving batch job workflows.
Preferred Qualifications:
Experience with performance tuning of batch jobs and ETL processes.
Knowledge of cloud platforms (e.g., AWS, Snowflake) for data management and testing.
Familiarity with testing tools and frameworks for automating batch job validations.
