• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.• Performance tuning of Snowflake cloud data

• Collaborate with data scientists to design data models and data pipelines, ensuring efficient data extraction, transformation, and loading (ETL) processes for people analytics projects• Build HR dashboards that identify insights and trends on key metrics that impact decisions and support business strategies.• Develop and maintain data pipelines for processing and transforming large-scale datasets using Dataflow. Implement data extraction, loading and transformation processes using SQL and Python. • Collaborate with data scientists to design and optimize machine learning models and workflows on the AI platform. • Optimize query performance and improve pipeline efficiency by partitioning data and implementing data caching mechanisms. • Created authorized views in BigQuery to provide required data to down streams (ML/Analytics/Dashboards) • Developed SQL based scripts to Load data into BigQuery. • Design and implement data pipelines to move and transform data from various sources into cloud- based data warehouses.

• Created and scheduled data pipelines using Apache Airflow for automated data extraction, transformation and loading. • Collaborated with Business Analysts to gather data requirements and deliver data-driven insights. • Assisted in performance tuning and query optimization to enhance system performance and reduce processing time. • Create Authorized Views in BigQuery to provide Requires Data to Down Stream • Design and implement data pipelines to move and transform data from various sources into cloud-based data warehouses. • Build and maintain data processing infrastructure on cloud platforms such as Google Cloud • Optimize data storage and retrieval by designing and implementing data partitioning, indexing, and compression strategies.

Supported multiple projects under Omni Platforms we are automating the manual work, and we are assigning the reservations and slots for the projects in big query. And also, in production systems we are checking usages, long running queries based on the JOB id and providing solutions to the application teams.

• Created Reservations based on the project requirements and moved specific project to the corresponding project.• Working based on the Jira Stories.

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes.• Experience in Database Application Development, Query Optimization, Performance Tuning.• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages. Extracted data from the Access file and loaded it into the database.• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.

• • Worked with the Business user to finalize the rules for loading of data.• Worked on build and develop the product based on the requirements.• Using Toad application tool wrote complex SQL queries against the Oracle ERP system &legacy systems to retrieve data and validate if for Siebel Import process. • Created different types of Reports to meet client requirements• Created SQL*plus reports as per client's various needs and developed business objects.

• Worked with the Business user to finalize the rules for loading of data.• Worked on build and develop the product based on the requirements.• Using Toad application tool wrote complex SQL queries against the Oracle ERP system &legacy systems to retrieve data and validate if for Siebel Import process. • Created different types of Reports to meet client requirements. • Wrote SQL scripts to create temporary tables and developed control files or SQL*Loader to load from legacy system into the temporary tables. • Created various types of procedures using PL/SQL and SQL queries for data validation, data cleansing. • Wrote Procedures to drop appropriate Indexes on tables to improve the performance of loading. • Extracted data from various sources like MS SQL Server and relational databases (Oracle) and supported in Production.