ETL Developer

Role Description

· Responsibilities for ETL developer [ Informatica & Snaplogic]

· Promote and apply ETL development best practices.

· Participates on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business process, system process, and industry standards.

· Experience with database design, querying, stored procedures, views, joins, performance tuning

· Understand Client Business Objectives and performing technical analysis responding to the needs.

· Develop, document and test ETL interfaces.

· Design & Develop Workflows, Sessions, Mappings in Informatica & Snaplogic

· Develop Data Replication/ Synchronization Tasks in AWS Cloud (Cloud Application Integrations)

· Post deployment support and defect resolutions

· Evaluate all functional requirements and map documents and perform troubleshoot on all development processes.

· Collaborate with application groups to prepare effective solutions for all programs.

· Documents all technical specifications and associate project deliverables.

· Design all test cases to provide support to all systems and perform unit tests.

· Qualifications for informatica developer

· Experience working with Informatica and SnapLogic toolset.

· Understand the existing ETL jobs and mappings, sessions and workflows.

· Ability to provide sporadic production support if any issues reported.

· Troubleshoot ETL jobs and fix the issues based the priorities.

· Analyze and understand the data at source and target system to fix the issues within the specified timelines.

· Tune the Informatica mappings.

Technical Expertise:

· Informatica and SnapLogic

· Integration experience working with AWS data services such as RedShift, Aurora, S3 etc.

· SQL & PL-SQL expertise working with Oracle database

· Performance tuning of data jobs and pipelines