ETL Developer

posted 2 months ago

Job Description

SQL

Basic Table structure, data types, keys, data integrity, E-R diagramsm, sorting and filtering, joins, aggregation, Views, materialized views, Complex queries, analytic functions and indexes.

PLSQL Basics

Stored procedures and functions, triggers. exception handling, collections, packages

Unix, Client and Server Architecture Basics

Basic understanding about Unix/Linux, VM, Client and Server arichitecture

Data warehousing concepts

\

Understanding about the data mart and data warehousing, Meta data, SCD, Multidimentional Analysis

Datastage Architecture

Good understanding about Datastage client/server setup, parallal processing, multiple job instance, Note setup, Partitioning.

Datastage

Parallel job creation with all the stages. Sequence job development. Job scheduling, monitoring, debugging the errors, Notification setup, Good in handling seqential files and dataset files.

Unit Testing

Unit testing Datastage job output with SQL & pl/SQL code using tools like Oracle SQL Developer

Industry best practices

Parameterized jobs, modularity, reusable stages creation, error handling, testing, code review, etc.