What are the responsibilities and job description for the Informatica ETL Developer position at The Bergaila Companies?
Overview
We put the unity in "opportunity."
Opportunity Snapshot:
- Compensation: $103.00/hour
- Location: Houston, TX (Downtown)
- Duration: 12 months
- Schedule: 9/80, M-Th 9 (hours), Friday (4 hours) in-office
- Benefits: Comprehensive insurance, 401(k) program, PTO & Holidays
- Must be a Houston local with right to work to be considered
Responsibilities
- Responsible for the design, development, testing, maintenance and support of OBIEE solutions for Oracle Financial, Human Resources, Procurement, Projects, and Asset Maintenance Analytics within the data warehouse
- Work closely with members of the data warehouse team including business customers to understand broad business information requirements, develop solutions to meet those requirements, and execute the design in order to meet business needs
- Utilize best practices to design, develop, and support the OBIEE/OBIA data warehouse architecture
- Develop and administer Informatica Repository, Mappings, Sessions, and Workflows Monitor nightly loads and troubleshooting issues as they arise in the Database, DAC and Informatica
- Develop and administer DAC tasks, task groups, subject areas, and execution plans for existing and new applications
- Migrate DAC and Informatica development objects to test, production, and disaster recovery
- Maintain Administrator documentation for all customizations and extensions
- Serve as a subject matter expert for OBIEE/OBIA, demonstrating expertise in Oracle BI Server, ETL, DAC, and OBIEE performance tuning of BI Applications
- Troubleshoot production issues on day-to-day bases
- Assist with migration from PowerCenter to IDMC
Qualifications
- A Bachelor's degree is preferred
- 2 years experience with DAC Administration
- Must have experience with IDMC – data integration and PowerCenter modernization
- Must have experience with OBIA – Financials, HR, Supply chain, etc
- Experience with CI/CD and Snowflake desired
- Experience with Python Scripting preferred
- Experience working with JSON files
- A minimum of a high school diploma or G.E.D equivalent is required
The Bergaila Way:
The Bergaila Companies is a nationally recognized leader in providing staffing services to all sectors of the energy industry. We continually focus on partnering with talented professionals, engineering the perfect fit between our clients and employees. Choosing a career path with Bergaila grants you immediate access to nationally recognized organizations we partner with. Bergaila consistently attracts and retains its Employees with our dedicated internal service team, top tier benefits programs for contractors and their families, and commitment to place you in the desired career of your choice.
Client Overview:
Our client is one of North America's largest Midstream Oil & gas companies. A publicly traded company they are a leading provider of midstream energy services to producers and consumers of natural gas, natural gas liquids (NGL's), crude oil, and refined products/petrochemicals.
Salary : $103