Informatica ETL Administrator

US-TX-Arlington
Requisition ID
2017-29066
Employee Type
Full Time-Regular
Category
Information Technology

Overview

Under general direction, the ETL System Administrator II is responsible for administration of the Extraction Transformation and Load (ETL) environment. Responsibilities include installing software, engineering solutions, compliance, change management, disaster recovery, security and all other aspects needed to manage and support the ETL environment. This is an administrative position that offers an opportunity to learn and develop DBA skills but does include ETL development tasks.

Responsibilities

JOB DUTIES

  • Implementation and support of Informatica software including patches and upgrades for the ETL environmen
  • Set up and configuration of enterprise production, QA, development and disaster recovery Informatica environments
  • Back-up and recovery of Informatica software, repository, and configurations
  • Disaster recovery planning, design, execution and documentation
  • Monitoring the environments and suggesting improvements for stability and performance tuning
  • Provide technical support and work with infrastructure teams to ensure an effective operating environment including throughput, repository sizing, capacity planning, and maintenance
  • Identify opportunities for improvement, make proposals and participate in the planning of new and enhanced technologies or services within area of expertise
  • Define standards and implement best practices to manage and support the ETL environment
  • Creation and maintenance of technical documentation, deployment diagrams and check-lists
  • Automating routine tasks where appropriate

OTHER IMPORTANT DUTIES

  • Assist developers and end-users with database usage, query development, and tuning.
  • Develop operating system scripts, data transfers, monitoring, etc.
  • Support database connectivity from client applications.

REPORTING RELATIONSHIP

Reports to: ETL System Administrator Manager Direct Reports: None

Qualifications

Knowledge

  • Knowledge of logical, physical, and data-warehouse modeling is desired.
  • SQL including PL/SQL experience a plus.
  • Advanced knowledge of Informatica PowerCenter on UNIX preferred.
  • Must have moderate knowledge using Oracle databases in a UNIX environment. (IBM AIX a plus.) UNIX scripting knowledge is important/

Skills

  • Must have strong project management skills
  • Must have the ability to think logically and design applications
  • Experience installing Informatica software in UNIX environment preferred.
  • Experience with PowerExchange a plus
  • Experience with Informatica Proactive Monitoring for PowerCenter a plus

Experience

  • Bachelor’s Degree preferred.
  • Suitable experience will substitute.
  • At least 5 years overall experience in information systems is required.

WORKING CONDITIONS

Normal office environment, will require occasional overtime. Must be able to provide routine off-hours support from home. May require very limited travel.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.