ETL Low Level Design Mapping Informatica Shell Scripting PLSQL Packages Procedures   Requirement id 110174 Job title Architect Job location in Menands, NY Skills required Data Warehouse Architecture, ETL, High Level Design Documents, Low Level Design Mapping Informatica She Open Date 18-Sep-2020 Close Date Job type Contract Duration 24 Months Compensation DOE Status requirement --- Job interview type Phone Screening    Email Recruiter: coolsoft Job Description Architect: Data Warehouse Architecture, ETL, High Level Design Documents, Low Level Design Mapping Informatica She Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/30/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Menands, NY that requires a Senior Data Warehouse Architect Day-to-Day Tasks include, but not limited to: Analyze the data model using ER Studio Data Architect 17.1.0. Analyze the source system data stores. Design the ETL as per standard. Create data lineage documents. Create high level ETL design documents as per standard. Create low level ETL design documents as per standard. Create Informatica 10.2.0 ETL mapping as per standard. Create Informatica 10.2.0 Sessions as per standard. Create Informatica 10.2.0 Workflow as per standard. Create Unix/Linux shell scripting as needed Create complex PL/SQL package, procedure, and function as needed. Create documentation for all work. Migrate the ETL mappings from Oracle Warehouse Builder (OWB) 11.2.0.4.0 to Informatica 10.2.0. Migrate and change the PL/SQL packages, procedures, and functions from existing to new data warehouse. Migrate and change the data from the existing to new data warehouse as needed. Migrate and change the Views and Materialized views from the existing to new data warehouse as needed. Migrate and change the data sharing extraction scripts as needed. Monitor and tune the performance of Informatica 10.2.0 ETL Monitor data anomalies between source system and data warehouse. Ensure the data quality of the data warehouse. Maintain and troubleshoot ETL processes. Mandatory Qualifications: 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. 60-84 months Candidate able to work independently, without assistance and provides guidance to others. May have an advanced education Preferred Qualifications: 66 Months experience with creating and maintaining Data warehouse using Oracle Database. 66 Months experience in Data Warehouse using Informatica ETL tool. 66 Months experience with SQL, PL/SQL, and Unix/Linux Scripts. 66 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 60 Months experience working with business intelligence tools (e.g., OBIEE 11G). 60 Months experience in redesign of Data Warehouse by using reverse engineering approach and applying informatica ETL tool. 60 Months experience with designing, creating applications and health care Data Warehouse and business intelligence reporting solutions. 48 Months experience working with HIPAA requirements or similar standards and Accessibility Standards. 48 Months experience with reviewing the ETL Design and ETL mappings of others for compliance and accepted standards of development. Languages Must have English Native or bilingual proficiency Additional vendor information Candidates need to meet 60% of the Preferred Qualifications to qualify for the position.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 110174 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), Data Warehouse Architecture job openings in Menands, NY Jobs List Senior Data Warehouse Architect - 4158 Create date: 18-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/30/20. Responsibilities TVT is a NYS HBITS Prime Vendor! Are you energetic and enthusiastic, as well as uniquely talented? We have a 24-month project with our client in Menands.... (This job is for - Communication Jobs in NY Menands Architect - (in Menands, NY))    Data Warehouse Architecture job openings in other states Jobs List Chesterfield County Data Warehouse Architect 4 (743061) Create date: 24-Jul-2024 Hybrid No of Submissions : 3 start date :08/05/2024 End date :07/31/2025 submission deadline : 7/29/2024 client info : Chesterfield County Note: * Agency Interview Type: Both Web Cam and In Person Interview Descript.... (This job is for - job Jobs in VA Chesterfield Architect - (in Chesterfield, VA)) ELECT - Data Warehouse-BI Developer 3 - REMOTE (700810) Create date: 25-Jan-2023 start date : 01/03/2023 End date : 12/29/2023 submission deadline : 1/30/2023 client info : ELECT Note : * REMOTE * Web Cam Interview Only Description : Responsible for designing, developing, and maintaining data .... (This job is for - Testing Jobs in VA Richmond Developer - (in Richmond, VA)) ITS63-EHS-FY20-Data Warehouse Architect-004-DW-REPOST -SP Create date: 27-Jan-2020 Note: Email Submission Note: Interview requirements: _MUST BE IN PERSON and person must be local Note: This positon May be filled PRIOR TO CLOSE DATE Note: Maximum number of resumes per ITS63 Vendors: __2 Note: Resumes must be emailed to: EOHHS ITContractorResumes@state.ma.us Submission Deadline: 1/30/2020 Sta.... (This job is for - job Jobs in MA Quincy Architect - (in Quincy, MA)) Architect - 53570 Create date: 20-Jun-2018 Description: Data Warehouse Architect The Data Warehouse Architect is responsible for the architectural design, development and maintenance of complex, enterprise-wide data warehousing systems. Provides leadership and direction including long and short-range planning of data warehouse architecture, ETL processes, and data mode.... (This job is for - Architect Jobs in GA Atlanta Architect - (in Atlanta, GA)) K2380 Data Architecture Consulting Services -SPO Create date: 19-Jun-2017 Submission Deadline : 7/6/2017 2.00PM Client : Washington State Health Care Authority (WSHCA) Description : The Washington State Health Care Authority, hereafter called “HCA,” is initiating this Request for Proposals (RFP) to solicit proposals from qualified vendors to supply IT consulting services to support HCAs .... (This job is for - Medicaid Jobs in WA Olympia Architect - (in Olympia, WA))    Data Warehouse Architecture job openings in NY Jobs List Data Warehouse Architect - 4145 Create date: 17-Sep-2020 Note: * On-site/Remote: On-site * Interview: Phone or video call * Please be advised responses are due no later than 9/28/20. Responsibilities Are you energetic and enthusiastic, as well as uniquely talented? We have a 30-month project with our client in New York, NY that requires a Data Wareho.... (This job is for - Python Jobs in NY NewYork Architect - (in New York, NY)) C001043 ETL Developer/ Data Warehouse Architect -SPO Create date: 26-Dec-2017 Note : Email Or Paper submission Submission Deadline : 1/5/2018 Start Date : 2/15/2018 End Date : 11/14/2018 Client : Office of the State Comptroller ("OSC") Description : SERVICES A. Requirements The Consultant shall work with the Data Analytics Bureau and the Division of the Chief.... (This job is for - job Jobs in NY Albany Developer - (in Albany, NY)) (Architect: Data Warehouse Architecture, ETL, High Level Design Documents, Low Level Design Mapping Informatica She in Menands, NY)

Featured Jobs Quality Assurance Consultant (Jobs in Los Angeles, California) Consultant (Jobs in Detroit, Michigan) Education Communication CCWIS Analyst (Jobs in Hartford, Connecticut) Implementation Stakeholders Consultant (Jobs in PORT HURON, Michigan) Problem Analyst (Jobs in Lincoln, Nebraska) Team Consultant (Jobs in Madison, Wisconsin) Communication Team Analyst (Jobs in Lansing, Michigan) Support Renewal Consultant (Jobs in Los Angeles, California) Support Consultant (Jobs in Boston, Massachusetts) - Consultant (Jobs in Arlington, Texas)