0

applicants

Oracle ETL Developer with Cognos

in New York(NY)

Location: Albany, NY

Duration: 12+ months

Responsibilities:

- 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
specifications
- 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
workflows;
- Investigating and resolving data loading and/or data integrity
issues

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
Scripting

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

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
environment

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
developers

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
Test Automation Architect in New Jersey(NJ) 22-11-2017
SAP FICO & Mobile Apps Tester in California(CA) 22-11-2017
Mobile Technical Architect in Wisconsin(WI) 22-11-2017
Session Border Controller Engineer in Pennsylvania(PA) 22-11-2017

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