Location: Hyderabad, TG, India
Date Posted: Mar 16, 2023
Category: IT Development
Job ID: 120224
Title: SSIS Developer
Experience: 5 to 9 Years
Location: Hyderabad / Bangalore (Hebbal) - Work from Office
Working Hours: 12.00pm to 9.00pm IST
Must have skills: SQL, SSIS, Power BI
Must have 4 -8 years of experience in Designing database objects.
Good Hands on T-Sql
Design & deploy ETL, ELT jobs to curate, transform and aggregate data to create source models for end user analytics use cases.
Design, deploy and maintenance of the SSIS packages with Task Factory components
Collaborate with business stakeholders to identify and meet data requirements
Experience with SQL server with different versions (2012,2017)
Expert level in ETL development using SSIS.
Expert level in Task Factory components for SSIS.
Good to have working knowledge with DTS package
Good experience with Data warehousing
Proficiency in SQL Server database and skills in one or more languages like SQL, T-SQL with knowledge of DDL, DML, stored procedures, triggers and performance tuning Strong experience in Design and develop SSIS/SSRS package and solutions and working knowledge with DTS package
Should be able to analyze and understand complex data
Familiarity with workflows in programming concepts
Bug Fixing and Maintenance activities for existing ETL packages
Working knowledge and have exposure working complex SQLs on SQL Server Eg UDFS, Stored Procedures, SQL Agent Jobs Working knowledge on transformations in Azure Data factory pipelines
Working knowledge on how to execute SSIS packages through Azure Data factory pipelines
Working knowledge on SSIS packages and different transformations on Dataflow Working knowledge on Migrate SQL Server Integration Services packages to an Azure SQL Managed Instance