ETL Developer

Job Title: ETL Developer
Job Location: Jersey City, NJ - 3 days/week onsite - preferring local independent resource, at this moment
Duration: 12+ months

Job Description:

Responsibilities:

• 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).
• Expert in PL/SQL programming and Database design, with strong data analysis skills.
• Self-managed and proactive communicator.
• 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).