AWS Informatica Engineer
About The Position
The AWS Informatica Engineer will work in the assigned job role of Technology Consultant 2, contributing across the software development lifecycle, from requirements elicitation and design through coding, testing, implementation, and production support. The role includes documenting business requirements and design decisions, participating in software design discussions, integrating features into existing applications, reviewing and maintaining code, coordinating testing and bug fixes, and creating user training and support materials. The engineer will also help resolve production issues, recommend preventive measures, and maintain records of code, tests, and support activities. The role focuses on data engineering and ETL development, including building scalable data warehouse and reporting applications and maintaining large-scale data pipelines. It involves developing ETL solutions with Informatica PowerCenter and Informatica PowerExchange, working with Informatica IDMC, and designing distributed, event-driven architectures and cloud-based applications using AWS services. The position also supports automation and orchestration through services such as Lambda and Step Functions, and CI/CD pipelines. The role is part of Infosys Financial Services, which works with financial institutions on digital transformation and technology initiatives across banking, wealth management, and insurance. The position may require relocation and/or travel to the work or project location. The estimated annual compensation for this role in Reston, Virginia, is $81,447 to $105,881.
Requirements
- Experience in data engineering or ETL development, with deep expertise in Informatica PowerCenter.
- Experience with Informatica Intelligent Data Management Cloud (IDMC).
- Proven experience with AWS cloud services, including EMR, ECS, Glue, Redshift, SNS, SQS, Lambda, CloudWatch, and S3.
- Strong proficiency in Python for data processing and automation.
- Experience supporting data warehouse environments and large-scale data pipelines.
- Hands-on experience with Docker for containerized development and deployment.
- Excellent problem-solving skills and strong verbal and written communication.
- Ability to work independently and collaboratively in a fast-paced environment.
- Experience writing efficient, maintainable code and implementing ETL data pipelines.
- Experience with Informatica PowerCenter and Informatica PowerExchange.
- Bachelor’s degree or foreign equivalent from an accredited institution, or three years of progressive experience in the specialty in lieu of each year of education.
- All applicants must be authorized to work in the United States.
Nice To Haves
- Experience with PowerCenter-to-IDMC migration.
- Experience with Apache Spark.
- Experience with Instabase.
- Experience optimizing data-driven applications using Java or Python.
Responsibilities
- Contribute to requirements elicitation by documenting assigned portions of business requirements.
- Facilitate software application design discussions and document design decisions for the technical team.
- Participate in coding and integrate features or updates into existing applications while maintaining system stability.
- Conduct code reviews, make changes to the codebase, and maintain code repositories.
- Implement test strategies, analyze results, and coordinate bug fixes to uphold software quality standards.
- Develop user training programs, documentation, and support frameworks for new software applications.
- Participate in resolving production issues and recommend preventive strategies to improve system reliability.
- Maintain records of code, testing techniques, and support activities.
- Design, build, and maintain scalable data warehouse and reporting applications using data processing solutions.
- Design and implement distributed, event-driven architectures using AWS services, including ECS, EventBridge, RDS, Redshift, Redshift Spectrum, S3, and EC2.
- Write efficient, maintainable code and implement ETL data pipelines.
- Maintain end-to-end scalable web and cloud-based applications.
- Drive automation and orchestration using Lambda, Step Functions, and CI/CD pipelines.
Benefits
- Medical, dental, vision, and life insurance.
- Long-term and short-term disability insurance.
- Health and dependent care reimbursement accounts.
- Accident, critical illness, hospital indemnity, and legal insurance.
- 401(k) plan, with contributions dependent on salary level.
- Paid holidays and paid time off.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
