| ETL SSIS Developer with life insurance experience at remote at Denver, Colorado, USA |
| Email: [email protected] |
| From: pavan, vdartinc [email protected] Reply to: [email protected] ETL SSIS Developer with life insurance domain experience Location Denver, CO (Remote allowed) C2C life insurance is mandatory Skill Matrix SQL Server 2016 or above 7+ years SSIS 5+ years Life Insurance Domain 2+ Years SSRS 2+ years SSAS 2+ years Analysis of existing SSIS packages and experience in data Extraction, Transformation and Loading from source to target system using SSIS tool. Ability to Design Technical documentation, ETL Development process and Deployment in different environments. Should handle job monitoring activities daily and respond to critical issues in a quick time. Involved effort estimation for enhancement request. Should interact with Clients to make them understand how the new development and changes will affect the system. Monitor the jobs using SQL Server Agent tool. Should be part of various BI SSIS Enhancements and supporting the project. Creating the change request (CHG) in service-now for any code deployment to production servers Experience in Incident Management using Service now tool. Should analyze the different Service now incidents to provide solutions to End users. Should be involved in requirement gathering and analysis and discussion with Business Analysts 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. Ability to so performance improvement activities. Coordinate with various team and business to understand the requirement and take it forward the development activity. Should be able to handle end-to-end enhancement activities or production fixes. Should help team members wherever they need and take it forward. Involve on data analysis and to get the mapping and to get the business requested reports. Create change request (CHG) in service-now for any code deployment to production servers. Should understand client requirements and able explain to the team to do development activities. Develop various ETL packages using SSIS tool and Should have good experience on SQL and able to write Stored Procedures in SQL Server 2016 or later. Develop different types of SSRS reports and able to deploy them into Report Server Should have knowledge and able to do fix and enhancements on SSAS cubes. Should Attend weekly status meetings and provide detailed status report. 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: [email protected] 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. Keywords: business intelligence information technology Colorado |
| [email protected] View all |
| Thu Jul 20 20:24:00 UTC 2023 |