Aparna Paliwal

• Designed and developed scalable ETL workflows using Informatica PowerCenter, IICS, and SQL for financial, government, and manufacturing sectors.
• Spearheaded cloud migration initiatives to Snowflake, enhancing performance and maintaining data integrity across platforms.
• Managed data modeling, ingestion, and orchestration with Control-M, MOVEit, and SSMS, supporting real-time analytics.
• Collaborated with cross-functional teams to convert business and regulatory requirements into technical solutions.
• Directed a team of 8 developers, overseeing task allocation and code reviews to ensure delivery timelines.
• Architected Snowflake-based data pipelines, managing ingestion via IICS and secure file transfers using MOVEit.
• Championed Agile practices by organizing Daily Stand-ups, managing sprints via JIRA, and aligning execution with business objectives.
• Delivered production support and deployment across environments, ensuring system stability and minimal downtime.

Led development and maintenance of Virgin Australia’s enterprise data warehouse ecosystem, including GDW, CDW, and legacy systems.

• Ensured data integrity and optimized ingestion patterns for real-time availability in analytics platforms.
• Gathered requirements for new data extracts from GDW to meet evolving business needs.
• Designed and developed ingestion patterns for data sourced from DWH and Oracle systems.
• Ingested raw data, performing integrity checks to maintain quality and consistency.
• Conducted testing and validation of ETL code using effective data manipulation techniques.
• Resolved user-raised tickets promptly, providing ongoing support and ensuring issue resolution.
• Generated real-time data extracts in flat file format for cloud platform integration.

• Designed and maintained ETL workflows in Informatica PowerCenter, focusing on dimensional modeling for SCD1/SCD2.
• Contributed to high-impact projects like Bristol Sanction Screening and FNZ Actuarial through data extraction and reporting.
• Developed automation scripts using Perl and Shell in UNIX to streamline job orchestration processes.
• Created parameter files and scheduled jobs while supporting multiple environment deployments.
• Executed rigorous unit testing and prepared documentation for release notes and implementation plans.
• Engaged with MDM teams for requirement gathering and defect resolution ensuring data integrity.
• Generated tailored reports with Cognos Report Studio while conducting end-user training sessions.
• Actively participated in Agile methodology, facilitating sprints using Atlassian JIRA for issue management.