Akkodis is hiring Datawarehouse Test Engineer role is a Contract 3 months with possible extension with a client located in Wilmington DE 19809 ,Wayne PA, Philadelphia PA Ideally looking for applicants to have a solid background in strong experience in data validation, ETL testing, SQL, and an understanding of data warehousing concepts.(Will get interview if local to Wilmington DE 19809 ,Wayne PA, Philadelphia PA)
Pay Range
$55-60/hr on w2. The pay may be negotiable based on experience, education, geographic location, and other factors.
We are seeking a detail-oriented Data Warehouse Test Engineer to ensure the accuracy, reliability, and quality of enterprise data warehouse and analytical systems. The ideal candidate will have strong experience in data validation, ETL testing, SQL, and an understanding of data warehousing concepts.
You will work closely with data engineers, BI teams, and business stakeholders to validate data across source systems, ETL pipelines, and reporting layers
Key Responsibilities
- Validate data integrity across source systems, ETL jobs, data warehouse, and data mart
- Design, develop, and execute test cases for
- ETL / ELT processes
Key Responsibilities
- Validate data integrity across source systems, ETL jobs, data warehouse, and data marts
- Design, develop, and execute test cases for:ETL / ELT processes
- Data transformations and business rules
- Aggregations and historical data
- Perform data reconciliation and balance checks between source and target systems
- Write and optimize complex SQL queries for data validation
- Test incremental loads, full loads, and CDC processes
- Validate data quality dimensions: accuracy, completeness, consistency, timeliness
- Identify, log, and track defects, work with engineering teams for resolution
- Validate BI reports and dashboards against underlying warehouse data
- Support UAT activities and production data validations
- Contribute to test sign-off and release readiness decisions Required Skills &
Qualifications
- Python and Data Validation Automation is required.
- Strong hands-on experience with Data Warehouse Testing
- Advanced SQL skills (joins, subqueries, CTEs, window functions)
- Data warehousing concepts (fact/dimension tables, star/snowflake schemas)
- ETL/ELT processes
- Experience testing on databases such as: Snowflake, Redshift, BigQuery, Teradata, Oracle, SQL Server (any relevant)
- Familiarity with ETL tools (e.g., Informatica, Talend, Databricks, SSIS, Airflow)
- Experience with data validation automation is a plus (Python, PyTest, dbt tests, etc.)
- Nice to Have:
- Experience with cloud data platforms (AWS, Azure, GCP)
- Exposure to Big Data technologies (Hive, Spark)
- Knowledge of data governance, metadata, and data lineage Education:
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent experience
- If you are interested in this role, then please click APPLY NOW. For other opportunities available at Akkodis, or any questions, feel free to contact me at Sneha.
- Jha@akkodisgroup.com.
- Equal Opportunity Employer/Veterans/Disabled
- Benefit offerings include medical, dental, vision, term life insurance, short-term disability insurance, additional voluntary benefits, commuter benefits, and a 401K plan.
- Our program provides employees the flexibility to choose the type of coverage that meets their individual needs.
- Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State, or local law; and Holiday pays upon meeting eligibility criteria.
- To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.modis.com/en-us/candidate-privacy/Akkodis | Digital Engineering Consulting Leader
- Leading digital engineering consultancy specializing in human-centered AI. Deep expertise in AI, data, cloud & edge computing worldwide.
- Regards,
- Sneha Kumari Jha
- Sr. Recruiter
- T: 610-904-7081E: Sneha.
- Jha@akkodisgroup.com
