Srujana Karanam

About Srujana Karanam

As a Data Engineer, I specialize in designing and building large-scale data processing systems. With 9+ years of experience in the field, I have developed expertise in data modeling, ETL development, and data warehousing. I have a strong understanding of SQL and NoSQL databases, as well as experience working with big data technologies such as Hadoop, Spark, and Kafka.I am passionate about data engineering and am always looking for new technologies and techniques to improve our data infrastructure. If you\'re looking for a skilled data engineer who can help you build scalable and reliable data systems, please don\'t hesitate to reach out.

Experience

1. Technical Lead

   HCLTech

   May 2025 — Present · Prosper, TX, US

   Client: Quest DiagnosticsDesigning and optimizing scalable data pipelines using Snowflake, improving workflow efficiency and reducing data processing time.Involved in planning, defining, and designing data solutions by translating business requirements into high-level and low-level design documents.Developing and maintaining data models with detailed documentation of entities, attributes, relationships, and data lineage.Creating and managing internal/external stages, leveraging COPY command to bulk load data from Amazon S3, and applying transformations during ingestion.Managing Snowflake warehouses with Auto-scale and Multi-cluster features to ensure high performance and cost optimization.Utilizing Snowflake cloning and time travel for snapshots, auditing, and point-in-time recovery.Implementing performance tuning strategies to optimize queries, monitor workloads, and improve database performance.Designing and orchestrating Matillion ETL jobs (orchestration and transformation) using iterators, SQL scripts, alter warehouse, and S3 load/unload components.Setting up Matillion environments for single database connections, implementing auditing, logging, and SNS notifications.Developing Python scripts for file validations, parameter handling, and custom logging in Matillion orchestration workflows.Conducting data source investigation, data quality checks, and cleansing before loading into Raw and Curated zones.Collaborating with business analysts, data scientists, developers, and cloud architects to deliver high-quality, trusted data solutions.Implementing data governance, security, and compliance best practices with role-based access controls and secure data sharing.Building interactive dashboards and reports in Amazon QuickSight, enabling data-driven insights for stakeholders.Driving cross-team collaboration and knowledge sharing, creating reusable frameworks and accelerators to enhance ETL development efficiency.

Education

• RRS College of Engineering and Technology

  Bachelor of Technology - BTech, Electronics and Communication Engineering

  2011 — 2015

• East Texas A&M University

  Master's degree, Computer Science