Informatica Administrator

Location: Libertyville, IL
Date Posted: 09-08-2017
Informatica Administrator

Years of experience  8-12
 
 Role summary

  Informatica Administrator plays a major role in the design, installation, creation, documentation, trouble shooting and enhancement of ETL processes.  The ideal candidate will have a solid understanding of data and ETL technologies, as well as experience in administering Custom ETL development or Commercial off the Shelf products (Informatica).
 

Skills:
  • Analytical and conceptual thinking – using logic and reason, creative and 
  • Communication skills – interpersonal, presentation and 
  • Computer savvy – skilled in the use of 
  • Integration – joining people, processes or 
  • Influencing and negotiation 
  • Problem solving
 
Specialized skills, knowledge or certifications unique to this role,
  • ETL Tools: 8+ years experience with 
  • Unix experience: 6+ 
  • Job scheduler tools: preferably 
  • Database: preferably Oracle & Sql server experience 
  • Working knowledge on UNIX scripting 
  • Excellent interpersonal skills (both written and 
  • Demonstrated experience working well with customers of varying levels of technical expertise in high-pressure situations and complex 
  • Must be good team 
  • Technically enthusiastic and willing to learn attitude is 
  •  Ability to work unsupervised in a multi-task environment          
  • XML and Java knowledge desirable.
  • Core financial industry knowledge as pertains to data relationships a plus
  • Data modeling experience is preferred
  • Informatica Professional certification preferred
  • Experience in data mining (SQL, ETL, data warehouse, etc.) and using databases in a business environment with large-scale, complex data sets.
 
Work flexibility (travel requirements, work schedule, etc.)
  • Able to provide 7x24 support
  • Able and willing to be flexible in adapting to new technologies, processes and standards
 

Role responsibilities:

Operational
  • Responsible to manage Development ,QA, UAT and Production 
  • Perform general ETL administration duties. This includes Product setup , upgrades, migrations, patching, storage management, security & performance 
  • Participate in development, testing, and maintenance of ETL 
  • Monitor test results, and make appropriate 
  • Maintain high availability and performance for production 
  • Responsible for backup, recovery and tuning of 
  • Root Cause Analysis on P1 P2 issues on 
  • Responsible for documentation :Define operational processes for Run book and SOP documentation, automating routine operational 
  • Identify opportunities for improvement, makes proposals and participates in the planning of new and enhanced technologies or services within area of 
  • Multi-Tasking capabilities and ability to work on multiple environments and projects as necessary under tighter SLAs for crunch 
  • Create and maintain installation documentation and architectural 
  • Interface with different departments within the organization regarding new 
  • Monitor program execution for expected 
  • Modifies, installs, and prepares technical documentation for system software 
  • Monitors systems capacity and performance, plans and executes disaster recovery 
  • Support ETL Development Team regarding ETL platform functionality during design and development 
  • Serve as an escalation point for ETL Developers to surface problems and inquiries requiring further evaluation beyond the associate’s skill 
  • Work with Job Scheduling team to setup and implement ETL 
  • Apply fixes, patches and service packs as required and 
  • Implement procedures for maintenance, monitoring, backup, and recovery operations for the ETL environment, includes regular reporting on health and performance of the ETL environment and 
  • Accurately track and manage hardware / software assets that are related to ETL.  Generate periodic license usage reports to reconcile hardware / software assets inventory data with licensed Informatica 
  • Follow departmental standards and guidelines
 
Strategy Work:
  • Research new technology associated with ETL administration and make 
  • Standardize environment & Improve standards and procedures that support the company’s ETL environment 
  • Research and recommend optimal ETL design 
  • Research/analyze data processing functions, methods and procedures


Education Required:
 
  • Bachelor’s degree in Computer Science or equivalent        
  • Master’ s degree in Computer Science
 
 
or
this job portal is powered by CATS