09/06/2022 updated
100 % available
Informatica power center consultant
India
India
Master in Compute ApplicationsJava (Programming Language)Microsoft WindowsData AnalysisComputing PlatformsMicrosoft AzureBig DataCustomer Relationship ManagementUnixC++ (Programming Language)Cloud ComputingDatabasesModemsSAP Crystal ReportsData IntegrationExtract Transform Load (ETL)
ETL, Data warehouse, Informatica Power Center 8.X,9.0,9.5,9.6.1,10.2, DIH, IDQ, Metadata manager, Data warehouse / mart design principles, Big Data, HDFS, Kafka, Database, Oracle, SQL / PL-SQL, SQL Server, Teradata, Very, BRIO, BRIO Intelligence Server, Hyperion, Cognos, BO, Crystal Reports, Windows NT 4.0/95/98/2000, Linux, Unix, Java, VB, C++, VC++, Perl, Linux Scripting, Data Integration, CRM, Informatica MDM, SAP R3, Salesforce, Data analytics, DB, SFDC, SAP BW, Web service, EDW, XML, Data Quality, SAP, Azure DWH, MDM - Customer, metadata, Master Data management, DWH, analytics, Cloud based integration, Informatica, SAP R/3, Legacy systems, Internet Protocol (IP), modem, PWC, Brio 6.6.4, Hyperion 8.3 suite, Oracle 9i, Siebel, Control-M, information storage, computing platform, Oracle Apps, ETL tool, Salesforce- Oracle
Experience
Professional experience10+ years
Languages
EnglishGood
Project history
Tech Lead
Solution
Architect
ETL consultant
Solution
Architect
ETL consultant
Work Experience Details
Solution Architect
PHILIPS LTD
Tools Base : Informatica PWC, Informatica Data Quality , Data Integration Hub
Functional Area : Health Care , Lighting ( Date Warehouse and Integration Landscape)
As Solution architect I was responsible in designing end-to-end integration / Data
warehouse solution for various platform
Involving application such SFDC, SAP R3, SAP BW. Experienced in designing solution for
the flowing integration patterns as well,
8) Web service based integration
9) Integrating various source systems with EDW
10) Database based integration ( ORACLE , TERADATA , SQL server)
11) XML, Flat file based integration
12) Message based integration
13) Data Quality using IDQ ( address doctor ) for Master Data management
14) Real time integration between SAP and Azure DWH using Kafka connector ( using
Event Hub )
Designed solution for Customer, Product Master Data integration through Informatica DIH
also involved in profiling Master data from source through Informatica Data quality.
Setting up the Integration platform which involves Infrastructure setup, Installation of
PWC, DIH, IDQ , Metadata Manager
Role and Responsibilities:
* Solution architect for all the Informatica projects.
* Installed and setup the informatica platform.
* Responsible in designing the DWH platform which serves as a platform for various
sales , service analytics
* Part of Philips architect community which is the authority board for platform
definition , tool selection , etc.,
* Designed Integration patterns for Cloud based integration (SFDC), web service based
Integration, and Application based integration.
* Responsible in developing Standards and Guidelines for Informatica platform
* Designed Integration solution for Master Data Management using Informatica DIH
* Responsible in setting up Informatica Metadata Manager in Philips for the first
time.
* Designed solutions to provision Informatica as service through web service hub.
Solution Architect
PHILIPS LTD
Tools Base : Informatica PWC, Informatica Data Quality , Data Integration Hub
Functional Area : Health Care , Lighting ( Date Warehouse and Integration Landscape)
As Solution architect I was responsible in designing end-to-end integration / Data
warehouse solution for various platform
Involving application such SFDC, SAP R3, SAP BW. Experienced in designing solution for
the flowing integration patterns as well,
8) Web service based integration
9) Integrating various source systems with EDW
10) Database based integration ( ORACLE , TERADATA , SQL server)
11) XML, Flat file based integration
12) Message based integration
13) Data Quality using IDQ ( address doctor ) for Master Data management
14) Real time integration between SAP and Azure DWH using Kafka connector ( using
Event Hub )
Designed solution for Customer, Product Master Data integration through Informatica DIH
also involved in profiling Master data from source through Informatica Data quality.
Setting up the Integration platform which involves Infrastructure setup, Installation of
PWC, DIH, IDQ , Metadata Manager
Role and Responsibilities:
* Solution architect for all the Informatica projects.
* Installed and setup the informatica platform.
* Responsible in designing the DWH platform which serves as a platform for various
sales , service analytics
* Part of Philips architect community which is the authority board for platform
definition , tool selection , etc.,
* Designed Integration patterns for Cloud based integration (SFDC), web service based
Integration, and Application based integration.
* Responsible in developing Standards and Guidelines for Informatica platform
* Designed Integration solution for Master Data Management using Informatica DIH
* Responsible in setting up Informatica Metadata Manager in Philips for the first
time.
* Designed solutions to provision Informatica as service through web service hub.
HCL TECHNOLOGIES
Client: * EMC2 Corporation
Tools Base : Informatica PWC, Brio 6.6.4, Hyperion 8.3 suite, Brio Intelligence Server,
Oracle 9i, Siebel, Control-M (Date warehouse Landscape)
Functional Area : Sales, Finance, Project Accounting (Finance), and Commissions.
EMC Corporation is the world leader in products, services, and solutions for
information storage and its management. EMC is the information storage standard for every
major computing platform and, through its solutions, serves as caretaker for more than
two-thirds of the world's most essential information. NRT is a Reporting environment that
supports the business and plays a major role in Sales, Finance, Project Accounting, and
Commission. NRT project is supposed to load the Dimension, fact tables and generate
report out of them
Client: * EMC2 Corporation
Tools Base : Informatica PWC, Brio 6.6.4, Hyperion 8.3 suite, Brio Intelligence Server,
Oracle 9i, Siebel, Control-M (Date warehouse Landscape)
Functional Area : Sales, Finance, Project Accounting (Finance), and Commissions.
EMC Corporation is the world leader in products, services, and solutions for
information storage and its management. EMC is the information storage standard for every
major computing platform and, through its solutions, serves as caretaker for more than
two-thirds of the world's most essential information. NRT is a Reporting environment that
supports the business and plays a major role in Sales, Finance, Project Accounting, and
Commission. NRT project is supposed to load the Dimension, fact tables and generate
report out of them