| Hiring For Data Warehouse Specialist, Remote at Remote, Remote, USA |
| Email: [email protected] |
| Title:- The Data Warehousing Specialist (DWS) designs, implements, and supports data warehousing initiatives. Remote IMPORTANT - READ FULLY: 1 - Candidates MUST have participated as an implementer/developer/tester in AT LEAST THREE (3) IDMC and/or Informatica MDM SaaS (NOT EDC on-prem) projects. If they have not had this specific experience, please don't hesitate to submit them for this role as they won't be considered. POSITION DETAILS: Enterprise Business Intelligence Solution (EBI) has for the last several years leveraged the Informatica PowerCenter application to perform a larger amount of data movement. This tool provides the capabilities of Extraction, Transformation and Loading (ETL) of data from any source to any target for any agency in the enterprise. EBI has learned that Information has scheduled the PowerCenter product line for end-of-life within the next few years. Informatica has a cloud-based replacement solution, and this project is the effort to migration all existing ETL workflows to that new solution. The resource selected for this role will support the integrity of migrating ETL workflows. This resource will utilize the Informatica Migration Toolset, correct any inconsistencies from automated migration and manually migrate any ETL workflows that the Toolset cannot accomplish. Responsibilities include: The EBI Data Warehouse Specialist will work closely with members of the EBI & Agency Stakeholders to confirm the migration of existing ETL workflows success. The EBI Data Warehouse Specialist will work perform the conversion of workflow management implementation to access and trigger the new IICS-based Informatica Workflows. Migration Expertise- In-depth knowledge of migration strategies, tools, and best practices for transitioning from PowerCenter to IDMC. Analyze EBI data and transformations and perform data validation and integration testing. Recommend and implement performance improvements of ETLs and optimization of scheduling efficiencies. Proficient with Informatica PowerCenter, EDC (Metadata Management), IDQ (Data Quality), Informaticas Intelligent Cloud Services (IICS), Informaticas Intelligent Data Management Cloud (IDMC), andHL7 Library on Linux. Proficient with workflow automation concepts and the tool CA Workload Automation DE. Monitoring and support of Informatica workflows in the EBI and effectively communicate with SMEs regarding failures, outages and/or delays in downstream processing as needed. Research and troubleshoot operational and performance issues on production systems. Work as directed by DoIT management to apply DoIT coding standards, Release Management procedures, source code control(GitHub) and best practices. Must safeguard and protect data in compliance with established EBI Data Governance, any state, federal or industry regulations and standards. Produces estimates of time and resources required to perform various tasks as part of a team. Skill Required / Desired Amount of Experience Experience in Informatica IDMC product line-up and/or hands-on experience with Informatica MDM SaaS Required 2 Years Informatica Powercenter, IICS, EDC (MetaData Management), IDQ (Data Quality) on Linux. Required 2 Years Must have participated as implementer/developer/tester in at least three (3) IDMC and/or Informatica MDM SaaS (NOT EDC on-prem) projects Required 1 Years Solid understanding of Data integration, Data Quality, data Architecture, Master Data Management, project life cycle, best practices and processes Required 3 Years Experience in integrating external workflow management applications with Informatica IDMC using Batch processes, API calls, and message queues. Required 3 Years Release Management procedures, source code control (GitHub) and best practices. Required 3 Years Excellent communication skills are required for this role Required 3 Years Experience with Broadcom's CA Workload dSeries product a plus. Desired 1 Years Thanks & Regards Manish Kumar Sr. Technical Recruiter Email: [email protected] Linkedin: Manish Chaudhary Jaat | LinkedIn ANVETA, Inc Address: 1333 Corporate Drive, Suite #108 Irving, TX 75038, USA -- Keywords: information technology California Delaware Texas Hiring For Data Warehouse Specialist, Remote [email protected] |
| [email protected] View all |
| Tue Nov 12 00:46:00 UTC 2024 |