Senior ETL/Data Integration Quality Assurance Analyst

Job Title: ETL / Data Integration Quality Assurance Analyst

Location: [“Remote”]

Employment Type: Contract

Department: Data & Analytics / Quality Assurance

Reports To: QA Lead or Data Engineering Manager

Position Summary

The Quality Assurance Analyst (ETL/Data Integration) is responsible for developing, executing, and maintaining quality assurance standards across data integration and ETL processes within the organization. This role requires strong technical expertise in data testing, cloud environments, and ETL tools, as well as the ability to coordinate testing activities across distributed teams. The ideal candidate has a deep understanding of backend data validation, data warehouse structures, and testing lifecycles, with a focus on ensuring data quality, consistency, and performance.

Key Responsibilities

Test Strategy and Planning (≈ 80%)

• Design, develop, and execute comprehensive test cases and test plans to ensure appropriate test coverage.
• Perform backend data validation, data mining, and data quality analysis using SQL.
• Conduct ETL and data integration testing to validate data extraction, transformation, and loading processes.
• Log, track, and manage defects through the testing lifecycle, ensuring timely resolution.
• Develop and maintain automation scripts using Python or similar tools for backend data validation.
• Ensure test activities comply with defined QA standards and best practices.

Test Project Management and Coordination (≈ 5%)

• Estimate and manage effort required for QA activities across assigned projects.
• Lead QA efforts across multiple projects, ensuring consistent quality and process adherence.
• Coordinate and lead defect triage meetings; track issue resolution.
• Serve as QA point of contact in Agile ceremonies and cross-functional meetings.
• Coordinate and communicate with project teams across distributed environments.
• Support User Acceptance Testing (UAT) and user demos as needed.
• Provide recommendations to streamline QA processes and improve efficiency.

Operational Management (≈ 15%)

• Document and communicate QA status reports, test results, and risk assessments.
• Identify risks and lead mitigation planning throughout project lifecycles.
• Troubleshoot and resolve complex software testing issues, using sound judgment within established practices.
• Support UAT activities by assisting with test data creation and validation.

Required Skills and Experience

ETL Testing

• Minimum 4 years of experience in ETL testing and/or development within Information Technology or Software QA.
• Strong understanding of database and data warehouse design; expert-level SQL skills for complex queries.
• Experience using ETL tools such as Informatica, with exposure to cloud environments (e.g., BigQuery, Spanner).
• Proven experience in QA automation for backend and data-centric testing.

Data Integration Testing

• Minimum 4 years of experience testing backend middleware or integration platforms.
• In-depth understanding of relational database design and data flow across systems.
• Experience designing and executing test strategies for data transfer protocols including Siebel, Oracle, SQL Server, FTP, TCP/IP, HTTPS, and Web Services (REST/SOAP).

Preferred / Nice-to-Have Skills

• Experience with performance testing and data throughput validation.
• Exposure to UAT coordination and stakeholder communication.
• Python scripting or automation experience for data validation.
• Strong analytical, communication, and coordination skills in Agile environments.

Education

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).

Key Attributes

• Detail-oriented and analytical mindset.
• Strong ownership of quality processes and outcomes.
• Excellent communication and collaboration skills.
• Ability to lead QA efforts across multiple concurrent projects.