SSIS Developer/Admin

This is an onsite position open to any qualified applicant in the United States.

We are Cognizant Artificial Intelligence

Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. However, clients need new business models built from analyzing customers and business operations at every angle to really understand them.

With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate, and scale the most desirable products and delivery models to enterprise scale within weeks.

* You must be legally authorized to work in United States without the need of employer sponsorship, now or at any time in the future *

Role: SSIS Developer/Admin

Location: Troy, MI.

Job Summary:

We are seeking a skilled SSIS Developer/Admin to design, develop, and maintain ETL solutions using SQL Server Integration Services (SSIS). The ideal candidate will have experience working with SQL Server, data warehousing, and ETL processes, ensuring efficient data integration and transformation.

Roles and responsibilities:

• Design, develop, and implement SSIS packages for ETL processes.
• Extract, transform, and load (ETL) data from various sources into SQL Server databases, data warehouses, or other destinations.
• Optimize SSIS packages for performance, scalability, and reliability.
• Collaborate with database administrators, data analysts, and business stakeholders to understand data requirements.
• Monitor, troubleshoot, and resolve ETL job failures and performance issues.
• Implement error handling, logging, and data validation mechanisms within SSIS packages.
• Develop and maintain SQL queries, stored procedures, functions, and views to support ETL processes.
• Ensure compliance with data governance, security, and quality standards.
• Document SSIS processes, workflows, and best practices.
• Install, configure, and manage SSIS servers and environments.
• Deploy, schedule, and monitor SSIS packages to ensure smooth data integration and transformation processes.
• Troubleshoot and resolve SSIS job failures, performance issues, and connectivity problems.
• Optimize SSIS performance by tuning memory usage, parallel execution, and resource allocation.
• Implement logging, error handling, and automated alerts for SSIS packages.
• Ensure SSIS security by managing roles, permissions, and access controls.
• Collaborate with developers, DBAs, and business stakeholders to support ETL processes.
• Maintain SSIS servers by applying patches, updates, and upgrades as needed.
• Document SSIS administration tasks, best practices, and troubleshooting procedures.

Required Qualifications:

• 7+ years of experience in SSIS development and ETL processes.
• Strong expertise in SQL Server (T-SQL, stored procedures, indexing, performance tuning).
• Experience with data warehousing concepts and dimensional modeling.
• Knowledge of data migration, transformation, and integration techniques.
• Experience in handling large datasets and optimizing ETL performance.
• Familiarity with other ETL tools, Power BI, or SSRS is a plus.
• Strong problem-solving and debugging skills.
• Excellent communication and collaboration abilities.

Salary and Other Compensation:

Applications will be accepted until April 06, 2025

The annual salary for this position is between $ 81,848 - $ 156,500 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Cognizant is an Equal Opportunity Employer M/F/D/V. Cognizant is committed to ensuring that all current and prospective associates are afforded equal opportunities and treatment and a work environment free of harassment.

Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network Assists Veterans in building and growing a career at Cognizant that allows them to leverage the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service.

#LI-KV1 #CB #Ind123