AWS Data Engineering & Production Support Technology Consultant – Redshift, Informatica, AutoSys & Python
Work Locations: Hartford, CT 06103 / Raleigh, NC 27617 / Richardson, TX 75082 / Tempe, AZ 85281
Contract Duration: 12 Months
Work Mode: Hybrid – 3 Days Onsite per Week (Mandatory)
Experience Required: 6–8 Years
Target Start Date: ASAP
Candidate Submission Criteria
- Preferred candidates with prior experience at Capital One, Freddie Mac, or Fannie Mae.
- Preferred project experience: 1–4 years; candidates with more than 6 months of relevant project experience can also be considered.
- Preferred work authorization: L2 , and s. H1B candidates may be considered for exceptional profiles.
- Face-to-face interview is mandatory at any one of the specified work locations.
- Candidates must be willing to work onsite 3 days per week.
- Preferred candidate locations: Reston, VA; Raleigh, NC; Hartford, CT; Plano, TX; Richardson, TX; and Tempe, AZ.
Job Description
We are looking for an experienced AWS Data Engineering & Production Support Technology Consultant with strong hands-on expertise in AWS Cloud, Amazon Redshift, Informatica, AutoSys, Python, SQL, and enterprise data warehousing. The ideal candidate should have experience supporting complex ETL and data integration environments, handling L3 production support, and developing cloud-based data solutions using AWS services and modern application technologies.
Key Responsibilities & Required Skills
- Strong hands-on experience with AWS Cloud services.
- Experience with Amazon Redshift and Redshift Spectrum.
- Hands-on experience with Informatica and AutoSys.
- Strong programming skills in Python.
- Proficiency in SQL and PL/SQL.
- Experience with Enterprise Data Warehousing (EDW) and Data Warehousing concepts.
- Strong knowledge of ETL processes and Data Integration.
- Experience providing L3 Application Support and Production Support.
- Hands-on experience with Amazon S3, Amazon RDS, AWS Lambda, Amazon ECS/ECR, Amazon EventBridge, and Amazon CloudWatch Logs.
- Experience with Java and Spring Boot.
- Knowledge of RESTful APIs and Microservices Architecture.
- Experience with GitLab for version control and d