Junior ETL Developer - 3643

MSI is seeking a Junior ETL Developer to support our government client in Washington, DC. 


Description

Our government client has an opportunity for an experienced, motivated Extract, Transform, and Load (ETL) Developer to support healthcare and benefit information technology projects for our customers. Working closely with project manager, the ETL Developer will analyze data storage needs, data usage, and oversee the loading of data into the system. This position is located on-site with the customer in their Washington, DC office.

Essential Functions and Job Responsibilities

The successful candidate will work with cross-functional team of users and customers to document and strategize for data management, analysis, and storage. Duties and responsibilities will include, but are not limited to:

  • Identify data storage needs required to build fact and summary tables based on source data
  • Develop data warehouse functionality – build data warehousing system from technical and functional specifications that meets needs and work with a development team to build the warehouse.
  • Extract, Transformation and Load data – extract necessary data and transfer it to new system.
  • Test and troubleshoot – test designs of new system to ensure smooth operations and fix any issues that arise.
  • Identify and capture lessons learned, best practices, and information gained during performance of tasks.

Minimum Requirements:

  • Bachelor’s degree in computer science, engineering, or a related scientific or technical discipline with 2+ years of experience
  • Experience extracting and summarizing data from a variety of data source types using Oracle SQL and Informatica (or similar tool set)
  • Experience in using Oracle PLSQL
  • Dimensional modeling experience
  • Experience interfacing with business users and understanding their requirements
  • Understanding of business intelligence development in the IT industry
  • Ability to learn and implement new and different techniques
  • Outstanding written and verbal communication skills
  • Must be able to obtain Positon of Trust and successfully pass a thorough Government background screening process requiring the completion of detailed forms and fingerprinting

Desired Qualifications:

  • Previous Department of Veterans Affairs experience
  • IBM Rational toolset experience

MSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin.