6-10 years experience required

Technology: OFSAA DIH (Data Integration Hub)

Responsibilities:

• Responsible to Design, develop, and implement solutions using OFSAA DIH to meet business requirements, includes configuring data models, defining data mappings, and creating integration workflows.
• Creation of External data descriptors and connectors and processing DIH definitions, Batch management based on M& T need.
• Create and maintain technical documentation related to OFSAA DIH configurations, development activities, and integration processes, document system changes and updates for reference and compliance purposes.
• Conduct testing of OFSAA DIH configurations and developments to ensure accuracy and reliability. Perform data validation and reconciliation to verify the integrity of integrated data.
• Integrate data from various source systems (internal and external) into the OFSAA DIH platform. Ensure data quality, consistency, and integrity throughout the integration process.

Qualifications:

• Experience on OFSAA platform (OFSAAI).
• OFS Data Integration Hub (Preferred) .
• Good understanding of OFSAA architecture and metadata management framework (Hierarchies, datasets etc.).
• Strong knowledge or Experience on Oracle Data Integrator.
• Knowledge of Data Modeling using Erwin tool, Data Migration Activities and Slowly Changing Dimension (SCD) Component.
• Must have good Knowledge and experience in OFSAA data Model and customization.
• Must have experience in Erwin data model tool.
• Experience in Business rules configurations in OFSAA framework and expertise in building T2T (Table to Table) & Data transformations in OFSAA etc.
• Experience in managing requirements gathering, business/gap analysis, solution design and documentation for OFSAA projects.
• Strong in Data Warehouse Principles, ETL/Data Flow tools.
• Experience with agile project methodology.
• Extensive knowledge in creating Oracle Packages, Procedures, Functions, Views, Triggers and Queries using Oracle SQL-PL/SQL.
• Database design, Performance tuning, development, and integration using Oracle.
• At least one End to end project execution experience in OFSAA solution is a plus.
• Should have appropriate analytical skills and capabilities to conduct fit gap assessment from OFSAA solution/ FSDF perspective.
• Understanding of OFSAA Reporting framework.
• Should have excellent Analytical and Communication skills.
• Strong in Data Warehouse Principles, ETL/Data Flow tools.