ETL Informatica developer

Job Details

Job Title: ETL Informatica Developer

Location: Jersey City NJ 07302 (Hybrid - 3 Days/week)

Duration: 12+ Month contract with Possible extension

• 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.

Mandatory skills:

• 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

Desired skills

• Source control repository - SVN/BitBucket, Continuous Build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible)
• Strong experience in Functional, ETL DB testing.
• Expertise in automation using TOSCA is a plus.
• Working Knowledge of Defect management process.
• Agile tools (Jira/Rally) experience is a must.
• Strong competency in requirement analysis, prioritize tasks, identify risks
• Highly motivated, able to work independently lead a team of onshore offshore
• Strong problem solving and analytical skills

Skills

• etl, informatica, integration, mulesoft, PL / SQL, Power center, Powercenter, TOSCA, data mapping