Informatica Administrator - Roles and Responsibilities


Communicating to Business :

Informatica Admin acts as brand ambassador between the business and the  various projects teams involving Application Support Team ,Network, Database Teams, Storage and Unix teams.

Infrastructure Support :

Responsible to manage Development ,QA and Production environments.

Maintaining the standards :

Making sure that code is sync in all the three environments.

Outages Handling :
  1. Password Changes.
  2. Patch installation (Hot Fixes /Software's )
  3. Bouncing Activities or  Restarting the Services
  4. Network Changes
Monitoring :

We can discriminate both environment monitoring and load monitoring concepts instead of consolidating. These are major activities in Informatica administration..



Environment Monitoring :
  1. Constantly keeping eye on whether the infrastructure is readily available, I meant to say keep monitoring the readiness in the environment.
  2. System level parameter checks CPU spike, Memory utilization , Number of parallel loads (sessions) running on each node.
Here the 2nd option is most intricate one and intensive checks are needed.

Load Monitoring :
  1. Monitoring the loads (workflows) whether the loads are scheduled to respective timings.
  2. Recovery or Re-start in loads in case of any failures.
  3. Identifying the tardiness in loading process in case of any sessions are in hung status.
We've done automation for most of the above monitoring activities but still the manual re-checks are more important.
  1. Alerts Monitoring.
  2. Load Monitoring .
  3. Servers Monitoring.


34 comments:

  1. what is GAMS ????

    ReplyDelete
  2. GAMS - It's a Global Application Management System. In any of the Projects irrespective vendor and clients, GAMS takes care of supporting the production applications.

    ReplyDelete
  3. Shiva...
    Instead of GAMS, it should be Support Team

    ReplyDelete
  4. Hi Rajani -

    yes I have changed it to the same...

    Many Thanks

    Shivkumar

    ReplyDelete
  5. Hi Shiva kumar,
    I would like to appreciate you for your wonderful job.
    Also i need some help from you. Could you please explain the roles and responsibilities of informatica production support as well. Please provide in detail.
    When and how support people interact with unix?

    ReplyDelete
  6. Shivakumar Krishnagouda PatilJuly 9, 2013 at 6:53 AM

    Hello Vikas -


    I have already posted detailed explanation what the Informatica Admin does in relative to the production support.

    Let me put in details on responsibilities relative to the unix.

    Many Thanks

    Shivakumar

    ReplyDelete
  7. Hi Siva,you have done a wonderful Job by starting this blog.It is very useful to the persons who are starting on with Informatica Power centre Administration.As a beginer they will get all the necessary stuff.Keep improving the blog with more practical scenarios.. Thanks Gowtham varma

    ReplyDelete
  8. Hi Siva, am new to the Administration work. Would you please Suggest how to automation Monitoring Work.

    ReplyDelete
  9. Shivakumar Krishnagouda PatilAugust 8, 2013 at 3:56 PM

    Hi Chinna –

    Pleas focus on all the Basic Architectural Level once you are hands on you can start with automations.
    You can reach me through the email or by call I can guide you on the all the stuffs.

    Here is my linked in address, http://in.linkedin.com/pub/shivakumar-patil/49/760/8aa

    Many Thanks

    Shivakumar

    ReplyDelete
  10. Hi Shivkumar,

    I read your blog. It is informative and very nicely updated.
    I have a colleague who wish to change his career into Informatica Admin role.
    Have a few question on it as below :
    He is Unix System Admin with 8 years experience and how good is it to change a career role from Unix System to Informatica Admin.
    As per your view , what is the future scope for this role.
    Couldn't find any institute for informatica course in pune area. Can you please suggest.

    Thanks

    ReplyDelete
  11. I really don't understand what does it mean by
    Maintaining the standards :
    Making sure that code is sync in all the three environments. how they call can be same ???

    ReplyDelete
  12. Shivakumar Krishnagouda PatilNovember 5, 2013 at 6:01 AM

    It’s not difficult to get started with BI or Informatica tool.
    But he can take it as additional learning there are lot many training materials are available.
    Self learning is best way. I always prefer for self learning.

    Many Thanks

    Shivakumar

    ReplyDelete
  13. Shivakumar Krishnagouda PatilNovember 5, 2013 at 6:23 AM

    My expertise and experience came up completely on handling the large scale Infrastructures on GRID environment.
    Where One to One, One to Many ,Many to Many Repository model each repository holding more than 1000 Data marts.
    There are many strategic models we built for Maintaining the technology standards aligning to ITIL and Change management, Six Sigma policies. Happy to help you know in case if you lean through.

    Many Thanks

    Shivakumar

    http://in.linkedin.com/pub/shivakumar-patil/49/760/8aa

    ReplyDelete
  14. Thanks for sharing this valuble information and itis useful for us .Biginfosys also provides the best online Informatica classes

    ReplyDelete
  15. Thanks for Sharing this valuble information and itis useful for me and informatica learners.We also provides the best Online Informatica Training classes

    ReplyDelete
  16. Appreciation for nice Update, I found something new and folks can get useful information about informatica Online Training

    ReplyDelete
  17. Hi Shivkumar,

    I was going through your blog, you have posted useful information, I would like to move in Informatica admin role, can you guide me how to achieve it, any training need to go through, any books to refer, how to start with it, it needs lot of hands-on experience? can I practice in home?

    Thanks,
    Pradeep

    ReplyDelete
  18. Hi Shivkumar,

    I was going through your blog. It is very useful and informative om Informatica admin.
    I am planning to switch to Informatica admin, could you please guide me,
    1)how to start with it,
    2) any book need to read, can you refer any institution? or online cource
    3) I need to get practical experience, is it easy to practice from home?
    4)can you share any documents

    Thanks in advance
    Pradeep

    ReplyDelete
  19. Dear Shivakumar,

    Very helpful blog and thanks for the contribution.

    I am looking to learn IDQ, do you suggest and trainer or do you train yourself by any chance?

    Also I want to install Informatica on my system, any help would be much appreciated

    Regards
    Sharad

    ReplyDelete
  20. Dear Shiva

    Very helpful blog and thanks for your valuable contribution.

    I am looking to learn IDQ, do you suggest any trainer or do you train yourself by any chance? I would be glade if you could.

    I would like to learn from industry experienced trainer, I have over 12 years working experience in PowerCentre.

    Look forward to your advise

    Also I wanted to instal Informatica on my PC, any help would be much appreciated.

    Regards
    Sharad

    ReplyDelete
  21. Shivakumar Krishnagouda PatilJanuary 18, 2014 at 9:30 AM

    Sure Please ...

    Many Thanks

    Shivakumar

    ReplyDelete
  22. Shivakumar Krishnagouda PatilJanuary 18, 2014 at 9:59 AM

    Hi Sharad

    I have sent you couple of documents if that would help let me know.
    I will post couple of articles too.

    Many Thanks

    Shivakumar

    ReplyDelete
  23. Hi ShivaKumar,

    The article you covered is so valuable for all Informatica Admins and its very usefull. Thanks a lot.
    I looking for some documentation regarding Informatica ETL Development . Please share it to me if you have.

    Thanks,
    Venkatesh

    ReplyDelete
    Replies
    1. Its my mail id: venkateshkmr57@gmail.com.

      Delete
  24. I would like to lean Informatica Admin. since i am from Support team, Can anyone suggest me, from where should i start ??

    ReplyDelete
    Replies
    1. Dear Thomas

      You can start learning and get hands on, please let me know if you need help.

      Many Thanks

      Shivakumar

      Delete
  25. Hi Shiva,

    The content in the Blog was very informative.
    I have been working as an Informatica developer for 5ys and now moving to the Informatica Admin role.
    I have no idea about the Admin role.
    Could you please guide me with a few books or some study materials.
    My Mail id is: tilottama.guha@gmail.com

    Thanks

    Tilo

    ReplyDelete
  26. Hi Tilo,

    You can go through my entire blog which is completely dedicated for Informatica Architecture and Administration
    There are no books available you can install Informatica and start learning. But let me know if you need any help.

    Many Thanks

    Shivakumar

    ReplyDelete
    Replies
    1. Hi Shiva,

      I likes your blogs very much as it is very informative.
      I need help to get session run failure error message in brief like how we see by clicking on session 'get run properties'. I do not need entire session log, need only first error code and error message. Please let me know where do i get that information? is it from repo tables or filesystem?

      looking forward for your response, please reply ASAP.

      Thanks,
      Vasu

      Delete
    2. Dear Vasu,

      Pls check the opb_rep_sesslog rep table.

      Thanks

      Delete
  27. Hi Shiva..Rohit here..

    What is the future of Informatica Admin/Support work??

    Please share your more experience on this..

    ReplyDelete
    Replies
    1. Hi Rohit

      Yes it's having enormous opportunities. Let me know if you need any help on learning.

      Thanks

      Shiv

      Delete
  28. Hi Shiva
    Could you please help me to know the automation concept for Monitoring purpose. Please send me the scripts to hi2chiru@gmail.com

    ReplyDelete
  29. Great blog post! You wrote and described everything in a great way with wonderful images. Love your style. Thanks!

    ReplyDelete

Popular Posts

Featured Post

Basic unix commands used in Administration

ls –ltr                Shows all the files and sub directories in the  current directory. ls –la                  Shows all the hidden...