Role SSE - SSIS Developer Primary Skill SQL Server, SSIS ,ETL Experience 4 8 years Location: Pune / Hyderabad / Coimbatore Job description: Must have strong hands-on knowledge on developing SSIS packages and usage of all the transformations in SSIS v Experience in Creating jobs, scheduling the jobs, deployment of packages, performance tuning; debugging/error handling skills v Strong in SQL Server complex queries v Hands-on experience of SSIS development/deployment with cloud system v Experience in designing and development of ETL work packages on at least 3 data warehouse projects, and be able to demonstrate expertise in any ETL and reporting tools v Provide estimation for the tasks as required with supporting data points v Understanding business requirements/scope of projects, create functional Data specifications as per business logic/process; Be able to translate functional specifications into ETL SSIS packages of the Data Warehouses development. v Experience of using multi-dimensional models such as Star Schemas and Snow Flake Schema v Work with the offshore Team in designing & building Data warehouse as part of ODS project. v Methodical and structured approach to design and development specific to Data programs v A good understanding of the concepts and best practices of data warehouse ETL design and be able to apply these suitable. v Communicate with entire offshore/onsite teams, customer and all concerned teams on day-to-day basis; Provide status reporting to all stakeholders at regular intervals v Excellent verbal/written communication, good organizational skills and team player v Create/own project documents creation as per SDLC like project plan etc and create best practices for SSIS development; Identify risks/mitigation plan v Hands-on experience in working with Python3, Azure DevOps (ADO) Secondary skills: v Knowledge of Database designing, implementation, creation & tuning of Data Aggregation mechanisms v Experience of working in other ETL tools v Experience of working in any data reporting tools or SSRS,
Employement Category:
Employement Type: Full time Industry: IT Services & Consulting Role Category: Not Specified Functional Area: Not Specified Role/Responsibilies: Sql Server Integration Services (ssis)
INNOVAPATH I T SOLUTIONS PRIVATE LIMITED Innovapath IT solutions is a fast growing IT company in Hyderabad which specializes in handling the projects which uses the most advanced technologies in Software industry.