View Our Website View All Jobs

ETL PL/SQL Specialist

eiWorkflow Solutions, LLC is a cloud software consulting firm based in Albany, NY. eiWorkflow Solutions, LLC is currently looking for a consultant for the following role in Albany, NY.

ETL PL/SQL Specialist

Tasks the role will be performing:

1. Capture and load source system data via ETL processes into the data warehouse;
2. Develop, test and implement program logic for ETL development.
3. Efficiently implement team developed ETL technical specifications
4. Optimize ETL data load jobs to improve performance and automate them and identify and create solutions to improve system performance and availability;
5. Develop and maintain logical and physical dimensional data models for Data Warehouse/Data Mart
6. 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.
8. Ongoing design, development, maintenance, and support of ETL workflows;
9. Investigating and resolving data loading and/or data integrity issues


Requirements for the position:


  1. 84 Months Demonstrated hands-on experience Developing and testing query solutions using Oracle PL/SQL query
  2. 84 Months Demonstrated hands-on experience with UNIX Shell Scripting
  3. 84 Months Demonstrated hands-on experience ETL design/Data Warehouse development using SQL and PL/SQL programming/ IBM Data Stage
  4. 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.
  5. 72 Months Demonstrated hands-on development experience using ER Studio for dimensional data modeling for Cognos or OBIEE 10/11g environment
  6. 72 Months Demonstrated hands-on ETL development experience in Oracle environment with IBM Datastage 
  7. 60 Months Demonstrated ETL development experience working with PPI, SSA, or HIPPA data security requirements.
  8. 84 Months Demonstrated experience mentoring and assisting other developers
  9. Bachelor Degree in computer science, information science, health science, engineering, or mathematics. A copy of the diploma must be submitted with the resume



Date First Created: 06/12/2017

Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, .docx, .odt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Human Check*