Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SSIS ETL Data Integration Planning Architect
(Jobs in Albany, NY)
 
Requirement id 134465
Job title Architect
Job location in Albany, NY
Skills required MS SQL, SSIS, ETL, Data Integration Planning
Open Date 13-Jun-2022
Close Date
Job type Contract
Duration 24 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Architect: MS SQL, SSIS, ETL, Data Integration Planning

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.
Expert (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)

Day-to-Day tasks

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.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 134465 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 Albany, NY
Jobs List

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 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))

Microsoft SQL Server Database Administrator - 4817
Create date: 06-Apr-2021
Description:

Day-to-Day Tasks include, but not limited to:

Install, configure, administer, and manage MS SQL Server databases including high availability and disaster recovery configurations.

Assist in Developing and implementing appropriate high availability and disaster recovery solutions.

P.... (This job is for - MS SQL Server Jobs in NY Albany Administrator - (in Albany, NY))

MSSQL Database Administrator - 4795
Create date: 01-Apr-2021
On-site/Remote:
On-site

Description:

Responsibilities

TVT is a NYS HBITS Prime Vendor! Are you Tech Terrific, an innovative thinker, and have great interpersonal skills? We have a 30-month project with our client in Albany, NY that requires a MSSQL Database Administrator, Expert.

Day-to-Day Tasks.... (This job is for - Developing Jobs in NY Albany Administrator - (in Albany, NY))
 
 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 Database Architect. - 6513
Create date: 27-Apr-2022
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, T.... (This job is for - ETL Jobs in NY Rensselaer Architect - (in RENSSELAER, NY))

Database Developer - 63746
Create date: 02-Jun-2020
Note:

* Candidate must be your W2 Employee.

* We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen.

* We should take signed RTR form from the candidate (Candidate RTR form should be only on the name of Apex Systems)

Job Description :

Database Developer

24 MONTHS

P.... (This job is for - SSIS Tableau Jobs in NY NewYork Developer - (in New York, NY))

SQL Database Developer - 60661
Create date: 05-Mar-2020
Job Description :

It combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country.





Here are the details:



Position: SQL Database Developer

Location: Buffalo, NY

Rate: Negotiable

Duration: 6+ Month Contr.... (This job is for - SSIS Jobs in NY Buffalo Developer - (in Buffalo, NY))

Senior MySQL Admin
Create date: 16-Dec-2014
Note: End Client Name : McGrawHill Education

Description:

Hands-on experience in database administration of MySQL.
Hands-on experience with various MySQL engine types, include InnoDB, MyISAM, MEMORY.
Hands-on experience with setup, configuration, maintenance, trouble-shooting MySQL replication environments.
Hand.... (This job is for - job Jobs in NY Hightstown Administrator - (in Hightstown, NY))
(Architect: MS SQL, SSIS, ETL, Data Integration Planning in Albany, 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