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
9804 Albany, NY 12234 ETL Programmer: SQL, IBM InfoSphere DataStage, Informatica, COBOL, App Coding, Unit Testing DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to
jobs@iit-inc.com    

Subject=IIT Career Site/Resume for JobID=9804 (ETL Programmer: SQL, IBM InfoSphere DataStage, Informatica, COBOL, App Coding, Unit Testing) in Albany NY 12234 (AMI)

Estimated Length: 24 months Full-Time Monday – Friday, flexible between the hours of 8:00 am and 5:00 pm. Minimum half-hour lunch. 

Mandatory Requirements

Expert level 84+ months 

Desired Requirements

  • 84 months of experience leading ETL (Extract, Transform, Load) mapping and data conversion.
  • 84 months of experience writing complex SQL statements and executing SQL queries and reports that meet New York State Agencies’ or Federal compliance requirements or United States Governmental business needs.  
  • 84 months of experience application coding, unit testing, system integration testing, regression testing, data migration testing, production implementation and operational support.
  • 36 months of experience using an industry-leader ETL tool (IBM InfoSphere DataStage or Informatica or equivalent).  
  • 84 months of experience in Mainframe COBOL.  
  • 12 months working with United States Government or New York State Agencies on complex legacy data conversion projects that involved a large environment of integrated legacy applications written in PowerBuilder or Mainframe COBOL.
  • Bachelor’s Degree in Computer Science from an accredited institution.

Responsibilities

  • Analyze the existing legacy applications that support ACCES-VR services and document ‘as is’ system analysis artifacts
  • Document data models and legacy system data flows
  • Provide ETL (Extract, Transform, Load) mapping expertise and lead ETL tasks related to modernization of CaMS system
  • Assist with ACCES-VR federal reporting and data mart activities
  • Contribute to routine production data processes, running of SQL queries, and reporting administration
  • Assist with mainframe payment processing COBOL programs’ support
  • Manage mainframe routine data processes (daily, weekly, quarterly, annual)
  • Assist with the support of a small Java application which works with the rest of legacy ACCES-VR applications 
  • Create test plans and contribute to unit, system integration and regression testing
  • Support data migration, data quality assurance testing and debugging activities
  • Lead technical analysis and design discussions and document technical artifacts related to a group of applications (PowerBuilder, Unisys Mainframe, PL SQL, Java, Oracle) that support ACCES-VR
 
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