ETL Tester IRC282631

Description

We are looking for a Senior ETL Tester with 6+ years of experience who views data quality through the lens of a software engineer. In this role, you will move beyond manual spreadsheet comparisons to design, build, and maintain robust, automated testing frameworks that ensure the absolute integrity, performance, and reliability of our data pipelines.

You will act as the ultimate gatekeeper of data quality. Working alongside Data Engineers and Analytics teams, you will leverage Python and advanced SQL to validate complex ELT/ETL transformations, verify large-scale cloud data migrations, and profile data structures. If you are passionate about treating data quality as code and implementing automated data assurance at scale, this role is for you.

Requirements

• Experience: 6+ years of hands-on experience in Data Quality Assurance, ETL Testing, or Data Analytics Engineering.
• Python Mastery for Testing: Proven track record of using Python to manipulate data (e.g., Pandas), call APIs, parse files (JSON, CSV, Parquet), and build automated test scripts.
• Expert-Level SQL: Exceptional ability to write, debug, and optimize complex SQL queries for massive datasets in modern cloud data warehouses.
• Data Architecture Knowledge: Strong conceptual understanding of data warehousing concepts, including Dimensional Modeling, Slowly Changing Dimensions (SCD), and ETL architectures.
• Agile Mindset: Comfortable operating in fast-moving, Agile team setups, utilizing Jira for sprint planning and Git for version control.
• Communication Skills: Ability to clearly explain data discrepancies, pinpoint root causes within complex pipeline steps, and present data-driven quality metrics to technical and business stakeholders.
  
  

Job responsibilities

• Test Automation & Frameworks: Design, develop, and scale end-to-end automated testing frameworks using Python and Pytest to validate data ingestion, transformation, and storage processes.
• ETL/ELT Validation: Write complex SQL scripts to verify data completeness, correctness, transformations, and business logic mapping between source systems and target data warehouses.
• Data Profiling & Quality: Implement data quality gates, schema validation checks, and data profiling metrics using programmatic tools (e.g., Great Expectations).
• Regression & Performance Testing: Conduct performance, scalability, and stress testing on data pipelines to identify bottlenecks in query execution and data throughput.
• CI/CD Integration: Embed automated data quality tests into CI/CD pipelines (e.g., GitHub Actions, GitLab CI/CD) and workflow orchestrators (e.g., Airflow, dbt) to catch data issues before they hit production.
• Collaboration & Defect Management: Partner closely with Data Engineers, Product Managers, and BI teams to analyze data requirements, trace data lineage, and log/track software bugs and data anomalies.
  
  

What we offer

Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.

Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!

Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.

Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.

Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.

Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!

About GlobalLogic

GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world's largest and most forward-thinking companies. Since 2000, we've been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.