Aditi Garg

Provided integration between two systems using Denodo data virtualization.

• * Experience in Denodo Data virtualization tool (v8.0) and ETL Informatica tools (v10.1.1/10.4.1) by extracting data from source system (SQL Server) and loading into target system (Oracle DB) (18c/19c).
  
  * Developed derived views by implementing joins and union in Denodo on top of base views as per requirements.
  
  * Experience in Data modeling by connecting and establishing Denodo API connection to source systems
  
  * Developed SQL queries in Denodo/ ETL Informatica to extract data from the source systems by joining the tables and loading the data to the target systems
  
  * Worked with Unix commands to access the workflow
  and job scheduling to schedule the workflows.
  
  * Performed data integration by developing, unit testing and deploying the data.
  
  * Developed re-usable mappings using various transformations like expression, aggregator, joiner, source qualifier, sorter, union, and filter in ETL Informatica as per the business requirements.