Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in noida
>
Neal Analytics
>
ETL Tester

ETL Tester

Neal Analytics

10 - 15 years

4 - 8 Lacs

noida mumbai pune gurugram chennai bengaluru

Posted:1 day ago| Platform:

Apply

Skills Required

manager quality assurance shell scripting informatica selenium test cases oracle ssis testing sql python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Its fun to work in a company where people truly BELIEVE in what they are doing!

Were committed to bringing passion and customer focus to the business.

Job Summary: We are seeking a detail-oriented and experienced Testing Engineer to join our team. The ETL Testing Engineer will be responsible for designing, executing, and automating test cases to ensure the quality and integrity of data extracted, transformed, and loaded into data warehouses and other data repositories. This role involves working closely with developers, data engineers, and analysts to validate data transformations, business rules, and performance across the ETL process.

Key Responsibilities:

ETL Testing:

Design, develop, and execute test cases for ETL processes to verify data extraction, transformation, and loading.
Validate data at different stages (source, transformation, and destination) to ensure the accuracy and completeness of data.
Identify and report data discrepancies, errors, and anomalies during the ETL process, ensuring that they are addressed promptly.
Verify data quality rules, business logic, and mappings used in the ETL processes.

Data Validation:

Perform data validation and reconciliation between source and target systems to ensure data integrity.
Create SQL queries to validate data transformations and conduct data profiling to identify data quality issues.
Validate ETL performance, including the efficiency of data loads and transformations, and ensure that SLAs are met.

Test Automation:

Develop and maintain automated test scripts to streamline the ETL testing process, using tools and frameworks.
Work closely with development teams to integrate automated tests into continuous integration/continuous deployment (CI/CD) pipelines.

Defect Management:

Track, manage, and report defects and issues related to the ETL process using defect management tools.
Collaborate with the development and data engineering teams to resolve issues and ensure that fixes are applied effectively.

Test Planning and Documentation:

Develop detailed test plans, test cases, and test scripts based on business requirements, ETL specifications, and data models.
Document test results, test coverage, and data validation processes to ensure comprehensive testing.
Provide regular updates on test progress, results, and any issues to project stakeholders.

Collaboration:

Work closely with data engineers, developers, business analysts, and QA teams to understand business requirements and technical specifications.
Participate in project meetings, provide input on data quality, and contribute to discussions about ETL process improvements.
Ensure thorough communication with team members to foster a collaborative environment and solve complex data quality issues.

Continuous Improvement:

Continuously review and refine testing processes to improve accuracy, efficiency, and coverage.
Stay up to date with industry trends, best practices, and emerging technologies related to ETL testing and automation.

Qualifications:

Bachelor s degree in Computer Science, Information Systems, or a related field.
10+ years of experience in ETL testing, data quality assurance, or a similar role.
Strong proficiency in SQL for data validation, querying, and analysis.
Hands-on experience with ETL tools (e.g., Informatica , Talend , SSIS , AWS Glue , or similar).
Familiarity with data warehouse concepts, data models, and database management systems (DBMS) such as Oracle , SQL Server , or PostgreSQL .
Experience with test automation tools and frameworks is a plus (e.g., Selenium , JUnit , or custom scripting for data tests).
Strong analytical and problem-solving skills with attention to detail.
Knowledge of CI/CD pipelines and experience integrating testing in DevOps environments is a plus.
Excellent communication and collaboration skills.

Preferred Skills:

Experience working with large-scale data environments, data lakes, or cloud platforms like AWS , Azure , or Google Cloud .
Experience with BI reporting tools like Power BI , Tableau , or Looker .
Knowledge of scripting languages (e.g., Python , Shell scripting ) for test automation.

More Jobs at Neal Analytics

GCP Engineer - Digi Ops

Chennai, Pune, Mumbai, Bengaluru, Gurgaon

3 - 6 yrs

INR 5 - 8 Lacs

Supply Chain Analytics

Bengaluru

3 - 7 yrs

INR 5 - 9 Lacs

Data Engineer/Senior/Architect

Mumbai, Pune, Chennai, Gurugram, Bengaluru

8.0 - 12.0 yrs

INR 25 - 30 Lacs

Senior Consultant-Digital Analytics

Mumbai, Gurugram, Bengaluru

8.0 - 13.0 yrs

INR 25 - 30 Lacs

Senior Data Scientist_Data Scientist

Mumbai, Bengaluru

5.0 - 10.0 yrs

INR 7 - 12 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Neal Analytics

IT Services and IT Consulting

Bellevue Washington

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

ETL Tester