Informatica Power Center

Location: (100% remote)

W2 Role

Overview:

The Lead Informatica Developer will be responsible for the design and development of ETL solutions. He/She will work closely with internal business users and business analysts to develop requirements and to provide production support of BI/DW processes.

Requirements:

  • Bachelors Degree in Computer Science or related field (required)
  •  More than 5 years of experience in data warehousing and data integration projects
  • More than 5 years of hands-on experience creating advanced mappings, transformations, and workflows using Informatica PowerCenter and PowerExchage
  • Hands-on experience PowerCenter
  •  IICS Experience is huge plus.
  • Hands-on experience with modernizing/transforming on-premise data integration solutions into cloud-based integration solutions using AWS
  • Experience with RedShift, Hadoop and Cloudera (Nice to have)
  •  Well versed in SQL and relational/dimensional databases
  • Ability to analyze data integration requirements, data sources/targets, business rules, and transformation logic
  •  Experience designing and developing data extraction, cleansing, transformation, and loading processes and workflows to load data into various cloud-based data warehouses
  • Ability to collaborate with technical and business users to define performance requirements and improve efficiency
  • Excellent verbal, written, and presentation skills
  • Strong analytical and problem-solving skills