Ramya Nagalla Email and Phone Number

• Developed ETL pipelines on GCP using Apache Beam and Dataflow to process large-scale data in real-time, resulting in a 20% improvement in data processing time.• Worked with informatica power exchange tools to give on demand access to the business users.• Worked on the installation and configuration of informatica power center.• Rebuild of legacy on-premises Oracle-based data warehouse to a data lake based on Azure Cloud• Design and implement data storage solutions using Azure services such as Azure SQL Database, Azure Cosmos DB, and Azure Data Lake Storage.• Develop and maintain data pipelines using Azure Data Factory and Azure Databricks.• Created and managed data processing jobs using Azure HDInsight and Azure Stream Analytics.• Worked with Python, SQL, and Bash scripts to develop custom data transformations and data quality rules, resulting in a 25% reduction in data processing errors.• Using informatica designer designed mappings, which populated the data into the target star schema on oracle instance.• Worked on installing, configuring, and managing NoSQL database systems, ensuring high availability and fault tolerance.• Experienced in handling data ingestion processes, including data import/export, batch processing, and real-time data streaming into NoSQL databases.• Worked on setting up data replication and sharing for NoSQL databases to distribute data across clusters and improve system resilience.• Developed and maintained ETL processes using SSIS to integrate data from multiple sources, improving data processing efficiency.• Worked on ETL tool Informatica, Oracle Database and PL/SQL, Python and Shell Scripts.• Advanced proficiency in Power BI Desktop, Power Query, DAX, and Power BI Service.• Strong data analysis and visualization skills using Excel, SQL, and other BI tools

• To enhance navigation performance within huge datasets, indexes were implemented on OLTP/OLAP tables. Creating mappings, sessions, and workflows to use with Informatica PowerCenter to load data for Ultima tix projects from source to target database.• Created the Informatica Mappings by leveraging the Aggregator, SQL overrides in Lookups, source qualifiers, and Router to govern data flow into different targets.• Created Sessions, gathered data from multiple sources, processed it as needed, and loaded it into the data warehouse.• With the Informatica Power Center Designer, strong mappings were created using a variety of transformations, including Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, and Aggregator.• Used Azure Data factory to extract raw files from different sources and load them into Azure Data Lake as parquet files.• The parquet files are pulled from the data lake to Azure Synapse analytics to create external tables and staging tables. The data modelling is done on the stating table and the final views are used for visualization reports.• Designed and implemented ETL workflows using Alteryx to automate data extraction and transformation and to improve efficiency.• Developed interactive dashboards and reports in Tableau, enabling stakeholders to visualize key performance metrics and drive data-driven decisions.• Conducted data quality assessments and implemented validation checks in Alteryx for reducing data discrepancies.• Assisted in the development of ETL workflows using SSIS for data extraction, transformation, and loading.• Created and managed SQL Server databases, optimizing query performance and ensuring data integrity.• Created materialized views, planned jobs, ETL workflows, and reporting that allowed data to move between eight ERP systems.

• Created and managed ETL (Extract, Transform, Load) processes and data pipelines to move and transform data from source systems into data warehouses or data lakes on AWS.• Worked on partitioning and clustering high-volume tables on fields in Big Query to make queries more efficient.• Worked on implementing scalable infrastructure and platform for large amounts of data ingestion, aggregation, integration, and analytics in Hadoop using Spark and Hive.• Performed tuning of NoSQL databases through monitoring tools and configurations, identifying and addressing bottlenecks for optimal performance.• Provided ongoing support for ETL jobs, monitored ETL processes, and resolved issues to ensure the stability and reliability of data pipelines on snowflake.• Created comprehensive documentation for ETL processes, data transformations, and Snowflake schemas, facilitating knowledge transfer and onboarding of new team members.• Used to write Python DAGs in airflow which orchestrate end-to-end data pipelines for multiple applications.• Worked on importing and exporting data from Snowflake, Oracle, and DB2 into HDFS and HIVE using Sqoop for analysis, visualization, and generating reports.• Utilized Tableau to create dynamic visualizations and dashboards that provided insights into sales and marketing performance.• Extracted, transformed, and loaded data using SQL and Alteryx, streamlining the data preparation process and enabling faster analysis.• Assisted in training team members on best practices for using Alteryx and Tableau, fostering a data-driven culture.• Created Hive tables using HiveQL, then loaded the data into Hive tables and analyzed the data by developing Hive queries.• Used Oozie Scheduler systems to automate the pipeline workflow and orchestrate the map-reduce jobs that extract and Zookeeper for providing coordinating services to the cluster.