QA Engineer with ETL and SQL

Job Title: QA Engineer with ETL and SQL
Location: NJ, NY, PA
Experience Required: 10+ years

Job Description

We are seeking a highly skilled and experienced QA Engineer with ETL and SQL expertise to join our team. The ideal candidate will have over 10 years of experience in QA testing, specifically in data integration and ETL processes. The QA Engineer will be responsible for ensuring the quality and reliability of data pipelines, ETL workflows, and SQL-based applications while collaborating with cross-functional teams to deliver high-quality solutions.

Key Responsibilities:

• Design, develop, and execute test strategies, test plans, and test cases for ETL processes, data integration pipelines, and SQL-based systems.
• Perform functional, regression, integration, system, and performance testing for ETL and data-driven applications.
• Validate data transformation, mapping, and migration processes to ensure accuracy and completeness.
• Test ETL workflows and ensure they meet business and technical requirements.
• Conduct data validation across multiple data sources, databases, and systems.
• Perform data profiling and ensure data quality standards are met.
• Work closely with Data Engineers to debug and resolve issues in ETL workflows.
• Develop complex SQL queries to validate data, transformations, and reporting accuracy.
• Perform back-end database testing and ensure data integrity.
• Analyze large datasets and validate against business requirements.
• Validate stored procedures, triggers, and views for performance and accuracy.
• Develop and maintain automated test scripts using tools like Selenium, JUnit, or similar frameworks.
• Implement test automation for ETL and SQL validation to streamline testing processes.
• Integrate automation testing with CI/CD pipelines for continuous testing.
• Document and track defects using tools like JIRA, HP ALM, or similar platforms.
• Work with development teams to resolve defects and retest fixes.
• Prepare detailed test summary reports and communicate findings with stakeholders.
• Collaborate with business analysts, developers, and data engineers to understand requirements and define test strategies.
• Provide feedback and recommendations for process improvements in QA and testing workflows.
• Participate in Agile ceremonies such as sprint planning, daily stand-ups, and retrospectives.

Required Skills and Experience:

• Strong experience with ETL tools such as Informatica, Talend, Datastage, or similar.
• Proficiency in validating data transformation, data mapping, and data workflows.
• Expert-level knowledge of SQL for querying, validating, and manipulating data.
• Hands-on experience with relational databases such as Oracle, SQL Server, MySQL, or PostgreSQL.
• Experience with QA tools such as Selenium, JIRA, HP ALM, TestNG, or similar platforms.
• Proficiency in creating and maintaining test plans and test scripts.
• Familiarity with data warehouse concepts, BI tools, and reporting systems (e.g., Tableau, Power BI).
• Understanding of data modeling and schema validation.
• Experience with Python, Java, or Shell scripting for automation and testing.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal abilities.
• Detail-oriented with a focus on delivering high-quality results.

Preferred Qualifications:

• Experience working in the banking or financial services industry.
• Knowledge of Agile/Scrum methodologies.
• Hands-on experience with cloud platforms such as AWS, Azure, or GCP.
• Familiarity with DevOps practices, including CI/CD pipelines and tools like Jenkins.