• Designed mappings/pipelines for data collection and flow from over ten source systems in a cloud architecture environment.• Improved ETL batch processing job efficiency by 25% by designing and implementing custom Python components for data transformations, reducing processing time and increasing data accuracy.• Designed and implemented a near-real-time data ingestion pipeline using Snow pipe, ensuring continuous data flow and availability for critical business analytics.• Developed complex SQL queries for Snowflake, optimizing data transformation processes, which resulted in a 40% decrease in run time for monthly reporting tasks.• Implemented GitLab for centralized source control and CI/CD management, significantly increasing communication speed between centralized systems and servers.• Implemented complex data transformations and enrichment operations within PySpark to clean and prepare streaming data for analysis.• Developed custom PySpark functions and libraries to streamline data transformations and improve efficiency.• Proficient in Snowflake’s unique features, such as Zero-Copy Cloning, Time Travel, and Automatic Clustering to manage and optimize data storage and retrieval.• Implemented end-to-end data pipelines using Apache Airflow to automate data workflows, including extraction, transformation, and loading processes.• Created custom Airflow operators and hooks to interact with external systems and APIs for data ingestion and transformation.

● Involved in gathering business requirements and translating them into technical requirements.● Hosted the Mapping sessions to map the data elements between source and target systems as a part of the data extraction process.● Experience in Identifying and understanding the Data Patterns, Identifying the Data Deviations and reporting them to the stakeholders.● Involved in Data Quality Team, migrating data like HTR – Hire to Retire, PTP – Procure to Pay, PTC – Project to Close & ATC – Accounting to Close.● Created Complex Informatica mappings that transfer SAP data from ODS (Operational Data Source) to Oracle EBS.● Conducted End-to-end testing as a part of the Project Plan to complete Mock and INT cycles leading up to the Foundation release.● Analyzed the source data and identified the filter conditions needed to address the data needs from the Target system.● Recommended Data Quality Standards for domestic/international addresses for Customers/Sites in the US/Canada.● Built the Data Validation reports for the Mock and INT cycles to capture the timings and process in preparing the Production cutover.● Involved in loading the GL Data (Balanced & Open) into EBS, Inception to date.● Designed the Aggregations and Roll-ups per the ATC conversions requirement, including GL.● Involved in loading and creating the Supplier Hierarchy in EBS from SAP.● Created parameter files and variables in complex mappings to create a virtual user interface.● Involved in creating Functions and stored Procedures in PL/SQL as per the requirements.● Involved in creating the vast Intermediate tables used across multiple conversion objects.

● Analyzed various schemas for implementation and Modeled the data warehousing data mart using Star Schema.● Created mappings using Transformations such as the Source qualifier, Aggregator, Expression, Lookup, Filter, Router, Rank, Sequence Generator, Update Strategy, etc.● Extracted data from flat files and the Oracle database and applied business logic to load them into the central Oracle database.● Developed complex mappings & mapplets in Informatica to load the data using different transformations.● Created and Monitored Sessions and Batches using Server Manager.● Extensively used various Performance tuning Techniques to improve the session performance (Partitioning, etc.).● Successfully moved the Sessions and Batches from the development to the production environment.● Extensively used Informatica client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager, and Informatica Server Manager.● Generated completion messages and status reports using Workflow Manager.● Created workflows and worklets for designed mappings.● Developed mappings and loaded data onto the relational database. I worked on dimensions and fact tables.