Tamilarasan Muthusamy

Created Informatica PowerCenter mappings utilizing various transformations and tasks. Designed and implemented new mappings in Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud (IDMC) to streamline data processing. Optimized data pipelines by applying transformations such as aggregations, filters, and joins.

Developed and maintained BigQuery for data extraction from Oracle and other source systems, performing analysis to fix production issues. Designed and developed Python & Unix scripts to automate operational tasks such as backups, data archiving, and monitoring. Created Informatica PowerCenter mappings utilizing various transformations and tasks.

Developed new features in BigQuery according to specification documents and optimized BigQuery scripts for data migration to Google Cloud Platform (GCP). Developed and managed SQL queries and PLSQL procedures to support project requirements. Monitored system health and metrics using Splunk, Dynatrace, and Akamai.

Developed Informatica PowerCenter mappings utilizing various transformations and optimized ETL processes using IICS for efficient data integration. Designed and developed Python & Unix scripts to automate operational tasks such as backups, data archiving, and monitoring. Automated MDM cloud deployments using GitLab CI/CD with AWS/Azure/GCP integration.

Developed and managed SQL queries and PLSQL procedures to support project requirements. Developed SSIS packages as per client requirements.

Created low-level design documents based on high-level design for DataStage and PL/SQL procedures. Analyzed, designed, and developed mappings/packages in DataStage per client specifications. Conducted performance tuning for DataStage mappings, including incremental aggregation and adjusting DTM buffer pool size and block size.

Developed low-level design documents based on high-level design for Informatica mappings and SSIS packages. Designed and developed mappings/packages in Informatica and SSIS based on client specifications. Conducted performance tuning for Informatica mappings, including incremental aggregation and adjusting DTM buffer pool and block sizes.

Developed and modified Oracle and Unix scripts. Analyzed, designed, and developed Informatica mappings based on client specifications. Conducted extensive performance tuning of Informatica mappings, including incremental aggregation and adjustments to DTM buffer pool and block sizes.

Developed complex Informatica mappings using Aggregator, Union, and Update Strategy transformations to integrate data from multiple flat file sources. Performed performance tuning on mappings, including incremental aggregation and optimization of DTM buffer pool and block sizes. Developed and executed SQL queries and PLSQL procedures to support project requirements.

Developed SQL queries and PLSQL procedures for reports using DB2 SQL Assist and manual SQL scripting. Developed and optimized mappings using Informatica ETL tool based on client specifications. Optimized performance of long-running reports by analyzing tables and creating indexes.

Completed a Master of Computer Applications degree, focusing on advanced topics in computer science and software development. Gained expertise in various programming languages, algorithms, and data structures.