Chandu Kinaruvilayil Radhakrishna Pillai

Analyzed and improved ETL workflows through Informatica IICS, resulting in increased data processing efficiency.

Conducted thorough analysis of issues and engaged in solution-oriented discussions with business and client teams in regular stand-up meetings.

Analyzed existing database structures and implemented SQL migration strategies to optimize data management.

Managed technical aspects of Autosys migration, coordinating with cross-functional teams for successful implementation.

Analyzed and adjusted workflow parameters to achieve significant reductions in runtime.

Analyzed and verified data entries to identify discrepancies and enhance overall data reliability.

Designed and validated Informatica mappings and session workflows through comprehensive unit testing.

Diagnosed and corrected software defects while overseeing change request implementation for project efficiency.

Applied a range of transformation strategies to facilitate the implementation of intricate and straightforward business logic.

Constructed staging data model to facilitate accurate data processing and analysis.

Facilitated SQL migration initiatives to ensure seamless data transition and integrity.

Led data warehouse migration to Azure Synapse Analytics to optimize operational costs and improve system scalability.

Facilitated transition of mappings to enhance data integration capabilities using Informatica IICS.

Facilitated transition of BTEQ scripts to Informatica IICS to enhance data integration processes.

Designed comprehensive mapping tasks and task flows to enhance data integration processes.

Optimized workflow performance through targeted tuning, resulting in reduced execution time.

Executed data validation activities to ensure accuracy and integrity of datasets.

Led development and unit testing of Informatica mapping session workflows.

Resolved software bugs and managed change requests to enhance system functionality.

Utilized diverse transformation techniques to implement both simple and complex business logic.

Streamlined automation of various HR processes, including census payroll, annuity, and lump sum, utilizing Informatica PowerCenter.

Engineered mappings aligned with BRD logic and designed workflows adaptable for diverse client needs.

Facilitated transition of tested development code from development repository to user acceptance testing and subsequently to production environments.

Diagnosed and resolved workflow and session errors in production environments within established timeframes.