View Our Website View All Jobs

ETL Oracle PL/SQL Programmer

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 Oracle PL/SQL Programmer

Tasks the role will be performing:

1.    Data Warehouse design, development, support and data mining related to new and existing complex Extract, Transform, Load (ETL) routines related to Fraud Detection/Improper Payment algorithms;
2.    Develop, test and implement program logic for data mining and ETL development;
3.    Efficiently implement ETL technical specifications from development through test, staging and production environments;
4.    Optimize ETL data load jobs to improve performance and automate;
5.    Investigating and resolving data loading and/or data integrity issues;
6.    Create solutions to improve system performance and availability;
7.    Develop and maintain logical and physical dimensional data models for data warehouse/data mart;
8.    Follow agency standards to ensure data accuracy and integrity through analysis and coding;
9.    Write clear documentation of process and data modeling and all associated tasks and documents including unit and quality assurance test plans.
10.    Strong communication skills to independently work closely with Office of Special Investigations, Data Warehouse and Management staff to ensure clear communication between all parties. 

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 PL/SQL programming
  4. 84 Months Demonstrated hands-on experience transforming data elements into meaningful Fraud Detection query and customer output
  5. 84 Months Demonstrated experience mentoring and assisting other developers   
  6. 36 Months Demonstrated experience working with PPI and SSA data security requirements (working with data contained in Employee Records in a State Agency, Federal Agency or Private Organization) in a data warehouse environment.
  7. 36 Months Demonstrated hands on experience developing dimensional data models for data analytics
  8. Bachelor degree in computer science, information science, health science, engineering, or mathematics. A copy of the diploma must be submitted with the resume 


If interested, please send your resume along with your expected all-inclusive rate and three professional references. Please include your current location, your expected all-inclusive hourly rate and your rate type (W2 or C2C) in your submission. Please note that submissions without the above requested information might not be considered complete.


Date First Created: 11/06/2016

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*