SQL Developer

DescriptionResponsibilitiesPromote and apply ETL development best practicesParticipate on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business processes, system processes, and industry standardsExperience with database design, querying, stored procedures, views, joins, and performance tuningUnderstand Client Business Objectives and perform technical analysis responding to the needsDevelop, document, and test ETL interfacesDesign & Develop Workflows, Sessions, and 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 troubleshooting on all development processesCollaborate with application groups to prepare effective solutions for all programsDocument 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 are reportedTroubleshoot ETL jobs and fix the issues based on the prioritiesAnalyze and understand the data at source and target systems to fix the issues within the specified timelinesTune the Informatica mappingsTechnical Experience:Informatica and SnapLogicIntegration experience working with AWS data services such as RedShift, Aurora, S3, etc.SQL & PL-SQL expertise working with Oracle databasePerformance tuning of data jobs and pipelinesMinimum 7-10 years of IT Experience working in ETL and data domain

#J-18808-Ljbffr