Data Integration Architect

7 days ago


Pune, India InfoCepts Full time

Job Title : Data Integration Architect


Purpose of the Position:

We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of collaborating with business stakeholders to gather requirements and translate them into comprehensive source-target mapping documents. This position calls for a strategic thinker who can lead the design and implementation of data architectures that align with business objectives.


Work Location: Pune/Nagpur/ Bengaluru/ Chennai


Key Result Areas and Activities:


Requirement Gathering & Analysis:

  • Work closely with business stakeholders, Business Analysts (BAs), and technical teams to understand and translate business requirements into technical specifications.
  • Engage in detailed discussions with business users to define data integration and transformation rules.

Source-Target Mapping:

  • Develop detailed source-target mapping documents, including transformation logic, data flow diagrams, and data lineage.
  • Review and validate mapping documents with business stakeholders to ensure accuracy.

Technical Leadership:

  • Lead the design and architecture of ETL processes using Informatica, ensuring alignment with business requirements and industry best practices.
  • Provide guidance and support to Informatica developers and troubleshoot development issues.

Data Integration & Architecture:

  • Design and implement data integration solutions utilizing Informatica, Oracle, and Azure Data Lake.
  • Optimize ETL processes for performance, scalability, and reusability.

Collaboration & Communication:

  • Collaborate with cross-functional teams to ensure successful delivery of data integration projects.
  • Clearly communicate complex technical concepts to non-technical stakeholders.


Work and Technical Experience:

Essential Skills :

  • Excellent understanding of ETL/ELT principles and the tools/technologies used to implement them.
  • Expertise in Informatica Power Center and IDMC DI.
  • Strong hands-on experience with Oracle databases, SQL, and PL/SQL.
  • Basic understanding of Azure Data Lake and cloud-based data storage solutions.
  • Experience in data modelling, data integration, and data warehousing.
  • Understanding of data governance and data quality principles with proven ability to create detailed source-target mapping documents.


Desirable Skills:

  • Certifications in Informatica, Oracle, or Azure
  • Familiarity with version control systems, such as Git, and project management tools like Jira.
  • Understanding of good practices
  • Research focused mindset


Qualifications:

  • 12+ years of experience in IT, with at least 5+ years working with Informatica.
  • 3+ years of experience as an ETL/Data Architect.
  • Bachelor’s degree in computer science, engineering, or related field (Master’s degree is a plus)
  • Demonstrated continued learning through one or more technical certifications or related methods



  • Pune, India InfoCepts Full time

    Job Title : Data Integration ArchitectPurpose of the Position:We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of collaborating...


  • Pune, India InfoCepts Full time

    Job Title : Data Integration ArchitectPurpose of the Position:We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of collaborating...


  • Pune, India InfoCepts Full time

    Job Title : Data Integration ArchitectPurpose of the Position: We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of collaborating...


  • Pune, India InfoCepts Full time

    Job Title : Data Integration Architect Purpose of the Position: We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of...


  • Pune, Maharashtra, India InfoCepts Full time

    We are seeking a seasoned Data Integration Architect to join our team at InfoCepts. As a key member of our data architecture team, you will play a crucial role in designing and implementing end-to-end data integration solutions that drive business value.With a strong background in ETL/ELT principles and expertise in Informatica Power Center and IDMC DI, you...


  • Pune, India Renovision Automation Services Pvt. Ltd Full time

    **Experience**: - 10+ years Location - Pune (preferred), Mumbai, Bangalore, Chennai, Noida Shift Time - 2 pm - 11 pm Mode of Work - Hybrid (thrice in a week) Notice Period - Immediate to 15 days **JD-** **Responsibilities**: - Develop and maintain scalable architecture, database design and data pipelines and build out new Data Source integrations to...


  • Pune, Maharashtra, India 4Gen Technologies (Shenzyn) Full time

    Job OverviewThe role of the Lead ETL Developer at 4Gen Technologies is to design and implement data integration solutions using Informatica Intelligent Cloud Services (IICS). As a seasoned professional with at least 8 years of experience in ETL development, you will be responsible for translating business requirements into technical designs and...


  • Pune, India InfoCepts Technologies Pvt. Ltd. Full time

    Job Title : Data Integration ArchitectPurpose of the Position : We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of collaborating...

  • Integration Architect

    6 months ago


    Pune, Maharashtra, India Arting Digital Private Limited Full time

    Job Tiltle: - Integration Architect Experience: - 8 yr Budget: - 27.60 LPA Location: - Pune Work Mode: - Hybrid Education: - Any graduation Primary Skills: - Machine Learning: Proficiency in Machine Learning and tools for model development, deployment, and management. - Azure Data Factory and Databricks: - Azure Datalake Storage: -...


  • Pune, Maharashtra, India Uddyam People Full time

    Job DescriptionThe Integration Architect at Uddyam People will be responsible for designing and implementing integration solutions that enable seamless communication between heterogeneous systems. The role requires a strong understanding of API management, middleware technologies, and data format conversion tools. As an Integration Architect, you will work...


  • pune, India InfoCepts Full time

    Job Title : Data Integration ArchitectPurpose of the Position: We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of collaborating...


  • pune, India InfoCepts Full time

    Job Title : Data Integration Architect Purpose of the Position: We are looking for an experienced Data Architect with a deep understanding of ETL processes, particularly with Informatica, and a solid foundation in Oracle and Azure Data Lake. The ideal candidate should excel in data integration and data modelling, with a proven track record of collaborating...


  • Pune, India L&T Technology Services Full time

    Job Description:Integration architectWorked in transforming the data from different PLM systems like Windchill, Enovia, Teamcenter and ERP and has Architect experience.Experience: 6+ yearsLoc: Pune


  • Pune, India L&T Technology Services Full time

    Job Description: Integration architect Worked in transforming the data from different PLM systems like Windchill, Enovia, Teamcenter and ERP and has Architect experience. Experience: 6+ years Loc: Pune


  • Pune, Maharashtra, India Birlasoft Full time

    About BirlasoftBirlasoft is a pioneer in combining domain expertise, enterprise solutions, and digital technologies to redefine business processes. We pride ourselves on our consultative approach, driving societal progress by enabling customers to run businesses with unmatched efficiency and innovation.As part of the CK Birla Group, a multibillion-dollar...


  • Pune, India L&T Technology Services Full time

    Job Description: Integration architect Worked in transforming the data from different PLM systems like Windchill, Enovia, Teamcenter and ERP and has Architect experience. Experience: 6+ years Loc: Pune


  • Pune, India L&T Technology Services Full time

    Job Description:Integration architectWorked in transforming the data from different PLM systems like Windchill, Enovia, Teamcenter and ERP and has Architect experience.Experience: 6+ yearsLoc: Pune


  • Pune, India L&T Technology Services Full time

    Job Description:Integration architectWorked in transforming the data from different PLM systems like Windchill, Enovia, Teamcenter and ERP and has Architect experience.Experience: 6+ yearsLoc: Pune


  • Pune, Maharashtra, India Mejoba Consulting Full time

    Job Summary:We are seeking an experienced Senior Data Integration Architect to join our team at Mejoba Consulting. As a key member of our data integration team, you will be responsible for designing and developing end-to-end data integration solutions using Ab Initio.Responsibilities:Collaborate with business stakeholders to understand data integration...


  • Pune, Maharashtra, India NTT DATA Full time

    **Req ID**: 304038 We are currently seeking a Data Governance Architect to join our team in Pune, Mahārāshtra (IN-MH), India (IN). Job Duties: Lead the data management practice that includes but not limited to - Data Governance/catalog - MDM - Data Quality - Testing Minimum Skills Required: Must have experience in data analysis, data engineering for 10+...