ETL DataStage Developer (Oracle Data Warehouse) 13+Years Exp

ACS -

Albany, NY, United States

13 days ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Java (Programming Language) Data Analysis Unit Testing Batch Processing Software Documentation Extract Transform Load (ETL) Data Security Data Warehousing IBM InfoSphere DataStage Software Debugging IBM Cognos Business Intelligence Unix Shell

+6 more

Oracle Databases Oracle (Applications) Oracle Warehouse Builder PL-SQL SQL Databases Software Coding

Job description

Role: Expert IT Specialist HBITS-08-14907 DURATION: 30 Months LOCATION: Albany, NY Hybrid Interview Type: Video This position will assist in supporting critical DOL operationa…

22 hours ago
Apply easily +

Requirements

Extensive experience developing ETL solutions in an Oracle database environment using IBM DataStage.
Strong experience designing and developing Data Warehouse solutions utilizing SQL and PL/SQL programming.
Proven experience optimizing and tuning SQL queries within Oracle environments to enhance performance and execution efficiency.
Hands-on experience developing and maintaining UNIX Shell scripts for automation and batch processing.
Solid experience in application programming, code development, and unit testing.
Experience creating and maintaining program documentation while mentoring and supporting junior developers.
Experience working with PPI and SSA data security requirements, including handling employee data in State, Federal, or private organizations, performing production issue analysis, debugging, and code modifications.
Experience designing and developing dimensional data models to support Cognos reporting and analytics.
Experience developing data analysis, reporting, and metrics queries to support operational monitoring and business oversight.