Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
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 - 11412-1
Create date: 15-Oct-2024
No of Submissions :

Start date : 11/2/2024

Submission deadline : 10/22/2024

Client Info : (EXP 6.30.2024) Health & Environmental Control Department (DHEC)

Note :

Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

A) An interview panel will cond.... (This job is for - Workflow Jobs in SC COLUMBIA Consultant - (in Columbia, SC))

Programmer Analyst 5 -134955
Create date: 13-Sep-2024
Bid Limit Per Vendor : 1

Start date : 10/14/2024

End Date : 09/30/2025

Submission deadline : 9/20/2024 at 10am EST.

Client Info : DOC

Note :

* Interview Process: Virtual Interview via MS Teams video. There is potential for a 2nd round interview which may be held in-person.
T SQLDatabase Admin Jobs in MI Lansing Analyst - (in Lansing, MI))

DATABASE DEVELOPER (SQL) - ADVANCED - 11345-1
Create date: 21-Aug-2024
No of Submissions : 2

Start date : 9/23/24

Submission deadline : 8/28/2024

Client Info : Department of Transportation

Note:

Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)?

A) PHONE

Q) INTERVIEW AVAILABILITY: How soon can you schedule an in.... (This job is for - Tuning Jobs in SC COLUMBIA Developer - (in Columbia, SC))

SYSTEMS SOFTWARE PROGRAMMER - ADVANCED - 11326-1
Create date: 06-Aug-2024
No of Submissions : 2

Start date : 9/2/2024

Submission deadline : 8/15/2024

Client Info : Department of Juvenile Justice

Note:

Q) INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)?

A) INTERVIEWS WILL BE CONDUCTED IN PERSON WITH AN INTERVIEW PANEL O.... (This job is for - job Jobs in SC Columbia Consultant - (in Columbia, SC))

DATABASE DEVELOPER (SQL) - ADVANCED - 11297-1
Create date: 18-Jul-2024
No of Submissions : 2

Start date : 8/05/2024

Submission deadline : 7/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

Q) INTERVIEW AVAILABILITY: How soon can you schedule an i.... (This job is for - SQL 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)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved