Database Extract, Transform and Load (ETL) Developer
Database Extract, Transform and Load (ETL) Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 67600 - 122200
1 Vacancy
Job Description
The Digital Modernization Sector has an opening for a Database Extract Transform and Load (ETL) Developer to work in Woodlawn MD.
This position is required to be onsite in Woodlawn MD five days a week.
The Database Extract Transform and Load (ETL) Developer will be responsible for database developer and Extract Transform and Load (ETL) development with custom home-grown scripting skills. Design development testing and maintenance of UNIX shell scripting and Python are needed for success.
Day to Day Job Responsibilities:
Support various data loading techniques to Greenplum MPP database.
Design develop and test custom in-house written automated ETL processes and troubleshoot any data load errors.
Perform source system data analysis to understand data relationships.
Investigate and resolve data quality data loading failures and develop data cleansing routines.
Generate Data Definition Language (DDL) scripts from Erwin modeling tool.
Automate the custom data loading process and continue to improve based on requirements.
Be available for scheduled for after-hours on-call support and will be required to support production release during non-peak hours.
Provide documented designs and recommendations for improvement of processes and automation of manual tasks ETL methods and procedures and ETL best practices.
Accept other duties as directed by management.
Required Qualifications:
BS degree and 2 years of prior relevant experience OR Masters with less than 2 years of prior relevant experience. Additional years of experience may be substituted/accepted in lieu of degree.
Must be able to obtain a public trust clearance.
Ability to effectively communicate information both verbally and written to end users team members and management.
Experience working with data warehouse projects.
Experience designing custom in-house written ETL processes to populate the data warehouse.
Ability to analyze source data for potential data quality issues and address these issues.
Knowledge of various industry leading data warehouse components (databases ETL tools BI/reporting tools).
Experience in scripting (Shell scripting python Java) and automation.
Prepare technical documents and presentations.
Desired Qualifications:
Ansible scripting.
Familiarity with Atlassian product suite (Git BitBucket Confluence Jira).
Experience with DevOps.
Experience with cloud environment AWS EC2 and S3.
Database Administration (DBA) skills.
Provide query support and troubleshooting for ad hoc query requests.
Original Posting:
May 21 2025For U.S. Positions: While subject to change based on business needs Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
Pay Range:
Pay Range $67600.00 - $122200.00The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job education experience knowledge skills and abilities as well as internal equity alignment with market data applicable bargaining agreement (if any) or other law.
Employment Type
Full-Time
