SQL SSIS Developer - Engineer Software IT (FTE)

Job Description

Overview

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

Key Responsibilities:

• 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

Technical Experience:

• 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