Job Description :
*Role: ETL Informatica Developer/Administrator*

*Location: Houston, TX*

*Contract to Hire*

*Employment Type: W2 only*

*Informatica* *ETL* Developer 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 *ETLrelated
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