Description
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 USA/Canada without the need of employer sponsorship, now or at any time in the future *
On site from day 1 – Locations: Wilmington, DE or Buffalo,NY
Job Title: SQL Server Data Engineer (SSIS SSRS)
Skill Family:-Microsoft Data Management.
Application Maintenance and Production support: Batch Job monitoring, Batch / Job Execution, Application Alerts/ Batch Abend Management, Incident Management, SSIS &SSSR, Service Request Fulfilment, Problem Management, Change Management, Defect Fixes (upto a maximum capacity), Release Support, Status reporting, Documentation (Run/Handbook).
Experience 10 to 11yrs
Technical Skills- Microsoft SSIS
Roles/Responsibilities
- Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM
- Builds data transformations with SSIS including importing data from files moving data from one database platform to another
- Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
- Design implement and maintain database objects (tables views indexes ) and database security
- Experience working with SSIS packages
- Proficient with ETL tools such as Microsoft SSIS
- Analyze and develop strategies and approaches to import and transfer data between source staging and ODS/Data Warehouse destinations
- Test and prepare ETL processes for deployment to production and non-production environments
- Support system and acceptance testing including the development or refinement of test plans.
Required qualifications:
- At least 5 years of experience in SSIS & SSRS.
- Knowledge of T-SQL & Stored procedure in SQL Server is a must.
- At least 3 years of experience in ETL, preferably in Informatica.
- Performing ad hoc and structured data analysis
- Experience in translating, merges, cleans up and maps data into conceptual, logical and physical data models.
- Documenting data standardization, data enrichment operations, data validations, data security requirements, and data exception handling processes.
- Experience in conducting discovery phase and documentation of different types of data loading through data analysis, from source to the semantic layer.
- Experience in analyzing and documenting the existing environment.
- Self-starting, self-motivating, and capable of making decisions independently.
Salary and Other Compensation :
The annual salary for this position is $115,000.00 to $125,000.00 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.
#LI-MC1 #CB #Ind123
Qualifications
Technical Skills
SNo
Primary Skill
Proficiency Level *
Rqrd./Dsrd.
1
Microsoft SSIS
PL1
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.