Informatica PowerCenter and Informatica Cloud
- Verification and maintenance of ETLs from various systems like Oracle EBS, Workday, custom applications etc., using Informatica Cloud / Informatica Powercenter.
- Duties and responsibilities include : ETL Administration; data source mapping; troubleshooting; development; source data reconciliations; ETL system development;Involving in Client Communications; and documenting.
- Basic understanding of Linux commands and understanding of shell scripts.
- IICS Application integration experience is a must.
- Informatica Powercenter experience is desirable
- Understand existing Informatica Powercenter Integrations and migrate to Informatica Cloud.
- Design, develop, maintain, monitor and execute production ETL processes using Informatica Cloud / Informatica Powercenter
- Experience working with Informatica connectors for cloud-based systems like Workday, Salesforce is an addon.
- Ability to communicate clearly, assertively, having a good command over English language to be able to interact with customers to solicit requirements.
- A strong penchant to learn new tools and technologies and be ready to adapt as per project demands.
- Good experience in Oracle SQL
- Understand API – REST and SOAP
- Familiar with API testing tools.
- Understanding and Knowledge of JSON, XML, Flat Files (CSV, Fixed-Width) and various protocols like SFTP, HTTP etc.
WHAT YOU NEED FOR THIS POSITION
Bachelor's Degree in Information Technology, Human Resources, Communication (preferred) or related field; 2-3 years of consulting experience or 5-7 years of applicable work experienceProfessional attitude, with a growth mindset seeking to drive change and improvement in all aspects of the roleAbility to communicate clearly, assertively, having a good command over English language to be able to interact with customers to solicit requirements.A strong penchant to learn new tools and technologies and be ready to adapt as per project demands.Experience implementing projects using Agile Iterative approachAbility to meaningfully articulate terminology, processes, functionality, and architectureUnderstanding of ERP processes and modules specifically with respect to HCM, Finance, SCM is preferable.Good experience in Oracle SQL and PL / SQL languagesA Good understanding of Oracle Fusion ERP / PPM / HCM API capabilitiesUnderstanding of Oracle Fusion ERP / PPM / HCM Data ModelUnderstand API – REST and SOAPFamiliar with API testing tools.Understanding and Knowledge of JSON, XML, Flat Files (CSV, Fixed-Width) and various protocols like SFTP, HTTP etc.Experience in Real time, Batch and ETL integrations.Self-motivated and independent with the ability to effectively listen and communicateWillingness to join a dynamic, multinational teamValues diversity of thought and collaborationAbility to continue to grow and learn despite existing expertiseSkills Required
Oracle Sql, Xml, Json