Ajai A

Data & Analytics professional with 2+ years of experience working with enterprise data, ETL workflows, data validation, reconciliation, and reporting in banking environments. Skilled in SQL, Python, Power BI, Tableau, and Advanced Excel, with hands-on experience in data cleaning, transformation, exploratory analysis, data quality analysis, and KPI reporting. Experienced in analyzing large-scale data pipelines, identifying data discrepancies and execution trends, and translating technical data into actionable insights.

Strong understanding of ETL processes, databases, AWS data environments, and end-to-end data flow.

Data & Analytics Platform Administrator - LTM - Coimbatore, India

(2024-06)

• Managed and monitored 300+ Talend ETL pipelines across Development, QA, and Production environments, supporting reliable data delivery for downstream reporting and analytics.
• Performed SQL-based data validation, reconciliation, and incremental load checks across enterprise datasets to identify discrepancies and maintain data quality.
• Analyzed pipeline execution trends, failure patterns, and data quality metrics to identify recurring issues and operational bottlenecks affecting data availability.
• Built and maintained Excel-based tracking dashboards and KPI reports to monitor pipeline health, execution status, SLA performance, and data quality metrics.
• Investigated ETL, application, database connectivity, Linux, and Tomcat issues through log analysis and root-cause investigation, resolving issues affecting downstream data processing and reporting.
• Installed and configured Talend Studio environments and managed user and Studio access provisioning to support data integration workflows.
• Supported ETL deployments using Jenkins, Bitbucket, and GitHub-based CI/CD workflows, ensuring timely movement of data integration artifacts across environments.
• Handled S3 bucket and transmission-server file transfers, supporting reliable movement of data files used in downstream processing and analytics.
• Supported Talend and Collibra patching activities and AWS-based data processing environments using S3, Amazon Redshift, and EC2.

ETL Support Engineer - LTM - Chennai, India

(2024-01 - 2024-05)

• Monitored and supported 150+ scheduled ETL jobs using Autosys and Talend TAC for daily data processing workflows.
• Executed SQL queries in Amazon Redshift and MySQL to perform source-to-target validation, investigate discrepancies, and reconcile data.
• Performed data quality checks across source files, transformed datasets, and target tables to identify missing, duplicate, and inconsistent records.
• Validated 100+ ETL jobs during a WebFOCUS-to-AWS migration through cross-platform data validation and reconciliation.
• Investigated file ingestion, connectivity, transformation, and data loading issues affecting downstream reporting and analytics.
• Prepared and maintained Excel-based batch execution and SLA reports to track operational performance and identify recurring issues.
• Collaborated with engineering teams to resolve data-related issues and minimize delays in downstream analytics processes.

Bachelor of Engineering (B.E.) - Electrical & Electronics Engineering - Anna University Regional Campus, Coimbatore