RAGUL GANDHI BABU

ETL Developer – Banking Domain
Client: Truist Financial Bank - US
Duration: [April 2021] – Present
Environment: Informatica BDM, Informatica PowerCenter, SQL, UNIX, Talend, Snowflake

As an ETL Developer with 4 years of experience in a large-scale banking project, I was responsible for designing, developing, and maintaining robust ETL solutions to support the client’s data warehousing and reporting needs. Working in a high-volume, performance-sensitive environment, I focused on efficient data integration, transformation, and loading using Informatica BDM and PowerCenter.

Key Responsibilities:

• Designed and implemented ETL workflows using Informatica BDM and PowerCenter to extract data from diverse sources including RDBMS, flat files, and cloud-based platforms.
• Performed complex data transformations and cleansing to meet business requirements and ensure high data quality.
• Wrote advanced SQL queries for data validation, analysis, and performance tuning on large datasets.
• Scheduled and monitored jobs in UNIX environment using shell scripting and scheduling tools (like ESP job scheduler).
• Collaborated closely with data analysts, business users, and stakeholders to gather requirements and deliver optimized data solutions.
• Participated in daily production support, proactively resolving data failures, performance issues, and system alerts.
• Played a key role in client calls, providing status updates, explaining technical solutions, and addressing data issues promptly.
• Gained exposure to Talend for data ingestion in parallel pipelines and Snowflake for cloud data warehousing and analytics.
• Contributed to documentation of ETL processes, job runbooks, and data dictionaries to improve team efficiency and knowledge sharing.

Achievements:

• Optimized existing ETL jobs to reduce run times by 30% through performance tuning and parallel processing strategies.
• Successfully supported multiple production deployments with zero post-deployment issues.
• Recognized by client stakeholders for proactive communication and quick issue resolution.