ETL Documentation Architect (Jobs in Rensselaer, NY)   Requirement id 133409 Job title Architect Job location in RENSSELAER, NY Skills required MS SQL, ETL, Data Modeling, Documentation Open Date 27-Apr-2022 Close Date Job type Contract Duration 24 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: MS SQL, ETL, Data Modeling, Documentation Description: Day-to-Day Tasks include, but not limited to: Build complex SQL queries, stored procedures, functions, views, and reports. Understand the business needs and work with developers to design modern and effective database architectures. Analyze functional requirements to perform ad-hoc Extract, Transform and Load (ETL) processes involving data analysis, data manipulation and setting up SSIS packages. Review performance logs to track and analyze production issues, identify and eliminate obsolete DB objects, and optimize stored procedures and jobs to improve database responsiveness. Participate in unit and regression testing by assisting business analysis team to mine and translate complex dataset. Work with data modelling team to draft/maintain system data model and data dictionary. Establish standards for system documentation and advise other team members. Participate in planning and transformation of UIS to new platform. Participate in data integration activities for PBS E-Registration and for mobile field inspection project. Qualifications: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. 84+ Months - Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. 84 months experience in design and development of advanced SQL queries, stored procedures, triggers, scripts, cursors, and views 84 months experience in MS SQL Server Management Studio (MS SQL Server version 2012+, and upgrade to MS SQL 2019) and proficient use of standard business and database software (including SSRS, SSMS, SSIS), and strong understanding of ETL concepts (Extract, Transform and Load) 84 months of experience in designing data architecture and data modelling (data dictionary and system documentation), including the ongoing maintenance of an existing data model 84 months of experience supporting day-to-day database operations, including: monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization, tuning, consolidating views and tracking and improving database performance metrics 60 months of experience with geocoding processes (importing GIS data to database, data modeling) and experience with Geographic Information Systems (i.e. ArcGIS Pro, Google Maps)   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 133409 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2),    MS SQL job openings in other states Jobs List WEB/INTERNET ENGINEER-CONSULTANT - 11198-1 Create date: 24-Apr-2024 Candidate Submission Limit Per Supplier : 2 Start date :5/17/2024 Submission deadline : 5/1/2024 Client info : Health & Environmental Control Department (DHEC) Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? - An interview panel will.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) Security Architect - 11168-1 Create date: 25-Mar-2024 Start date : 5/2/2024 Submission deadline : 4/1/2024 Client Info : Department of Motor Vehicles Note : Q) Interview Process (who will conduct i/v, phone or in-person, how many rounds of i/vs)? A) • Eric Crane, Security Team Manager • In-person preferred but will be willing to accommoda.... (This job is for - job Jobs in SC Blythewood Architect - (in Blythewood, SC)) SYSTEMS ANALYST-11159-1 Create date: 12-Mar-2024 start date :APRIL 9, 2024 submission deadline :3/19/2024 client info :Department of Health and Human Services Note: Q) INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)? A) HIRING MANAGER WILL CONDUCT MICROSOFT TEAMS INTERVIEWS Q) SCHEDULE INTE.... (This job is for - job Jobs in SC COLUMBIA Analyst - (in Columbia, SC)) DATABASE DEVELOPER (SQL) - ADVANCED - 11149-1 Create date: 05-Mar-2024 Start date : 3/4/24 Submission deadline : 3/12/2024 Client info : Department of Transportation Description : RE-DEVELOPMENT AND INTEGRATION OF MULTIPLE DATABASE SYSTEMS SERVING INTERFACING BETWEEN THE AGENCY PERSONNEL INFORMATION SYSTEM, CLOUD HOSTED ENTERPR.... (This job is for - job Jobs in SC COLUMBIA Developer - (in Columbia, SC)) DATABASE DEVELOPER (SQL) - ADVANCED -11131-1 Create date: 20-Feb-2024 Start date :03/04/2024 Submission deadline : 2/27/2024 Client Info : Department of Transportation Note : Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? A) PHONE Description : ------------------------------------------------------ RE-DEVELOPM.... (This job is for - Tuning RDBMS Jobs in SC COLUMBIA Developer - (in Columbia, SC))    MS SQL job openings in NY Jobs List AWS Sr. Java Developer Create date: 08-Jul-2022 Description: Responsibilities · Develop JSON RESTful web service APIs for Digital Banking Platform. · Participate in complete project life cycle. Provide technical requirements/specifications, project estimates, and system design configuration for simple to complex projects. Complex projects may include multiple bus.... (This job is for - TOMCATJava Jobs in NY NewYork Developer - (in New York, NY)) Expert Software Architect - 6829 Create date: 13-Jun-2022 Description: Qualifications Software Architect - Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large scale software system. Expert (84+ months) - Candidate is able to pro.... (This job is for - job Jobs in NY Albany Architect - (in Albany, NY)) Expert Database Architect - 6828 Create date: 13-Jun-2022 Description: Qualifications Database Architect- Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. .... (This job is for - SSIS ETL Jobs in NY Albany Architect - (in Albany, NY)) Expert Software Architect - 6120 Create date: 03-Mar-2022 Description: Day-to-Day Tasks include, but not limited to: Mentoring and guiding team members through the development process. Working with project managers and business analysts to understand the schedule, scope, requirements and deliverables. Design software components that address scope and requirement.... (This job is for - Oracle Design Jobs in NY Albany Architect - (in Albany, NY)) Senior Software Developer - 5356 Create date: 10-Aug-2021 Description: Day-to-Day Tasks include, but not limited to: Primarily responsible for Supporting and Maintaining MS Access Applications. Assist with modernizing MS Access Database applications written in MS Access, to other technologies (Oracle, MS SQL, Java). Manage and develop data extracts and reporting.... (This job is for - OracleJava Jobs in NY Albany Developer - (in Albany, NY)) (Architect: MS SQL, ETL, Data Modeling, Documentation in RENSSELAER, NY)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)