SSIS Developer

• Advanced knowledge of ETL, including the ability to read and write efficient, robust code, follow or implement best practices and coding standards, and creation

• Confident in taking up ad-hoc API design & developments with limited technical resources sometimes open sources to integrate Strong in SQL queries

• Ability to write complex SQL query and performance tuning for the same Data modeling, diverse schema mid-high knowledge should be useful to pick-up other ETL tools on-demand
• Hands on experience with SQL Excellent analytical and quantitative capabilities to solve adhoc, non-routine problems in a timely and insightful manner , should be able to solve the problems independently
• Excellent creating Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Normalization, De-normalization
• Excellent Query Optimization and performance tuning of stored procedures, functions etc
• Excellent ETL (Extracting, Transforming and Loading) development, SSIS for migration of data between legacy systems, ERP to SQL Server 2016/2012
• Developing ETL Packages using SSIS and Different types of Data Loading (Direct, Incremental, SCD, etc) implementing using Packages and used Configuration files
• Worked with various tasks such as Control Flow (Execute SQL Task, For Each Loop Container, Data Flow Task and Worked with Transformations such as Aggregate, Sort, Lookup, Merge join, Multicast, Conditional split, Derived column etc
• Excellent Logging, Error handling by using Event Handler in various projects
• Excellent creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent and Implemented Check points at Package level
• Excellent experience on Deployment, Dynamic Configuration, Providing Securities and Scheduling the Packages
• Python & pyspark experience knowledge is quite added advantage

Soft Skills:

• Good communication (both verbal and written), and interpersonal skills
• Strong problem-solving and analytical skills
• Ability to work in Agile environment, understand the requirements clearly, collaborate with other team members effectively and develop and deliver the assigned modules as per agreed timelines
• Good client facing skills
• Ability to learn new technologies in short span of time and implement in projects
• Flexibility and adaptability