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
Bachelor's degree