Technical expertise with Azure Data Lake and ETL tools
Proficient in building custom queries for data validation
Familiarity with data validation across multiple formats including JSON and XML
Understanding of performance testing for batch jobs
Bachelor's or Master's degree in a related field
Responsibilities
Lead data testing strategy and execution across various platforms
Develop and implement data test frameworks and scenarios
Validate data accuracy and consistency between systems
Review data mapping documents and business transformation rules
Coordinate data testing activities across systems
Identify defects and manage resolution tracking
Mentor junior data testers and QA resources
Benefits
Flexible work options
401(k) with 150% match up to 6%
Employee Share Ownership Plan
Medical, Prescription, Dental & Vision Insurance
Company-Paid Mobile Phone Plan
3 Weeks PTO + 7 Paid Holidays
Paid Parental Leave
Tuition Reimbursement and access to 20,000+ online courses
Career Planning & Coaching
Well-being support and counseling programs
Full Job Description
Details
About the job:
What you will do at Sogeti:
Lead end-to-end data testing strategy, planning, and execution for data warehouses, data lakes, ETL/ELT pipelines, reporting, and analytics platforms
Define and implement data test frameworks, test scenarios, and validation rules for structured and semi-structured data
Validate data accuracy, completeness, consistency, timeliness, and reconciliation across source-to-target systems
Review and approve data mapping documents, business rules, and transformation logic
Coordinate data testing activities across upstream and downstream systems
Lead defect identification, root cause analysis, prioritization, and resolution tracking
Collaborate closely with Data Engineers, QA teams, Business Analysts, Product Owners, and SMEs
Ensure data testing aligns with regulatory, audit, and governance standards, where applicable
Provide status updates, reporting, and risk assessments to project and program leadership
Mentor and guide junior data testers and QA resources
What you will bring:
Strong data testing experience - Understanding of requirements, data mapping validation, data transformation rules, and downstream validation Technical understanding of the platforms and files - Azure Data Lake, MuleSoft, Databus, handling of different file formats, JSON, XML etc Building custom queries for data validation between different types of sources and target systems Understanding of historical data validation, full data, and incremental data validations Performance testing for batch jobs - Understanding of current state requirements, development of workload models, associated metrics, baseline vs actual comparison reports etc.
Education:
Bachelor's or Master's degree in Computer Science, Software Engineering, Information Systems, Business Administration, or a related field.
Life at Sogeti - Sogeti supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
Counseling & Support for Physical, Financial, Emotional & Spiritual Well-being
Disaster Relief Programs
About Sogeti USA
Sogeti USA is a technology consulting firm that provides a range of services including application development, testing, and infrastructure management. The company is a subsidiary of Capgemini, a global consulting firm headquartered in Paris, France. Sogeti USA has a strong presence in the United States with over 20 offices across the country. The company has a focus on digital transformation and helping clients leverage emerging technologies to drive business value.
