Skip to main content

SSIS Lead

00067847821

Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.), Cognizant combines a passion for client satisfaction, technology innovation, deep industry and business process expertise, and a global, collaborative workforce that embodies the future of work. Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 2000, and the Fortune 500 and is ranked among the top performing and fastest growing companies in the world.

Our Culture

Your passion, integrity and experience are integral to Cognizant's success. You will join a dynamic and expanding global leader in IT and Business consultancy where you will be valued for who you are. We take pride in our partnership with our clients, so your ability to add value and provide exceptional service to our clients is fundamental to your success. In return, you will be presented with opportunities to develop your career and collaborate with talented colleagues in a supportive, diverse environment.

At Cognizant we recognize that companies that are open and welcoming to a multi-culturally diverse workforce will thrive with fresh perspectives and collaborative knowledge. Cognizant focuses on promoting & increasing gender diversity and providing a workplace which encourages great participation and an equal playing field, where merit and accomplishment are the only criteria for success.

Job summary:

We are seeking an experienced SSIS Lead to drive the design, development, and optimization of our data integration and ETL processes. This role is ideal for someone who thrives on solving complex data challenges, leading technical initiatives, and ensuring the reliability and scalability of enterprise data pipelines. You’ll collaborate closely with data engineers, analysts, architects, and business stakeholders to deliver high‑quality data solutions that power critical business decisions.

Key Responsibilities:

  • Lead the end‑to‑end design, development, and deployment of SSIS packages and ETL workflows.

  • Establish best practices, coding standards, and performance optimization techniques for ETL processes.

  • Conduct code reviews and mentor developers on SSIS, SQL, and data integration patterns.

  • Build, maintain, and enhance complex SSIS packages for data extraction, transformation, and loading.

  • Integrate data from multiple sources including SQL Server, APIs, flat files, cloud platforms, and third‑party systems.

  • Troubleshoot and resolve ETL failures, performance bottlenecks, and data quality issues.

  • Collaborate with stakeholders to design scalable and secure data integration frameworks.

  • Ensure ETL processes align with data governance, security, and compliance standards.

  • Maintain documentation for ETL workflows, data mappings, and operational procedures.

  • Work with business teams to understand data requirements and translate them into technical solutions.

  • Provide technical guidance during project planning, estimation, and solution design.

  • Communicate progress, risks, and technical decisions to leadership and cross‑functional teams.

Skills Required:

  • 6+ years of hands‑on experience with SSIS, Data Modelling, Data Warehousing and SQL Server Integration Services development.

  • Strong proficiency in T‑SQL, stored procedures, query optimization, and relational database concepts.

  • Proven experience leading ETL or data integration projects in an enterprise environment.

  • Solid understanding of data warehousing, star/snowflake schemas, and dimensional modeling.

  • Experience with version control Git, CI/CD pipelines, and deployment automation.

  • Familiarity with cloud data platforms (Azure Data Factory, Synapse, AWS Glue, etc.) is a strong plus.

  • Excellent problem‑solving skills and the ability to work independently and collaboratively.

Benefits:

Joining Cognizant will give you the opportunity to learn and collaborate with some of the most talented people in the industry, while having your finger on the pulse of emerging industry trends and working on the cutting edge of technology in your field of expertise.

We recognize that our people perform at their best when they feel valued as significant contributors and that is why at Cognizant, taking care of our employees is a priority:

· You can pursue innovative career tracks and opportunities here

· You can enhance your professional development through education and dedicated training

· We’ll give you the skills you need to keep pace with the changing workplace while our compensation, benefits and wellness packages help you stay healthy and plan for the future.

Next Steps:

Please reach out to our friendly and welcoming team today to apply and register your interest for this full-time role. We'd love to help you get your next role and enable you to fulfil your professional ambitions.


What we offer

  • The chance to work with impact. Here, you’re empowered to bring your biggest thinking to help our company and clients improve everyday life.
  • Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
  • The opportunity to thrive on a high caliber team with heart. We celebrate each other’s experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
  • A comprehensive total rewards package, including a competitive salary and a pension plan with matching contributions.
  • Flexible health and financial benefits to support you and your eligible dependents—from day one.
  • True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.  

About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.

Other employment-related information
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, provincial or local laws.

If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.

Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.

Your path to Cognizant

Wondering what to expect after you apply? Here’s a peek at our recruitment process—and keep in mind that not all candidates advance through every step and the process may vary depending on your role and location.

Your Application Midnight Blue RGB

Step 1: Application

Find an open role that aligns with your skills and career goals and show us why you’re the person for the job. Consider joining our Talent Community if you don’t find the right opportunity.

Phone Call Midnight Blue RGB

Step 2: Recruiter call

If one of our recruiters sees a fit, they’ll set up a short introductory call to learn more about you and how your experiences and skills align with the role.

Step 3: Interview(s)

If you and our team would like to continue the process, you’ll meet with one of our hiring managers. Some roles may also require technical assessments and/or client interviews.

Step 4: Final decision

Our hiring team will then review each candidates’ potential to succeed in the role. This process may take some time because we want to get it right—but you can count on us to keep you updated.

Benefits that help you thrive and grow

Our teams achieve incredible things when they feel fully supported. That’s why our benefits program is built around the diverse needs of our people—so they can enjoy a fulfilling, balanced and healthy life.

Untitled Design 49
Financial wellbeing

Financial wellbeing

We regularly review market data to ensure compensation is competitive and reflects the value you bring. Your benefits extend beyond pay and may include retirement plans, financial education, discount programs, etc.

1 (1)
Physical and mental wellbeing

Physical and mental wellbeing

We empower you to prioritize your wellbeing through paid time off, flexible working where possible, healthcare plans, counselling, our Mental Health Allyship program and more. 

Your Career, Your Way
Your career, your way

Your career, your way

With 90% of our associates building skills through GenAI training, job shadowing, industry certifications and more, you have everything you need to build a full career.

Professionals
Real-world impact

Real-world impact

Think about the biggest brands you rely on. Chances are, they rely on us to help strengthen their business. Here, you’ll turn bold ideas into solutions that improve lives everywhere.

Haven't yet found the right opportunity?

Receive the latest updates on job opportunities, recruitment events and company news—tailored just for you!

Get the latest updates