ETL Developer
Remote
Job Description
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
- 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
– 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
Working Experience
– Minimum 7-10 years of IT Experience working in ETL and data domain
– Minimum 7-10 years of IT Experience working in ETL and data domain