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.