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
10581 Quincy, MA 02171 Application Architect: Oracle PL/SQL, Data Warehouse, Erwin ERD Modeling, Linux (1pos) 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=10581 (Application Architect: Oracle PL/SQL, Data Warehouse, Erwin ERD Modeling, Linux (1pos)) in Quincy MA 02171 (NON)

Estimated Length: Open Ended 40 Hours per Week

QUALIFICATIONS

  • 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

PREFERRED QUALIFICATIONS

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

SPECIFIC DUTIES

  • 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 rotation
 
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