EvonSys
Consultant/Senior Consultant - QA (Pittsburgh)
EvonSys, Pittsburgh, Pennsylvania, United States, 15289
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: Bachelors 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.
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: Bachelors 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.