ETL Tester

About Sonata Software

In today's market, we observe a distinct duality in technology adoption. On one front, clients are keenly focused on cost containment, while on the other, there is a strong drive to modernize their digital storefronts, aiming to appeal to both consumers and B2B customers alike.

As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook. In addition, we bring agility and systems thinking to accelerate time to market for our clients.

Headquartered in Bengaluru, India, Sonata Software has a strong global presence, with strategic operations spanning across key regions such as the US, UK, Europe, APAC, and ANZ. We are a trusted partner of world-leading companies in TMT (Telecom, Media, and Technology), Retail & CPG, Manufacturing, BFSI (Banking, Financial Services and Insurance), and HLS (Healthcare and Lifesciences). Our bouquet of Modernization Engineering services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms.

To know more, visit : www.sonata-software.com

If this opportunity aligns with your aspirations, please share your updated profile with Sofia Safa

Job Title : ETL Tester

Location : Hyderabad

Job Summary :

We are seeking a highly experienced QA professional with over 3+ years of experience to join our Quality Assurance team for the data migration project. The ideal candidate will have a strong background in ETL testing, data validation, and migration projects, with expertise in creating test cases and test plans, as well as hands-on experience with data migration to cloud platforms like Snowflake. The role requires leadership capabilities to manage testing efforts, including coordinating with both on-shore and off-shore teams, ensuring seamless collaboration and delivery. Proficiency in ETL tools like Talend (preferred), Informatica PowerCenter, or DataStage is essential, along with a solid understanding of SQL and semi-structured data formats such as JSON and XML.

Key Responsibilities :

• Develop and implement comprehensive test strategies and plans for da ta migration projects, ensuring full coverage of functional and non-functional requirements.
• Create detailed test cases, test plans, and test scripts for validating data migration processes and transformations.
• Conduct thorough data validation and verification testing, leveraging advanced SQL skills to write and execute complex queries for data accuracy, completeness, and consistency.
• Utilize ETL tools such as Talend, Informatica PowerCenter, or DataStage to design and execute data integration tests, ensuring successful data transformation and loading into target systems like Snowflake.
• Validate semi-structured data formats (JSON, XML) , ensuring proper parsing, mapping, and integration within data migration workflows.
• Lead testing efforts for data migration to cloud platforms, ensuring seamless data transfer and integrity.
• Act as the QA Lead to manage and coordinate testing activities with on-shore and off-shore teams, ensuring alignment, timely communication, and delivery of quality outcomes.
• Document and communicate test results, defects, and issues clearly to the development and project teams, ensuring timely resolutions.
• Collaborate with cross-functional teams to create and maintain automated testing frameworks for ETL processes, improving testing efficiency and coverage.
• Monitor adherence to QA best practices and standards while driving process improvements.
• Stay updated on the latest QA tools, technologies, and methodologies to enhance project outcomes.

Qualifications :

Preferred Skills :