Nitin Dagar

Data Analyst

Haryana, India 5+ yrs exp 70 · Very Good

About

Data Analyst with 4.5+ years of experience in data analytics, visualization, and automation, delivering actionable insights across diverse business functions. Skilled in designing and optimizing ETL/ELT pipelines using Azure Data Factory, Databricks, and PySpark, with strong expertise in SQL, Power BI, and Tableau. Adept at building interactive dashboards, performance metrics, and data models to support strategic decision‑making. Experienced in automating workflows with Python and SQL, improving efficiency and reducing manual effort. Proven ability to ensure data quality, integrity, and scalability through robust frameworks and governance practices. Collaborative team player with certifications in Microsoft Azure and Power BI, eager to leverage expertise in data engineering and analytics to drive impactful business outcomes.

Skills & Expertise

No skills listed yet

Work Experience

Software Engineer (Data Analytics & Automation)

Infosys Ltd

Dec 2021 - Present

Designed and optimized scalable ETL/ELT pipelines using Azure Data Factory, Databricks, SQL, and PySpark to ensure efficient data ingestion and transformation across enterprise systems. Developed and implemented data quality frameworks with validation rules, anomaly detection, and reconciliation mechanisms, improving accuracy and integrity of large datasets. Established monitoring and observability practices including alerts, dashboards, and SLAs in Azure and Power BI, enabling proactive issue resolution and minimizing downtime. Conducted pipeline audits and compliance reviews to ensure adherence to governance standards, regulatory mandates, and best practices across teams. Collaborated with architects, analysts, and product owners in Agile/Scrum environments, contributing to backlog prioritization, sprint planning, and technical issue resolution via Jira. Automated workflows with Python and SQL, reducing manual effort and significantly improving reporting and pipeline efficiency. Supported data modeling and Delta Lake implementations (Delta Live Tables, Autoloader) to enhance data warehousing and reporting processes. Mentored junior team members on coding standards, reusable frameworks, and best practices, improving overall productivity and code quality.

Associate Software Engineer (Cloud & Data Operations)

DXC Technology

Aug 2021 - Dec 2021

Architected and implemented SQL‑based validation frameworks to ensure data integrity across multiple business systems, automating checks and reducing manual validation efforts. Analyzed large datasets using Python, PySpark, and SQL to detect anomalies, uncover recurring patterns, and generate actionable insights that supported strategic decision‑making on customer behavior and operational performance. Developed and delivered reports and dashboards in Power BI and Tableau, enabling stakeholders to monitor KPIs and identify operational inefficiencies in real time. Collaborated in Agile/Scrum teams with analysts, developers, and QA engineers, actively contributing to sprint planning, daily stand‑ups, and retrospectives using Jira to deliver analytics features and reporting enhancements on schedule.