Database Engineer

  • Praescient Analytics
  • Washington, DC, USA
  • May 22, 2018
Full-time Big Data Computer Science Data Architecture Data Integration Data Modeling Data Reporting ETL MySQL SQL Unix

Job Description

Praescient Analytics is seeking an ETL Engineer to support DOD & DHS customers in the Washington, DC and Northern Virginia Area.

Praescient offers a chance to learn and develop your technical skills in a highly collaborative environment, but also a real opportunity to impact essential customer missions. We hire developers and engineers who are passionate about product craftsmanship and clean, efficient code. It’s time to stop reinventing analytic platforms and start solving real world problems. If you have a strong DataStage, ETL knowledge and care about making a difference with your work, we want to talk to you!

This position requires an: ACTIVE TS/SCI SECURITY CLEARANCE.


  • Develop, implement, configure and administer ETL processes for large scale data warehouses using Datastage (IBM InfoSphere)
  • Use DataStage, Talend, or Informatica to create validation process to validate data conversions
  • Maintain and monitor Unix file system for ETL projects
  • Work with system owners to resolve conversion errors
  • Support Schema Modeling for data ingestion
  • Create SQL scripts/queries for data verification
  • Monitor testing and ensure defects are being entered, tested and closed
  • Document and maintain testing results and test logs
  • Enable restoration of ETL application in case of server crash or degradation
  • Manage internal client needs and expectations ensuring issues are identified, resolved and escalated quickly and appropriately
  • Communicate known problems and fixes to team members and other technical groups
  • Provide remote “off hours” support as needed

Required Qualifications

  • Bachelor’s Degree with demonstrated academic achievement in Computer Science, Database Warehousing, or Database (DB2) expert technical experience.
  • In-depth knowledge of DataStage (IBM InfoSphere) or Talend, or Informatica, Unix and Linux
  • ETL experience (3-5 years)
  • DB2 experience (3-5 years)
  • API integration experience
  • Must have appropriate clearance level

About Praescient

If you have a background in most or all of the above, then odds are you have a lot of choices of how to spend your time. Consider Praescient as a rare opportunity to join a team that is actually impacting the security of the city on a daily basis.

Our people and our culture make Praescient an amazing place to work. Each member of our team brings a unique set of skills to Praescient and we work together to solve really interesting, really important problems. Our culture is about collaboration, innovation, opportunity and development. We make a difference by being different.

What we believe in

  • Working with a tech-savvy team on super exciting, cutting-edge opportunities
  • Friendly work atmosphere, casual dress at HQ offices
  • A caffeinated developer is a happy developer (read: Free soda and Monster)
  • Free breakfast and lunch at our HQ office daily
  • Competitive salary
  • Comprehensive, Company Paid Health, Vision and Dental Insurance Plans for you and your family
  • Life Insurance, AD&D, Short term and Long Term Disability coverage at no cost to the participant. Additional coverage can be purchased for team members and their dependents
  • Paid Family Leave
  • Pet Insurance
  • Fun company events and outings
  • Company profit sharing plan
  • Education and Training stipends
  • 401(k) & matching, without vesting
  • 15 days paid time off plus 10 Federal Holidays

Each and every day at Praescient brings new and exciting challenges. We have a fast moving, ever changing environment which captivates us, and we hope it will do the same for you, too. If you hate being bored, you will love Praescient.

Praescient Analytics is committed to providing equal employment opportunities for all employees and applicants without regard to race, color, age, religion, sex, sexual orientation, marital status, gender identity, national origin, legally protected physical or mental disability, genetic information, citizenship status, or status in the uniformed services of the United States, status as a disabled veteran or veteran of the Vietnam era, or on any other basis which is protected under applicable law. This includes a commitment to provide a work environment that is free from all forms of illegal harassment including sexual harassment.

This covers all terms and conditions of employment including (but not limited to):

  • Hiring, placement, promotion, transfer, or demotion of all job classifications;
  • Recruiting, advertising or solicitation for employment;
  • Treatment during employment;
  • Rates of pay or other forms of compensation;
  • Benefits;
  • Selection for training;
  • Company sponsored social and recreational activities; and
  • Layoff or termination

The general responsibility for ensuring compliance and continued implementation of Praescient Analytics’ policies belongs to the Human Resource Department. However, all Praescient employees share in the responsibility to foster a discrimination-free work environment where everyone is treated with dignity and respect. Additionally, you should feel free to raise any concerns to management to the extent those are not being addressed.

Job ID