ETL Test Engineer

About ProArch:

Founded in 2006, ProArch began as a tight-knit team of business-minded IT professionals passionate about delivering exceptional cloud-based technology solutions. Today, we’ve grown into a global force spread across US, UK and India into multidisciplinary experts spanning cloud, infrastructure, data analytics, cybersecurity, compliance, and software development. Organizations turn to ProArch for forward-thinking guidance, seamless implementation, and dependable ongoing support partnering with us to reach every milestone on the path to their vision.

Our services consist of specific practice areas that are methodically designed to complement and enhance each other's effectiveness. This interconnected approach removes roadblocks and drives rapid growth and financial stability. Many of our clients leverage the full scope of our services, creating a supply chain of value that impacts the entire organization from IT to customer experience.

At our core, we believe in the power of technology to transform. We’re passionate about inspiring innovation that shapes our people, our clients, our partners, and the communities we serve.

Position Overview:

We are seeking an experienced ETL Test Engineer with strong hands-on expertise in QuerySurge, SQL, and end-to-end data validation across complex data pipelines. The ideal candidate will be responsible for validating data flows, ensuring data accuracy, and developing automated data testing assets using QuerySurge and other QA tools.

Requirements

ETL / Data Validation

• Perform end-to-end ETL testing across multiple data sources, staging layers, data warehouses, and reporting systems.
• Validate data transformations, business rules, and mappings from source to target.
• Review and analyse ETL requirements, mapping documents, and architecture diagrams.
• Design and execute complex SQL queries to validate data accuracy, completeness, and reconciliation.
• Conduct regression, functional, and integration testing of ETL workflows.
• Identify data anomalies, mismatches, transformation gaps, and document defects.

QuerySurge Automation (Primary Responsibility)

• Build and maintain Query Surge scenarios, test suites, and data verification scripts.
• Configure QuerySurge connections, drivers, test queries, and execution agents.
• Develop automated data validation workflows and integrate them within CI/CD pipelines.
• Troubleshoot QuerySurge agent issues, drivers, environment variables, and connectivity.
• Analyse QuerySurge test results, generate defect summaries, and integrate outcomes with Jira, Jenkins, Azure DevOps, etc.
• Implement QueryPairs and reusable automation components for scalable data testing.

Quality Engineering & Documentation

• Create test plans, test cases, and traceability matrices for ETL scenarios.
• Collaborate with data engineers, developers, BAs, and architects to clarify transformation logic.
• Provide detailed defect reports with SQL evidence, logs, screenshots, and expected vs actual results.
• Participate in requirement walkthroughs, design reviews, stand-ups, and other Agile ceremonies.

CI/CD & Automation Integration (Preferred)

• Integrate Query Surge test suites with Jenkins, Azure DevOps, GitHub Actions, or similar tools.
• Use APIs, REST endpoints, or Query Surge CLI for automated test execution.
• Contribute to improving automation coverage and enhancing data quality frameworks.

Required Skills & Experience

• 3–7 years of experience in ETL, Data Warehouse, or BI testing.
• Strong hands-on expertise in QuerySurge—test suite creation, execution, debugging, agent configuration, and connectivity setup.
• Strong SQL proficiency (joins, aggregations, window functions, complex queries).
• Experience testing data workflows built using tools such as Informatica, Talend, SSIS, ADF, Snowflake Pipelines, etc.
• Experience with relational databases (SQL Server, Oracle, MySQL, PostgreSQL) and cloud data platforms (Snowflake, Redshift, BigQuery).
• Familiarity with defect tracking tools (Jira, Azure Boards, QC).
• Understanding of data modelling concepts: Star Schema, SCDs, Fact/Dimension tables.
• Strong analytical and communication skills for reporting data issues to engineering teams.

Life @ ProArch

• At ProArch, we believe our people are the key to our success. That’s why we foster an environment where every employee—known proudly as a ProArchian—can grow, thrive, and make a meaningful impact.
• We empower employees to develop at their own pace through Career Pathways, a clear and supportive guide to professional progression.
• Our culture is one of positivity, inclusivity, and respect. Titles don’t define how we treat each other—every ProArchian is valued equally, and collaboration across roles and teams is the norm.
• We understand that great work starts with balance. That’s why we prioritize work-life harmony, offering flexible work schedules and encouraging time for what matters most.
• Beyond the workplace, ProArchians actively give back—organizing volunteer efforts and charitable initiatives that empower the communities we call home.
• And because we know that extraordinary efforts deserve recognition, we celebrate those who go above and beyond with appreciation programs.
• At ProArch, we’re not just using technology to transform businesses—we’re using it to create a better experience for our people, our clients, and our communities.

Competencies: 

• Excellent Communication 
• Analytical Skills 
• Negotiation Skills
• Problem Solving Skills 
• Client Engagement
• Relationship Building