Informatica ETL Developer
The Informatica ETL developer will be 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. The candidate will 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.
KEY RESPONSIBILITIES:
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
5 yrs. of experience required
Must Haves
Experience with OBIA Financials HR Supply chain etc..
Experience with DAC Administration
Experience with IDMC data integration and PowerCenter modernization
Nice to haves
Experience with Snowflake
Experience with JSON files
Experience with CICD
Experience with Python scripting
Informatica ETL Developer The Informatica ETL developer will be 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. The candidate will work cl...
Informatica ETL Developer
The Informatica ETL developer will be 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. The candidate will 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.
KEY RESPONSIBILITIES:
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
5 yrs. of experience required
Must Haves
Experience with OBIA Financials HR Supply chain etc..
Experience with DAC Administration
Experience with IDMC data integration and PowerCenter modernization
Nice to haves
Experience with Snowflake
Experience with JSON files
Experience with CICD
Experience with Python scripting
View more
View less