What are the responsibilities and job description for the Data Warehouse Test Engineer (Contract | Hybrid – Philadelphia Area) position at Soni?
Overview
We are partnering with a client to identify a Data Warehouse Test Engineer for a 3 month contract engagement. This role is responsible for ensuring the quality, accuracy, and integrity of enterprise data warehouse and analytics platforms.
The position follows a hybrid work model, requiring 2–4 days per week onsite in the Greater Philadelphia market. The ideal candidate brings strong experience in data validation, ETL testing, and SQL, along with a solid understanding of modern data warehousing concepts.
Key Responsibilities
We are partnering with a client to identify a Data Warehouse Test Engineer for a 3 month contract engagement. This role is responsible for ensuring the quality, accuracy, and integrity of enterprise data warehouse and analytics platforms.
The position follows a hybrid work model, requiring 2–4 days per week onsite in the Greater Philadelphia market. The ideal candidate brings strong experience in data validation, ETL testing, and SQL, along with a solid understanding of modern data warehousing concepts.
Key Responsibilities
- Validate data accuracy and consistency across source systems, ETL/ELT pipelines, and data warehouse environments
- Design and execute test cases for data transformations, business rules, aggregations, and historical data
- Perform data reconciliation between source and target systems to ensure integrity
- Develop and optimize SQL queries for data validation and analysis
- Validate batch and incremental data loads, including change data capture (CDC) processes
- Assess data quality across key dimensions such as accuracy, completeness, and timeliness
- Identify, log, and track defects, collaborating with engineering teams for resolution
- Validate BI reports and dashboards against underlying data sources
- Support user acceptance testing (UAT) and production validation activities
- Contribute to release readiness and quality assurance processes
- Hands-on experience in data warehouse testing and data validation
- Strong proficiency in SQL (e.g., joins, subqueries, CTEs, window functions)
- Experience testing ETL/ELT processes and data transformations
- Familiarity with data warehouse structures (e.g., fact/dimension models, star/snowflake schemas)
- Experience with relational or cloud-based databases (e.g., Snowflake, Redshift, SQL Server, Oracle, BigQuery, Teradata)
- Experience with Python for data validation/automation (required)
- Familiarity with ETL tools (e.g., Informatica, Talend, SSIS, Databricks, Airflow)
- Strong analytical mindset with high attention to detail
- Ability to work both independently and in cross-functional team environments
- Clear communication skills across technical and business stakeholders
- Exposure to cloud data platforms (AWS, Azure, or GCP)
- Experience with big data technologies (e.g., Spark, Hive)
- Knowledge of data governance, lineage, and metadata management
- Familiarity with Agile/Scrum methodologies and CI/CD pipelines for data workflows
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience)