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!
**What You-ll Do**
+ As an Informatica Developer at Sogeti you will have the opportunity to:
+ 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)
**Minimum 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 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
+ 1+ years of 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
+ Detailed Financial Services industry experience
+ Experience working on an agile project team and agile methodologies
+ Experience with XML
+ Exposure to Mainframes/Cobol data formats desirable
+ Experience with MQ Series
+ Experience with Web Services
**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
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.