Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
ETL Migration Implementation MS Access Administrator
(Jobs in Albany, NY)
 
Requirement id 116710
Job title Administrator
Job location in Albany, NY
Skills required ETL, Migration, Implementation, MS Access
Open Date 14-May-2021
Close Date
Job type Contract
Duration 30 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Administrator: ETL, Migration, Implementation, MS Access

Description:

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

Work in conjunction with the project data migration lead to conduct data analysis of both current and to-be WIC systems, in order to maintain an understanding of current and future needs.
Collaborate with customers, vendors, and technical workgroups to identify and document data and reporting requirements, reporting processes, gap analysis, and prioritization of reporting needs.
Create documents describing business flow and function using flow charts and data/process models describing these business functions.
Develop ETL mappings for migration of data from SYBASE, MS ACCESS to Oracle
Create report and dashboard prototypes.
Participate in development of solutions to meet end user reporting requirements.
Develop data test protocols, including test plans, creation and execution of test scripts, scenarios, and test plans that validate initial business requirements. Test report accuracy and document test results.
Evaluate implementation strategies and document issues requiring resolution.
Schedule, facilitate, and record report development meetings as needed.

Preferred 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.
60-84 Months-Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.

Mandatory Qualifications:

72 Months Experience using Informatica 8.x or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings, and merging data from multiple source systems including but not limited to ORACLE and flat files.
36 Months Experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge with IDQ 8.x or higher.
60 Months Work experience implementing Fine Grain Access Control Audit (FGACA) and Virtual Private Database (VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI)
60 Months Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica.
60 Months Experience writing complex UNIX scripts to validate and ftp files, and for calling Informatica workflows.
60 Months Experience converting complex SQL, PL/SQL (stored procedures/functions), as well as SAS code with Oracle 9i, 10g or higher, to Informatica mappings.
72 Months Experience in Dimensional Data Modeling for creating logical and physical data models using Erwin.
72 Months Experience specifying and conducting system testing (e.g., unit, integration, regression, load, performance) and user acceptance testing.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 116710 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),
ETL job openings in Albany, NY
Jobs List

Expert IT Specialist - 6826
Create date: 13-Jun-2022
Description:

Qualifications

IT Specialist - Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Expert (84+ months) - Can.... (This job is for - Obiee ETL SSA Jobs in NY Albany Specialist - (in Albany, NY))

Expert IT Specialist - 6512
Create date: 04-May-2022
Description:

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

Capture and load source system data via ETL processes into the data mart.
Develop, test and implement program logic for ETL development.
Efficiently implement team developed ETL technical specifications.
Optimize ETL data load jobs to imp.... (This job is for - ETL Jobs in NY Albany Specialist - (in Albany, NY))

Expert Business Analyst - 6425
Create date: 26-Apr-2022
Description:

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

Work as a liaison among stakeholders to elicit, analyze, communicate and validate the requirements for changes to current business processes, policies and information systems and for the development of new business processes, policies and information systems.
.... (This job is for - ETLObiee Jobs in NY Albany Analyst - (in Albany, NY))

IT Specialist - 6312
Create date: 07-Apr-2022
Description:

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

Manages ETL solutions for medium to large scale data warehouse projects.
ETL application analysis, design, development, and implementation, including data analysis, data access, data structures, data manipulation, data reporting solutions, database, and te.... (This job is for - ETL Jobs in NY Albany Specialist - (in Albany, NY))

IT Specialist - 6195
Create date: 14-Mar-2022
Description:

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

Support and development for the SFS Analytics Financial Data Warehouse.
Analyze, design, build and test ETL components and data models for a BIApps Peoplesoft Financials data warehouse.

Qualifications:

84 months of Data Warehouse .... (This job is for - ETLRPD Jobs in NY Albany Specialist - (in Albany, NY))
 
 ETL job openings in other states
Jobs List

Data Warehouse Developer III - 130341
Create date: 09-May-2024
No of Submissions : 2

Start date : 06/17/2024

End date : 06/30/2024

Submission deadline : 5/15/2024 at 4:00PM CST.

Client info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? No.... (This job is for - ETLCDC Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III -129720
Create date: 24-Apr-2024
No of Submissions : 2

Start date : 06/03/2024

End Date : 06/30/2024

Submission deadline : 5/1/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? No.... (This job is for - ETL Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Developer III - 128748
Create date: 28-Mar-2024
Start date : 05/20/2024

End date : 06/30/2024

Submission deadline : 4/4/2024 at 4:00PM CST.

Client info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.

* Duration: 6/30/2024, likely to extend.

* Onsite or Remote? No WI residency required. Open to n.... (This job is for - ETL CDC Jobs in WI Madison Developer - (in Madison, WI))

Data Warehouse Architect 3 - 128536
Create date: 27-Mar-2024
Start date : 04/22/2024

End Date : 09/30/2024

Submission deadline : 4/1/2024 at 10am EST.

Client Info : DHHS

Note :

* Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discouraged. A screensho.... (This job is for - ETL Jobs in MI Lansing Architect - (in Lansing, MI))

Data Warehouse Developer III -128359
Create date: 18-Mar-2024
Start date : 04/08/2024

End Date : 06/30/2024

Submission deadline : 3/20/2024 at 4:00PM CST.

Client Info : ETF

Note :

* Interview Process: 1-2 rounds via Microsoft Teams.
* Duration: 6/30/2024, likely to extend.
* Onsite or Remote? Candidates MUST be WI residents or willing to r.... (This job is for - ETL Alteryx Jobs in WI Madison Developer - (in Madison, WI))
 
 ETL job openings in NY
Jobs List

Expert Systems Architect - 7021
Create date: 27-Jul-2022
Description:

Qualifications

Systems Architect - Defines the architecture of a computerized system (i.e., a system composed of software and hardware) in order to fulfill certain requirement, including a breakdown of the system into components, the component interactions and interfaces (including with the environment, especi.... (This job is for - ETL TFS Jobs in NY NewYork Architect - (in New York, NY))

Expert Programmer - 6632
Create date: 13-May-2022
Description:

Qualifications

Programmer: Creates computer software. May specialize in one area of computer software or may write code for many kinds of software.
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.... (This job is for - Analytics ETL SSIS Jobs in NY NewYork Consultant - (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))

Expert Systems Developer - 6046
Create date: 16-Feb-2022
Description:

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

Work in coordination with a team of developers to expand the current Data Warehouse.
Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
Perform unit testing and correct all identified bugs.
Perform.... (This job is for - ETLSDLC Jobs in NY Rensselaer Developer - (in RENSSELAER, NY))

Power Platform Automate BI SQL Developer - 5623
Create date: 26-Oct-2021
Description:

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

Develop optimal and scalable Business Intelligence (BI) to meet customer needs.
Design, develop, test and implement data warehouse systems for reporting and analysis.
Prepare and maintain reporting and analysis documentations.
Generate Po.... (This job is for - ETL Documentation Jobs in NY NewYork Developer - (in New York, NY))
(Administrator: ETL, Migration, Implementation, MS Access 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