Data Architect | Informatica | Onsite | US

6 months ago


New York, United States Photon Full time
Job Description

Key Responsibilities:
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. Performance Optimization: Identify opportunities to enhance data processing efficiency, optimize data workflows, and improve overall system performance using Informatica's performance tuning techniques.
  7. 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.
  8. 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.
  9. 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.
  10. 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


  • New York, United States Inizio Partners Full time

    About the job Informatica MDM Architect Role & Responsibilities Overview: Designing & implementing MDM strategies, policies, and procedures Managing and governing master data across the organization to ensure accuracy, consistency, and integrity. Collaborating with stakeholders across the organization to establish data standards and ensure adherence to...


  • New York, United States Tech Tammina Full time

    Job Title: Data Warehouse Architects / EngineersLocation: NYC, NYExperience: 14+ years in the IT industry. 8+ years working with US companies in the US. 8+ years as a Data Architect/Engineer. 5+ years of recent experience (since 2015) in a major banking or brokerage house environment. 6+ years with Informatica and Azure. 6+ years designing and implementing...


  • New York, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are in search of an experienced Data/Information Architect to join our team in New York, New York. This role involves the design, implementation, and management of identity solutions, along with engaging with customers and facilitating workshops. This role offers a long-term contract employment opportunity in the industry of...


  • New York, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are in search of an experienced Data/Information Architect to join our team in New York, New York. This role involves the design, implementation, and management of identity solutions, along with engaging with customers and facilitating workshops. This role offers a long-term contract employment opportunity in the industry of...


  • New York, United States Tata Consultancy Services Full time

    Role: ETL Informatica ConsultantLocation: New York, NY(Onsite)Job Type: Full TimeJob DescriptionKnowledge of PL/SQL is Must with hands-on experience.Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources...


  • new york city, United States Tata Consultancy Services Full time

    Role: ETL Informatica ConsultantLocation: New York, NY(Onsite)Job Type: Full TimeJob DescriptionKnowledge of PL/SQL is Must with hands-on experience.Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources...

  • Software Architect

    1 week ago


    New York, New York, United States Mitchell Martin Full time

    Job Description: We are seeking a highly skilled Software Architect to design and develop database/ETL software packages and programs for the banking industry. The ideal candidate will have experience with ETL, Informatica Powercenter 9x/10x, Teradata Database 14/16x, and Teradata Tools and Utilities.About the Role:Develop database/ETL software packages and...


  • york, United States Tata Consultancy Services Full time

    Role: ETL Informatica ConsultantLocation: New York, NY(Onsite)Job Type: Full Time Job DescriptionKnowledge of PL/SQL is Must with hands-on experience.Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources...


  • New York, United States CloudBC Labs Full time

    POSITIONInformatica PowerCenter DeveloperLOCATIONHYBRID On-site 3x week REQUIRED in any of the locations Preferred Locations: Purchase, NY; Morristown, NJ Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New York, NY;...

  • Informatica iics

    2 weeks ago


    New York, United States TechnoGen Full time

    Informatica Cloud Data Governance Catalogue Specialist - Consultant Location: NY / NJ Type: Contract on C2C The candidate should have a deep understanding of Informatica Data Governance tools and how they automate business processes. The candidate facilitates use case discussions and documents how the Informatica software interacts with the migration and use...

  • Informatica Cloud

    2 weeks ago


    New York, United States The Dignify Solutions LLC Full time

    Locations: New York, NY / Charlotte, NC - onsite 8+ years of ETL expertise with good IICS experience 1. Informatica Cloud (IICS), Data Integration, App & API Integration, Data Replication and Mass Ingestions services of Informatica Intelligent Cloud Services 2. Expertise in AWS Cloud and Snowflake Cloud Datawarehouse 3. Ability to handle end-to-end Data...

  • Informatica Developer

    2 weeks ago


    New York, United States Diverse Lynx Full time

    5+ Years of experience with Administration of Informatica Eco Systems (IICS, Power Center, IDQ). 2+ Years of recent technical experience on Informatica Integration Cloud Services (IICS). Informatica certification is a plus. Knowledge of Linux system. Knowledge of SAN storage, network, and virtual environments. Communication (written, verbal and listening),...


  • New York, United States SysMind Tech Full time

    Title: Azure Data Architect Location: NY/NJ(Onsite) At least 5+ years of experience in big data, database and data warehouse architecture and delivery. Minimum of 3+ years of professional experience in following areas: - Solution/technical architecture in tperson cloud - Big Data/analytics/information analysis/database management in tperson cloud -...


  • New York, United States Tata Consultancy Services Full time

    Knowledge of PL/SQL is Must with hands-on experience. Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources involving flat files and relational tables.Good Concept of Data warehouse to be...


  • New York, United States Informatica LLC Full time

    Build Your Career at Informatica We‘re looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world‘s most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data...


  • New York, United States Informatica LLC Full time

    Build Your Career at Informatica We‘re looking for a diverse group of collaborators who believe data has the power to improve society. Adventurous, work-from-anywhere minds who value solving some of the world‘s most challenging problems. Here, employees are encouraged to push their boldest ideas forward, united by a passion to create a world where data...

  • Snowflake Architect

    3 weeks ago


    New York, United States Lorven Technologies Inc. Full time

    Snowflake ArchitectLocation: New York, NY (Day1 Onsite) Job Type: (C2C/W2)Responsibilities: Relevant Experience: 12+ YearsMandatory Skills: Snowflake, SQL Cloud platforms (AWS, Azure or GCP), ETL tools (e.g., Informatica, Talend), Python or Java is a plusJob Description: Snowflake Architect with deep expertise in the payment’s domain. Architecture Design:...


  • new york city, United States Tata Consultancy Services Full time

    Role: ETL Informatica ConsultantLocation: New York, NY(Onsite)Job Type: Full TimeJob DescriptionKnowledge of PL/SQL is Must with hands-on experience.Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources...


  • New York, United States Saransh Inc Full time

    Role: Snowflake Architect with payments experienceLocation: NYC, NY (Onsite from Day 1)Duration: Long Term ContractOverall 12+ yrs experience is requiredMandatory Skills:Snowflake, SQL Cloud platforms (AWS, Azure or GCP), ETL tools (e.g., Informatica, Talend), Python or Java is a plus.Job Description:Snowflake Architect with deep expertise in the payment’s...


  • New York, United States Shulman Fleming & Partners Full time

    Senior Data ArchitectMUST be local to New York. Hybrid Schedule. At least 3 days onsite.Salary: up to $240k baseNo SponsorshipKey Responsibilities:Build and document reference architecture, including conceptual, logical, and physical models.Communicate and mentor teams on architectural standards and best practices.Support engineering teams in implementing...