Type: Full time
Expected Start Date: 08/29/2019
Compensation: $70,000-$75,000/ year plus benefits
Develop SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLE DB providers form the existing diversified data sources.
Use SSIS to extract the data from different type of data sources into data warehouse using Data Flow Task, Script Task, Execute SQL task with different Transformations like Data transformation, Data conversion, unpivot, derived columns, conditional split, Look up, sort, Multi casting, Merge Join, Merge, Data Conversion etc.
Change the config files of SSIS packages appropriately for the layers to connect to the respective server and the data base with PCM (package configuration manager) for deployment.
Analyze specific errors on the execution of the SSIS packages and troubleshooting them.
Migrate data from Homogenous and Heterogeneous Data Sources and legacy system (DB2, Flat Files and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformations constraints.
Create Windows PowerShell scripts to automate the ETL Execution process for the end users of the SSIS packages.
Work on Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, DDLs, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
Perform Incremental Loads and Data cleaning in SSIS, Maintaining the history of the data and manage Error handling, logging using Event Handlers in SSIS.
Translate project requirements into project objectives and tasks, managing task assignment to project resources and reporting on and managing project scope throughout the project lifecycle.
Collect different kind of tickets and transformed depending on the business validations and delivered to the ERP system which is the virtual point of the organization.
Develop complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces
Use performance point in providing business intelligence to assist the users to make better business decisions.
Assist Quality assurance by reviewing Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and product knowledge.
Document the project implementation steps and share it with client teams.
Report project status to Client, Vendor and Contrive Solutions management.
Attend training in new technologies for career advancement
Bachelor Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.
1-2+ years in SQL, T-SQL, ETL (Extraction, Transformations, Loading), SSIS Packages, Tableau, Microsoft power BI, Excel, Flat Files and DB2.
Excellent problem solving and analytical skills
Excellent written and oral communication skills
Strong organizational, analytical, and collaborative skills
• Benefits included - Health/Dental, training, travel expenses.
• Employer location Northborough MA. Duties for current role to be performed at Helena, MT
Referral bonus is available for this position