Capgemini ETL Developer in Kansas City, Kansas
Seeking an ETL Developer to join our team in Kansas City. As an ETL Developer at Sogeti you will assist in the build-out of enterprise data warehouses alongside a data modeler and/or data architect. You'll have the opportunity to:
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 architects and 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).
Bachelor's degree from a 4-year college or university required
US citizen/permanent resident (Sogeti does not sponsor any work visas)
The ideal candidate will have:
3+years of experience performing ETL in an EDW environment
Big data experience/knowledge strongly preferred
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 or IBM Infosphere Datastage
Strongdevelopment skills using Informatica PowerCenter or IBM Infosphere Datastage
Experience analyzing data, developing data mapping requirements,or equivalent knowledge
Corecompetency in:ETL tools (Informatica, Datastage), 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
Some benefits our employees enjoy:
401(k) Savings Plan - 150% match of up to 6% base salary
Health insurance coverage with extremely low premiums
Bonus Program that can pay up to $24,000 a year
$12,000 in education reimbursement
15 days PTO plus 7 paid holidays
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!
Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled