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
10787 Quincy, MA 02171 Application Architect: SQL Code, Data Warehouse, Erwin ERD Modeling, Linux, Shell Scripting (1pos) 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=10787 (Application Architect: SQL Code, Data Warehouse, Erwin ERD Modeling, Linux, Shell Scripting (1pos)) in Quincy MA 02171 (NON)

Estimated Length: Open Ended 40 Hours per Week


  • 5+ years of experience in database architecture and development including analyzing, designing, documenting, coding, testing and implementing primarily SQL code
  • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data architecture modeling
  • Exceptional Oracle SQL skills and PL/SQL skills
  • Hands on experience with set based operations, analytic functions and query hints
  • Command of data warehouse modeling concepts is required
  • Strong problem solving and analytical skills
  • Strong Erwin ERD modeling
  • Proficiency with Linux and shell scripting
  • Experience working with a large, multi-terabyte data warehouse


  • BS in Computer Science or related degree, or equivalent experience
  • Medicaid or other healthcare or claims processing experience
  • AWS (Cloud) Experience
  • Informatica ETL experience


  • Creates data models and designs to meet specific business needs
  • Ability to determine appropriate sourcing and storage of data from multiple source systems
  • Understands and is able to translate business requirements into Data Warehouse solutions
  • Codes Oracle ETL scripts that will extract data from an operational database and populate the staging and target data warehouse schemas
  • Documents code and processes for distribution to all interested parties
  • Documents design using industry standards including ERWIN diagramming
  • Provides query writing support and tuning expertise to analysts and end users
  • Develops shell scripts for production job automation
  • Is able to work in a 24x7 environment which requires on-call rotatio
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