Skip to content

Pranav Chandra Mothukuri

Data Engineer

Professional Summary

Data Engineer with 4 years of hands-on experience designing, building and operating scalable ETL/ELT pipelines and analytic datasets on AWS and Azure. Proven work across healthcare and financial domains delivering automated ingestion, PySpark transformations, data quality frameworks and dimensional models to enable reporting, compliance and ML initiatives. Strong Python/SQL skills, experience with Glue, ADF, Redshift and Power BI/Tableau, and a track record of improving dataset accuracy and pipeline reliability.

Technical Skills

Databases: SQL Server,PostgreSQL,MySQL,Azure SQL Database,Amazon Redshift,SQL
Cloud Platforms: AWS,AWS Glue,Amazon S3,Lambda,Amazon Athena,IAM,EC2,Microsoft Azure,Azure Data Lake Storage,CloudWatch,Kafka,Python
DevOps & Infrastructure: Azure DevOps,CI,CD
Data Engineering & Processing: Azure Databricks,Data Pipelines,Data Lake,Apache Spark,PySpark,Spark SQL,Hadoop,Hive
Data Warehousing: Data Warehousing,Data Modeling,Dimensional Modeling
Data Analysis & Visualization: Pandas,NumPy,Power BI,Tableau,Dashboard Development,KPI Reporting,Microsoft Excel
Machine Learning & AI: NLP Data Preparation,Machine Learning,Feature Engineering,OpenAI API,Prompt Engineering
Data Integration & ETL: Azure Data Factory,ETL,ELT Development,Data Integration
Compliance & Governance: Metadata Management,Data Quality,Git,GitHub
Project Management & Collaboration: Agile Scrum,SDLC,Requirement Analysis

Work Experience

HCA Healthcare
Data Engineer
May 2025 – Present
Tech Stack: AWS Glue, Python, PySpark, AWS Lambda, Amazon S3, Amazon Athena, Amazon Redshift, CloudWatch, IAM, Power BI
  • Designed and implemented AWS Glue ETL pipelines using Python and PySpark to ingest enterprise healthcare data into centralized analytics platforms, enabling trusted reporting and analytics consumption.
  • Built automated ingestion workflows with AWS Lambda and S3 to eliminate manual steps, reducing manual processing effort by 30% and improving data availability for reporting teams.
  • Implemented automated data quality validations using Python and SQL across ingestion pipelines, improving dataset accuracy by 25% and ensuring consistency for compliance and operational analytics.
  • Developed a metadata-driven ingestion framework to standardize onboarding of new data sources, improving maintainability and accelerating source integration for analytics consumers.
  • Prepared feature-ready and curated datasets to support machine learning initiatives and internal AI/LLM experiments, enabling predictive analytics inputs and knowledge retrieval capabilities.
  • Monitored Glue jobs and CloudWatch alerts, performed root-cause analysis and remediation to maintain pipeline reliability (~90%) and enforce IAM-based security controls and encryption standards.
PNC Financial Services
Data Engineer
August 2023 – July 2024
Tech Stack: Azure Data Factory, Azure Databricks, PySpark, Python, T-SQL, SQL Server, Power BI
  • Designed and maintained ETL/ELT pipelines with Azure Data Factory to integrate APIs, relational and flat-file sources into centralized financial reporting and analytics platforms.
  • Built PySpark transformations in Azure Databricks to cleanse, standardize and enrich large financial datasets, improving data quality by 25% for downstream reporting.
  • Automated ETL workflows and SQL-based transformations to reduce manual intervention by 30%, accelerating reporting readiness for finance and risk teams.
  • Created dimensional data models and curated datasets to support financial performance analysis and regulatory reporting requirements for enterprise BI.
  • Optimized complex SQL queries and transformation logic for large transactional tables, improving processing efficiency and supporting scalable data operations.
  • Developed and optimized SQL Server stored procedures, views and database objects using T-SQL to support enterprise reporting and analytics delivery.
Chewy
Data Analyst
October 2021 – July 2023
Tech Stack: SQL, Python, Pandas, Power BI, Tableau, Excel
  • Analyzed customer behavior, sales trends and operational performance using SQL and Python (Pandas) to generate actionable insights for merchandising and operations teams.
  • Designed and delivered Power BI dashboards and automated reporting solutions, improving visibility into sales performance and inventory operations by 25%.
  • Built reusable reporting datasets integrating operational and transactional systems, enabling consistent analytics and streamlining reporting processes for stakeholders.
  • Authored complex SQL queries and ad hoc analyses to support trend analysis and executive reporting, delivering timely insights for operational and strategic decisions.
  • Performed data quality assessments and validation activities, improving reporting consistency by 20% and strengthening stakeholder confidence in analytics outputs.
  • Supported ML and AI-enabled analytics proofs-of-concept by preparing historical datasets, feature-ready outputs and NLP-based text analysis for customer segmentation initiatives.

Education

University of South Florida
Master of Science, Computer Science
Kakatiya Institute of Technology and Science
Bachelor of Science, Computer Science

Certifications

AWS Solution Architect
Cloud Computing Foundation Gold Certification — Wipro
Artificial Intelligence Foundation Gold Certification — Wipro
Cloud Infrastructure (AWS) Certification — Brain O Vision
NPTEL Certification – Data Analytics with Python — NPTEL
NPTEL Certification – Robotics and Control — NPTEL
Data Science and Cloud Solutions Internship Certificate — 3CORTEX

Powered by Drivetube · Create your own profile at drivetube.ai

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • Your free digital resume

    at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept.

    Documentation
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed.

    Documentation
  • Written by senior career writers

    human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile.

    Documentation
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do.

    Documentation
  • Documentation

    every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.