Ananda Reddy

• Working as Senior Data Engineer in Cloud Data Warehouse space with Snowflake, Oracle, Informatica, Unix and SQL/PLSQL as technical skill set. • Monitored and managed IICS resources, ensuring optimal performance, scalability, and availability for critical data integration processes. • Automate file-based data ingestion using Python wrapper scripts, AWS & Snowflake. • Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which includes data load into snowflake table.

• Understanding the Business Requirements and Develop an ETL process to load data from source to target. • Configured and scheduled data integration workflows, mappings, and tasks in IICS to support data integration and data synchronization needs. • ETL pipelines in and out of data warehouse using combination Snowflakes SQL queries against Snowflake. • Designed and implemented efficient PL/SQL code, including stored procedures, functions, and triggers, to support application functionalities. • Optimized database performance by fine-tuning SQL queries, indexing strategies, and database structures in SQL, PL/SQL. • Performed automation using Python to reduce manual effort. • Monitored and managed IICS resources, ensuring optimal performance, scalability, and availability for critical data integration processes. • Experience with Snowflake Multi - Cluster Warehouses. • Experience in building Tasks, Streams, Materialized Views and Snowpipe. • Experience in using Snowflake Clone and Time Travel. • Having experience in azure services like ADLS gen2, synapse, ADF, Databrics. • Having experience in creating the procedure to load data into final azure tables. • Monitoring the ETL jobs in prod and performing the tuning to optimize to Bach time.

• My role involves gathering requirement from user and creating informatica PowerCenter ETL mappings for loading data from different sources to staging area and then creating dashboards on top of staging area. • Involved in creating the YOY& Rolling weeks, months, quarters, year reports for business in Tableau. • Managing historical data from various heterogeneous data sources (i.e. Flat files and Oracle). • Developed Slowly Changed mappings like SCD Type 1 and SCD Type 2 in Informatica power center & IICS. • Developed mapping tasks and task flows in IICS. • I have been closely interacting with customer as part of gathering any requirement. • I have to create mapping design document. • I have created different mappings and used different transformations like (Source Qualifier, lookup, router, expression, aggregator, update strategy etc.,) • Worked on Agile tools like jira, confluence and change management tools like Service now along with CI/CD tolls like git & Jenkins. • Good experience in Data warehouse concepts like star schema, snow flake schema. • I have used different tasks like session, command, email, event wait etc., • Involved in performance tuning like mapping, session level to increase the performance. • I took part in support tasks as well like monitoring the daily scheduled loads and resolving issues • Responsible for the performance tuning of the SSIS ETL process at source level, Target level, mapping level and session level. • Developed, tested, and deployed complex ETL packages using SQL Server Integration Services (SSIS) to extract data from various source systems, perform necessary transformations, and load into the target data warehouse. • Optimized existing ETL SSIS processes to enhance performance, reduce processing times, and improve overall efficiency. • Implemented error handling and logging mechanisms within SSIS packages to ensure accurate and reliable data processing.

● Involved in requirement gathering from clients and analysis. ● Designed / Developed tables, views, synonyms, indexes for ETL Processes. ● Involved in the code review, unit testing and peer review and documentation. ● Designing and developing the ETL Mapping Specification based on the Business requirements & specifications and designing the ETL process. ● Designing & Developing the ETL mappings using Informatica Power Center Designer as per the requirements ● Data extraction from source systems, cleansing & transforming the data in staging and finally loading the data into warehouse schemas. ● Designing the Mapplets, Reusable Transformations and documentation. ● Analysing the job running time and improving the performance. ● Involved in reviews and Unit Testing. ● Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs. ● Created Sessions, Workflows, Link Tasks, Controls and Command Tasks using Workflow Manager and monitored the workflows using Workflow Monitor. ● Involved in creating the shortcuts for source, target and transformations.

● Involved in requirement gathering from clients and analysis. ● Designed / Developed tables, views, synonyms, indexes for ETL Processes. ● Involved in the code review, unit testing and peer review and documentation. ● Designing and developing the ETL Mapping Specification based on the Business requirements & specifications and designing the ETL process. ● Designing & Developing the ETL mappings using Informatica Power Center Designer as per the requirements ● Data extraction from source systems, cleansing & transforming the data in staging and finally loading the data into warehouse schemas. ● Designing the Mapplets, Reusable Transformations and documentation. ● Analysing the job running time and improving the performance. ● Involved in reviews and Unit Testing. ● Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs. ● Created Sessions, Workflows, Link Tasks, Controls and Command Tasks using Workflow Manager and monitored the workflows using Workflow Monitor. ● Involved in creating the shortcuts for source, target and transformations.