Log In
Sign Up
Software
Leidos Hiring for Database Extract, Transform and Load (ETL) Developer Job at Baltimore, MD Full Time
br{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]>
Description
Job Description:
The Database Extract, Transform and Load (ETL) Developer will be responsible for database developer and Extract, Transform and Load (ETL) development with custom scripting skills. Also design, development, testing, and maintenance of UNIX shell scripting and Python.
Day to Day Job Responsibilities
Support various data loading techniques to Greenplum MPP database, develop automated ETL processes, and troubleshoot any data load errors
Support 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
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
Provide support for AWS, EC2, S3
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 Skills
Experience working with 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
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 presentations
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 (Greenplum v5+) – 3 years
Custom ETL Scripting – 3 years
Shell Scripting – 3 years
Python – 3 years
AWS (EC2 & S3) – 1 year
EDUCATION & EXPERIENCE: BS degree and 2 – 4 years of prior relevant experience or Masters with less than 2 years of prior relevant experience.
External Referral Bonus:
Ineligible
External Referral Bonus $:
Potential for Telework:
No
Clearance Level Required:
Public Trust
Travel:
No
Scheduled Weekly Hours:
40
Shift:
Day
Requisition Category:
Professional
Job Family:
Database Management