Vasanth Mareedu Email & Phone Number

• Having 10+ years of experience in Design, Development, and Implementation of Data warehousing application projects• Extensive Experience in developing Enterprise Datawarehouse projects using ETL tools like Informatica Intelligent Cloud Service (IICS), Azure Data Factory (ADF), Oracle Data Integrator (ODI) • Expertise experience in Informatica Intelligent Cloud Service (IICS).• Development experience and immense knowledge on Cloud Data Warehouses such as Snowflake and Autonomous Data Warehouse (ADW).• Good experience in technical leadership, mentoring and managing resources.• Experience on implementing projects in Agile methodology, waterfall Methodology.• Good experience on IICS in developing mappings to extract the data from the different sources and load into target warehouse.• Developed mapping tasks to process data based on the data flow logic defined in a mapping and to read the parameter values from parameter file during the execution. • Good experience on IICS mapping transformations like filters, aggregator, expression, union, lookup, and joiner• Create a reusable mapping template for data synchronization between source and stage/target.• Hands on experience in IICS taskflow creation to run data integration tasks either in serial or concurrently.• Experience in embedding a taskflow within another taskflow for a final load plan scheduling.• Developed Pipelines in Azure Data Factory using Multiple Activities like Lookup, for each, get metadata, if activity, Stored Procedure, Copy Activity, Execute Pipeline, Validation, Filter, etc.• Experience in Implementing Pipelines, Linked services, datasets, and data flows in Azure Data Factory.• Create a trigger that runs a pipeline in response on a Schedule, Tumbling window and Event.• Developed Data Factory pipelines to Load Data from SFTP to Blob and ADLS Gen2.• Experience on ODI12c studio components like Designer, Topology, Operator and Security Navigators.• Sound knowledge in developing ODI Mappings, packages, procedures, sequences and scenarios, Load Plans.• Developed several ODI12c Mappings with transformation logics like, filters, joins, lookups, Oracle functions etc.• Worked on hands over documents like technical, operational and migration document.

Listed skills include Oracle, Pl/Sql, Sql, Business Intelligence, and 4 others.