| 100% Remote : Sql/SSIS Developer at Denver, Colorado, USA |
| Email: [email protected] |
| Hello, Role:SQL/ SSIS Developer Location Denver, CO (Remote allowed) 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. Keywords: business intelligence information technology Colorado |
| [email protected] View all |
| Thu Jul 20 19:54:00 UTC 2023 |