·
Ability to understand the
mapping documents and design/build IBM DataStage jobs to the requirements
·
Ability to write complex SQL
queries based on requirements to extract the data from Oracle databases
·
Construct DataStage jobs to
implement the requirements:
Extract the data from Oracle sources
Build JSON files using Hierarchical stage
Perform structural validation
Data type/allowable values validations and reporting
Transform
data to ISO format
·
Perform unit testing and
participate in integration and system testing
·
Perform code fixing and code
deployment through different cycles of testing
·
Involve and contribute to the
data reconciliation process
·
Very familiar with different
stages within DataStage
·
ICON and Multifonds
experience is a plus
·
Familiar with Kafka connector
in Data Stage is a plus
·
Ability to work in Dublin/UK
time zone hours
·
Ability to write complex
transformation rule using JAVA or any other language
·
Ability to understand E2E in
terms of connectivity to legacy as well as new system