ASRC Federal is seeking an experienced Data Engineer (ETL Developer) to join our team in anticipation of upcoming work in the National Capital Region.
The successful candidate will design, develop, and optimize ETL processes, specializing in the migration of data from legacy systems, ensuring efficient and accurate data transfer and seamless integration.
The program provides data management services including extraction, transformation, loading (ETL) and migration of legacy data;
data governance, and the consumption of data.
Key Responsibilities
- Design, develop, and implement Extract, Transform, Load (ETL) processes for migrating data from legacy systems into an AWS environment, with a focus on Oracle databases.
- Utilize data mapping, data mining, and data transformational analysis tools to ensure efficient and accurate data transfer.
- Design, build, and sustain database management systems for the purpose of ETL, emphasizing database modeling, design, and architecture.
- Implement metadata and repository creation and configuration for seamless ETL operations.
- Collaborate with cross-functional teams to ensure alignment with project objectives.
- Implement best practices for ETL processes within an AWS environment.
- Conduct thorough analysis and testing to ensure data integrity, accuracy, and consistency throughout the ETL process.
- Leverage experience in Oracle databases to ensure compatibility, performance, and security in ETL workflows.
- Create and maintain detailed documentation for ETL processes, database configurations, and system requirements.
ASRC Federal Advantages
Learning and Development : After 90 days of employment, regular full-time employees are eligible to participate in our professional development program including funds annually to go towards Associate’s, Bachelor’s or Graduate Degrees;
Industry standard professional certification; A professional certificate program; Continuing education classes; and Registration fees to attend professional conferences.
- Employee Resource Groups : That provide our employees the opportunity to collaborate and network with colleagues with common interests, backgrounds, and experiences including Women's Impact Network (WIN), Multicultural ERG, Military Community (MILCOM), and Pride ERG for LGBTQ+ employees and allies.
- Purpose Driven Careers : Certified Great Place to Work; Certified Military Times' 'Best for Vets' and Military.com Top 25 Veteran Employer.’
- Benefits : Comprehensive insurance packages including medical, dental, vision, life insurance, and short term / long term disability, as well as a 401K with generous company match and immediate vesting.
RequirementsQualifications
- Active Top Secret Clearance.
- Bachelor’s degree in related field and 7+ years of relevant experience.
- Hands-on experience with AWS services (such as AWS Glue) and Oracle databases in an ETL context.
- Experience with large data sources (5-9 TB).
- Strong knowledge of data modeling, design, and relational database architecture.
- Proficient in data mapping, data mining, and data transformation tools.
If you want to know about the requirements for this role, read on for all the relevant information.
J-18808-Ljbffr
Remote working / work at home options are available for this role.