Overview
Remote
On Site
Contract - W2
Skills
Evaluation
Business Process
Database Design
Stored Procedures
Technical Analysis
Interfaces
Functional Requirements
Collaboration
Specification Gathering
Test Cases
Snap Logic
Workflow
Production Support
Informatica
Amazon Web Services
Amazon Redshift
Amazon S3
SQL
PL/SQL
Oracle
Database
Performance Tuning
Extract
Transform
Load
Data Domain
DICE
Job Details
ETL Developer (Snaplogic and Informatica) X 3
Remote
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
Working Experience
- Minimum 7-10 years of IT Experience working in ETL and data domain
#DICE
Remote
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
Working Experience
- Minimum 7-10 years of IT Experience working in ETL and data domain
#DICE
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.