Capgemini Informatica Application Integration Lead/Architect in Des Moines, Iowa

Informatica Application Integration Lead/Architect

Sogeti USA is looking for an Informatica Applicaion Intergration Lead/Architect to join our team in Des Moines, Iowa. This opportunity is a full time position with Sogeti USA part of Capgemini. At Sogeti, you will have great benefits, great growth opportunity and career development.

What You-ll Do:

  • Asan Informatica Lead/Architect at Sogeti you will have the opportunity to:

  • Lead an offshore team and coach/mentor team.

  • Technical skills used- Informatica Intelligent Cloud Services, ApplicationIntegration, API Management, Secure Agent, Cloud API Gateway, IICS

  • PowerCenter (ETL)

  • MDM (nice tohave)

  • Service Management (Production Support, Dashboards, Monitoring, Alerts)

  • Leadthe development and customization of applications and function as a teamlead with supervisory responsibilities

  • Managethe creation of complex SQL code and mappings to extract, transform, andload data ensuring compatibility with all tables and users specifications

  • Workwith various levels of project managers, data modelers, softwaredevelopers, and system administrators to design load processes andidentify potential problem areas in source systems

  • Solvedata integrity issues and ensure timely data availability.

  • Leadthe creation, execution, and organization of sessions, monitoring loadtimes and rearranging processes to increase the efficiency andeffectiveness of the loading process

  • Performdata load monitoring and problem resolution;take action to resolve recurringissues.

  • Analyticaland logical thinking to create and modify process flows - adaptable incommunication style to reflect the audience (executive vs developer)

Education Qualification:


A four-year College Degree in Business or Information Systems is required.

The ideal candidate will have:

  • 7+years of experience in the ITfield, with at least five years in a programming capacity

  • Solidunderstanding of programming, database, system design, and conditionallogic

  • Abilityto design, code, test, and debug

  • Experiencedesigning and implementing a minimum of 2 end-to-end projectimplementations using Informatica PowerCenter

  • Strongdevelopment skills using Informatica PowerCenter

  • Experience analyzing data, developing data mapping requirements,or equivalent knowledge

  • Corecompetency in:ETL tools (Informatica), Relational DBMS (Oracle, SQLServer)

  • Competentlevel of understanding of SQL, PL/SQL, SSIS, Stored Procedures, and API'sof assigned modules

  • Strongoral and written communication skills are required

  • Excellentcritical thinking skills

  • Abilityto drive assignment through to completion, including interactions with 3rdparty vendors

  • Abilityto give direction, with experience guiding other team members andcoordinating offshore teams

Sogeti is a leading provider of IT projects and managed services specializing in Applications and New Technology, Infrastructure and Cloud Services, Business Intelligence &Analytics, Digital Transformation and Mobility and Product Life Cycle Management, combining world class methodologies and its global delivery model, Rightshore®. Sogeti brings together more than 30,000 professionals in 20 countries and has a strong local presence in over 100 locations in Europe, USA and India. Sogeti USA is the technology and engineering services division of Capgemini America, Inc. of Capgemini SE, 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!

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!)

  • Medical/Prescription/Dental/VisionCoverage!

  • BonusProgram that pays up to $24,000!

  • $12,000in Tuition Reimbursement

  • 100%Company-paid mobile phone plan

  • PersonalTime Off (PTO)- Ensuring a balance of work and home life

Sogeti 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.