Informatica Architect

1 day ago

Bengaluru Hyderabad Pune, India Anlage Infotech Full time ₹ 20,00,000 - ₹ 25,00,000 per year

Role & responsibilities

Top 3 skills which is mandatory

• PowerExchange CDC with Oracle configuration, logs, extraction groups, and monitoring.

• IDMC Services: CMIDB, CDI, and CAI.

• Oracle database internals, MS SQL Server, and CDC mechanisms.

• Informatica Certified Professional – IDMC, CDI, or PowerCenter.

• Experience with cloud environments (AWS, Azure, GCP) for IDMC deployment.

Informatica Architect

Key Responsibilities

1. Current-State Assessment & Gap Analysis


• Perform detailed analysis of existing PowerExchange CDC configuration with Oracle.

• Identify data extraction, transformation, and load patterns, dependencies, and performance metrics.

• Document architecture gaps and opportunities for modernization within IDMC.

2. Target-State Design & Solution Architecture


• Design the target-state IDMC architecture leveraging:

- Cloud Mass Ingestion (CMI–DB) for CDC and bulk ingestion.

- Cloud Data Integration (CDI) for data transformation, orchestration, and integration pipelines.

- Cloud Application Integration (CAI) for process integration and event-driven workflows.

• Define configuration parameters, connectivity details, and orchestration logic between IDMC services and Oracle.

• Develop architecture diagrams, configuration templates, and security/compliance recommendations.

3. Proof of Concept (POC) & Implementation


• Plan and execute POC to validate CDC, performance, and functional parity between PowerExchange and IDMC.

• Collaborate with Informatica and Oracle admin teams for environment setup, agent configuration, and connectivity.

• Oversee end-to-end migration, including deployment, testing, and performance tuning.

• Ensure compliance with NTT DATA delivery standards and data governance guidelines.

4. Documentation & Knowledge Transfer


• Prepare comprehensive documentation of analysis findings, design decisions, and configuration steps.

• Develop standard operating procedures (SOPs) for IDMC platform operations, monitoring, and troubleshooting.

• Conduct workshops and handover sessions for development and operations teams.

5. Technical Leadership & Mentoring


• Provide architectural direction and mentoring to data engineers, ETL developers, and administrators.

• Review technical deliverables to ensure adherence to solution design and best practices.

• Lead client discussions, manage stakeholder expectations, and ensure alignment with business objectives.

Required Skills & Experience


• 10+ years of experience in Informatica data integration technologies, including PowerExchange, PowerCenter, and IDMC.

• Hands-on expertise in:

- PowerExchange CDC with Oracle – configuration, logs, extraction groups, and monitoring.

- IDMC Services: CMI–DB, CDI, and CAI.

• Strong understanding of Oracle database internals, MS SQL Server, and CDC mechanisms.

• Experience in data migration, replication, and real-time streaming.

• Working knowledge of file formats – Parquet, CSV, JSON, and integration into data pipelines.

• Proven ability to conduct POCs, performance optimization, and solution validation.

• Excellent skills in architecture documentation, data flow design, and presentation.

• Strong analytical, communication, and leadership abilities.

Preferred Qualifications


• Informatica Certified Professional – IDMC, CDI, or PowerCenter.

• Experience with cloud environments (AWS, Azure, GCP) for IDMC deployment.

• Knowledge of Data Quality (IDQ) and Data Governance within IDMC ecosystem.

• Prior experience in migration or modernization projects from on-premises to cloud

  • Solutions Architect

    1 week ago

    Bengaluru, Karnataka, India Informatica Full time

    **Build Your Career at Informatica**: We seek innovative thinkers who believe in the power of data to drive meaningful change. At Informatica, we welcome adventurous, work-from-anywhere minds eager to tackle the world's most complex challenges. Our employees are empowered to push their bold ideas forward, and we are united by a shared passion for using data...

  • Solutions Architect

    1 week ago

    Bengaluru, Karnataka, India Informatica Full time

    Full Time- On-SiteBengaluru, Karnataka, India Job Category: Customer Experience Posted within last 24 Hours Build Your Career at Informatica We seek innovative thinkers who believe in the power of data to drive meaningful change. At Informatica, we welcome adventurous, work-from-anywhere minds eager to tackle the world's most complex challenges. Our...

  • Solutions Architect

    3 weeks ago

    Bengaluru, India Informatica 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...

  • Solutions Architect

    3 weeks ago

    Bengaluru, India Informatica Full time

    Build Your Career at InformaticaWe'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...

  • Solutions Architect

    4 weeks ago

    Bengaluru, India Informatica Full time

    Build Your Career at InformaticaWe'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...

  • ▷ Apply in 3 Minutes! Solutions Architect

    4 weeks ago

    Bengaluru, India Informatica 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...

  • Senior Solutions Architect

    4 weeks ago

    Bengaluru, India Informatica Full time

    Job Description 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...

  • Informatica Architect

    3 weeks ago

    Hyderabad, India Tata Consultancy Services Full time

    I hope you're doing well! I came across your profile and was impressed by your extensive experience as an/a (mention role/skill). We have a similar opportunity to join our dynamic team at TCS. Role: Informatica Architect Location: Pan India Skills: Hands on in Informatica, MDM, SQL, Python, Hadoop ecosystem

  • Solutions architect

    3 weeks ago

    Bengaluru, India Informatica Full time

    Build Your Career at InformaticaWe'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...

  • Solutions Architect

    3 weeks ago

    Bengaluru, India Informatica Full time

    Build Your Career at InformaticaWe'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...