ETL Developer

ETL Developer (Informatica, Snaplogic)
Remote

Responsibilities for ETL developer Informatica & SnapLogic and Oracle plsql program:

• 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 SanpLogic
- 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