Manoj N Email and Phone Number

* Understanding the business rules and sourcing the data from multiple source systems.* Used Sql queries to validate the data after loading. * Design, Development, Testing and implementation of ETL processes using informatica cloud.* Complete technical documentation to ensure system is fully documented.* Data cleansing prior to loading it into the target systems. * Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.* Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.* Developed and scheduled the Jobs using Autosys Scheduler.* Experience in creating mappings and ICRT Processes.

• Extensively worked on SQL override in Source Qualifier Transformation for better performance.• Created Reports using SQL Server Reporting Services (SSRS).• Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance.• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.• Developed various T-SQL stored procedures, triggers, views, and created/modified tables for data extraction, data load and transformation.• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing various kinds of transformations using SSIS packages.• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts. • Created various SSIS packages involving Fuzzy lookup, Conditional Splitting, Data Conversion tasks. • Extensively worked on designing reports using SQL Server Reporting Services (SSRS). • Implemented stored procedures and functions to meet the dynamic nature of SSIS packages and SSRS Reports existing software application requirements.• Worked extensively in designing, parameters, Cascading, Conditional formatting reports. • Created numerous SSIS Packages using 'Execute SQL Task', Merge, Derived column, Script and Row Count Tasks. • Used Error handling and Error logging techniques to capture data in SSIS in various ETL solutions. • Identified, debugged and resolved database Performance Issues (monitoring and tuning) to ensure optimum database performance using SQL Profiler. • Design and maintain MS SQL SSIS Packages, T-SQL Stored Procedures, scripts, and code for high performance.• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.

• Assisted in complete Life Cycle including Design, Development and Testing of an Application. • Actively involved in complete software development life cycle and designing database schemas in the line of end user's business Requirements. • Developed various T-SQL stored procedures, triggers, views, and created/modified tables for data extraction, data load and transformation.• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing various kinds of transformations using SSIS packages.• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts. • Created various SSIS packages involving Fuzzy lookup, Conditional Splitting, Data Conversion tasks. • Extensively worked on designing reports using SQL Server Reporting Services (SSRS). • Implemented stored procedures and functions to meet the dynamic nature of SSIS packages and SSRS Reports existing software application requirements.• Worked extensively in designing, parameters, Cascading, Conditional formatting reports. • Created numerous SSIS Packages using 'Execute SQL Task', Merge, Derived column, Script and Row Count Tasks.