Skills & Expertise (40)
Work Experience
Data Analyst
Rainbow Infotech Pvt. Ltd.
Feb 2025 - Present
Designed and implemented SQL-based data transformation logic to convert raw and semi-structured source data into structured, analytics-ready datasets aligned with business requirements. Built and maintained end-to-end ETL/ELT pipelines for ingesting data into centralized storage and preparing it for reporting, analysis, and downstream processing. Performed data modeling using fact and dimension-style tables to support scalable analytics and efficient querying across large datasets. Wrote and optimized complex SQL queries, improving query performance and reducing execution time for analytical workloads. Supported Spark-based distributed data processing workflows using Azure Databricks to handle high-volume data transformations. Developed a dedicated data quality model to validate transformed datasets by checking completeness, accuracy, and consistency before analytical consumption. Implemented automated data quality and validation checks within pipelines to ensure reliable, trustworthy, and production-ready datasets. Used Python (Pandas, NumPy) for exploratory analysis, data preparation, validation logic, and feature-ready datasets. Developed and maintained Power BI dashboards for KPI tracking, trend analysis, and business insights. Collaborated closely with business stakeholders, analysts, and developers to identify critical data elements, define transformation rules, and align datasets with reporting and analytical needs. Monitored, troubleshot, and resolved data pipeline failures and performance bottlenecks to ensure data reliability and availability.
Education
Post Graduate Diploma in Big Data Analytics - C-DAC
2024 - 2025 · India
Bachelor of Engineering - Walchand Institute of Technology
2017 - 2021 · India
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Open to Relocation
