Capgemini ETL Developer in Chicago, Illinois

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 wholly-owned subsidiary of Cap Gemini 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!

What You-ll Do

The ETL Developer will collaborate with Data Architect and internal stakeholders. Understand and translate business requirements into data analysis and mapping as well as integration routines involving moving, cleansing and transforming large amounts of data between multiple systems. This includes Identifing data sources, providing data flow diagrams and document source to target mapping and processes.

Day to Day Responsibilities:

  • Design and development of large complex ETL jobs.

  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.

  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, etc.

  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.

  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.

  • Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques

Desired Skills &Experience:

  • 7+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).

  • 5+ Years in BI development leveraging the Microsoft SQL Server

  • 5+ years in SSIS and use of Stored Procedures.

  • Azure cloud experience a plus.

  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).

  • Deep understanding of relational database design concepts and SQL programming

  • Experience guiding/mentoring developers with lesser experience.

  • Requires strong analytical, conceptual and problem-solving abilities.

  • Strong experience with business intelligence and data warehousing design principles and industry best practices.

  • Bachelor-s Degree from an accredited institution.

  • US Citizen or Green Card

  • Candidates who are currently employed by a client of Sogeti USA or an affiliated Sogeti or the Capgemini Group business may not be eligible for consideration.

The benefits our employees enjoy:

  • 401(k) Savings Plan- Matched150% up to 6%. (Our 401k is in the top 1% of 401(k) plans offered in theUS!)

  • Medical/Prescription/Dental/VisionCoverage!

  • Low-premium and deductible.Plan with free preventive care.

  • $12,000 in TuitionReimbursement

  • 100% Company-paid mobile phoneplan

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