Job was saved successfully.
Job was removed from Saved Jobs.

Job Details


Sr. ETL Developer



Full Time

On Site


Windsor Mill, Maryland, United States


Job Description:

Leidos has ongoing needs for qualified Sr. ETL Developers with strong systems, software, and AWS cloud experience to support a major mainframe systems modernization initiative for federal customer. Based in DevOps framework, participate in and/or direct major deliverables of projects through all aspects of the software development lifecycle including scope and work estimation, architecture and design, coding, and unit testing.

Primary Responsibilities:

  • Re-engineer mainframe batch jobs to equivalent ETL batch processes, preferably using Cloud-Native tools like AWS Glue based on Apache Spark.

  • Leverage serverless cloud services to prepare (extract and transform) and load large numbers of datasets for data processing.

  • Extend standard ETL tool capabilities using combination of Java and Python routines, including microservices and web service invocations.

  • Implement overall solution comprising of ETL jobs (Core), Lambda, Spring Cloud Microservices, Kafka, Java, and Python.

  • Develop and integrate custom developed software solutions to leverage automated deployment technologies.

  • Develop, prototype, and deploy solutions in AWS Cloud.

  • Coordinate closely with mainframe resources to ensure requirements are clearly understood.

  • Analyze (though proof of concept, performance, and end-to-end testing) and effectively coordinate the infrastructure/service needs working with the architecture and Data Center teams.

  • Closely work with the architecture team to review the design and ETL code.

  • Use industry leading DevOps tools such as Jenkins, Ansible and AWS CloudFormation.

  • Communicate key project data to team members and build team cohesion and effectiveness.

  • Leverage Atlassian tool suite like JIRA and Confluence to track activities.

  • Identify and apply best practices and standard operating procedures.

  • Create innovative solutions to meet the technical needs of customers.

Basic Qualifications:

  • Experience working in the software development lifecycle, with strong experience on ETL based development.

  • Experience working with relational database like PostgreSQL.

  • Experience working with programming languages (Java and Python preferred) and Linux bash scripting

  • Experience working in a fast-paced development environment with drive to completion.

  • Experience with development using Amazon Web Services (AWS).

  • Well versed with using version control systems (Git and Subversion preferred)

  • Well versed with using issue/problem tracking systems (Jira preferred)

  • Candidate must have bachelor’s with 8-12 years of prior relevant experience or master’s with 6-10 years of prior relevant experience.

Preferred Qualifications:

  • Working experience on AWS Glue and Glue studio.

  • Familiarity working with multiple file formats, and knowledge on COBOL COPYBOOK and EBCDIC character format is strongly desired.

  • Prior experience working mainframe modernization.

Pay Range:

Pay Range $97,500.00 - $150,000.00 - $202,500.00

The Leidos pay range for this job level is a general guideline only and 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.