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

Discord

Remote Director of ML Safety & Trust (San Francisco) Job at Discord

 ...A leading company in the tech industry is seeking a visionary Director of Machine Learning for their Trust & Safety team. The role demands extensive experience in ML and data science to innovate and implement scalable solutions that enhance user safety and effectively... 

Amazon

Amazon Delivery Station Warehouse Associate Job at Amazon

 ...Amazon Delivery Station Warehouse Associate Job Overview Youll be part of the dedicated...  ...fast-paced, active roles receive trucks full of orders, then prepare them for delivery....  .... # Noise level. It can get noisy at times. We provide hearing protection if you need... 

Newmark ltd

Appraiser, Senior Job at Newmark ltd

 ...Job Description Appraises real estate properties independently for the purposes of dispute resolution, mortgage underwriting, acquisition/disposition, portfolio analysis, estate purposes and other intended uses. Responsibilities ESSENTIAL DUTIES: Prepare... 

Silver Cross Hospital

Gastroenterologist Job at Silver Cross Hospital

 ...be treated. Summary: Silver Cross Medical Group is seeking a full-time, board-eligible/board-certified (BE/BC) General Gastroenterologist to add to their well-established team servicing the southwest suburbs of Chicago. The Physician will provide medical care in... 

Duly Healthcare

Strategic Executive Assistant to Leadership Job at Duly Healthcare

 ...and interpersonal skills. Candidates must have over 6 years of executive assistant experience and be highly proficient in Microsoft Office tools. The position offers a competitive salary and comprehensive benefits including healthcare, 401(k) matching, and paid...