Senior SSIS-SQL Developer
Sogeti USA

Job Info

---

Sogeti islooking for a talented Senior SSIS-SQL Developer to join our Chicagoland teambuilt on the success of our people and partnerships. Come be a part of our"People centric" culture!

Sogeti is a wholly owned subsidiary of Capgemini and theTechnology and Engineering Services Division of Capgemini. We have more than25,000 professionals in 15 countries and has a strong local presence in over100 locations scattered throughout the US, Europe and India.

Sogeti is a leading provider of technology and software testing,specializing in Application, Infrastructure, and Engineering Services. We offercutting-edge solutions around Testing, Business Intelligence & Analytics,PLM, Mobile, Cloud, and Cyber Security, combining world class methodologies andits global delivery model, Rightshore®. Our roots and the bedrock of oursuccess lie in the provision of local professional services - teams ofexperienced IT professionals working closely with local clients.

Sogeti offers an environment that celebrates innovation and helpsyou to achieve a good balance between your professional and personal life. Westrive to be THE employer of choice!

All Sogeti Prospective Candidates Must:

Possess a Bachelors and/or Masters Degree from an accreditedinstitution.

Be a US Citizen or a current permanent resident Green Card holder.Sponsorship now or in the future is unable to be provided for this role.

Be currently residing in the Chicagoland area. Non-localcandidates will NOT be considered as onsite will eventually be required.

Willingness to travel/commute and work onsite throughout theentire Chicagoland area possibly including domestic throughout the US, onceallowable and safe.

You will be focusedon building and maintaining data integration services and develop and testsolutions that allow extracting, loading, analyzing and organizing data. You willdesign data solutions using the MS SQL Server Integration Services platform. Youwill help to define enterprise needs and determine how to meet them, implementyour development plan and then test and debug systems to ensure efficiency andeffectiveness.

Weare looking for a bright minded, self-motivated, team player with a strongbackground and skilled with a high degree of intellectual curiosity andabilities with:

SSIS: Very strong with extensive knowledge and experience inwriting/developing and maintaining SSIS packages. Knowledge and experience insetting up SSIS server, including configuration security aspects, etc. Strongunderstanding and experience in data flow, ability to handle multipleinputs in SSIS like CSV, PSV, Excel (xlsx), string etc. Implementing businesslogic. Experience in consuming .NET or Java Components/APIs/Web APIs from withinSSIS. Interaction with third party ETLs (knowledge of Adeptia will be plus).

SQL ServerDatabase: Very strong with extensiveknowledge, experience and understanding of RDBMS database concepts &implementation. Experience and knowledge in writing, updating storedprocedures, ability to write complex queries, ability to understand databasearchitecture and data flow within and between databases. Experience with otherSQL Server aspects like (but not confine to) indexes, security, linked server,Synonyms.

Analytical Skills: ability to analyze and identify the defect area reportedby client/ production support tickets. Ability to understand complex businessprocesses & workflow, functional & technical process of application.Ability to perform root cause analysis on database as well as in SSIS package.Identify and resolve database related performance and/or other issues.

SSRS: Knowledge and experience in developing and maintaining SSRSreports.

Tools: TFS: Experience in using TFS as source code repository, agileboard, etc. JIRA and Confluence: JIRA is used for product support andenhancement ticket. Confluence is the document repository.

Methodology: Agile -Normal course of project execution is under Agile methodology. Hence knowledgeand experience to work in agile structure (Sprints, retrospectives, etc)

Technical SkillsRequirements:

10-15+ years' experience in software development.

7+ years' experience in developing SSIS packages, working with SQLServer database, strong understanding of RDBMS concepts, with ability tounderstand and write complex queries, stored procedures, analytical skills.

Experience in development and production support environment.

As a senior developer ability to work independently, highlymotivated self-starter and a good team player with ability to work underminimal supervision.

Ability to perform effort estimation, breakdown workload into MVP.

Strong Communicationskills.

Understanding of .NET.Ability to write .NET code will be added advantage.

Postgres and AS400/DB2 -just awareness will also suffice, as it is added advantage.

Benefits Our Employees Enjoy Working at Sogeti:

401(k) Savings Plan: matched 150% up to 6%. Our 401k is in the top1% of 401(k) plans offered in the US!

Employee Stock Option Plan

Annual Individual Bonus Plan

Medical/Prescription/Dental/Vision Coverage: low premium anddeductible with free preventative care.

Life Insurance: provided at 2x base salary plus long term andshort term disability.

100% Company-paid Mobile Phone Plan

Personal Time Off (PTO): ensuring a balance of work and home life

Career Planning and Coaching Program

All of our employees receive wide-ranging training coveringbusiness acumen, technical and professional skills development. Employees alsohave opportunities to hone your functional skills and expertise in an area ofspecialization. We offer a variety of formal and informal training programs atevery level to help employees acquire and build specialized skills faster.Learning takes place both on the job and through formal training conductedonline, in the classroom, or in collaboration with teammates.

Continuing Education: $12,000 Annual Tuition Reimbursement plusaccess to over 20,000 online courses and certifications through CapgeminiUniversity, as well as many offerings through Coursera and Degreed.

Paid Parental Leave: eligibility up to 6 weeks

Adoption Assistance: up to $5,000

Perks and Discount Programs for Health, Fitness, Auto and manymore.

Counseling, Assistance and other Support Programs.

Equal Employment Opportunity

All employment decisions shall be made without regard to age,race, creed, color, religion, sex, national origin, ancestry, disabilitystatus, veteran status, sexual orientation, gender identity or expression,genetic information, marital status, citizenship status or any other basis asprotected by federal, state or local law.

In order for you to be reviewed and receive feedback on yourapplication, all prospective candidates must meet all requirements, possess allskills (exact or comparable) and every "must have". If you do notreceive feedback, you are welcome to reach out to me at any point for more specifics.

Paige Evans, Corporate IT Recruiter | Illinois

Sogeti

E: paige.evans@sogeti.com

Schedule a time on my calendar at:https://calendly.com/paige-evans-sogeti

This job has expired.