Job Description
ASRC Federal is seeking an ETL (Extract Transform Load) Developer to work with our IT Team in support of our contract in support of the Drug Enforcement Agency's Diversion Control Division.Work Location: Hybrid - Arlington, VA (2 days per week onsite). Fully remote work may be considered.Responsibilities:
Shall formulate and define scope and objectives.Shall devise or modify procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.Shall prepare detailed specifications from which programs will be written and shall design, code, test, debug, and document those programs.Shall be competent to work at the highest technical level of all phases of applications systems analysis and programming activities
Requirements
A BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or equivalent, and at least four (4) years' experience in the field. Eight (8) years of related experience is equivalent to a BS/BA in Engineering, Physics, Computer Science, Information Technology, Mathematics or related discipline.Strong understanding of Data warehousing techniques and Star/Snowflake modelsMust have experience with AWS Glue, Data Catalog, Kafka, AWS Lambda, Python, Oracle SQL and Snowflake.Must have experience with Data Transformation and Data Integration.Must have high level of expertise in writing SQL queries on oracle and Snowflake.Experienced with orchestrating event trigger with AWS Lambda or Python to trigger workflows and process.Experienced with streaming of data with Kafka and reporting, analyzing and error correction with streams.Experience maintaining bookmarks to maintain the state of information/Data.Utilizing AWS Glue Data quality to evaluate, monitor and enforce data integrity across pipelines.Experience managing AWS Glue Data Catalog to store, discover and maintain metadata.Experience in building and maintaining data pipelines with AWS Glue.Experience with building and maintain AWS Data Lake in S3Experience with Tuning data processing units and configuring workers.
Candidate must be approved through the DEA's Background Investigation process for a Public Trust clearance.
Numbers & Facts
| Location | Reston, VA (Remote) |
| Industry | Aerospace and Defense |
| Company Size | 5,000 to 9,999 employees |
| Year Founded | 2003 |
| Website | http://www.asrcfederal.com |
Benefits
Military Leave, On Site Cafeteria, Parking, Prescription Drug Coverage, Professional Development, 401K, Employee Referral Program, Flexible Spending Accounts, Employee Events, Tuition Reimbursement, Work From Home, Life Insurance, Merchandise Discounts
About Company
ASRC Federal comprises a family of companies that provide mission-critical services to federal government agencies dedicated to defense, civil and intelligence support. Our customer-focused service delivery model and emphasis on operational excellence are foundational elements infused in all our companies. The reliability and quality of day-in, day-out service delivery from our family of companies ensure our customers that we keep our sights on their mission-critical priorities.
Skills
- AWS Lambdaunmatched
- Amazon Simple Storage Service (S3)unmatched
- Amazon Web Services (AWS)unmatched
- Background Investigationunmatched
- Computer Scienceunmatched
- Data Analysisunmatched
- Data Lakeunmatched
- Data Managementunmatched
- Data Processingunmatched
- Data Qualityunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- Debugging Skillsunmatched
- Information Technology & Information Systemsunmatched
- Mathematicsunmatched
- Metadataunmatched
- Oracleunmatched
- Oracle Databaseunmatched
- Physicsunmatched
- Problem Solving Skillsunmatched
- Procedure Developmentunmatched
- Python Programming/Scripting Languageunmatched
- SQL (Structured Query Language)unmatched
- Sales Pipelineunmatched
- Snowflake Schemaunmatched
- Star Schemaunmatched
- Systems Analysisunmatched
- Systems/Internals Programmingunmatched
- Testingunmatched
- United States Drug Enforcement Agency (DEA)unmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder