ETL/Data Warehouse Developer

Overview

On Site
$60
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 1 day((s))
100% Travel

Skills

OLTP
XML
PL/SQL
Stored Procedures
Triggers
Packages
Indexes
Relational Databases
Informatica PowerCenter
Informatica Data Quality
ETL Tools
Data Migration
Flat Files
UNIX Shell Scripting
Data Quality
Data Profiling
Data Cleansing
Data Standardization
Match and Merge
Oracle 11g+
Materialized Views
SQL Loader
External Tables
Built-in Packages
SCD (Slowly Changing Dimensions)
CDC (Change Data Capture)
OLAP
Performance Tuning
Functions

Job Details

  • 60 months of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases.

  • 60 months of experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality.

  • 60 months of experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.

  • 60 months of experience with Data Quality processes, approaches, measurement techniques and business cases for data analysis, data profiling, data cleansing, data standardization, match and merge functionality using Informatica Data Quality

  • 60 months of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.

  • 60 months of experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.

  • 60 months of experience writing complex UNIX shell scripts to validate and ftp files, and for scheduling / automating ETL process

  • 60 months of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.

_________________________________________________________

Agency: Information Technology Services (ITS)

Project: OFT-IES (Integrated Eligibility System)

Detailed Job Description: The Software Developer will be working with the product development team writing the code, designing the architecture, and ensuring the software functions correctly. They will report to Shyam Dubey at our Albany office.
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.

About GreyCell Labs, Inc