Job Title: Senior AWS Glue ETL Developer
Schedule: Full-Time
Clearance: Public Trust
Location: 100% remote; candidate must live in the United States
Travel Required: No
Job Description:
Total Force Alliance (TFA) is seeking a highly skilled Senior AWS Glue ETL Developer with strong systems, software, and AWS cloud experience to support a major mainframe systems modernization initiative for the U.S. Office of Child Support Services (OCSS) program based in Washington, DC. 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, unit testing, support deployments and testing in higher environments.
Primary Responsibilities:
- Re-engineer mainframe batch jobs to equivalent ETL batch processes, preferably using Cloud-Native tools like AWS Glue.
- Leverage serverless cloud services to prepare (extract and transform) and load large numbers of datasets for data processing.
- Coordinate closely with mainframe resources to ensure requirements and specifications are clearly understood.
- Design Glue jobs to meet requirements, consider performance where applicable, code per standards, and perform end-to-end testing.
- Document the design specifications and contribute to implementation plan then work with the architecture team and lead developer to review the design and the code.
- Effectively coordinate the infrastructure/service needs working with the architecture and infrastructure teams.
- Implement overall solution comprising of Glue ETL PySpark jobs including SQL queries, Lambda, Step Functions, REST API calls.
- Develop and integrate custom developed software solutions to leverage automated deployment technologies.
- Use industry leading DevOps tools such as CodeCommit, CodeBuild, CodePipeline and AWS CloudFormation.
- Communicate key project data to team members and infrastructure 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.
Required Experience & Qualifications:
- Candidate must have bachelor’s with 8-12 years of prior relevant experience or master’s with 6-10 years of prior relevant experience
- Experience working in the software development lifecycle, with strong experience on ETL based development.
- Working experience with development using Amazon Web Services (AWS) and primarily on AWS Glue studio.
- Experience working with programming language PySpark/Python
- Experience working with relational database like PostgreSQL.
- Well versed with using version control systems (CodeCommit, CodeBuild, CodePipeline preferred)
- Well versed with using issue/problem tracking systems (Jira preferred)
- Experience working in a fast-paced development environment with drive to completion.
Preferred Qualifications:
- Public Trust security clearance
- Familiarity working with multiple file formats, and knowledge on DB2, JCL, COBOL COPYBOOK and EBCDIC character format is strongly desired.
- AWS, Agile, or other related Certification(s)
- Prior experience working mainframe modernization.
- Prior experience with Linux bash scripting
Additional Requirements:
- Candidates must have been a US resident for at least 3 consecutive years immediately prior to this engagement and must be able to obtain and retain a Public Trust level clearance.
- This position is fully remote; candidate must live in the United States.
About Total Force Alliance:
Total Force Alliance, LLC is an SBA-certified Service-Disabled Veteran (SDVOSB) and Economically Disadvantaged Woman-Owned Small Business (EDWOSB) founded in 2023 and headquartered in Miami, Florida. We provide top-notch talent recruitment and retention for niche skillsets and in-demand talent for Enterprise IT Services: Operations, Engineering, Cybersecurity, ServiceNow Development, and Cloud Services. Our corporate culture and industry partnerships enable us to offer unrivaled salary, benefits, training and professional development to select IT professionals that can innovate and deliver technical solutions targeted to Federal Civilian, Health, Defense, Intelligence and Cyber strategic priorities.
Benefits:
- Medical, Dental & Vision
- Mental Health Resources
- Paid Time Off & Holidays
- 401(k) with Company Matching
- Life, Accident & Injury Insurance
- Flexible Spending Account (FSA)
- Health Savings Account (HSA)
- Certification Preparation & Exam Reimbursement
- Virtual Personal & Professional Development Classes
Total Force Alliance, LLC is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other protected characteristics.