| Sr. Application Developer (SSIS Developer) at Boston, Massachusetts, USA |
| Email: [email protected] |
| From: Lovely Singh, Tek Inspiration [email protected] Reply to: [email protected] Hi, Hope you are doing great!!! Please share suitable profile Title: Sr. Application Developer (SSIS Developer) Location: Boston,MA Hybrid (majority remote, with periodic onsite at 250 Washington Street,Boston, MA) Duration: 4-6 months MoI; Skype Must have MA, RI, NH, or CT location consultant The Developer will develop SSIS packages for thestandardization of incoming data and on Data Cleanup and Standardizationprojects for the Office of Population Health (OPH). The incumbent will workclosely with Business Analysts and Data Architects who will provide therequirements for the code development. The position reports to the IT Program Lead for OPH who is under the ExecutiveOffice of Human Services (EOHHS). JOB DUTIES (Detailed Statement of Duties and Responsibilities): Review the current database architecture, re-design & develop the new database to improve the efficiency, usability and streamline data import and export processes. Develop advanced T-SQL code for implementing application business logic using stored procedures, views, and functions. Document specific requirements for data integration, including file format, fields, etc. Develop ETL processes for the import and export of data between the DPH internal systems using SQL Server Integration Services (SSIS) and advanced T-SQL to include stored procedures, user-defined functions, views, etc. Design, develop, revise, and maintain a wide variety of custom SSRS reports to support our business. Assist in the Creation and Analysis of optimized stored procedures for data pulls for reports/exports. Develop data warehouse objects and processes for the purpose of supporting business intelligence, including ETL, fact/dimension tables, and cubes. Research, analyze, document, and maintain internal Applications and Database architectures. Provide technical assistance and information to technical and non-technical users. Analyze, design, implement and maintain the businesses critical systems, maintaining at all times the proper data security standards set forth by the organization. REQUIRED SKILLS (Special Skill Set, Abilities, Knowledge): Analytical thinking Structured approach to problem skill with attention to details Self starter Communicate with technical and non-technical stakeholders Good customer service skills QUALIFICATIONS (Education, Years' Experience, Certificates): Bachelor's degree in Computer Science, Computer Information Systems, Information Management or equivalent work experience Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms, Data Warehousing 10 Years working in a data centric IT environment. 5 years hands on experience with ETL tools and integration engines, preferably MS SSIS, Snowflake Proven track record of designing and implementing complex and large scale Enterprise Databases Documenting databases using Entity Relationship Models and Data Dictionaries Writing SQL scripts REGARD Lovely Singh Keywords: information technology microsoft Connecticut Massachusetts New Hampshire Rhode Island |
| [email protected] View all |
| Tue Feb 07 03:25:00 UTC 2023 |