Rajashekar M Email and Phone Number

• Interacting with business analysts, data architects, application developers to develop a Data Model.• Supporting the development, optimization, and maintenance of Informatica mappings with various source data including Oracle and SQL. • Transformed data using Redshift SQL and loading of stage data into fact and dimensional structure.• Processing delimited files and loading staging tables using Talend bulk load components.• Developing Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. • Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files. • Creating mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches.• Solid experience in implementing complex business rules by creating re-usable transformations and robust mappings using Talend transformations like tConvertType, tSortRow, tReplace, tAggregateRow, tUnite etc.• Extensively working with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc. • Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager. • Designed the Talend ETL flow to load the data into hive tables and create the Talend jobs to load the data into Oracle and Hive tables. • Experienced in using debug mode of Talend to debug a job to fix errors. • Working on production issues related to ETL processes and data, identified root cause, and resolved issues.Environment: Informatica Power Centre 10.1, Talend Data Integration (6.1,6.4), MS SQL Server, T-SQL, Oracle PL/SQL, AWS Redshift, Unix, MS-Access, MS Excel and CSV files.