Product Engineer, Java Spring Boot
Allstate
CloudDistributed SystemsGradleJavaJenkinsKafkaMavenMicroservicesMongoDBPythonSpringSpring Boot+1 more
Java Data Developer, AWS, ETL, Database Expert
CACI International Inc
full-time
Posted on:
Location Type: Remote
Location: Remote • Virginia • 🇺🇸 United States
Visit company websiteSalary
💰 $98,500 - $206,800 per year
Job Level
SeniorLead
Tech Stack
Amazon RedshiftAWSCloudETLJavaOraclePostgresPythonSQL
About the role
- 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.
- Work with cross-functional teams in an Agile environment to identify and prioritize project requirements and develop solutions to meet those requirements.
- Ensure adherence to coding standards and contribute to the improvement of the overall code quality.
- Stay up to date with new technologies, trends, and best practices in AWS, ETL, and database development.
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
- 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
Benefits
- health insurance
- wellness
- financial
- retirement
- family support
- continuing education
- time off benefits
- flexible time off benefit
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
AWSETLJavaSQLPythondata modelingdata warehousingdata governanceAmazon RedshiftAurora PostgreSQL
Soft skills
problem-solvingcommunicationcollaborationAgiletroubleshooting
