Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic

AZHAR WAR

Pune

Summary

Dynamic Ab Initio Developer with a proven track record, adept at optimizing ETL pipelines and enhancing system performance. Skilled in SQL and troubleshooting, I excel in cross-functional collaboration and delivering impactful solutions, achieving a 30% reduction in processing time while ensuring data integrity and stability.

Overview

1
1
Certification
6
6
years of professional experience

Work History

Ab Initio Developer

Globant
Pune
04.2023 - Current
  • Designed, developed, and optimized Ab Initio ETL graphs, workflows, and Plans to implement complex business logic and support enterprise data integration.
  • Built and maintained high-performance ETL pipelines, improving processing time by 15–30% through performance tuning and optimization.
  • Led Mainframe-to-Ab Initio and Informatica-to-Ab Initio migration activities, including development, testing, validation, and data reconciliation to ensure seamless integration.
  • Developed complex SQL queries for data extraction, validation, reporting, and ETL support.
  • Performed ETL testing, debugging, and validation, contributing to zero post-release production defects.
  • Implemented application enhancements, production fixes, and performance improvements, ensuring system stability and business continuity.
  • Optimized job scheduling and execution using Ab Initio scheduling tools, improving operational efficiency and reliability.
  • Monitored ETL workflows and application health using Grafana and Kibana, proactively identifying issues and performing root cause analysis.
  • Resolved production issues related to ETL jobs, server performance, disk space, and memory utilization through troubleshooting and performance tuning.
  • Collaborated with cross-functional teams, business stakeholders, and production support teams to gather requirements, resolve incidents, and deliver scalable solutions.
  • Managed incidents, change requests, and problem records using ServiceNow and JIRA, following ITIL best practices.
  • Prepared technical documentation, deployment guides, and failure recovery procedures to support knowledge sharing and operational excellence.
  • Supported application deployments, release validation, and post-production monitoring across multiple environments.

Software Engineer

Tech Mahindra
02.2021 - 03.2023
  • Executed SQL and PL/SQL queries for data extraction, validation, and issue analysis.
  • Managed incidents, problems, changes, and service requests to ensure ITIL compliance and timely resolutions.
  • Monitored server logs to maintain application health and identify anomalies, preventing system failures.
  • Collaborated with cross-functional teams and developers to resolve escalated incidents efficiently.

Education

B.Tech/B.E. - Computers

Lovely Professional University
Jalandhar
01-2020

12th - English

J & K
01-2016

10th - English

J & K
01-2014

Skills

  • ETL & Data Engineering: Ab Initio (GDE, EME, PSET, Plans, Control Center), ETL Development, Data Integration, Data Warehousing
  • Programming & Querying: SQL, PL/SQL, Python, PySpark (Basics), Spark SQL
  • Cloud & Big Data: Google Cloud Platform (Associate Cloud Engineer), Databricks, AWS (Foundational Knowledge)
  • Databases: Oracle Database, DBeaver
  • Development Tools: Unix/Linux, Shell Scripting, Jenkins, Git
  • Support & Monitoring: Production Support, ServiceNow, Debugging & Troubleshooting
  • Data Technologies: Web Services, Data Pipelines
  • Methodologies: Agile, Scrum

Languages

  • English
  • Hindi
  • Urdu

Certification

  • Google Associate Cloud Engineer Certification
  • Google Generative AI Leader
  • Google Cloud Digital Leader

Timeline

Ab Initio Developer

Globant
04.2023 - Current

Software Engineer

Tech Mahindra
02.2021 - 03.2023

B.Tech/B.E. - Computers

Lovely Professional University

12th - English

10th - English

AZHAR WAR