Oracle BI Developer - Los Angeles, United States - Estrada Consulting Incorporated

Description

QUALIFICATIONS AND DUTIES
a. Design, automate and support sophisticated data extraction, transformation, and loading applications.
b. Strong knowledge of Oracle database for batch application development within data warehouse / data lake environment.
c. Perform data ingestion from heterogeneous data sources to on-premises or cloud data storage, (including and not limited to snowflake, AWS, etc.)
d. Knowledge of RPD metadata i.e. customized analytics repository, designing physical layer, developing BMM and presentation layers, setting up LDAP Authentication
and developing dynamic and interactive dashboards.
e. Experience managing ETL using DBT, ODI, Oracle PL/SQL, Oracle SQL and ShellScript.
f. Experience and knowledge in developing dimensional hierarchies, design data model to support multiple Enterprise Data Management reports. Work with all stakeholders including business customers, vendors, and internal resources to facilitate team communication and achieve the mission.
g.

Creates and improves data solutions that enable smooth data delivery and is in charge of gathering, processing, maintaining, and analyzing enormous amounts of data.

h. Experience in data quality validation.
i. Knowledge/Experience in API development frameworks.
j. Knowledge/Experience in Cloud native data integration technologies.

6 months contract
Location-Los Angeles California 90017 United States


About Estrada Consulting Incorporated:
Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia.

We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries.

The Company headquarters is in Sacramento, California, and was established in year 2000.

Visit to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.