ETL Tester

Description

Our client is a fast-growing automation-led next-generation service provider delivering excellence in IT, BPO, and consulting services. They are driven by a combination of robust strategies, passionate teams, and a global culture rooted in innovation and automation.

Our client’s Digital offerings have helped clients achieve operational excellence and customer delight. Their focus lies on taking a leadership position in helping clients attain customer intimacy as their competitive advantage. They are now on a journey of metamorphosing the experiences of the customer’s customers by leveraging our industry-leading delivery and execution model, built around the strategy— Automate Everything™, Cloudify Everything™, Transform Customer Experiences™.

Powering our client’s complex technology solutions and services is the Bottom-Up Disruption, a disruptive crowdsourcing initiative that brings about innovation and improvement to everyday complexities and, ultimately, growing the client’s business. The digitally empowered workforce of our client represents various nationalities, comprising 19,833 employees, and lives the company’s philosophy of ‘customer success, first and always’. The company reported a 2020 global revenue of USD $845.04 Mn.

We are currently searching for an ETL Tester:

Responsibilities

• Develop, document, and implement comprehensive test plans and test cases for ETL processes in ADO (Azure DevOps).
• Execute test cases, including functional, integration, system, and performance testing of ETL processes.
• Validate data extraction, transformation, and load processes to ensure data quality and integrity.
• Identify, document, and track defects using Azure DevOps.
• Collaborate with development teams to troubleshoot and resolve issues promptly.
• Conduct root cause analysis of defects and provide recommendations for improvements.
• Work closely with business analysts, data architects, and developers to understand ETL requirements and translate them into test scenarios.
• Participate in requirement review meetings and provide feedback on testability.
• Ensure data accuracy, completeness, and consistency across different stages of the ETL process and Power Platform Applications (Power BI, Power Apps, Power Automate).
• Perform data validation and reconciliation to verify the correctness of data transformations and loads.
• Develop and execute SQL queries to validate data transformations and ensure data integrity.
• Generate and maintain detailed test reports and documentation.
• Provide regular updates on testing progress, issues, and risks to QA Lead.
• Document test results, defects, and corrective actions taken.

Requirements

• Minimum of 8 years in software testing, with significant experience in ETL testing.
• Proven experience in data validation, data reconciliation, and data quality assurance.
• In-depth knowledge of ETL processes, data warehousing, and data integration concepts.
• Strong background in database testing, data validation, and data quality assurance.
• Proficiency in SQL and experience with database testing.
• Familiarity with ETL tools such as Azure ADF, Azure Synapse Analytics, SSIS, or similar.
• Experience with Power BI Testing.

Desired 

• Knowledge of Power Platform application testing is an added advantage.
• Strong problem-solving and analytical abilities.
• Attention to detail and a commitment to quality.
• Excellent communication and interpersonal skills.
• Ability to work effectively in a collaborative team environment.
• Strong organizational and time management skills.

Languages

• Advanced Oral English.
• Native Spanish.

Note:

• Fully remote.

If you meet these qualifications and are pursuing new challenges, Start your application to join an award-winning employer. Explore all our job openings | Sequoia Career’s Page: https://www.sequoia-connect.com/careers/.