What are the responsibilities and job description for the Informatica Developer position at The Jupiter Group, Inc?
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
