Responsibilities for ETL developer [ Informatica & SnapLogic]Promote and apply ETL development best practicesParticipates on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business process, system process, and industry standardsExperience with database design, querying, stored procedures, views, joins, performance tuningUnderstand Client Business Objectives and performing technical analysis responding to the needsDevelop, document and test ETL interfacesDesign & Develop Workflows, Sessions, Mappings in Informatica & SnaplogicDevelop Data Replication/ Synchronization Tasks in AWS Cloud (Cloud Application Integrations)Post deployment support and defect resolutionsEvaluate all functional requirements and map documents and perform troubleshoot on all development processesCollaborate with application groups to prepare effective solutions for all programsDocuments all technical specifications and associate project deliverablesDesign all test cases to provide support to all systems and perform unit testsQualifications for informatica developerExperience working with Informatica and SnapLogic toolsetUnderstand the existing ETL jobs and mappings, sessions and workflowsAbility to provide sporadic production support if any issues reportedTroubleshoot ETL jobs and fix the issues based the prioritiesAnalyze and understand the data at source and target system to fix the issues within the specified timelinesTune 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