Informatica ExpertPortland, Oregon (5 days work from office in a week)Job SummaryMin. 6+ yrs of experience in Informatica Power center Support and development workSelf-driven to understand the existing data model and the data processing workflows in the existing DWH landscapeTroubleshoot, analyze, and resolve job failure incidents or data mismatch/missing reported by the users and fix the data issues at root-levelDesign, develop, and test new mappings and dataflows and enhance existing ones based on business requirementsExcellent analytical and problem-solving abilities to address complex technical challengesSolid understanding of data management concepts, data integration, and data quality best practicesExperienced in analysis of job failures, and data mismatch/inconsistency between source file, staging table and target tablesResolve and close incidents within the Service Level AgreementsPerformance maintenance of the existing ETL jobs that meets the customer expectationGood proactive communication skills (verbal & writing) to engage with different stakeholders (Client SMEs, business user, other support groups)Work pro-actively to prevent potential issues that’s probable in the Informatica mappings/tables/dataWeekend support for P1 tickets during off-business hrs/weekends