ETL Data architect : Cincinnati, OH Hybrid at Cincinnati, Ohio, USA |
Email: [email protected] |
From: Upama, CBS [email protected] Reply to: [email protected] ETL Data architect Location: Cincinnati, OH (Hybrid Schedule The Data Integration and Warehouse Team is looking for a Technical Analyst with a development background to support new front-end integrations into, and Production Support issues derived from, our Business Unit systems into the Enterprise Data Warehouse via CXML integration. This person may also be a Technical Analyst on our Data Production Support team that supports our productionalized integrations for all of our business units via CXML integration, ETL, and mainframe ingestion, among others. The main focus on this team will be to define requirements/solutions and coordinate with a developer, if necessary, on incidents and requests that come into the Data team. The person who applies for this position should have a unique blend of soft skills, analytical skills, technical skills, and agility. He or she is proactive, dependency-aware, and can transition seamlessly between a holistic, enterprise perspective and a critical attention to detail. Responsibilities: Acts as a liaison between Data and different technical groups such as security, infrastructure, BU IT, and more Lead and guide development and analysis of an Informatica-based ETL architecture Head complex ETL requirements and design Develop mapping requirements, documenting data movement and transformation rules Collaborate with product development teams and senior designers to develop architectural requirements to ensure performant and scalable solutions that meet the business needs Conduct impact assessment and determine size of effort based on requirements for larger initiatives Enhance SDLC process to help further automate deployments, testing, and impact analysis Partner with development team to resolve difficult design and development issues Serve as mentor to other Technical Analysts Identify process and technical improvements that can be made and work to implement them according to team standards Work with the product owner and IT sponsor to prioritize work and shape backlog Contribute/participate in the Data Analyst Center of Excellence Performs other duties as assigned Qualifications: Excellent analytical, problem-solving, critical-thinking, and communication skills Adept experience within Informatica PowerCenter Exposure within Informatica IDMC (CDI, CAI, CMI, CDIE) Some cloud exposure, preferably Azure and/or Snowflake Excels in relational data base tools, including SQL Excellent oral, written, and interpersonal skills Ability to self-manage and stay on track with commitments; resourceful in solving problems and removing impediments Ability to think creatively, champion new ideas and challenge the status quo Adaptable and can effectively cope with rapidly changing business landscape Experience: 7+ years related experience in Data Integration Development or Data Analysis 5+ years experience within ETL Architecture Bachelors degree in Information Technology, Business, Computer Science, or related discipline or equivalent work experience. Agile delivery experience necessary Commercial Insurance experience a plus Keywords: information technology Ohio |
[email protected] View all |
Tue Jul 18 02:02:00 UTC 2023 |