thiyagarjan gopalakrishnan

Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
Actively involved in interacting with business users to record user requirements and Business Analysis.
Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this project.
Prepared source to target mapping and conducted meetings with the business to understand data / transformation logic.
Parsing high-level design spec to simple ETL coding and mapping standards.
Developed mappings using Source, Target, Lookup, Expression, Filter transformations in Informatica Cloud.
Worked on Informatica cloud Services by using Bundles, Integration Templates, Mappings, Task Flows, Saved Queries, Input and Output Macro fields, Mapping Configuration Tasks and Cascading Filters.
Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and SQL server database.
Maintained warehouse metadata, naming standards and warehouse standards for future application development.
Created the design and technical specifications for the ETL process of the project.
Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.
Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
Performance tuning of the processes at mapping level, session level, source level and target level.
Created Workflows containing command, email, session, decision and a wide variety of tasks.
Tuning the mappings based on criteria, creating partitions in case of performance issues.
Created different parameter files and started sessions using these parameter files using PMCMD command to change session parameters, mapping parameters, and variables at runtime.
Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
Wrote hundreds of SQL query for data analysis to validate the input data against business rules.
Resolving the tickets based on the priority levels raised by QA team.
Developed Parameter files for passing values to the mappings as per requirement.
Performed Data synchronization task for incremental load, Data Replication Tasks, Mappings and Task Flows and customize tasks, assignments, and decision tasks.
Configured logs directory and parameter; also configured mapping task and customized error, log, commit and pre- post Components.
Scheduled batch and sessions within Informatica using Informatica scheduler and also customized pre written shell scripts for job scheduling.
Performing ETL and database code migrations across environments using deployment groups.
Migrated the codes using CICD into GitHub.
Tuned the mappings by removing the Source/Target bottlenecks and Expressions to improve the throughput of the data loads.

Involved in all phases of SDLC from requirement gathering, design, development, testing, Production,
user training and support for production environment.
• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Outlined the complete process flow and documented the data conversion, integration and load
mechanisms to verify specifications for this project.
• Prepared source to target mapping and conducted meetings with the business to understand data /
transformation logic.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Developed mappings using Source, Target, Lookup, Expression, Filter transformations in Informatica
Cloud.
3
• Worked on Informatica cloud Services by using Bundles, Integration Templates, Mappings, Task
Flows, Saved Queries, Input and Output Macro fields, Mapping Configuration Tasks and Cascading
Filters.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load
the data from flat files and SQL server database.
• Maintained warehouse metadata, naming standards and warehouse standards for future application
development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to
extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards
utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy
& stored procedure transformation.
• Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Performance tuning of the processes at mapping level, session level, source level and target level.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Created different parameter files and started sessions using these parameter files using PMCMD
command to change session parameters, mapping parameters, and variables at runtime.
• Performed data validation after the successful End to End tests and appropriate error handling in
ETL processes.
• Wrote hundreds of SQL query for data analysis

Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
Documented Data Mappings/ Transformations as per the business requirement.
Worked on project documentation which included the Technical and ETL Specification documents.
Used Informatica PowerCenter to load data from heterogeneous source systems into target database.
Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
Involved in extracting the data from the Flat Files and Relational databases into staging area.
Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
Developed Mappings and Reusable Transformations to Load Data into target tables.
Developed Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
Developed several reusable transformations and mapplets that were used in other mappings.
Prepared Technical Design documents and Test cases.
Extensively worked on Unit testing for the Informatica code using SQL Queries.
Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
Implemented various Performance Tuning techniques.
Wrote SQL queries to view and validate the data loaded into the warehouse.
Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
Improved performance testing in Mapping and the session level.
Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
Used PMCMD command to run workflows from command line interface.
Coordinated with multiple teams to run Informatica jobs for loading historical data in production.
Maintaining bug, status using JIRA tool.

Experienced in using Informatica for data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems in different Modules like Shipments, Purchasing, Sales Order, Accounts Payables and Account Receivables.
Designed and implemented ETL mappings and processes as per the company standards, using Informatica PowerCenter.
Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
Used SQL to analyze source data, performed data analysis and validate the data.
Scheduled Informatica Jobs through Autosys scheduling tool.
Studying the existing system and conducting reviews to provide a unified view of the program.
Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
Involved in creating Informatica mappings, Mapplets, worklets and workflows to populate the data from different sources to warehouse.
Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
Involved in testing the database using complex SQL scripts and handled the performance issues effectively.