ETL Informatica Developer with Oracle PL/SQL - ICONMA, LLC

Location: Jersey City, NJ/ Plano, TX

• Individual should be able to demonstrate technical and analytical skill in developing complex ETL workflows using Informatica Powercenter.
• Create data mapping to ingest data from disparate data sources ranging from flat files to RDMS, Hive or REST APIs. Responsible for developing Unix scripting.
• Proficiency in MuleSoft tools desired.
• Must be able to work independently with minimum supervision.
• Responsible to develop test cases and perform unit testing.
• Must be able to interact and co-ordinate with distributed team.
• Must have good communication skills.
• Responsible to provide regular task status update to the management.

• Technically strong in Informatica Power center.
• Technically strong in performance tuning of targets, sources, mappings and SQL queries.
• Conceptually good in PL/SQL, Functions, and writing complex SQLs, and creating and exposing views/materialized views. Strong in UNIX commands and Scripting. Good in MuleSoft Integration.

• Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)
• Expert in PL/SQL programming and Database design, with strong data analysis skills
• Unix scripts
• Autosys
• Informatica for ETL
• Previous experience of working in a data warehouse project is a plus
• Python programming
• Tableau/reporting experience
• Experience in working with Mulesoft and other API technologies.
• Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)