Divya Jithan

Results-driven ETL Developer with 4 years of hands-on experience across enterprise data pipeline design, Informatica IICS workflow and mapping development, advanced SQL-based transformation logic, and Python automation scripting. Proven track record of working end-to-end across the full data lifecycle — from source-to-target mapping specification analysis and Informatica IICS session/workflow configuration to dimensional data model design (Star/Snowflake Schema, SCD Type 1 & 2), cloud ETL pipeline integration (AWS S3, AWS Glue), and Python-based automation framework development. Deep functional expertise in Informatica IICS internals — mappings, sessions, transformations, session log debugging, and pipeline failure root-cause analysis — gained through direct involvement in 3 enterprise-scale projects across Oracle-to-SQL Server database migration, hotel data warehousing, and cloud-based e-commerce data integration.

Skilled in advanced SQL, PL/SQL & T-SQL, Teradata, and cloud platform ETL workflows.

ETL Developer — Data Pipeline & Integration Specialist - AR Softcon Pvt. Ltd.

• Hyderabad, India

(2022-07)

• Worked end-to-end across the full ETL pipeline lifecycle on 3 enterprise projects — analyzing source-to-target mapping specifications, configuring and reviewing Informatica IICS workflows and mapping logic, writing complex SQL for transformation rule implementation, and performing data reconciliation at scale across Oracle, SQL Server, and Teradata environments.
• Developed deep, hands-on expertise in Informatica IICS internals — session configuration, mapping logic, workflow scheduling, transformation design, session log analysis, and pipeline failure root-cause identification — through direct involvement in live pipeline runs across DWH migration and cloud integration projects.
• Designed and implemented SCD Type 1 & 2 handling logic, Initial Load and Incremental Load pipeline configurations, Star/Snowflake dimensional models, and Fact/Dimension table population strategies — working directly against Teradata and SQL Server data warehouses.
• Built Python (Pandas + Pytest) automation scripts for source-to-target data comparison and transformation rule validation — reducing manual SQL-based comparison effort by ~35% and enabling consistent nightly validation coverage across cloud pipeline runs.
• Configured and validated AWS S3 data ingestion pipelines and AWS Glue ETL job outputs end-to-end — confirming schema conformity, data completeness, and business rule accuracy across cloud-based data integration architecture.
• Integrated Python/Pytest automation suite with Jenkins for scheduled nightly ETL pipeline runs; managed all automation scripts in Git/GitHub with proper branching and version control practices.
• Performed REST API integration using Postman for real-time data feeds alongside batch ETL pipelines — validated JSON/XML schema conformity, response accuracy, and data completeness across multi-source integration scenarios.
• Collaborated with offshore development teams and global business SMEs across time zones to triage ETL defects, resolve data discrepancies, and align on mapping specifications — raised and tracked 100+ defects end-to-end in JIRA with full root-cause analysis documentation.
• Worked within Agile/Scrum delivery — participated in sprint planning, daily standups, retrospectives, and backlog grooming; maintained Requirement Traceability Matrix (RTM), test plans, and defect reports per project standards.

B.E. - Computer Science Engineering - Thangavelu Engineering College