Informatica Technical Architect

Role Description:

• Experience in Architecting, Designing and Developing large-scale Data engineering applications having highly scalable distributed data processing systems

• 3-5 years implementing batch and real-time Data integration frameworks and/or applications

• 2-3 years of experience of implementing ETL with IICS

• 3-5 years of hands-on experience working with columnar DB like MongoDB

• Proficient with Dev-ops, Continuous Integration and Continuous Delivery (Jenkins, Stash)

• Experience and comfort executing projects in Agile environments (Kanban and Scrum)

• Competencies: Master Data Management (MDM), Informatica

• Experience (Years): 10 & Above

Essential Skills:

• In-depth understanding of ETL process & Data warehousing System

• Experience with Oracle PL/SQL and Advanced Oracle query optimization (must have minimum three years hands on experience)

• Developing PL/SQL objects as per business logic in Oracle / Teradata / PostgreSQL

• Performing SQL & PL/SQL code tuning, creation of partitions and indexes to improve performance.

• Working experience with Informatica IICS

• Working experience in IDMC MDM SaaS• CDI, CAI for Mass Ingestion, Cloud Ingestion and Cloud Integration Hub

• Cloud Data Quality (CDQ), Knowledge of master data and Data Governance

Desirable Skills:

• Cloud Data Quality (CDQ), Knowledge of master data and Data Governance