Source description
About the role
Position : ETL Developer Location : 100% Remote Duration : 9+Months Contract Must Have : • 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
Description: Responsibilities for ETL developer [Informatica & Snap Logic] • 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
More at Thoughtwave Software and Solutions