Senior Application Consultant

at  BLACK SWAN GROUP PTE LTD

JOB OBJECTIVES

We are presently seeking candidate for the position of Informatica Developer , who can also act as Technical Delivery Manager . This role is to engage in various projects and impact assessments related to the data transformations for Finance Technology Systems.

KEY REQUIREMENTS

Ø 5 years + relevant experience in Informatica Power Center (ETL) - (Designer, Repository Manager, Workflow Manager) , ETL tools, Oracle 19c ( SQL*Plus, PL/SQL ) and strong Data Analytical skills
Ø Strong on DW Fundamentals, concepts
Ø Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.
Ø Excellent understanding of various relational database design concepts.
Ø Extensive experience in Data Modeling & Architecture.
Ø Experience full lifecycle data warehouse development.
Ø Strong experience in Data Migration and Data Quality initiatives.
Ø Error handling and Performance Improvements.
Ø Conduct and participate in design and code walkthroughs.
Ø Good hands on capability - can independently develop good quality deliverable and guide/mentor junior team members effectively.
Ø Experience in Unix Shell Scripting (AIX/SUN/Intel Xeon Linux)
Ø Experience with Job scheduling tools like Control-

o Attending impact assessment sessions, and actively participate in reviews with the subject matter experts in Finance Technology.
o Perform impact analysis on the existing system functionalities with respect to the new proposed changes.
o Discuss with requestors to gather and ascertain requirements
o Development/SIT Testing/ UAT Support/Implementation
o Work with users on the requirements/clarifications and attending to UAT queries
o Help to prepare the FS documents and walkthrough the functional specifications with requestors
o Assisting the Stream Lead in the delivery of the project and on the coordination with various stakeholders.
o Step in as a Technical Delivery Manager to manage the end to end delivery of the assignment, when demanded.
o Deliver the project / tasks within the committed timelines.
o Maintain the risks and issues tracker and see them to closure.