Client – NIIT Technologies Ltd.
Position – SSIS Developer
Exp: 6 to 12 years
Location – Noida-Gurgaon
1. Professional with around 6+ years of total IT experience in the Design, Modelling, Development, Implementation and Support of SQL Server 2016/2017.
1. Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
1. Experience in designing SSIS framework
1. Skilled in error and event handling: precedence Constraints, Break Points, Check points, Logging, Data Cleansing, Data Quality Services, Master Data Management.
1. Experience in importing/exporting data between different sources using SSIS/DTS utility.
1. Transformed data from one server to other servers using tools like, and SQL Server Integration Services (SSIS) (2016/2017).
1. Experience in creating configuration files to deploy the SSIS packages across all environments.
1. SQL Query/SSIS Package optimization, performance tuning, common table expression, Windows function.
1. Experience in third party tool like Zappysys, Pragmatics.
1. Experience in No SQL database like MongoDB.
1. Best industry practices for SQL query and SSIS implementation.
1. Having sound knowledge about XML and JSON file import/export.
1. Experience to create a JSON format data using SQL query.
1. Defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
1. Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
1. Good ability to quickly grasp and master new concepts and technologies.
1. Good to have knowledge to import/export data from salesforce.
1. Good to have knowledge about CICD deployment.
1. Good to have knowledge about Master Data Services and Master Data Management.