To our valued Leidos candidates:

Coronavirus is on everyone's mind with the effects being felt around the world. The markets are volatile, and we're all concerned for the health and safety of our families, friends, and colleagues. Please know that we're taking all necessary measures to safeguard our employees, customers and the communities in which we live, including following all recommended best practices around social distancing.

With that in mind, in an abundance of caution, we are canceling all face to face career events, such as job fairs and open house events. In the coming days and weeks, we will be hosting career events virtually, using our online chat tools so that we may continue our hiring practice safely and securely. You can find available virtual career events at career-events.leidos.com.

Whenever possible, we are using telephone meetings and online chats to conduct interviews and hiring discussions, and we are offering options for video interviews so that you can have a virtual face to face meeting with your potential new leader.

As a company, as a country, as a world, we have confronted challenging moments before. We are confident that, guided by our values and the strength of our community as well as the commitment we have to the important work we do each day, we will find our way through this time together. We will do this with the care and concern for one another and the common good that defines. Please keep those impacted by the virus in your thoughts.

Close Window
Join our talent network

Job #: R-00028562
Location: Baltimore, MD
Category: Database Management
Schedule (FT/PT): Full Time
Travel Required: No
Shift: Day
Potential for Telework: No
Clearance Required: Public Trust
Referral Eligibility: Eligible
Group: Health

Share: mail twitter linkedin

Description

Job Description:

Leidos is hiring an ETL (Extract, Transform, and Load) Developer to play a key role on our SSA ITSSC II program in Windsor Mill, MD. As our Database Developer your responsibilities of this position may include:

  • Database developer and Extract, Transform and Load (ETL) developer with custom scripting skills.
  • Design, development, testing, and maintenance of UNIX shell scripting and Python
  • 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  

Required Skills

  • Bachelor's degree plus 4 years experience; or Master's degree plus 2 years' experience
  • 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

External Referral Bonus:

Eligible

Potential for Telework:

No

Clearance Level Required:

Public Trust

Travel:

No

Scheduled Weekly Hours:

40

Shift:

Day

Requisition Category:

Professional

Job Family:

Database Management

Leidos

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 33,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $10.19 billion for the fiscal year ended December 28, 2018. For more information, visit www.Leidos.com.

Pay and Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here.

Securing Your Data

Leidos will never ask you to provide payment-related information at any part of the employment application process. And Leidos will communicate with you only through emails that are sent from a Leidos.com email address. If you receive an email purporting to be from Leidos that asks for payment-related information or any other personal information, please report the email to [email protected].

Commitment to Diversity

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.

   Save Job Saved

Talent Community

Join our Talent Community to create a profile, enabling a streamlined application process and to help our recruiters better understand your areas of expertise and interest.

Join our Talent Community