Description

Design and maintain ETL interfaces and data integration workflows for AWS environments.

Responsibilities

• Design and develop workflows, sessions, and mappings using Informatica and SnapLogic.
• Build data replication and synchronization tasks within AWS Cloud Application Integration.
• Perform technical analysis of business processes to design effective data solutions.
• Develop, document, and unit test ETL interfaces and technical specifications.
• Troubleshoot ETL jobs, resolve defects, and provide post-deployment production support.

Required Skills

• 3+ years of experience in ETL development.
• Hands-on expertise with Informatica and SnapLogic toolsets.
• Strong SQL and PL/SQL skills for Oracle database environments.
• Experience with database design, stored procedures, views, and joins.
• Proficiency in performance tuning for data jobs, pipelines, and Informatica mappings.
• Experience with AWS data services including RedShift, Aurora, and S3.
• Working knowledge of .Net.
• Bachelor's degree.

Key Skills

Education

Bachelor's degree