Job Description :
Role: ETL Informatica Administrator
Location: Houston, TX
Contract to Hire

Employement Type: W2 only

* Informatica ETL Administrator to design, develop, maintenance and
production support.

* Work with initiative leads, product teams, technical leads,
architects, subject matter experts, developers, technical support groups and
test teams to deliver value to the business.
* Design, prototype, develop, test, and document existing and new
ETLs, and related components; make recommendations for related functions
that result in a more cost effective product delivery.
* Perform unit testing of ETLs and related components and document
test results.

* Complete code reviews for ETLs and related components, and complete
documentation of issues identified and action items.
* Correct testing defects and support all testing, including but not
limited to: Development Integration Testing, System Testing, User Acceptance
Testing, End-to-End Testing, and Performance Testing.
* Perform troubleshooting on ETLs and related components
* Identify application bottlenecks and opportunities to optimize
performance

* Provide resolution to an extensive range of complicated ETL-related
problems, proactively and as issues surface.
* Informatica PowerCenter base system grid configuration and support
including installation, upgrades, performance tuning, etc.
* Perform code version control activities.

Qualifications

* Minimum six (6) years of current and hands-on experience with
Informatica PowerCenter (including 2 years of v 9.x or higher) design,
development and performance tuning
* Minimum six (6) years of current and hands-on experience with
complex SQL and high-volume Relational databases and SQL Query performance
tuning
* Minimum six (6) years of current and hands-on UNIX shell scripting
experience.
* Minimum two (2) years of current and hands-on experience with an
enterprise job scheduler (Control-M, Autosys, Redwood, etc
* Minimum two (2) years of Informatica PowerCenter system maintenance,
installation and upgrade experience
* Minimum two (2) years of current and hands-on experience with code /
version management tools.
* Minimum 7 years of current and hands-on experience with SQL and
Relational databases

Strongly Preferred Skills

* Informatica Grid architecture configuration and support
* Informatica S3/Redshift connector/integration experience
* Experience with AWS technologies: Lambda, Data Pipeline, EMR/Python, S3,
Redshift, Athena
* Experienced Agile team member and with Agile development methodology

Nice to Have Skills

* Experience with Tableau and Business Objects