Data Architect / ETL Developer

Industry: Information Services


5 - 7 years

Posted 360 days ago

Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services. OST is one of an elite set of companies worldwide to be externally appraised CMMI Level 5.   The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.   Description of specific Duties in a typical workday for this position:

  • Lead design and implementation of data integration solutions including ETL and Data Architecture
  • Ensure data warehouse integrity
  • Design Data Marts for data warehouse leveraging data transactions from Oracle Federal Financial and PRISM
  • Design, code, deploy, and test applications according to requirements and industry best practices.
  • Building ETL flows
  • Setup and configure ETL tools
  • Convert program or file data submission process to a business rules submission
  • Develop an ETL processing framework based on requirements
  • Establish and document business requirements and design for ETL processing framework
  • Develop unit test cases and associated SQL scripts
  • Schedule ETL jobs
  • Use UNIX commands to assist with development
  • Manage source code under version control tool such as PVCS
  • Conduct peer reviews and code reviews

  Position Requirements

  • US Citizenship
  • Ability to successfully pass a National Agency Check with Law and Credit (NACLC) background investigation
  • Bachelor’s degree in computer science, information systems, or related field.
  • 5+ relevantyears of hands onexperience in a wide array of data warehouse and integrationtechnologiessuch as :
    • Informatica,
    • Pentaho Data Integration & Business Analytics or Talend
    • Experience with Oracle Data Warehouses
  • 5+years data warehouseexperienceincludingExperience designing Enterprise Data Warehouse and Marts
    • Data architecture
    • ETL architecture
    • Automated job processing
  • Experience designing schemas (e.g., Star, Snowflake) to develop ETL workflows and BI reports
  • Experience designing and developing Informatica ETL workflows using version 9, 10
  • Experience performing Informatica Upgrades
  • Experienceworking with Unix Solaris
  • Experienceworking with Job Scheduling Tool(s) such as BMC Control-M or similar.
  • Must be a creative thinker who can work well on a team

  Nice to have:

  • Secret Clearance
  • Experience leading a small team of Warehouse ETL/OBIEE developers is a plus
  • Experience with UNIX commands and terminal emulators such as PuTTY
  • Experience working ETLs against Oracle Federal Financials
  • Ability to develop and conduct software test activities