Software ETL QA Engineer

Designation - Sr. ETL Test Engineer / Lead ETL Test Engineer

Work Location - Pittsburgh

Candidate Current Location - Pittsburgh (Should be Currently Located or Willing to Relocate to Pittsburgh)

Exp - 5 Years in ETL Testing (Must Have Experience)

Position Overview: We are seeking a highly skilled and motivated Database and ETL Tester to join our team. As a Database and ETL Tester, you will be responsible for validating the integrity, accuracy, and quality of data in both databases and ETL (Extract, Transform, Load) processes. You will ensure that data flows correctly from source systems to target databases and that it meets business requirements, while also ensuring database systems' consistency, performance, and correctness.

Key Responsibilities:

• ETL Testing:
• Validate and verify ETL processes to ensure data extraction, transformation, and loading are done accurately and efficiently.
• Perform testing of ETL pipelines to verify data mapping, transformations, data quality, and integrity.
• Test data flow from source to target databases, ensuring all transformations are correctly applied.
• Ensure that data load jobs are executed successfully without data loss or duplication.
• Database Testing:
• Perform functional, regression, and integration testing of databases to ensure their accuracy, consistency, and performance.
• Develop and execute SQL queries to validate the data loaded into the database and verify it meets specified requirements.
• Verify data integrity and ensure consistency across source and target databases.
• Test database performance under various conditions (e.g., data volume, concurrent users).
• Test Case Design and Execution:
• Design, develop, and execute detailed test cases, test scripts, and scenarios for both ETL processes and database functionalities based on business requirements and specifications.
• Perform data validation and verification using SQL queries, and ensure proper reporting of test results.
• Data Validation:
• Verify that transformed data is correct, meets requirements, and is loaded accurately into target databases.
• Conduct data reconciliation between source and target systems to ensure accuracy during the ETL process.
• Automation Testing:
• Design, develop, and maintain automated test scripts for ETL and database testing.
• Work with test automation tools to increase the efficiency of the testing process.
• Issue Reporting and Tracking:
• Identify, document, and track defects and discrepancies found during testing.
• Collaborate with developers, ETL developers, and business analysts to troubleshoot issues and ensure resolution.

Key Skills and Qualifications:

• Proven experience in ETL testing, database testing, and data validation.
• Strong knowledge of SQL, including the ability to write complex queries for data validation and verification.
• Experience with ETL tools such as Informatica, Talend, SSIS, or similar.
• Familiarity with databases like Oracle, SQL Server, MySQL, PostgreSQL, or NoSQL databases.
• Experience in writing and executing test cases for ETL processes and databases.
• Strong understanding of data warehousing concepts, data modeling, and data flow.
• Practical experience using Toad.
• Knowledge of automated testing tools like Selenium, QTP, or custom scripts for ETL and database testing.
• Strong analytical, problem-solving, and debugging skills.
• Good understanding of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Agile processes.
• Proficient in Excel formulas.
• Strong understanding of banking domain concepts.
• Ability to work independently and collaboratively in cross-functional teams.

Preferred Qualifications:

• Bachelor’s degree in computer science, Information Technology, or related fields.
• Experience with cloud-based databases or ETL tools (e.g., AWS, Google Cloud, Azure).
• Knowledge of Big Data technologies (e.g., Hadoop, Spark) and data lake testing is advantageous.
• 5 years’ experience in database testing

Job Type: Full-time

Location: USA- Pittsburgh

This role provides an excellent opportunity to work on cutting-edge ETL and database technologies while ensuring the integrity and performance of data across systems. If you have a passion for data quality and testing, we invite you to join our team and contribute to the success of our projects.