OBIEE Developer - Miami, United States - PhoenixProConnect, LLC

Description

Phoenix Pro Connect Technology is working with a South Florida client looking to hire an OBIEE developer/architect.

**** Must be in office in Miami **** Must be authorized to work in US****

Job Description:

As an Oracle OBIEE Developer, you will design and develop solutions with technical expertise in data warehouse design, ETL (Informatica), reporting, and analytics. This role involves the design and development of enterprise data warehouse (EDW), ETL, and business intelligence systems on OBIEE. You will also provide support for the ongoing operation and enhancements of EDW, ETL, and OBIEE systems.

Qualifications:

• Experience in building Enterprise Data Warehouse (EDW), Master Data Management (MDM), and Big Data implementations.
• Experience in building data models/DataMarts, such as Star and Snowflake schemas, for both horizontal and vertical lines of business.
• Proficient in developing OBIEE Repository at three layers: Physical, Business Model, and Presentation Layers.
• Experience with star-schema, snowflake, FACT, and dimensional data modeling.
• Expertise in SQL and strong hands-on scripting skills (PowerShell, Bash, and Python).
• Ability to understand current data warehouses and address any gaps.
• Clear and concise written and verbal communication skills.

Technological Stack:

• Oracle OBIEE 12.2
• Informatica PowerCenter 9 and higher
• Oracle SQL PL/SQL
• Proficiency with MS Visio or Erwin tools

Primary Responsibilities:

• Perform data engineering functions, including data extraction, transformation, loading, and integration, to support enterprise data infrastructures using Informatica PowerCenter.
• Analyze requirements and architecture specifications to create detailed design documentation.
• Collaborate with data modelers, business teams, and system analysts to prepare source-to-target mapping specifications.
• Use Informatica PowerCenter to create and maintain topology, interfaces, packages, and load plan components.
• Conduct data analysis, identify data patterns and issues, and provide solutions using ETL/ELT tools.

Education and Experience:

• Multiple project experience in data analysis, data profiling, and data cleansing.
• In-depth understanding of ETL/ELT concepts and techniques as applied in OLTP, ODS, and data warehouse applications.
• Understanding of SQL performance and tuning techniques (Oracle experience preferred).
• Experience with full Software Development Lifecycle methodologies.
• Provide technical leadership to BI team members to deliver on-time, on-budget, on-requirements, and on-quality OBIEE data warehouse management.
• Ensure that all products and data within the platform are architected and integrated as a cohesive unit, ensuring proper documentation.