SUMMARY:

• Over 18 years’ experience in Data Warehousing , Migration, ETL,MDM, Quality, Profiling, Data Integration Big Data.
• Strong ETL Skills with Multiple ETL Tools Informatica Power Cent re, Cloud , BDE,BDM, Talend BDM, DI, DP, MDM, SAP BODS , Oracle Data Integrator in development in Data Warehous e |Migration and Big Data Application.
• Extensive experience in development of DWH Applications in ETL & BI application from Multiple Legacy systems to ODS, Star Flake , Snow Flake Schemas Oracle, Syba se, Teradata & SQL - Server.
• Excellent knowledge & experience in creating source to target mapping , data validation, cleansing, transformations & business rules along with Requirement Gathering, Analysis, Coding, testing, Code Review, production support, production fixes & Knowledge Transfer to the Client.
• Extensively worked on the BI Reports with Requirement Gathering, analysis, development, testing & documentations of Reports, Cubes & Data Extracts as per BRD specifications.
• Strong knowledge and Experience with Informatica & Talend BDM, D ata Profile, Integration, Quality & MDM.
• Strong Reporting experience in requirement gathering, development, Testing, Deployment & Support with Cognos, Business Objects, Web Focus, Micro strategy Reporting tools.
• Strong Team lead & mentoring skills for helping the member in the team for initial development of Informatica mapping, development of test cases, code review of the mapping and helping them in documentation and in production support in pressure environment
• Excellent analytical & logical programming skills with a good understanding at the conceptual level & excellent presentation, interpersonal skills with a desire to achieve specified goals.
• Strong competency in import in HDFS and HIVE Schema design, Data imports and Analysis and Hands-on experience in writing HIVE Queries .

TECHNICAL EXPERIENCE:

Database: Oracle 11g, 12C, Sybase IQ, Teradata, SQL Server 20 08 /201 4

ETL Tools: Informatica Power Center , Cloud, BDE, IDQ, Data Profiling, MDM HUB . Talend ETL, BDM, Data Profiler, Data Integrator.

SAP Data Services BODS: Designer, Monitor, Admin Console & Repository.

MS SQL: Server Integration Services (SSIS) , DTS .

OLAP Tool: SAP Business Objects - SAP HANA - Designer 11i, Universe, Xcelcuis Reports.

Cognos: Cognos 10 , Report Net, Report Studio, Frame Work Manager,

Microstrategy: Enterprise Manager, Report Services , Web Focus.

Data Modeling: Erwin, DB-Artisian, SAP HANA - Attribute, Calculation & Analytical View.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Informatica Analyst

Responsibilities:

• Worked on CAMS , APPR , LMTA data migration, integration Project for Ontario Government where Data was migrated from Multiple Legacy System to EDW in Oracle.
• Worked on design, development and Performance Tuning Informatica mappings, Workflow Batch process of STG, DW, DM with Worklets, Pushdown Optimizations, Drop, Create index scripts, parallelism to ensure the batch comprising of 850 tables completed on time on delta runs and tuning complex queries in Oracle.
• Worked on enhancement of existing Oracle PLSQL Procedure and Packages as per specification provided.
• Worked on data profiling on the table and columns with IDQ and developed mapplets with in IDQ using cleansing transformation for data to be cleansed before data being loaded in STG Schemas.
• Worked closely with Informatica Admins, Operation for Code movement to SIT,UAT and finally to Production for smooth code movement of Informatica, DB object to ensure Initial load, Delta Load were conducted in a timely manner and resolved all the issue in Initial Load and Delta smoothly.
• Worked on resolution of Production Fixes on Delta run enhancement of the existing Informatica code.
• Worked strongly on Documentation for Operation Using Deployment Gr oup, import export procedure, run book for Prod Support. Knowledge Transfer to ensure smooth running of the Batch.

Environment: Informatica Power Center 9.5 6, IDQ, Designer, Data Quality, Analyst, Oracle 11g, SQL, PLSQL.

Confidential

Senior Informatica, Talend & Onshore Lead

Responsibilities:

• Worked on E DW Integration Project with Onshore | Offshore Model for the Gaming Company to migrate the data from HDFS DATALKE server in EDW Dimension and FACT Table with Informatica and Talend ETL TT
• Worked with Multiple Teams across Globe with BA, Data Architect, Data Model resources on enhancement of exiting Informatica Code and Development of new Mapping & Workflow for the new GAME releases on agile SDLC and SCRUM Model .
• Worked with Agile methodology and work profile comprise closely interacting Business Analyst for BRD Document and to develop layer of coding from DATA LAKE(HDFS) source to Teradata staging, EDW DIM, FACT Tables on ON-SHORE and getting worked developed from OFFSHORE.
• Worked in DATLAKE HDSF HIVE Table to understand the source data and developed Informatica Mapping with multiple transformation, used TERADATA TPT connections and Informatica PUSHDOWN OPTIMISATION to migrate HIGH Volume of data as per BATCH Requirement.
• Worked with DATA Model resource for suggesting amendment in DATA MODEL as per agile SDLC including adding of columns, changes in attributes for table after feedback from BA.
• Worked strongly on Documentation for the offshore team in Mapping development Guidelines, Development of Parameter File, Teradata TPT connections and development of test cases .
• Worked with Talend Data Profiling to integrate data from the source, and transformed the data to meet the user’s requirement and Designed Data Profiling using several transformations to perform Data profiling , Data Cleansing and Data Transformation.
• Worked with BA to implement data quality checks for amount field, null, spaces, date formats to develop to store reject data and how fix, repair, merge the data rejected with golden record with threshold values and with Informatica mapping and update statement.

Environment: Informatica Power Center 9.5, BDE,BDM IDQ, Talend Enterprise, BDM, Data Profiler, Data Integrator, MDM, Hadoop, Data Lake Teradata, Data Lake HDFS, Hiv e, SQL Server.

Confidential

Senior Informatica Analyst, MDM Developer

Responsibilities:

• Worked with Informatica IDQ for Data Profiling, Analysis for analyses of multiple feeds of source data with steps for matching/removing duplicate data, Null, junk data in source attributes, null, occurrences, pattern in data, formats, structures, spaces, max, min length, distinct values, nvl, duplicate dates and matching/merge of data and verifying the quality of data in Target Table.
• Worked with Informatica Analyst to perform Data Quality checks on column and row level records the how to match, merge, union & consolidate all different record with one active with row level profiling to create golden record for column, row wise data.
• Worked with Data Stewards and Source System Team to define the Systems and Trust of source system after analysis of Age, Confidence level, Validity of data, Decay Graph Process of feeds.
• Worked on Defining the Trust, Validation rules and setting exact and fuzzy logic for the match/merge, tokenization rule to get the golden master record.
• Worked on Landing tables, Staging and stg, derivative table, Base objects and BO derivative Tables, Delta Detection, lookups, queries, packages to load the data in BO tables.
• Worked with Informatica Workbench with Data Steward Data Manager & Merge Manager with Multiple Selection of Un-merged records with cross reference instance and cell data of the base Object table to identify record to be matched with trust values | score to be merged as per insert | update | tokenization to get a golden record with consolidated indicator as 1.
• Worked with the source and data steward teams how to evaluate and then code the golden column record, column wise and row-wise and history, soft deletes to present the data in analytical format to the client, BA with the Unit Test Case document in QA environment.

Environment: Teradata, SQL, PLSQL, UNIX, Tidal, XENA, Informatica MDM, IDQ, Informatica Analyst .

Confidential

Senior Informatica Onshore Lead & Analyst

Responsibilities:

• Worked on Confidential Bank in WCDW, RCDW Banking system in Informatica Dev Team and worked with Onsite and Offshore team to provide the production support for monthly data delta runs.
• The complete tasks include of production support comprised of running the WCDW, RCDW data load process via tool Tidal | Autosys, interacting with infrastructure teams, Bank GCC & Onsite DBA teams for the data runs and working | fixing the data load failures by implementing dbse script and working with the compliance procedures and approvals for multiple departments .
• Worked on Development | Enhancement | Signoff of Application Management for RCDW and GCC implementation Guide for ORS division of the bank as per Client Specification.
• Worked on the defect fixes | enhancement of Mapping & Workflow for the new releases as per the Mapping Docs with usage Joiner Lookups, Aggregator, Routers with UAT Testing.
• Worked on Modification & Performance tuning of existing mapping process by tuning the sources, mappings, transformations, session partitioning, caches, targets, queries & session.
• Worked on production , pager support on during weekends , holidays hours for monitoring the production batch job runs and working to close the production tickets / issues on priority basis.
• Worked on creation of Operation Manual | Run Books documents with other technical documentations, project design, code walkthroughs & signoff from client.

Environment: Oracle 11g, SQL, PLSQL, UNIX. Tidal, Autosys, Informatica Power Center 9.5, Designer, Workflow Manager, Monitor.

Confidential, Dallas

Senior Informatica Developer & Onshore Lead

Responsibilities:

• Worked with Client, Onsite and Offshore team model to design, develop and unit test all the ETL components feeds for Episilon CRM project for Initial & Delta Loads.
• Worked with of Informatica Power Exchange with Cobol File Source, Data maps, COB for development of mapping in Informatica Power Center with multiple Transformations.
• Worked on the Informatica run process for zipping, archiving and encrypting of files to be sent to vendors & creation of Promotion Request, project design, code walkthroughs.
• Designed, developed, implemented and maintained Power Center and IDQ application for matching and merging process and Integrated Informatica applications as Mapplets within Power Center mappings and Utilized IDQ data profiling and matching/removing duplicate data.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting , monitoring capabilities of IDQ.
• Worked with identification and eliminated duplicates in datasets thorough IDQ components of Edit Distance, Jaro Distance and Mixed Field matcher, to for single view of customers.
• Worked on providing Onsite, Informatica Corporate training & mentoring to Client Resources.
• Worked with the Data modeler in designing the Schema using Erwin with proper relationships defined and Designed the complex views that we can use from the source to populate the warehouse with required columns.

Environment: Oracle 10g, SQL, LINUX, Teradata, SQL Server, Episilon, Amdocs CRM, Informatica Power Center 9.5, Designer, Workflow, Monitor, Power Exchange, SSIS, Informatica MDM, IDQ, Informatica Analyst