Informatica ETL IICS Consultant

Experience Level

3- 5 years of relevant ETL development

Required Qualification

Bachelor’s degree in Engineering (BTech – CS, IT, E&TC) backed by real-world work experience

Employment Type

Full Time





Duties & Responsibilities

  • 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 in Oracle PL/SQL programming and utilizing Oracle query optimization techniques
  • Proficient with Dev-ops, Continuous Integration and Continuous Delivery (Jenkins, Stash)
  • Experience and comfort executing projects in Agile environments (Kanban and Scrum)

Skills Required

  • 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 like CDI, CAI for Mass Ingestion, Cloud Ingestion and Cloud Integration Hub
  • Exposure to Unix based Shell Scripting is a must
  • Experience with Big Data skills like SQOOP, Hive, Spark is a PLUS