Oracle ETL Developer with Cognos

in New York(NY)

Location: Albany, NY

Duration: 12+ months


- Capture and load source system data via ETL processes into the
data warehouse;
- Develop, test and implement program logic for ETL development.
- Efficiently implement team developed ETL technical
- Optimize ETL data load jobs to improve performance and automate
them and identify and create solutions to improve system
performance and availability;
- Develop and maintain logical and physical dimensional data
models for Data Warehouse/Data Mart
- Following agency standards to ensure the accuracy and integrity
of data and applications through analysis and coding as performed
by the ETL process;
- 7 Writing clear ETL process and data modeling documentation and
clear documentation of all associated tasks and documents.
- Ongoing design, development, maintenance, and support of ETL
- Investigating and resolving data loading and/or data integrity

Skills Needed

84 Months Demonstrated hands-on experience Developing and testing
query solutions using Oracle PL/SQL query

84 Months Demonstrated hands-on experience with UNIX Shell

84 Months Demonstrated hands-on experience ETL design/Data
Warehouse development using SQL and PL/SQL programming/ IBM Data

72 Months Demonstrated hands-on experience with Performance
tuning and Optimization of sessions, mappings, sources and
targets, Production support, trouble shooting and solving
migration issues, and identifying errors during data loads and
transformations for Cognos or OBIEE 10/11g environment.

72 Months Demonstrated hands-on development experience using ER
Studio for dimensional data modeling for Cognos or OBIEE 10/11g

72 Months Demonstrated hands-on ETL development experience in
Oracle environment with IBM Datastage

60 Months Demonstrated ETL development experience working with
PPI, SSA, or HIPPA data security requirements.

84 Months Demonstrated experience mentoring and assisting other

Bachelor Degree in computer science, information science, health
science, engineering, or mathematics - A copy of the diploma must
be submitted with the Candidate Response Form

Recent jobs at EADJObs.com
Senior Business Analyst in New York(NY) 29-12-2017
SQL DBA :: Lansing in Michigan(MI) 29-12-2017
Sr. ETL Developer in California(CA) 08-12-2017
devloper in California(CA) 08-12-2017
Java developer in Ohio(OH) 08-12-2017

« Go back to category
Recommend to a friend
Published at 11-09-2017
Viewed: 54 times