Informatica Developer

Rootshell Enterprise Technologies•Dallas, TX

2d•Onsite

About The Position

Rootshell Enterprise Technologies Inc. is seeking an Informatica Developer for a direct client in Frisco, Texas. The role focuses on developing and maintaining ETL solutions, including a control framework for loading Excel files into Oracle tables, data quality controls, auditing, error logging, and business self-service data cleansing. The developer will work with Informatica, Oracle, PL/SQL, Unix scripting, reporting and dashboards, and web services/API integrations. The role also involves executing and monitoring Informatica sessions, identifying performance bottlenecks, developing and maintaining code for enhancements and integrations, resolving defects, conducting code reviews, and performing performance analysis and tuning. The developer will participate in business meetings to advise on technical feasibility, support system integration testing, coordinate user acceptance testing with business owners, and provide technical leadership.

Requirements

At least 5 years of ETL and ELT experience.
Strong technical expertise in Informatica PowerCenter.
Oracle Informatica Administrator experience to manage administrative activities.
Experience in data visualization and reporting.
Experience integrating ETL/ELT with web services.

Nice To Haves

Python development experience integrated with front-end Java components.
Exposure to Siebel EIM.

Responsibilities

Develop a control framework for loading data from Excel files into Oracle tables using Informatica.
Execute and monitor Informatica sessions, identify performance issues, and find bottlenecks.
Enable business self-service data-cleansing activities.
Define, develop, document, and maintain PL/SQL stored procedures, functions, and packages.
Develop ETL data controls, error logging, auditing, and data quality programs using Informatica.
Develop Unix scripts to schedule Informatica jobs and handle ETL post-processing.
Perform system integration testing and coordinate user acceptance testing with business owners through sign-off.
Participate in business team meetings as the technical representative and advise on technical feasibility.
Develop and maintain code for enhancements, projects, and integrations; fix defects; and participate in and conduct peer code reviews.
Follow and propose design and coding standards and processes, and provide technical leadership.
Conduct code performance analysis, tuning, and review.
Work on reporting and dashboards and integrate ETL/ELT with web services and API calls to synchronize data with other systems.