Position: DWH with Oracle+Teradata Developer
Company: Chrysalis Gate
Experience required: 5y
English level: upper

We are looking for DWH with Oracle+Teradata Developer to join our client’s team on a subcontract basis.

Requirements:
● Informatica:
- Experience with partitions (using);
- Experience with Fast Load;
- Understanding the Pushdown Optimization option;
● Oracle:
- Understanding the query plan, physical table joins, rollback segment.
- Knowledge of indexes (types of indexes, intended use of indexes), partitions, subpartitions;
- Knowledge of PL/SQL syntax (writing procedures, packages, functions);
- Work with tables of large volumes (less 1 billion records);
- Experience using hints;
- Queues in Oracle;
- Creation of jobs, chains, programs;
- Knowledge of Apex (version 20.1);
● Teradata:
Knowledge of Teradata architecture;
- Understanding Primary index and Secondary index;
- Knowledge of partitions, statistics, compression;
- Writing procedures and functions.
● Working with PuTTY;
● Writing Bash scripts.

We offer:
The full-time workload on a remote basis
Start - ASAP
Duration - 12+ months
Part of the interview will be Livecoding