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
The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.
- Cognizant is a global community with more than 300,000+ associates around the world.
- We don’t just dream of a better way – we make it happen.
- We take care of our people, clients, company, communities and climate by doing what’s right.
- We foster an innovative environment where you can build the career path that’s right for you.
About us:
Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World’s Best Employers 2024) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com
Our commitment to diversity and inclusion:
Cognizant is an equal opportunity employer that embraces diversity, champions equity and values inclusion. We are dedicated to nurturing a community where everyone feels heard, accepted and welcome. 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 protected characteristic as outlined by federal, state 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.
Disclaimer:
Compensation 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.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.