Description

You will design, develop, and maintain ETL interfaces and workflows using Informatica and SnapLogic.

Responsibilities

• Design and develop workflows, sessions, and mappings within Informatica and SnapLogic.
• Develop data replication and synchronization tasks using AWS Cloud Application Integration.
• Perform technical analysis to map functional requirements to technical specifications and project deliverables.
• Troubleshoot ETL jobs, perform unit testing, and provide post-deployment support and defect resolution.
• Tune Informatica mappings and data pipelines to optimize performance.

Required Skills

• 7-10 years of IT experience in ETL and data domains.
• Expertise in Informatica and SnapLogic toolsets.
• Advanced SQL and PL-SQL skills for Oracle database environments.
• Hands-on experience with AWS data services, including Redshift, Aurora, and S3.
• Strong knowledge of database design, stored procedures, views, and joins.
• Proven ability in performance tuning for data jobs and pipelines.
• Experience analyzing source and target systems to resolve data issues.
• Ability to document technical specifications and design comprehensive test cases.

Preferred Skills

• Experience with AWS Cloud Application Integration.

Key Skills

Education

Any Graduate