Role: OBIEE & Informatica Developers
Job Type: Full-time
Location: CA (Remote)
10+ years Experience required.
Published On: 08 June 2022
Duties/Responsibilities:
- Design and Implement the ETL Informatica and Oracle Business Intelligence architecture for the Agency
- Configure Informatica 9.6.1 and Oracle Business Intelligence 11.1.1.7.0 with Oracle database to store the repository, metadata information and the agency data
- Create Data Warehouse Dimensional Model as the BI solution
- Develop complex ETL Informatica Mappings for the Organization using various transformations available in Informatica like Expression, Lookup, Router, Joiner, Sequence Generator, Sorter, Filter, Aggregator and Update Strategy transformations for populating the target tables in the data warehouse
- Troubleshoot performance issues in the mappings and optimize performance by tuning the Informatica mappings
- Work with session logs, Informatica Debugger, and Performance logs for error handling to fix workflows and session failures
- In-depth understanding of RPD configuration, Load balancing & Security model
- Configure Logical Layer, Logical tables/dimensions, columns, Logical Joins/keys, set levels to support Drill-down, Aggregation, Level based hierarchies and Parent-child hierarchies
- Develop various kinds of reports pivots, charts, tabular using global and local filters
- Work closely with end users to design reports & dashboards, suggesting better ways of reporting in OBIEE so that required information is visualized by end users
Basic Qualifications:
- 3-5 years of experience developing solutions in an OBIEE 10/11G environment including Informatica PowerCenter (8.x/9.x)
- 3-5 years of hands-on experience with Oracle 11G databases, Oracle Data Warehouse and Data Marts to support Business Intelligence
- 3-5 years of demonstrated hands-on experience with OBIEE 11g presentation layer dashboards and analyses development.
- 3-5 years of demonstrated hands-on development experience with OBIEE 11g Repository development.
- 3-5 years of hands-on development experience with SQL and PL/SQL
- 3-5 years of hands-on experience in Dimensional Modeling
- 3-5 years of development experience with TOAD (SQL querying tool)
- 3+ years for ETL Informatica Development Experience
- 3+ years of Oracle OBIA/OBIEE application experience including implementation, configuration, troubleshooting, and report development
- Experience in upgrading the ETL/OBIEE environment from Informatica 8.6 to 9.6 and OBIEE 10.3 to OBIEE 11.7
- Experience with Siebel CRM systems and/or other application platforms
- Experience with UNIX shell scripting
- Excellent Troubleshooting and root cause analysis skills
- Excellent communication and ability to document requirements and create functional and technical specifications
- Ability to obtain a Public Trust Clearance
- Must be a US Citizen or a Green Card holder who has lived in the US for 3 years or longer
Preferred Skills:
- 3+ years of experience gathering requirements, designing, developing and documenting custom dashboards, reports, agents, actions, etc.
- 3+ years of experience creating and modifying OBIEE reports
- Knowledge of Siebel CRM
- Knowledge of Oracle Database Administration