SSIS Developer/ Engineer
About The Position
Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.Location: Whippany, NJWorks in the area of Software Engineering, which encompasses the development, maintenance and optimization of software solutions/applications. 1. Applies scientific methods to analyse and solve software engineering problems. 2. He/she is responsible for the development and application of software engineering practice and knowledge, in research, design, development and maintenance. 3. His/her work requires the exercise of original thought and judgement and the ability to supervise the technical and administrative work of other software engineers. 4. The software engineer builds skills and expertise of his/her software engineering discipline to reach standard software engineer skills expectations for the applicable role, as defined in Professional Communities. 5. The software engineer collaborates and acts as team player with other software engineers and stakeholders.
Requirements
- Strong experience with SQL Server, T‑SQL, and SSIS.
- Solid understanding of ETL, data warehousing, and relational modeling.
- Experience with query performance tuning and debugging.
- Ability to work in Agile, collaborative environments.
Responsibilities
- Develop and maintain SSIS ETL packages for data extraction, transformation, and loading.
- Write and optimize T‑SQL stored procedures, functions, views, and queries.
- Design and maintain database schemas, indexes, and performance tuning strategies.
- Support data warehousing processes, staging, and data quality checks.
- Troubleshoot ETL/data issues and ensure reliability of data pipelines.
- Collaborate with analysts, architects, and business teams on requirements and delivery.
- Prepare technical documentation for ETL processes and database structures.
Benefits
- Flexible work
- Healthcare including dental, vision, mental health, and well-being programs
- Financial well-being programs such as 401(k) and Employee Share Ownership Plan
- Paid time off and paid holidays
- Paid parental leave
- Family building benefits like adoption assistance, surrogacy, and cryopreservation
- Social well-being benefits like subsidized back-up child/elder care and tutoring
- Mentoring, coaching and learning programs
- Employee Resource Groups
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
