Extensive Experience in End to end Software Development Life Cycle (SDLC) including Requirement gathering ETL Analysis,Design, Development, Data Analysis and Production Support, Administration, Testingof Data warehouse, BI Applications Using Informatica ETL tool
Strong experience in the Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica PowerCenter10.x/9.x/8.x/7.x
Experience inInformatica PowerExchange,Informatica Data Quality(IDQ)8.x/9.x/10.x
Worked on Source data cleansing, Exception Handling for Data Quality, Data Profiling, Data cleansing and DATAMASKING
Experience in Informatica Cloud design development /REALTIME Process design,publishing
Experience inOracle 12c/11g/10g/9i, DB2, SQL Server , Teradata, Teradata
Experience in extract data and integration of data from Salesforce SFDC API 41 and Hyperion cube
Worked on integrating data from Flat files like fixed width /delimited, XML files andCOBOL files.
Experience with Informatica B2B Data Exchange products
Strong experience in ETL and SQL performance tuning
Involved in Data analysis and data profiling handled huge volume of source data
Experience with Informatica Admin activities—Installation , Upgrade, Migration , Users accounts connections
Exposure to ERP system as a source legacy systems including SAP, Oracle financials, JD Edwards, DB2 Mainframes, AS400
Knowledge of Informatica MDM implementation
Experience in request management system JIRA,SERVICENOW and AGILE projects
Expertise in job scheduling tools including Maestro, Control-M, Autosys,GECS,UC4
Knowledgein Big Data Hadoop Ecosystem (HDFS, MapReduce2, Accumulo, Pig, Hive, Hbase)
Experience in data modeling tool such as Erwin 3.5,ER Studio 7.1, MSVisio
Experience in working with SQL, PL/SQL programming, writing Stored Procedures, Functions, Triggers and Views on Oracle, DB2, SQL Server, DB2 ,materialized views
Experience in UNIX commands and Shell scripting
Strong understanding of BI Software development life cycle (SDLC) methodologies including Waterfall and Agile scrum
Expert proficiency in Microsoft Office Excel includes creation of Spreadsheets, workbooks, Macros, Pivots, Charts
Self-motivated, quick learner, adaptive to new technologies, team player with good verbal and written communication skills and possess strong leadership qualities.