Database Engineer Data Warehouse, Greenplum, SQL, ETL

  • Leidos,
  • Baltimore, MD
  • 2 days ago
company banner
Leidos
Database, SQL, Java, DBA, PLSQL, Shell Scripting, Python, Management
Full Time

Job Description

Description

Job Description:

Leidos is seeking an expert in the various data loading techniques to Greenplum MPP database and develop process to automate it, and troubleshoot any data load errors

Day to Day responsibilities:
  • Expert in the various data loading techniques to Greenplum MPP database and develop process to automate it, and troubleshoot any data load errors
  • Database development experience with strong skills in SQL and PL/pgSQL.
  • Expert in shell scripting, regular expression and automating tasks
  • Perform source system data analysis to understand data relationships
  • Investigate and resolve data quality, data loading failures and develop data cleansing routines
  • Design and document logical and physical data models in data modeling tool
  • Generate Data Definition Language (DDL) scripts from modeling tool
  • Design and document source to target data mappings
  • Design, develop and test custom ETL or data stage routines
  • Automate the custom data loading process and continue to improve based on requirements.
  • Provide ad hoc query support for ad hoc query requests
  • Experience with AWS, EC2, S3
  • Provide mentorship to group members and will be expected to help develop and support mid and junior level staff.
  • May be scheduled for after hours on-call support and will be required to support production release during non-peak hours.
  • The selected candidate will accept other duties as directed by management
  • Responsibilities of this position may also include:
  • Database developer and Extract, Transform and Load (ETL) developer with custom scripting skills


Required skills
  • Experience working with complex data warehouse projects
  • Experience designing custom ETL processes to populate the data warehouse
  • Ability to analyze source data for potential data quality issues and address these issues
  • Ability to effectively communicate information, both verbally and written to end users, team members and management
  • High-level knowledge of various industry leading data ware house components (databases, ETL tools, BI/reporting tools)
  • Experience in scripting (Shell scripting, python, Java) and automation
  • Experience with DevOps
  • Prepare technical documents and presentation
  • Familiarity with Atlassian product suites, git, bitbucket, confluence, jira


Desired skills
  • Ansible scripting
  • Experience with cloud environment, AWS
  • Database Administration (DBA) skills


Experience Level
  • Database (PostgreSQL v9.6+ or Greenplum v5+) - 4 years
  • Custom ETL Scripting - 5 years
  • SQL and pg/PLSQL - 4 years
  • Shell Scripting - 5 years
  • Python - 5 years
  • AWS (EC2 & S3) - 1 year


Educational requirements
  • Bachelor's degree


External Referral Bonus:
Eligible

Potential for Telework:
No

Clearance Level Required:
ADP2 / IT2

Travel:
No

Scheduled Weekly Hours:
40

Shift:
Day

Requisition Category:
Professional

Job Family:
Database Management

Pay Range:


Company Information

Leidos is a Fortune 500® information technology, engineering, and science solutions and services leader working to solve the world's toughest challenges in the defense, intelligence, homeland security, civil, and health markets. The company's 31,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $10.17 billion for the fiscal year ended December 29, 2017. (NYSE: LDOS) All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.
Dice Id : SCNCAPI2
Position Id : R-00049875
Originally Posted : 2 months ago

Similar Positions at Leidos

AWS Database Engineer
  • Fort Meade, MD
  • 3 days ago
Database Engineer (Senior)
  • Annapolis Junction, MD
  • 3 days ago
Cassandra Database Engineer
  • Annapolis Junction, MD
  • 3 days ago
MongoDB Database Engineer
  • Annapolis Junction, MD
  • 3 days ago
Sr MongoDB NoSQL Database Engineer
  • Baltimore, MD
  • 3 days ago
Sr. Database Engineer w/ Polygraph
  • Laurel, MD
  • 3 days ago
Sr. Database Engineer w/ Polygraph
  • Laurel, MD
  • 3 days ago
Database Engineer
  • Gaithersburg, MD
  • 3 days ago
SQL Server Database Engineer
  • Arlington, VA
  • 3 days ago
DB2/SQL Server Database Administrator
  • Annapolis Junction, MD
  • 3 days ago