ETL/Database Developer

Overview

On Site
$60,000+
Full Time

Skills

ETL
SSIS
ODI
OCI
Oracle's ADW
OBIEE
SQL
T-SQL
Data Modeling
Linux

Job Details


Job Title: Sr. ETL/Database Developer

Experience: 6 to 10Years

Must Have:
1. ODI - Oracle Data Integrator
2. OCI - Oracle Cloud Infrastructure
3. Strong Oracle experience required
4. Hands-on experience working with and managing Oracle's Autonomous Data Warehouse (ADW) service
5. Familiarity with Oracle Business Intelligence Enterprise Edition (OBIEE) is a plus

    • Develop and maintain SSIS packages:
      This includes designing the package structure, configuring data sources and destinations, and implementing data transformations.
  • Extract data from diverse sources:
    SSIS can connect to various data sources, including SQL Server databases, flat files, Excel files, and other databases.
  • Transform data:
    This involves cleaning, cleansing, and aggregating data to prepare it for loading into the target database.
      • SQL Server knowledge: Strong understanding of SQL Server databases, T-SQL, and stored procedures
  • Data modeling: Ability to understand data structures and design data models for ETL processes.
  • ETL concepts: Understanding of ETL principles, data warehousing, and data integration.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.