Data Architect | Informatica | Onsite | US
Photon - new york city, NY
Apply NowJob Description
Job Description Key Responsibilities: Data Architecture Design: Collaborate with stakeholders, including business analysts, data engineers, and database administrators, to understand business requirements and design data architectures that support data integration, transformation, and storage within the Informatica ecosystem. Informatica Tool Selection: Evaluate and recommend appropriate Informatica tools and components for specific data-related projects and initiatives, ensuring alignment with organizational goals and data management standards. Data Modeling: Develop and maintain data models that capture the structure, relationships, and definitions of data entities, ensuring data accuracy, consistency, and integrity throughout the data lifecycle. Data Integration: Design and implement data integration solutions using Informatica PowerCenter, PowerExchange, and other relevant Informatica products to facilitate seamless data flow between various systems and platforms. Data Quality and Governance: Define and enforce data quality standards, data governance policies, and data security measures to ensure compliance with industry regulations and organizational data governance requirements. Performance Optimization: Identify opportunities to enhance data processing efficiency, optimize data workflows, and improve overall system performance using Informatica's performance tuning techniques. Metadata Management: Implement and maintain metadata repositories, enabling effective data lineage, data impact analysis, and data cataloging to support data governance and data lineage requirements. Collaboration and Support: Work closely with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand their data needs and provide guidance on leveraging Informatica solutions effectively. Documentation and Training: Create and maintain comprehensive technical documentation for data integration processes, data models, and system architectures. Conduct training sessions for end-users and team members to promote knowledge sharing and best practices adoption. Continuous Improvement: Stay abreast of the latest developments in Informatica technologies and data management practices, and proactively identify opportunities to improve existing processes and adopt new features to enhance overall data solutions. Requirements: Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. Proven experience as a Data Architect, with a focus on Informatica tools and technologies. In-depth knowledge of data modeling, data integration, ETL (Extract, Transform, Load) processes, and data governance principles. Hands-on experience with Informatica PowerCenter, PowerExchange, Informatica Data Quality (IDQ), and Informatica MDM (Master Data Management) is highly desirable. Strong SQL and database management skills. Familiarity with data warehousing concepts and data analytics tools. Excellent analytical, problem-solving, and communication skills. Ability to work collaboratively in a team environment and lead data-related projects. Experience in data profiling, data mapping, and data lineage analysis is a plus. Industry certifications in Informatica or data management domains are advantageous
Created: 2024-11-12