EvonSys · 1 week ago
Software ETL QA Engineer
Pittsburgh, PA
Full-time
Onsite
Senior Level
5+ years expEvonSys is seeking a highly skilled and motivated Database and ETL Tester to join their team. The role involves validating the integrity, accuracy, and quality of data in ETL processes and databases, ensuring data flows correctly from source systems to target databases while meeting business requirements.
ComputerRoboticsSoftware
Hiring Manager
Vijaya Emani
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
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)
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
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
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
Identify, document, and track defects and discrepancies found during testing
Collaborate with developers, ETL developers, and business analysts to troubleshoot issues and ensure resolution
Qualification
Required
5+ Years in ETL Testing (Must Have Experience)
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
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
Company
EvonSys
EvonSys is a global leader in Digital Transformation solutions to businesses worldwide with the power of low code solutions.
201-500 employees
H1B Sponsorship
EvonSys has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (23)
2024 (25)
2023 (13)
2022 (6)
2021 (17)
2020 (21)
Funding
Current Stage
Growth StageTotal Funding
$0.03M2022-12-15Seed· $0.03M
Leadership Team
Arun MS
Founder & CEO
Punna Paramasivan
Chief Strategy Officer
Recent News
2025-03-26
2025-02-21
Company data provided by crunchbase