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 QuerySurgetest 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 employeeknown proudly as a ProArchiancan 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 otherevery 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 backorganizing 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 businesseswe'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

ETL Test Engineer

ETL Test Engineer

ETL Test engineer

Senior ETL Test Engineer - SQL Databricks

Etl Test Engineer with Power BI