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:

• As an 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)
• Lead the development and customization of applications and function as a team lead with supervisory responsibilities
• Manage the creation of complex SQL code and mappings to extract, transform, and load data ensuring compatibility with all tables and users specifications
• Work with various levels of project managers, data modelers, software developers, and system administrators to design load processes and identify potential problem areas in source systems
• Solve data integrity issues and ensure timely data availability.
• Lead the creation, execution, and organization of sessions, monitoring load times and rearranging processes to increase the efficiency and effectiveness of the loading process
• Perform data load monitoring and problem resolution;take action to resolve recurring issues.
• Analytical and logical thinking to create and modify process flows - adaptable in communication style to reflect the audience (executive vs developer)

Education Qualification:

• A four-year CollegeDegree in Business or Information Systems is required.

The ideal candidate will have:

• 7+ years of experience in the IT field, with at least five years in a programming capacity
• Solid understanding of programming, database, system design, and conditional logic
• Ability to design, code, test, and debug
• Experience designing and implementing a minimum of 2 end-to-end project implementations using Informatica PowerCenter
• Strong development skills using Informatica PowerCenter
• Experience analyzing data, developing data mapping requirements, or equivalent knowledge
• Core competency in:ETL tools (Informatica), Relational DBMS (Oracle, SQL Server)
• Competent level of understanding of SQL, PL/SQL, SSIS, Stored Procedures, and API's of assigned modules
• Strong oral and written communication skills are required
• Excellent critical thinking skills
• Ability to drive assignment through to completion, including interactions with 3rd party vendors
• Ability to give direction, with experience guiding other team members and coordinating 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/Vision Coverage!
• Bonus Program that pays up to $24,000!
• $12,000 in Tuition Reimbursement
• 100% Company-paid mobile phone plan
• Personal Time Off (PTO)- Ensuring a balance of work and home life