17 years of IT experience and technical proficiency in the field of Data management, Data integration, Master data management, Data quality and Data governance.
Strong Informatica Administration & Architecture skills in building brand new Informatica Environments.
In-depth knowledge of multiple informatica products like Data Engineering Integration (Big Data Management), Data Engineering Quality (Big Data Quality), Data Engineering Quality (Big Data Quality), Enterprise data catalog, Enterprise data preparation, Axon, PowerCenter, Powerexchange CDC and IICS (Informatica Intelligent Cloud Services).
Proficient in UNIX/Linux Shell Scripting.
Successfully delivered many bigdata projects (including cloud and on-prem clusters) for various informatica customers on Cloudera and Databricks.
Good knowledge of python, Scala and pyspark language.
Successfully implemented the Kubernetes and docker based deployment of Informatica platforms.
Successfully implemented many projects in on-prem as well as public clouds (like AWS and Microsoft Azure).
Good knowledge on authentication mechanism of LDAP, Kerberos and SAML which usually configured with integration environment.
Collaborate with customer and conduct workshop, sessions and health checks of informatica environments.
Overview
13
13
years of professional experience
Work History
Senior Cloud solution specialist
Various Informatica customers
02.2014 - Current
Collaborated with diverse clientele to strategize and execute the seamless transition of Informatica Powercenter infrastructure to IDMC cloud.
Performed comprehensive analysis and debugging, effectively resolving product feature gaps by providing innovative and tailored solutions to customers.
Demonstrated exceptional problem-solving skills by efficiently managing critical customer blockers, ensuring a successful IDMC go-live.
Orchestrated effective communication and collaboration between customers and Research and Development teams to promptly address and rectify critical product bugs, essential for customer go-live.
Provided extensive support during customer go-lives and migrations, ensuring a streamlined and enhanced user experience.
Optimized customer data pipelines, surpassing Powercenter platform performance in IICS cloud, through meticulous tuning and configuration.
Create reference architecture and best practice documents for customer with their informatica infrastructure.
Work on advisory role with customers on their data management, data migration and data governance initiatives.
Act as an advisor for the customers cloud data lake and data warehouse journey.
Help customers with their data governance implementation (EDC, Axon and IDQ/BDQ).
Help customer’s architects in their platform sizing, scaling, performance, platform governance and operational issues.
E-Product Datamart, Project Technical Lead
Nationwide Insurance
Columbus, OH
07.2013 - 02.2014
Existing requirement analysis and data mapping for the Report attributes
Creating a prototype/POC
Analysis of all the source system to understand the data load strategy
Analysis of the specifications/requirements provided by the business user
Analyze and identify the potential performance bottlenecks of the Proto environment
Preparation and Updating of the TDD, TAD.
Code promotion to Test environment and Support of SIT
Preparation of production run book and mapping documents
TSG INFORMATICA ARCHITECT, Project Technical Lead
GE Aviation/Energy TSG
Cincinnati, OH
12.2010 - 07.2013
Project lead for a team of 31(6 onsite and 25 offshore)
Ensuring 24x5 production support and reporting various production issues encountered to customer on daily basis.
Involve in the design, development and implementations of the Enterprise Data Warehouse (EDW) Data marts providing inputs and reviews at various stages of the project from run team prospective to improve performance from ETL loading and reporting prospective.
Answering the technical queries, driving the product initiatives and metrics collection & analysis.
Creating, updating and maintaining technical documentation for tools and projects involved as required.
Heading the change managements for code promotions into production for various technologies
Inspection, reviews, performance tuning and arranging meetings for defect preventions.
Planning the schedules for maintenance of applications and servers.
Preparing business continuity plan as the DWH reports are used on daily basis to assess the risk of various power projects and make important decisions.
Co-ordination with design teams and technical support of different tools to improve performance and availability along with installation and configuration of the data warehouse tools as required.
Solution architect for Business and Project teams to choose PowerCenter products
Automating Agile manual process in PowerCenter Administration which will reduce tickets and SLA’s.
Handling Proof of Concepts for New PowerCenter tools and design configurations to fit GE Environments.
Preparing presentation, Case studies with POC results and taking GO or NO – GO decisions
Education
B. E -
Biju Patnaik University of Technology
05.2006
Skills
Informatica 10x PC, IDQ, EDC, EDP, DEI
Informatica Cloud suit(CDI, CAI, MIS, CIH)
Unix, Linux, Solaris, Ubuntu, Centos and Windows
SQL, PL/SQL, Unix Shell scripting
Oracle, MS SQL Server 2017, My SQL, Teradata, Greenplum, DB2