Sai Kumar Sirangi
Professional Summary
Senior Data Analyst with 5+ years delivering analytics, data engineering and BI solutions across cloud and on-prem environments. Strong SQL and Python expertise with hands-on experience building ETL pipelines (Informatica, Airflow, Databricks), data models (dimensional and normalized), data quality frameworks and interactive dashboards (Tableau, Power BI). Experienced with Snowflake, Redshift, Teradata and AWS data services; skilled at optimizing queries and pipelines, enabling faster reporting and reliable ML-ready datasets. Collaborative communicator who partners with stakeholders, data architects and data scientists to translate business needs into production analytics.
Technical Skills
Work Experience
- Gathered and translated complex business requirements into analytics-ready data specifications; mapped source systems (Snowflake, Redshift, Oracle, MSSQL, APIs) to dimensional and normalized target models to support BI and ML use cases.
- Designed and implemented ETL and batch/near-real-time pipelines on Databricks and PySpark to ingest, transform and load data to Snowflake and S3, improving data availability for reporting.
- Built data validation, cleansing and reconciliation workflows (SQL, Python) to enforce data quality and lineage; implemented role-based access controls and encryption policies to meet compliance requirements.
- Developed Airflow/Databricks scheduling for automated data jobs and created Databricks scheduled jobs to push curated datasets to collaboration platforms, reducing manual intervention and operational errors.
- Implemented feature engineering and aggregation pipelines (PySpark, pandas, SQL) used by data science teams; accelerated model experimentation by delivering consistent training datasets.
- Optimized Spark jobs and Snowflake/Redshift SQL (query tuning, partitioning, clustering) and designed incremental ETL flows to reduce compute costs and improve run-times (reported improvements in ingestion and processing efficiency).
- Built streaming and batch data ingestion pipelines using Python to read from the enterprise Streaming Data Platform and land curated datasets into the analytical cloud data warehouse for downstream analytics.
- Designed and delivered Tableau dashboards consolidating metrics from multiple sources; validated dashboard data using SSMS/SSIS and complex SQL queries to ensure reporting accuracy.
- Implemented serverless ETL workflows on AWS (Lambda, Glue, S3, Redshift) and tuned Hive/Spark batch jobs to process terabytes of structured and semi-structured data with improved stability.
- Established CI/CD patterns for data engineering using Git, Jenkins and Docker to standardize deployments and reduce release errors; automated data load processes and scheduling to accelerate delivery.
- Created and enforced data governance artifacts (data dictionaries, lineage, profiling) and collaborated with architects to define ETL metadata strategies supporting compliance and discoverability.
- Automated data workflows in Python/SQL/Spark to support ML model pipelines and reporting, decreasing manual effort by ~50% and improving pipeline reliability.
- Performed data ingestion and staging using SQL Server Import/Export and SSMS to load flat files (CSV, Excel, Parquet) and prepared cleansed datasets for analytics and reporting.
- Executed comprehensive data quality checks and data mapping to ensure accuracy and consistency across reporting feeds; documented transformations and staging rules for auditability.
- Developed and maintained PL/SQL and T-SQL routines to implement enhancements and resolve data issues, improving data processing stability for reporting consumers.
- Created SQL views and semantic layers to support Power BI dashboards, enabling self-service access to validated metrics for stakeholders.
- Collaborated with BI and analytics teams to troubleshoot ETL failures, tune import jobs and optimize data structures for faster query performance.
- Delivered repeatable staging patterns and data validation scripts that reduced end-to-end data preparation time and improved dashboard refresh reliability.
- Collected and analyzed functional requirements; authored SRS and designed N-tier application architectures using C# and ASP.NET to meet client specifications.
- Developed web UI components and reusable user controls (.ascx) and validation routines to improve UX consistency and accelerate feature delivery across modules.
- Implemented backend services and data access layers using stored procedures and SQL Server, optimizing queries for application responsiveness and data integrity.
- Built Crystal Reports and reporting interfaces, integrating them into the application for operational and management reporting requirements.
- Performed unit and integration testing, participated in deployment activities on IIS and provided production support to resolve defects and improve stability.
- Collaborated across teams to design document upload, multi-select controls and risk-question components that were reused across the application, reducing duplicate development.
Powered by Drivetube · Create your own profile at drivetube.ai
Explore Drivetube
- Drivetube Profile — 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.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 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.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — 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.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — 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.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.