CACI is seeking an experienced Java Developer with a strong background in AWS, ETL, and database development to design, develop, and maintain scalable and efficient data pipelines, and optimize cloud database and analytics services.
Requirements
- 7+ years of experience in Java development, with a focus on AWS, ETL, and database development
- Strong experience with AWS services, including Glue, Lambda, S3, and API Gateway
- AWS Glue experience should include creating and managing ETL jobs, data catalogs, and workflows
- Proficiency in writing SQL statements for Oracle, Amazon Redshift, and Aurora PostgreSQL
- Experience with ETL tools, such as AWS Glue
- Strong understanding of data modeling, data warehousing, and data governance principles
- Experience with cloud-based data warehousing solutions, such as Amazon Redshift
Responsibilities
- Utilize thorough understanding of AWS cloud environment and AWS services to design, develop, and deploy ETL pipelines using AWS Glue, ensuring data quality, integrity, and security.
- Support and guide transition from Oracle to Aurora PostgreSQL, as appropriate.
- Develop and maintain Java-based applications that interact with AWS services, including S3, Lambda, and API Gateway.
- Write efficient and optimized SQL statements for Amazon Redshift.
- Optimize cloud database queries and ensure data consistency and accuracy.
- Collaborate with data engineers and data scientists to design and implement data pipelines for use in data warehouses and data lakes.
- Develop and maintain Python scripts for data processing, data transformation, and data reporting and analysis.
Other
- Strong understanding of software development life cycles, especially the Agile Scrum methodology
- Excellent problem-solving skills, with the ability to troubleshoot complex technical issues
- Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams
- Bachelor’s degree in computer science, Information Technology, or a related field
- Experience with DevOps practices, including continuous integration and continuous deployment (CI/CD)
