ETL Tester - Python/Automation Testing (6-10 yrs)

Job Title : ETL Testing with Python

Location : Pune, Maharashtra, India

Experience : 6 to 10 Years

Company : RiDiK (A Subsidiary of CLPS, Nasdaq: CLPS) -

Job Description :

RiDiK, a subsidiary of CLPS, is seeking a highly skilled and experienced ETL Testing Engineer with strong Python automation expertise to join our dynamic team in Pune.

This role is crucial for ensuring the quality and reliability of our data pipelines and BI reporting systems.

The ideal candidate will possess a deep understanding of ETL/Data warehousing concepts, strong SQL skills, and a proven track record in developing and implementing robust test automation frameworks using Python.

Responsibilities :

- Design, develop, and deploy scalable and maintainable automation frameworks using Python for ETL, data pipelines, API, and web applications.

- Evaluate and implement appropriate automation tools and technologies to enhance testing efficiency.

- Lead proof of concepts for new automation technologies and strategies.

- Perform comprehensive ETL testing, including data validation, transformation, and loading processes.

- Develop and execute test plans and test cases for data warehousing systems.

- Verify data integrity and consistency across various data sources and targets.

- Conduct thorough testing of BI reports using tools like Tableau or similar, ensuring data accuracy and presentation.

- Write and interpret complex SQL queries for data validation and manipulation.

- Utilize SQL to perform in-depth database testing on systems like Vertica, Oracle, and Teradata.

- Develop and maintain SQL scripts for test data setup and validation.

- Design and execute API tests to ensure the functionality and reliability of data-related APIs.

- Utilize test management tools like HP Quality Center and JIRA for test planning, execution, and defect tracking.

- Generate comprehensive test reports and metrics to communicate testing progress and results.

- Work closely with development, architecture, and infrastructure teams to ensure seamless integration of testing processes.

- Participate in Agile/Scrum ceremonies and contribute to sprint planning and execution.

- Communicate effectively with stakeholders to address testing-related issues and provide timely updates.

- Prior experience in testing MLOps systems is highly desirable.

- Exposure to testing ML/AI-based software and data outputs is a significant advantage.

- Knowledge of testing data science projects is an added advantage.

- Working knowledge of AWS is required.

- Proficient experience of working on SDLC & Agile Methodology.

- Strong knowledge of enterprise application architecture and technologies, including databases, web, web services, and reporting.

Required Skills and Experience :

- 7+ years of automation testing experience in a product organization.

- Strong proficiency in Python for test automation.

- Extensive experience in developing automation frameworks for web, data pipeline, and API-based ap-pplications.

- Expertise in test automation frameworks such as JUnit, Selenium, DBUnit, and TestNG.

- Deep understanding of ETL/Data warehousing concepts and testing methodologies.

- Advanced SQL skills with experience in writing and interpreting complex queries.

- Experience in testing databases such as Vertica, Oracle, and Teradata.

- Hands-on experience in BI reporting testing using tools like Tableau.

- Proficiency in API testing.

- Experience with test management and defect tracking tools (HP Quality Center, JIRA).

- Strong understanding of SDLC and Agile methodologies.

- Excellent analytical and problem-solving skills.

- Working knowledge of AWS.

- Immediate joiner candidates are preferred.

Preferred Skills :

- Experience in testing MLOps systems.

- Exposure to testing ML/AI-based software and data outputs.

- Knowledge of testing data science projects.

- Experience in end-to-end automated test case management, reporting and bug tracking.

Education :

- Master's degree in computer science, Information Technology, or a related field.

Why Join RiDiK (CLPS) ?

- Opportunity to work with cutting-edge technologies and contribute to innovative projects.

- Collaborative and supportive work environment.

- Career growth and development opportunities.

- Competitive compensation and benefits package.

- Be a part of a global organization with a strong presence in the technology industry