ETL Developer with Snaplogic

Role: ETL Developer with Snaplogic Experience

Location: Chicago, IL

Duration: 6 Months

Description:

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

Working Experience

• Minimum 7-10 years of IT Experience working in ETL and data domain

Thanks

Job Types: Full-time, Contract

Pay: $55.00 - $60.00 per hour

Schedule:

• 8 hour shift

Experience:

• Informatica and SnapLogic toolset: 8 years (Required)
• ETL and data domain: 3 years (Required)

Ability to Relocate:

• North Chicago, IL 60064: Relocate before starting work (Required)

Work Location: In person

Salary : $55 - $60