Consultant/Senior Consultant - QA

Location: USA- Pittsburgh

Job Type: Full-time

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

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.