•
Designed, developed, and implemented solutions using OFSAA DIH, including configuring data models, defining data mappings, and creating integration workflows
•
Integrated data from various source systems (internal and external) into the OFSAA DIH platform, ensuring data quality, consistency, and integrity throughout the integration process
•
Created and managed EDDs and Connectors to facilitate data exchange between OFSAA and external systems
•
Expertise in data modeling using tools like Erwin, and a strong understanding of OFSAA data models and their customization
•
Developed complex SQL queries and PL/SQL stored procedures for data manipulation, validation, and performance tuning within OFSAA and related Oracle environments
•
Strong understanding of ETL principles and experience in designing and developing ETL workflows
•
Configured and tested DQ rules within OFSAA to ensure data governance and quality standards
•
Expertise in building T2T (Table to Table) transformations in OFSAA to transform data according to business rules
•
Refreshed and published DIH metadata to ensure system-wide consistency and accuracy