IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
10892 Rensselaer, NY 12144 Oracle DW/BI Developer- PL/SQL, Oracle datawarehousing,ETL processes,data marts,Informatica,OWB DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to

Subject=IIT Career Site/Resume for JobID=10892 (Oracle DW/BI Developer- PL/SQL, Oracle datawarehousing,ETL processes,data marts,Informatica,OWB) in Rensselaer NY 12144 (BOB)

Estimated Length: 24 months Full-Time 8:00 – 5:00 (negotiable)

Mandatory Requirements

Expert 84+ Months 

Desired Requirements

  • 84 months experience in a data warehouse setting as an ODI developer including developing maps, procedures, load plans, packages and testing those solutions
  • 60 months experience in developing ETL in Oracle Warehouse Builder (OWB) including migrating OWB projects to ODI 12c.
  • 60 months Data modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • 60 months experience in an Oracle Data Warehouse as a developer performing development work using PL/SQL
  • 60 months experience in UNIX or LINUX environment, Unix Shell Scripting. 
  • 84 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
  • 60 months problem solving technical issues. 
  • Bachelor’s Degree.


  • Work in coordination with a team of developers to expand the current Data Warehouse.
  • Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
  • Perform unit testing and correct all identified bugs.
  • Perform complex PL/SQL coding in a Data Warehouse environment.
  • Assist with responding to Juvenile Justice data requests. 
  • The individual in this position will work under the direction of a Technical Lead & Project Manager.
  • Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL
Submit Resume For This Job (via email)
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer