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 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)) ITSAC 529400647 Systems Analyst 3 -SP Create date: 01-Aug-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000007LzPAAU/529400647 Note: Online Submission Note: Total estimated hours per Candidate shall not exceed 2000 hours Note: RTR form must be signed by the candidate Submission Deadline: 8/8/2023 5:00 PM CT Start Date: 9/1/2023 End Dat.... (This job is for - Integration Jobs in TX Austin Analyst - (in Austin, TX)) T-SQL Developer - SME - 119468 - SP Create date: 22-Jun-2023 start date : 7/10/2023 End date : 09/30/2024 submission deadline : 6/30/2023 3:00:00 PM client info : MDEK12 Note : * Off-site Description : This position will require qualified T-SQL Developers to take the lead in the fol.... (This job is for - T SQL Jobs in MS Jackson Developer - (in Jackson, MS)) ITSAC 529300549 Developer/Programmer Analyst 3 -SP Create date: 04-May-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000006lgkAAA/529300549 Note: Online Submission Note: Total estimated hours per Candidate shall not exceed 696 hours Note: RTR form must be signed by the candidate Submission Deadline: 5/9/2023 5:00 PM CT Start Date: 6/5/2023 End Date.... (This job is for - Developer ProgrammerIntegration Jobs in TX Austin Developer - (in Austin, TX))     (Developer: ETL Process, MS SQL Server, Relational Database, SQL DBA T SQL Stored Procedures SSIS RDB in Boston, MA)

Featured Jobs IT Specialist (Jobs in Raleigh, North Carolina) IT Specialist (Jobs in Raleigh, North Carolina) Systems Specialist (Jobs in Raleigh, North Carolina) Functional Analyst (Jobs in Madison, Wisconsin) Biztalk PowerShell XSLT Developer (Jobs in Hartford, Connecticut) DFS DHCP Active Engineer (Jobs in Madison, Wisconsin) Team Developer (Jobs in Hartford, Connecticut) Quality Assurance Ms Consultant (Jobs in Durham, North Carolina) PMP PMI Agile Manager (Jobs in Richmond, Virginia) TSQL Specialist (Jobs in Raleigh, North Carolina)