Logo
C4 Technical Services

ETL Developer (Snaplogic / Informatica)

C4 Technical Services, Eagan, Minnesota


ETL Developer Remote 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 • 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 DICE kgohmannc4techservices.com cclausenc4techservices.com