ETLTester SQL/Python(Data Quality Engineer)

Skills:

Python, Functional Testing, Advanced SQL, CICD, Selenium, Cucumber, Data Quality Engineer,

Company Overview

EIL Global is a leading IT services provider, headquartered in Adelaide, Australia, with a reach extending across the Asia Pacific and EMEA regions. We deliver comprehensive digital transformation solutions, including AIOPS, AI-based workforce automation, and blockchain solutions. With a focused team of 11-50 employees, we excel in IT infrastructure support encompassing desktops, servers, networks, and data centre technologies.

Job Overview

Experience: 4-8 yearsWork locations: Chennai/PuneWFO: 3 days mandateWe are searching for a Mid-Level ETL Tester SQL Python Data Quality Engineer to join our team in Chennai or Pune. The role requires a minimum of 4-8 years of experience, with a focus on data quality, functional testing, and leveraging advanced SQL skills. The successful candidate will play a vital role in ensuring data integrity and accuracy across our systems. This role mandates on-site work for 3 days a week.

Interview Process

The interview process includes an L1 interview, client interview, DIGI, HR interview, followed by offer and onboarding.

Qualifications And Skills

• Strong proficiency in Python or Java for automating testing processes and scripts (Must have).
• Proven experience in functional testing methodologies to assess the functionality and reliability of software applications (Must have).
• Advanced SQL skills to efficiently extract, manipulate, and validate vast amounts of data (Must have).
• Experience in implementing CI/CD pipelines to streamline software delivery and integration processes.
• Proficient in using Selenium for automated web application testing to ensure high-quality user experiences.
• Hands-on experience with Cucumber for behavior-driven development and automated acceptance testing.
• Strong attention to data quality, ensuring high standards of accuracy and consistency in data management.
• Excellent problem-solving skills to identify, troubleshoot, and resolve complex data quality issues effectively.
  

Advanced SQL Topics

• Window Functions: RANK, DENSE_RANK, ROW_NUMBER, LEAD, LAG, PARTITION BY, ORDER BY, and window frames.
• Common Table Expressions (CTEs): Recursive CTEs and multiple CTEs.
• Subqueries: Correlated subqueries, scalar subqueries, EXISTS and NOT EXISTS.
• Analytical Functions: CUME_DIST, PERCENT_RANK, NTILE.
• Full-Text Search: Full-text indexes, ranking functions, stop words.
• Hierarchical Queries: CONNECT BY PRIOR, START WITH.
• Optimization Techniques: Indexes, query tuning, materialized views.
  

Roles And Responsibilities

• Collaborate with cross-functional teams to understand data requirements and testing needs.
• Conduct thorough functional testing to ensure application performance meets specifications and requirements.
• Utilize Python and SQL to develop robust test scripts and automate data validation processes.
• Implement CI/CD practices to enhance the efficiency and reliability of data integration and deployment.
• Apply Selenium and Cucumber to automate testing procedures and improve test coverage.
• Monitor and maintain data quality standards by identifying discrepancies and implementing corrective actions.
• Document and report on testing activities, results, and findings to relevant stakeholders.
• Continuously improve testing strategies and methodologies for optimal data assurance outcomes.