ETL Test Lead Job at Sogeti, Saint Paul, MN

dG00SGFzcGVzZUdjMW1QOVpvZGFvTSt2Y0E9PQ==
  • Sogeti
  • Saint Paul, MN

Job Description

Direct message the job poster from Sogeti Talent Acquisition @ Sogeti USA, part of Capgemini Sogeti is a leading provider of professional technology services, specializing in Application Management, Infrastructure Management and High-Tech Engineering. Sogeti offers cutting-edge solutions around Testing, Business Intelligence, Mobility, Cloud and Security, combining world-class methodologies and the global delivery model, Rightshore. Sogeti brings together more than 20,000 professionals in 15 countries and is present in over 100 locations in Europe, the US and India. Sogeti is a division of Capgemini S.A., listed on the Paris Stock Exchange. At Sogeti USA, we are committed to building a long and enduring relationship with our employees and to creating an environment that rewards and empowers. Our mission is to constantly exceed our employees' expectations in the same way that we strive to exceed our clients' expectations. We offer an environment that celebrates innovation and helps you to achieve a good balance between your professional and personal life. We strive to be an employer of choice! NOTE: This is a FULL-TIME position with Sogeti. Candidates looking for contract work need not apply. We are seeking a highly skilled and experienced Data Test Lead to join our team in the health insurance sector. The successful candidate will be responsible for managing a team of 3-4 offshore data testers and ensuring the quality and accuracy of our data processing systems. This role requires a strong background in ETL tools, SQL scripting, and data testing. Key Responsibilities: Lead and manage a team of 3-4 offshore data testers, providing guidance, support, and mentorship. Develop, execute, and maintain complex SQL scripts to validate data transformations and ensure data integrity. Utilize Informatica as the primary ETL tool, with a future transition to Azure Data Factory (ADF). Design and implement test strategies, plans, and cases for data validation and ETL processes. Conduct thorough testing of data pipelines, including data extraction, transformation, and loading (ETL) processes. Ensure compliance with data quality standards and regulatory requirements. Collaborate with cross-functional teams, including data engineers, analysts, and business stakeholders, to understand data requirements and deliver high-quality solutions. Utilize QuerySurge for automated data testing and validation. Test and validate health insurance claims data to ensure accuracy and compliance. Qualifications: Bachelor's degree in Computer Science, Information Technology, or a related field. Proven experience as a Data Test Lead or similar role in the health insurance industry. Strong proficiency in SQL scripting and complex query development. Extensive experience with Informatica and Azure Data Factory (ADF). Hands-on experience with Right Data for data testing and validation. Familiarity with health insurance claims data and testing processes. Excellent analytical and problem-solving skills. Strong leadership and team management abilities. Effective communication and collaboration skills. Preferred Qualifications: Experience with other ETL tools and data testing frameworks. Knowledge of data governance and regulatory compliance in the health insurance industry. Certification in Informatica, Azure Data Factory, or related technologies. The benefits our employees enjoy: 401(k) Savings Plan- Matched 150% up to 6%. (Our 401k is in the top 1% of 401(k) plans offered in the US!) $12,000 in Tuition Reimbursement Personal Time Off (PTO)- Ensuring a balance of work and home life Life at Sogeti We support all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: Healthcare including dental, vision, mental health, and well-being programs Financial well-being programs such as 401(k) (matched 150% up to 6%) and Employee Share Ownership Plan 3 weeks Personal Time Off (PTO) and 7 Paid Holidays Paid parental leave Family building benefits like adoption assistance, surrogacy, and cryopreservation Social well-being benefits like subsidized back-up child/elder care and tutoring Mentoring, coaching and learning programs Continuing Education: $12,000 Annual Tuition Reimbursement plus access to over 20,000 online courses and certifications through Capgemini University, as well as Coursera and Degreed. Programs for Counseling, Support, Health and Fitness perks, Auto discounts and much, much more! Employee Resource Groups Disaster Relief Disclaimer Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law. Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini. #J-18808-Ljbffr Sogeti

Job Tags

Holiday work, Full time, Contract work, Work from home, Offshore,

Similar Jobs

Creativefuego

4 months ago Pulley Marketing Manager, Crypto global 5+ experience (San Francisco) Job at Creativefuego

 ...the long term. With Pulleys cap table management tools, companies can better understand and...  ...to meet the demand. We are seeking a Marketing Manager for our Crypto offerings. This...  ...impact and prioritization. We are a remote-first team with an office in San Francisco... 

Home Health Care, Inc.

Shift Lead CNA - Evenings/Overnights Job at Home Health Care, Inc.

 ...Job Title: Lead Caregiver Company: Sunflower Communities Position Type: Full-Time (Evenings, and Overnights) Compensation: $23 - $30 per hour + shift Differential Successful applicants will email Nikky at ****@*****.*** explaining... 

TrackFive

Physician (MD/DO) - Nephrology in Mountain Home, AR Job at TrackFive

LocumJobsOnline is working with Adelphi Medical Staffing to find a qualified Nephrology MD in Mountain Home, Arkansas, 72653!About The PositionJOB OVERVIEW Job Title: NephrologistJob Type: Permanent (Full-Time)Location: Mountain Home, ARService Setting: Inpatient and... 

Milestone Therapy

Occupational Therapist or COTA Specializing in Pediatrics Job at Milestone Therapy

Milestone Therapy has an immediate opening for a full-time and/or part-time Pediatric Occupational Therapist or Certified Occupational Therapy Assistant. Milestone Therapy provides pediatric Physical Therapy, Occupational Therapy and Speech Therapy. Our therapists provide... 

TalentSphere Staffing Solutions

Kitchen Designer Job at TalentSphere Staffing Solutions

Kitchen Designer Sales Expert"Unlock Your Earning Potential: Join Our Clients Team as a Kitchen Designer in Baltimore, MD!"$60,000- $65,000 salary base + commissionLocation: Lansing, MichiganJoin our client a premium windows, doors, kitchens, and interior solutions...