ETL Data Testing/ Data Quality Assurance Engineer- Databricks

About the company:

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.

Roles & Responsibilities

Experience- 8 to 14 years

immediate Joiners preferred

Job Location- Bengaluru, Pune, Chennai, Gurugram, Kolkata

Mandate Skills- Data Pipeline Testing, SQL queries, Python, Azure Databricks

• 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.