MS SQL Server SQL DBA T SQL Stored Procedures SSIS RDBMS Triggers Data Warehouse Ar   Requirement id 115500 Job title Developer Job location in Boston, MA Skills required ETL Process, MS SQL Server, Relational Database, SQL DBA T SQL Stored Procedures SSIS RDB Open Date 26-Mar-2021 Close Date Job type Not specified Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: ETL Process, MS SQL Server, Relational Database, SQL DBA T SQL Stored Procedures SSIS RDB Bid Number: BD-21-1056-ADMFN-HRDAD-60452 Note: Email and Online Submission Note: Total number of positions sought: 1 Note: Resumes allowed per authorized vendor: 2 Submission Deadline: 4/2/2021 04:00 PM EST Start Date: 4/12/2021 End Date: 7/11/2021 Client: Human Resources Division (HRD) Description: This position requires that the candidate be a skilled ETL developer and able to design, develop, and support complex integration processes (including interfaces) using SQL Server technology, stored procedures and SQL program code. In addition, the candidate will be involved in database administration, implementing data transformation rules and data validations into the data warehouses. The ideal candidate for this position will have strong technical knowledge and be very analytical. This position reports to the Director of Application Systems for the Human Resources Division (HRD) and works closely with technical and business team. Primary Responsibilities • ETL Developer on this project will work as part of technical team and involved in design, development of ETL packages, data warehouse architecture, reporting and BI solutions. • Design and develop solutions for managing data movement in, out of and between various data systems, platforms and file types. • Responsible for developing and testing stored procedures, user defined functions, triggers, and other objects that assist in the implementation of business rules/logic. • Manipulating data to provide meaningful insight • Troubleshoot issues and tune at all layers: database, ETL, and presentation • Design and develop relational database models/schemas. • Query performance tuning and write ad-hoc queries. • Provide assistance in MS SQL server support • Create IT documents for knowledge base, user guides, and other various communications systems • Work with Director of Application Systems to ensure successful transition of VRM project deliverables to production environment • Follow established business, technical and project policies and guidelines aligned with HRD, ANF and EOTSS principles and standards to include the following: use of best practices, meeting management, project plans, status reports and dashboards, risk and issue tracking, change requests and resource management. Qualifications Education, Skills and Competencies • 10+ years SQL DBA/Development experience • 8+ years SSIS integration • 7+ years of RDBMS design and development and performance tuning experience • Advanced SQL skills: T-SQL, stored procedures, triggers, complex queries • Experience on at least one full-cycle SQL ETL solution project. • Experience locating and reconciling duplicate data from multiple disparate sources • Experience with advanced query design, stored procedures, views and functions • Experience with index design and T-SQL performance tuning techniques • Strong oral and written communication skills. • Ability to communicate with technical and business resources at many levels in a manner that supports progress and success. • Ability to understand, appreciate and adapt to new business cultures and ways of working. • Demonstrates initiative and works independently with minimal supervision   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 115500 while calling.   Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1), ETL Process job openings in Boston, MA Jobs List ITS63 2021-005 Data Quality Analyst -SP Create date: 12-Nov-2020 Bid Number: BD-21-1052-5000-5000-56382 Note: Total number of positions sought: 2 Note: Email Submission Submission Deadline: 11/19/2020 02:00 PM EST Start Date: 11/27/2020 End Date: 11/26/2021 Client: Center for Health Information & Analysis Description: CHIAs Data Operations Te.... (This job is for - Quality Assurance Jobs in MA Boston Analyst - (in Boston, MA)) ITS63 EHS FY19-001 ETL/Data Architect- BEACON -SP Create date: 12-Mar-2019 Note: Maximum number of resumes per ITS63 Vendor: 2 Note: RTR form Must signed by candidate. Submission Deadline: 3/15/2019 Start Date: 3/25/2019 End Date: 3/24/2020 Client: EOHHS Description: ETL/Data Architect Job Description: • Collaborate with all developers and business users to g.... (This job is for - job Jobs in MA Boston Architect - (in Boston, MA))    ETL Process job openings in other states Jobs List T-SQL Developer - SME - 135469 - SP Create date: 01-Oct-2024 No of Submissions: 1 Start date : 10/14/2024 Immediately End date : 02/28/2026 Submission deadline : 10/3/2024 3:00:00 PM Client info: MDEK12 Note: * This is a two day urgent posting, note the expiration date. Description: This position will require qualif.... (This job is for - T SQL Jobs in MS Jackson Developer - (in Jackson, MS)) VDOT Data Analyst/Cloud ETL Developer (742720) Create date: 24-Jul-2024 No of submissions :2 Start date :8/5/2024 End date :06/30/2025 Submission deadline :7/29/2024 Client info : VDOT Note: * Hybrid *Agency Interview Type:Both Phone and In Person Description : *Local Richmond, VA cand.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) Data Base Programmer/Analyst - 62749 Create date: 22-May-2024 No of Submissions : 1 Start date : 06/03/2024 End date : 12/31/2024 Submission deadline : 05/24/2024 Client info : CO CDPHE Note : * Position Location : Hybrid * Bill Rate - USD 76.00 Per Hour * Max Rate - USD 96.00 Per Hour .... (This job is for - MS SQL Server GCP Jobs in CO Denver Analyst - (in Denver, CO)) Database Administrator 3 - 61820 Create date: 01-Dec-2023 Start date : 12/11/2023 End date :12/11/2024 Submission deadline 12/04/2023 Client info : TN DOT Note: * Position Location: Hybrid Description : Install, upgrade, patch the oracle database infrastructure. .... (This job is for - job Jobs in TN Nashville Administrator - (in Nashville, TN)) Certified Cloud Engineer - 122666 - SP Create date: 28-Sep-2023 Start date : 10/16/2023 End Date : 6 Months from projected start date Submission deadline : 9/29/2023 @ 4:00PM CST. Client Info : UW - Madison Note : * Interview Process: Remote, Microsoft Teams * Duration: 6 months with the possibility of extension for another 3 or 6 months * .... (This job is for - GluJS Jobs in WI Madison Architect - (in Madison, WI))     (Developer: ETL Process, MS SQL Server, Relational Database, SQL DBA T SQL Stored Procedures SSIS RDB in Boston, MA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)