ETL Tester at IQVIA in Gurugram, Haryana, India

ETL Tester Location: Gurugram, India Role Overview: We are seeking a skilled QC Resource to join our team. As an ETL Tester, you will play a crucial role in ensuring the quality and accuracy of our data processing pipelines. Your responsibilities will include validating data sources, executing test cases, troubleshooting defects, and collaborating with development teams. If you have a strong background in ETL testing, SQL, Python, and ADF, we’d love to hear from you! Responsibilities: ETL Testing: Validate data sources, ensuring accurate extraction, transformation, and loading processes. Create and execute System Integration Test (SIT) plans and test cases. Review data models, mappings, and architectural documentation. Run queries in the database to verify results against expectations. Troubleshoot erroneous results and log defects in HP Quality Center/ALM. Collaborate with development teams to resolve software-related defects. Strong knowledge on Python automation for ETL testing. Technical Skills: Proficiency in any ETL tools like SSIS,Informatica,Abinitio and ADF. Strong experience with SQL for data validation and comparison. Good experience on Python. Experience in using python automation for ETL testing. Understanding of Robot Framework or any BDD Framework and API Testing. Knowledge of both dimensional modeling and data warehouse concepts (star schemas, snowflakes, dimensions, facts). Exposure on testing concepts like STLC, Defect management, Test scenario/test case design etc. Exposure to risk frameworks and mitigation strategies. Exposure to SCD Concepts. Experience with Selenium, basics of java and pyspark is a plus. Qualifications: Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, or related fields. Certifications such as CSTE (Certified Software Tester) or ISTQB (International Software Testing Qualifications Board)  is a plus. Desired Traits: Detail-oriented with strong analytical skills. Excellent communication and collaboration abilities. Passion for ensuring data quality and system reliability. Company Culture: Our company values innovation, teamwork, and continuous learning. We encourage creativity and provide opportunities for professional growth. IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism. Additional Locations: Bangalore, India