Senior ETL Developer
Apply NowCompany: Avani Technology Solutions, Inc.
Location: Albany, NY 12203
Description:
The Consultant must meet or exceed the following Mandatory Criteria:
Five years' experience troubleshooting complex technical problems involving networking, database, application, storage and associated servers;
Three years' experience modeling data for reporting and analytics;
Five years' experience in tuning Structured Query Language ("SQL") for performance;
Three years' experience providing technical guidance to a team of software developers to implement solutions to multiple concurrent complex technical problems;
Three years' experience providing technical guidance to a team of software developers regarding all aspects of performance tuning an enterprise data warehouse reporting and analytics system; and
Five years' experience performing Oracle database development using SQL and Procedural Language/Structured Query Language ("PL/SQL").
Desired Criteria:
A minimum of one year experience architecting and implementing Oracle Security utilizing users, roles, object and system privileges, application contexts, Virtual Private Database and associated policies;
A minimum of one year experience using Oracle Warehouse Builder ("OWB") to create complex ETL processes;
A minimum of one year experience working with Oracle Business Intelligence Enterprise Edition ("OBIEE");
A minimum of one year experience programming utilizing Unix korn shell scripting language, preferably IBM Advanced Interactive eXecutive ("AIX"); and
A minimum of six months' experience performing ETL Development using Attunity Compose.
Five years' experience troubleshooting complex technical problems involving networking, database, application, storage and associated servers;
Three years' experience modeling data for reporting and analytics;
Five years' experience in tuning Structured Query Language ("SQL") for performance;
Three years' experience providing technical guidance to a team of software developers to implement solutions to multiple concurrent complex technical problems;
Three years' experience providing technical guidance to a team of software developers regarding all aspects of performance tuning an enterprise data warehouse reporting and analytics system; and
Five years' experience performing Oracle database development using SQL and Procedural Language/Structured Query Language ("PL/SQL").
Desired Criteria:
A minimum of one year experience architecting and implementing Oracle Security utilizing users, roles, object and system privileges, application contexts, Virtual Private Database and associated policies;
A minimum of one year experience using Oracle Warehouse Builder ("OWB") to create complex ETL processes;
A minimum of one year experience working with Oracle Business Intelligence Enterprise Edition ("OBIEE");
A minimum of one year experience programming utilizing Unix korn shell scripting language, preferably IBM Advanced Interactive eXecutive ("AIX"); and
A minimum of six months' experience performing ETL Development using Attunity Compose.