SSIS Senior Developer at Cognizant in LONG BEACH, California

Job Description:

SSIS Senior Developer

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

Roles and Responsibilities:

 

·         Be responsible for business and functional requirements gathering, a review of existing business model, systems configurations and operating methodologies as well as understanding evolving business needs 

·         Design and Develop the complex ETL packages using Full/Incremental Load strategy 

·         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 

·         Develop ETL test cases and validation scripts 

·         System Integration testing  and Support to user acceptance testing 

·         Serve as lead in designing and developing ETL (MSBI) code for efficient and scalable data transformations in the Enterprise Data Warehouse  

·         Extend and maintain the EDW/Mart data layers – Type II SCD dimensions and facts 

·         Work closely team members such as Data Analysts, QA and other ETL engineers to develop and release new capabilities as well as research technical requirements and resolve issues

 

 

 

 

Required Qualifications:

·         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 

·         Experience with database technologies like SQL Server, Azure SQL, Azure Synapse 

·         Experience in tuning/optimizing performances of SSIS load and Power shell scripts automation 

·         Experience in documenting functional and technical design. 

·         Excellent communication skill (both verbal and written) with overseas client handling experience. 

·         Strong knowledge on MS Power BI tool along with profound knowledge on query writing 

·         Strong systems skills especially in implementation, maintenance, enhancement and documentation 

 

#LI-MS3

#CB

IND123

 

 

 

Technical Skills

SNo	Primary Skill	Proficiency Level *	Rqrd./Dsrd.
1	MS Power BI	PL1	Required
2	Markit EDM	PL3	Desired
3	HTML 5	PL3	Desired
4	Microsoft SSIS	PL1	Required
5	MS SQL Server	PL2	Required

 

* Proficiency Legends

Proficiency Level	Generic Reference
PL1	The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
PL2	The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
PL3	The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.
PL4	The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.

Apply Now