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
10821 Menands, NY 12204 ETL Developer: Informatica, IDQ, Data Warehouse, ETL, UNIX, PL/SQL, Oracle, Rhapsody 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=10821 (ETL Developer: Informatica, IDQ, Data Warehouse, ETL, UNIX, PL/SQL, Oracle, Rhapsody) in Menands NY 12204 (SJU)

Estimated Length: 24 months Full-Time 8 hour days (regular business hours are 8:00am - 5:00pm but can be negotiated)

Mandatory Requirements

Senior 60-84 Months

Desired Requirements

  • 60 Months Demonstrated experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge with IDQ 8.x or higher.
  • 60 Months Demonstrated experience using Informatica 8.x or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings. 
  • 60 Months Demonstrated experience using Informatica 8.x or higher merging data from multiple source systems including but not limited to ORACLE and flat files.
  • 24 months Demonstrated Rhapsody experience acquiring and managing large amounts of data including HL7 message formats. 
  • 60 Months Demonstrated experience writing complex UNIX scripts. (e.g. validate and to ftp files, and for calling Informatica workflows)
  • 60 Months  Demonstrated experience converting complex SQL, PL/SQL (stored procedures/functions), with Oracle  9i, 10g or higher, to Informatica mappings  
  • 60 Months    Demonstrated experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing
  • 60 Months      Demonstrated Experience in Dimensional Data Modeling for creating logical and physical data models using a commercial data modeling tool like ERWIN or ERStudio. 
  • 60 Months Demonstrated Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica.   


  • Leading the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Center.
  • Leading the ETL team in shaping, enhancing and recommending best practices to the overall ETL/Informatica architecture 
  • Investigating and resolving difficult design and build issues, data loading and data integrity issues.
  • Writing SQL for querying the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.
  • Performance tuning Informatica workflows.
  • Using Informatica to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets.
  • Working with large and complex Oracle data warehouses, data marts and OLTP databases.
  • Writing UNIX shell scripts to validate and ftp files and to call workflows. 
  • Using Rhapsody to acquire and manage large amounts of data with the HL7 message format


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