Informatica Cloud ETL Developer

Duration: Full Time/Permanent

• Hands-on exp with Informatica 9.6 and above. Well versed with all Informatica Client Components (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager).
• Well versed with concepts such as Merge files and partitioning of Source query to run workflow as multiple instance.
• Have exposure to all facets of Extract, Transform and Load (ETL) processes.
• Be able to create the complex mappings in order to extract the data from source to target using informatica cloud(IDMC).
• Working with different db., Flat files, Fixed width files as source/target.
• Working with XML as a Source/Target, Webservice consumer transformation using wsdl files and API calls.
• Experience in Design, develop, test and support from SQL stored procedures, views, Informatica workflows.
• Develop and optimize UNIX Shell scripts and file transmissions.
• Working knowledge of ESP scheduling tool to create/modify jobs.
• Develop, unit test and system test integration components.
• Work with Business Analysts and external teams to understand the scope of work, priorities and requirements for the data solution.

Preferred Skills:

• Designing, implementing, and maintaining data integrations for batch ETL using Informatica Cloud (IDMC/IICS).
• Experience in IICS Data Integration Components like Task flow, Mappings and all tasks etc.
• Migrating Informatica Power center to Informatica Cloud, hence migration exp will be ideal.
• Experience with the IICS command line utility.
• Experience with Stone branch Scheduling tool.

Qualification:

• Bachelor Of Computer Science