Akhilesh Tiwari

Led a team of 5 members in modernizing PowerCenter jobs to IICS and loading data into Snowflake DWH.

Executed comprehensive assessment of IICS project scope, gathering requirements and designing solutions.

Developed and tested IICS taskflows, ensuring deployment through Git and Bamboo artifacts.

Developed ETL flows for diverse source systems to efficiently load data into integrated data warehouse utilizing PowerCenter and IICS.
Implemented PowerCenter/IICS jobs based on Slowly Changing Dimensions to facilitate data processing.
Established Control-M scheduling jobs to optimize task automation and management.
Utilized Unix commands for file analysis and server job executions as needed.
Followed comprehensive steps in extraction, transformation, loading, validation, and ETL testing throughout development.
Considered critical aspects of data pipelines, ensuring quality control, fault recovery, scalability, and notification systems.
Optimized performance of PySpark and shell scripts through systematic enhancements.
Conducted peer reviews and quality assessments before final customer delivery.

• Implemented Financial Service Data Foundation, successfully transitioning to client.
• Coordinated third-party product integration with FCCM and Risk Analysis for optimal configuration.
• Monitored customer traction and established thresholds for performance tracking.
• Served as Techno-Functional Consultant for FCCM module focusing on AML and KYC compliance.