9 days ago
Base Salary
$86k - $138k/yr
Responsibilities
- Design and implement ETL workflows using Informatica and AWS Glue.
- Develop data transformation logic for schema compliance, accuracy, and quality.
- Integrate data from on-premises, cloud, and legacy systems.
- Implement data validation and data quality checks.
- Optimize data pipeline performance and reliability.
- Maintain data lineage tracking and documentation.
- Provide database and data expertise and guidance to development and technical teams.
- Support database design, data modeling, performance tuning, optimization, implementation, and operational support.
- Support MongoDB, Aurora PostgreSQL, Amazon RDS, Oracle, and relational database environments.
- Support ETL platforms for large-scale databases exceeding 5TB.
- Troubleshoot complex database issues and identify performance and operational improvements.
- Support Databricks and enterprise-level data solutions.
- Collaborate with developers, architects, and technical teams on scalable data integration solutions.
Requirements
- Bachelor’s degree and five years of professional experience, or a high school diploma/equivalent and nine years of professional experience.
- Five years of demonstrated database ETL experience.
- Hands-on expertise with MongoDB, Aurora PostgreSQL, Amazon RDS, relational databases, and Oracle.
- Experience with ETL tools such as Informatica and AWS Glue.
- Experience supporting databases larger than 5TB and optimizing enterprise database environments for performance, scalability, reliability, and availability.
- Ability to provide technical expertise on database architecture, design, implementation, and operational support.
- U.S. citizenship and the ability to obtain and maintain the required Public Trust clearance.
- Preferred: active IRS MBI clearance.
- Preferred: Databricks experience and foundational/basic Databricks certification.
- Preferred: Informatica or AWS Glue certification.
- Preferred: experience supporting highly scalable, enterprise-level database environments.
Benefits
- Eligible employees may receive medical, dental, vision, life, health savings account, short- and long-term disability, EAP, parental leave, 401(k), paid time off, and company-paid holidays.
- The position is onsite in Lanham, Maryland, with an 8 a.m. to 5 p.m. Eastern time schedule.
Tech Stack
Categories
Data Engineering
About Peraton
Peraton builds and integrates mission systems, cyber, space, and intelligence solutions for U.S. defense, intelligence, and civil agencies. It delivers enterprise IT, satellite and terrestrial communications, and spectrum management under government contracts. Founded in 2017, the company is headquartered in Reston, Virginia and is privately held by Veritas Capital.