ETL Developer
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.