Thursday, 17 March 2016

Informatica Admin @ Waterloo, ON, Canada


Experience : 9-10 years

Contact

Informatica Administrator is responsible for implementing and supporting a reliable, high-performance Informatica environment. Will be working with architects, application development team and infrastructure teams to create and manage Informatica environment to meet current and future business objectives

Job description for Informatica Admin:
 
       Expertise in installing, configuring and upgrading Informatica PowerCenter (9.x) to 10.x and other related components (like PowerExchange connectors, webservices, salesforce connectors etc.) on Linux environment (HA configuration)
       Ensure the integrity, availability, reliability, security, and performance of Informatica platforms, tools, and services.
       Troubleshoot issues related to databases, job failures, software bugs and performance bottlenecks to all incidents working with multiple cross functional teams like DBA, Unix Server Administrator, Informatica Global Support and work on problems and drive them to resolutions.
       Be able to proactively monitor the overall system
       executing daily health check reports - job execution stats, volume processed, execution times, IO times taken etc.) and take appropriate actions to improve the overall health of the system
       Strong ability to troubleshoot performance and configuration related issues including connectivity issues due to firewalls, load balancers etc.
       Day to day administration activities - manage users, groups, privileges, roles and permissions, folder creation and management, domain management tasks (including backup and restore), configuring DB connections etc.
       Strong understanding of MS SQL Server and Oracle databases, schemas, table structures, data models etc.
       Experienced with code promotion - migration of ETL objects from lower environment to production.
       Good understanding of performing administration tasks via Batch scripts, UNIX Shell scripts and command-line utilities etc.
       Capacity planning, management and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed.
       Plan and build roadmaps for the future of the Informatica data integration platform and influence IT with the latest Informatica products, best practices and improve the overall state of Informatica.
       Supporting the development teams as needed
       Good understanding of data mapping, data validation, data manipulation, data analysis use cases
       Provide detailed documentation and maintain an Informatica knowledge base repository
       Strong understanding of Informatica GRID, HA and parallel computing.
       Excellent analytical and problem solving skills