ETL Data Testing/ Data Quality Engineer- Databricks

Tredence Inc.; Bengaluru; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A global data science solutions provider is seeking an experienced data testing professional with 8 to 10 years of experience. The role involves leading data and analytics projects, managing testing environments, and ensuring data integrity using Snowflake and Azure technologies. Candidates should hold a bachelor's degree in a relevant field and possess strong SQL skills. The position offers the opportunity to contribute to diverse test scenarios and work with various teams to enhance the testing process.

Qualifications

• 8 to 10 years of experience in leading data & analytics projects.
• Strong SQL skills and familiarity with Azure data warehousing concepts.
• Proven experience in data-centric testing with Snowflake data platforms.

Responsibilities

• Set up and manage unique test environments for each cycle.
• Collaborate with teams to ensure availability and consistency of test environments.
• Design and execute test cases using Snowflake data.

Skills

Software testing

Data-centric testing

SQL skills

Automated scripting

ETL processes

Education

Bachelor's degree in Computer Science, IT, or related field

Tools

Snowflake

Azure

Job description

Tredence is a global data science solutions provider founded in 2013 by Shub Bhowmick, Sumit Mehra, and Shashank Dubey focused on solving the last-mile problem in AI. Headquartered in San Jose, California, with offices in San Jose, Foster City, Chicago, London, and Toronto, the company embraces a vertical-first approach and an outcome-driven mindset to help clients accelerate value realization with the largest companies in retail, CPG, hi-tech, telecom, healthcare, travel, and industrials as our clients.

Job Description

Role requires experience in leading and delivering data & analytics projects covering technology delivery, managing delivery risks and issues, controlling costs, improving ROI and driving value creation.

Experience - 8 to 10 years

• Set up and manage unique and isolated test environments for each testing cycle.
• Collaborate with DevOps and infrastructure teams to ensure the availability and consistency of test environments.
• Implement and maintain environment configurations in alignment with Snowflake testing principles.
• Manage and manipulate test data in Snowflake data warehouses to support various testing scenarios.
• Collaborate with data engineering and data science teams to ensure the availability of realistic and diverse datasets for testing.
• Implement strategies for efficient data extraction, transformation, and loading (ETL) processes for testing purposes.
• Design and execute test cases to validate the functionality and performance of applications using Snowflake data.
• Ensure that tests are independent, isolated, and reflect real-world usage scenarios.
• Collaborate with business analysts and development teams to understand requirements and user stories.
• Develop and maintain automated test scripts for Snowflake testing, incorporating data verification and validation.
• Integrate automated scripts into the continuous integration/continuous deployment (CI/CD) pipeline.
• Collaborate with the Test Automation Engineer to enhance and optimize automated testing processes.
• Identify, document, and track defects, ensuring timely communication with development teams.
• Generate comprehensive test reports highlighting test results, coverage, and any issues found during testing.
• Work with the development team to prioritize and facilitate the resolution of identified defects.
• Collaborate with cross-functional teams, including developers, data engineers, business analysts, and other testers.
• Communicate effectively with team members, stakeholders, and management to provide updates on testing progress and any potential risks.
• Stay informed about Azure platform updates and new features relevant to testing.
• Continuously evaluate and improve testing processes, incorporating industry best practices.
• Contribute to the overall quality assurance strategy and methodology.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience in software testing with a focus on data-centric testing and Snowflake data platforms.
• Strong SQL skills and familiarity with Azure data warehousing concepts.
• Familiarity with Azure Advanced concepts and complete data flow in all layers of Snowflake Cloud.
• Experience with testing tools and frameworks, and proficiency in scripting languages for automation.
• Knowledge of data validation, ETL processes, and data integrity testing.