Company – Agreeya Solutions India Pvt. Ltd.
Position-SSIS Developer (Data ware house)
Shift Time: 10.00 AM-4 PM (GGN Office) and 7.00 PM to 10.00 PM (home)
· Professional with around 7+ years of total IT experience in the Design, Modelling, Development, Implementation and Support of SQL Server 2016/2017.
· Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
· Experience in designing SSIS framework
· Skilled in error and event handling: precedence Constraints, Break Points, Check points, Logging, Data Cleansing, Data Quality Services, Master Data Management.
· Experience in importing/exporting data between different sources using SSIS/DTS utility.
· Transformed data from one server to other servers using tools like, and SQL Server Integration Services (SSIS) (2016/2017).
· Experience in creating configuration files to deploy the SSIS packages across all environments.
· SQL Query/SSIS Package optimization, performance tuning, common table expression, Windows function.
· Experience in third party tool like Zappysys, Pragmatics.
· Experience in No SQL database like MongoDB.
· Best industry practices for SQL query and SSIS implementation.
· Having sound knowledge about XML and JSON file import/export.
· Experience to create a JSON format data using SQL query.
· Defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
· 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.
· Good ability to quickly grasp and master new concepts and technologies.
· Good to have knowledge to import/export data from salesforce.
· Good to have knowledge about CICD deployment.
· Good to have knowledge about Master Data Services and Master Data Management.
· Ability to lead team as well as perform as an individual contributor. (30:70 ratio)