[xrecnet] ETL SSIS Developer with life insurance domain at remote

ETL SSIS Developer

Location – Denver, CO (Remote allowed)

Life insurance experience is mandatory

C2C

 

 

Skill Matrix –

• SQL Server 2016 or above – 7+ years
• SSIS – 5+ years
• Life Insurance Domain – 2+ Years
• SSRS – 2+ years
• SSAS – 2+ years

 

1. Analysis of existing SSIS packages and experience in data Extraction, Transformation and Loading from source to target system using SSIS tool.
2. Ability to Design Technical documentation, ETL Development process and Deployment in different environments.
3. Should handle job monitoring activities daily and respond to critical issues in a quick time.
4. Involved effort estimation for enhancement request.
5. Should interact with Clients to make them understand how the new development and changes will affect the system.
6. Monitor the jobs using SQL Server Agent tool.
7. Should be part of various BI SSIS Enhancements and supporting the project.
8. Creating the change request (CHG) in service-now for any code deployment to production servers
9. Experience in Incident Management using Service now tool.
10. Should analyze the different Service now incidents to provide solutions to End users.
11. Should be involved in requirement gathering and analysis and discussion with Business Analysts
12. Should work on to write the critical and very complex SQL script/Stored procedure to pull the data from data source and show it in SSRS reports.
13. Ability to so performance improvement activities.
14. Coordinate with various team and business to understand the requirement and take it forward the development activity. 
15.   Should be able to handle end-to-end enhancement activities or production fixes.
16.   Should help team members wherever they need and take it forward.
17.  Involve on data analysis and to get the mapping and to get the business requested reports.
18. Create change request (CHG) in service-now for any code deployment to production servers.
19.  Should understand client requirements and able explain to the team to do development activities.
20. Develop various ETL packages using SSIS tool and
21. Should have good experience on SQL and able to write Stored Procedures in SQL Server 2016 or later.
22. Develop different types of SSRS reports and able to deploy them into Report Server
23. Should have knowledge and able to do fix and enhancements on SSAS cubes.
24. Should Attend weekly status meetings and provide detailed status report.
25. Should be coordinating with the Offshore team on daily activities,

Should have good experience on Informatica Power Center Production Support activities,

Should have knowledge and experience on monitoring Control-M jobs.

 

 

 

Regards

Pavan

VDart Inc

Ph: (470) 251-2584 Ext:1866

Email: Pavankumar.s@vdartinc.com

Website: https://vdart.com

 

 

 

Confidentiality Notice

 

The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.

 

 

--
You received this message because you are subscribed to the Google Groups "Xrecnet IT Recruiters Network - Corp to Corp IT Jobs & Hotlists" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xrecnet+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/xrecnet/CAGf9M0-wbCW%3D7dB%2BtRqjUJ%3DR%3DDfmLdgqtSiXfn7EJZWV%3DzRhMQ%40mail.gmail.com.