Logo
raag solutions

OFSAA DIH Senior Developer (Full time)

raag solutions, Buffalo, New York, United States, 14266


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.