Consultant/Senior Consultant - QA

EvonSys; Pittsburgh (Allegheny County); On-site; USD 80,000 - 100,000; Full time

Job summary

A data solutions company is looking for an ETL and Database Tester in Pittsburgh. The role involves validating ETL processes, testing data flow, and ensuring data quality across systems. Candidates should have extensive experience in ETL testing and database testing, strong SQL skills, and familiarity with various ETL tools. This is a full-time position, ideal for those passionate about data integrity and quality assurance.

Qualifications

• Proven experience in ETL testing and database testing.
• Strong knowledge of SQL, able to write complex queries.
• Experience with ETL tools like Informatica, Talend, or SSIS.

Responsibilities

• Validate and verify ETL processes for data accuracy.
• Test ETL pipelines and verify data mapping.
• Develop automated test scripts for ETL and database testing.

Skills

ETL testing

SQL

Database testing

Data validation

Automation testing tools

Analytical skills

Education

Bachelor’s degree in Computer Science or related field

Tools

Informatica

Talend

SQL Server

Oracle

Toad

Selenium

Job description

This role focuses on ETL and database testing to ensure data integrity, accuracy, and performance across systems. Location details are not specified in this description.

Responsibilities

• 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 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

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.