SSIS Developer at Cognizant in Plano, Texas

Job Description:

Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.). Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 1000, and the Fortune 500 and we are among the top performing and fastest growing companies in the world.Our strength is built on our ability to work together. Our diverse backgrounds offer different perspectives and new ways of thinking. It encourages lively discussions, inspires thought leadership, and helps us build better solutions for our clients. We want someone who thrives in this setting and is inspired to craft meaningful solutions through true collaboration.

SSIS Developer – Full – Time *This role is not able to offer visa transfer or sponsorship now or in the future*

AIA - Artificial Intelligence and Analytics Practice

This Practice that leads all initiatives surrounding incorporating AI into Customer Intelligence, Operations Intelligence, Product Intelligence, and Fraud Insights

Location and Travel: Plano, TX

 

·         Create an ETL design/Framework and implementation checks in SSIS packages

·         Understand functional side of Business requirements

·         Troubleshoot issues related to package debugging, performance, configuration and migration

·         Create data load mappings, import/export methods, Incremental /Full load data from Source systems to various targets

·         Setup up the SSIS package encryption for security purpose

·         Automate data extractions, loads and consolidations (when applicable) using batches or PowerShell scripts

·         Understand End-To-End data flow between various data sources and SSIS packages

·         Should be able to analyze and optimize SQL queries and provide tuning recommendations to SSIS jobs, time/CPU consuming queries if situation arises

·         Should interface with third party providers, plan and execute releases and hot fixes

·         Establish system administration processes for production support activities for data load, calculations and translations completed

   Delivery of low level design documents with ETL & DWH strategy, standards and adhering to ETL & BIW principles & policies

Cognizant is committed to veteran and military communities. Cognizant has been often recognized as a military friendly employer and is a coalition member of the Veteran Jobs Mission. Our business resource group Veterans Network assists our military associates in building and growing a career at Cognizant that allows them to leverage the leadership, loyalty, integrity, and commitment to excellence

·         5 - 8 years of experience developing ETL Packages/ Framework in SSIS

·         Advanced level of working knowledge in SQL installation, Administering and Configuration of SSIS packages

·         Strong understanding on Star schema and Snowflake schema modelling, SCD types in the data warehousing projects under SSIS

·         Strong ETL design/Framework experience is required

·         Programming language experience with SQL, SSIS expressions, C# or VB.net, PowerShell and VBA

·         Worked on various third party software’s for ETL activities

·         Experience in implementing the proper deployment model,  Custom Error handling, Alert and Log mechanism in SSIS project

·         Knowledge of business principles required in order to provide analytical support

·         Knowledge of MS SSIS architecture and best practices for developments/implementations

Apply Now