17 Sep
|
NexionPro Services
|
Karnataka
17 Sep
NexionPro Services
Karnataka
Position-ETL/Data Warehouse Test Automation Engineer
Location- Bangalore/Chennai/Hyderabad
Experience: 5–8 Years
About the Role
We're looking for an experienced ETL/Data Warehouse Test Automation Engineer to join our data quality team. This role focuses on validating data pipelines and warehouse solutions in a regulated (GxP) workplace, combining robust SQL and Python-based automation skills with hands-on Computer System Validation (CSV) experience.
What You'll Do
Design and execute test strategies for ETL/ELT pipelines and data warehouse solutions
Perform data validation, reconciliation, and source-to-target testing
Build and maintain automated test scripts using Python for data quality checks
Write and execute complex SQL queries to validate data transformations and business rules
Support Computer System Validation (CSV) activities in compliance with GxP requirements
Ensure traceability, auditability, and documentation standards required in regulated environments
Investigate data discrepancies and defects through root-cause analysis
Explore and apply AI/GenAI tools to enhance test automation efficiency and coverage
Collaborate with data engineers, QA teams, and business stakeholders to ensure release quality
What We're Looking For
5–8 years of experience in ETL/Data Warehouse testing and test automation
Strong SQL skills, including complex queries, joins, and data validation logic
Proficiency in Python for building test automation frameworks
Hands-on experience with data validation, reconciliation, and data completeness checks
Experience with GxP-regulated environments and Computer System Validation (CSV)
Practical exposure to AI/GenAI tools in a QA/testing context (e.g., AI-assisted test automation)
Strong analytical and problem-solving skills
Ability to work independently in an Agile environment
Positive to Have
Experience with ETL tools (Informatica, dbt, Azure Data Factory, etc.)
Familiarity with cloud data warehouses (Snowflake, BigQuery, Redshift)
Exposure to test management tools (JIRA, QTest, etc.)
Pharma/Life Sciences domain experience
📌 Test Automation Specialist Karnataka
🏢 NexionPro Services
📍 Karnataka