Ajay Babu Mandha

About Ajay Babu Mandha

Cybersecurity and DevSecOps professional with hands-on experience in cloud security, SIEM…

Experience

1. Azure Data Engineer

   Charter Communications

   Apr 2022 — Present · Irving, TX, US

   Managed end-to-end operations of ETL data pipelines, ensuring scalability and smooth functioning.Implemented optimized query techniques and indexing strategies to enhance data fetching efficiency.Utilized SQL queries, including DDL, DML, and various database objects (indexes, triggers, views, stored procedures, functions, and packages) for data manipulation and retrieval.Integrated on-premises (MySQL, Cassandra) and cloud-based (Blob storage, Azure SQL DB) data using Azure Data Factory, applying transformations and loading data into Snowflake.Orchestrated seamless data movement into SQL databases using Data Factory\'s data pipelines.For Snowflake modeling, we developed methods for data warehousing, data cleansing, handling Slowly Changing Dimensions (SCD), assigning surrogate keys, and change data capturing.Large volumes of data from several sources were gathered and processed by designing and implementing scalable data ingestion pipelines with the use of tools like Apache Kafka, Apache Flume, and Apache Nifi.Using technologies like Apache Spark, Apache Beam, or Apache Airflow, I developed and maintained ETL/ELT workflows that improved data extraction, transformation, and loading efficiency.Implemented data quality checks and data cleansing techniques to ensure the accuracy and integrity of the data throughout the pipeline.

Education

• Indiana Wesleyan University

  Master's degree, Information Technology Leadership