Athulya Viswanathan
ETL Developer
Hire this person
Send a job offer directly to this candidate
About
Experienced Informatica Developer with 8+ years of expertise in designing and delivering enterprise-grade ETL/ELT solutions using Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC). Strong background in SQL, data warehousing, dimensional modeling, and hybrid cloud integrations (AWS and Snowflake). Proven ability to perform data validation, troubleshooting, and performance tuning in financial services environments.
Experience
Informatica Developer / Data Analyst at Widzeo Private Limited (2025-01 – 2025-06)
Designed and developed ETL/ELT solutions for cloud data integration
- Designed ETL workflows using Informatica IDMC and PowerCenter integrating AWS S3, Snowflake, and SQL Server sources.
- Developed scalable ELT pipelines into Snowflake improving reporting performance by 30%.
- Performed data validation, reconciliation, and root cause analysis for data discrepancies.
- Optimized SQL queries and ETL performance reducing batch runtime by 25%.
- Collaborated with business teams to define KPIs and reporting requirements.
Data Analyst at Happy City Index (Present)
Research Project - City growth analytics and data modeling
- Designing structured datasets and dimensional models for city growth analytics.
- Developing SQL-based transformation pipelines and data quality frameworks.
- Performing statistical trend analysis for comparative index scoring methodology.
Senior Informatica Engineer at Cognizant Technology Solutions (2021-10 – 2024-11)
Enterprise ETL solutions for banking regulatory reporting
- Developed enterprise ETL solutions using Informatica PowerCenter and IDMC for banking regulatory reporting.
- Integrated AWS Redshift and on-prem SQL Server systems.
- Optimized ETL jobs reducing load time by 35%.
- Performed extensive data validation and troubleshooting on large transactional datasets.
- Partnered with business and technical teams to deliver scalable data integration solutions.
Informatica Data Engineer at Tata Consultancy Services (2015-07 – 2021-10)
ETL pipeline development for financial systems
- Developed ETL pipelines using Informatica PowerCenter for financial systems.
- Designed star schema-based data marts for reporting.
- Conducted workflow performance tuning and SQL optimization.
- Troubleshot production issues ensuring SLA compliance.
Education
B.Tech in Computer Science & Engineering – Amrita University
