Susmitha R Email & Phone Number

Texas, United States

• Designed, developed, and tested dimensional data models using Star and Snowflake schemas by the Kimball methodology.
• I design and manage scalable data warehouses using Snowflake, ensuring efficient data storage and retrieval.
• Developed and maintain complex DBT models that streamline data transformation and enhance data quality.
• Integrated DBT with CI/CD pipelines to automate deployments and ensure consistent, reliable data delivery.
• Managed AWS tools, including CloudWatch and CloudTrail, to monitor and track cloud resources and activities.
• Implemented user versioning in S3 buckets for highly sensitive data storage.

• Created ETL mapping document and ETL design templates for the development team.
• Created external tables on top of S3 data which can be queried using AWS services.
• Developed ETL pipelines in and out of the data warehouse using a combination of Python and Snowflakes Snows Writing SQL queries against Snowflake.
• Utilized Matillion to design and implement complex ETL workflows that streamline data integration and transformation processes.
• leveraged Matillion's intuitive interface and powerful features to optimize data workflows, ensuring high performance and reliability. Additionally, implemented best practices for error handling, logging, and.
• Utilized Azure Machine Learning to develop predictive models and apply advanced analytics techniques, empowering data-driven decision-making and optimizing business processes.

• Experience in architecting, designing, installing, configuring, and managing Apache Hadoop Clusters, MapR, and Hortonworks & Cloudera Hadoop Distribution.
• Developed ETL data pipelines using Spark, Spark streaming, and Scala.
• Building Real-Time Data pipelines that code modularization, with dynamic configurations to handle multiple data transfer requests without making the production job changes.
• Loaded data from RDBMS to Hadoop using Sqoop
• Worked collaboratively to manage build-outs of large data clusters and real-time streaming with Spark.
• Responsible for loading Data pipelines from web servers using Sqoop, Kafka, and Spark Streaming API

• Suggestions on converting to Hadoop using MapReduce, Hive, Sqoop, Flume, and Pig Latin.
• Collecting and aggregating large amounts of log data using Apache Flume and staging data in HDFS for further analysis
• Extracted data from various locations and loaded them into the Oracle table using SQL*LOADER.
• Responsible for cluster maintenance, adding and removing cluster nodes, cluster monitoring, and troubleshooting, managing and reviewing data backups, and reviewing Hadoop log files.
• Developed the Pig Latin code for loading, filtering, and storing the data.
• Create, develop, modify, and maintain Database objects, PL/SQL packages, functions, stored procedures, triggers, views, and materialized views to extract data from different sources.