Client: Prime Therapeutics/MagellanRXJob Title: ETL Developer Location: 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
- 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 pipelinesWorking Experience- Minimum 7-10 years of IT Experience working in ETL and data doma Background Check :YesDrug Screen :YesNotes :Selling points for candidate :Project Verification Info :The information provided below is for Apex Systems AV use only and is not to be distributed publicly, or to any third party. Any distribution of the below information will result in corrective action from Apex Systems Vendor Management. MSA: Blanket Approval Received Client Letter: Will ProvideCandidate must be your W2 Employee :YesExclusive to Apex :NoFace to face interview required :NoCandidate must be local :NoCandidate must be authorized to work without sponsorship ::NoInterview times set : :NoType of project :Master Job Title :Branch Code :