Informatica ConsultantThe Claims Technology team is seeking a highly experienced Informatica Consultant to work closely with business and technology partners to deliver solutions in the Claims Technology space. This role involves managing multiple project ETL implementations of the claims product.Required Skills & Qualifications5-7 years of proven, hands-on experience in API testing using SoapUI, SOATest, or equivalentExperience as a Lead technical data developer in a hands-on role and architect providing data design/architecture across multiple projects in a Data Warehousing environment (7 years) with very large amounts of dataAdvanced Oracle PL/SQL experience (12 years) with the ability to guide the team with performance tuning and optimizationsAbility to design the conceptual, logical, and physical data models necessary to support the analytic data requirements for various department reporting needsStrong experience building high-performance ETL Data Frameworks with error handling and scalabilityStrong analytics and communication skills, including the ability to drive diverse groups towards common goals and clearly articulate both problems and proposed solutionsAbility to balance the need to deliver multiple concurrent projects while maintaining architectural standardsExperience in Agile/Scrum delivery modelsUnix scripting experienceCreates documentation for all activities and works with the project solution team in the design of application and code developedImproving and streamlining processes regarding data flow and data quality to improve data accuracy, viability, and valueStrong Excel data analysis skills with pivots and graphsPrior work experience in the client's industryPreferred Skills & QualificationsExperience in data visualization tools like Tableau (preferred), Power BIExperience/Exposure in Python, Hadoop, and Gen AI/ClientFinancial Services/Banking industry experienceFraud Detection, Prevention, Servicing, and/or Claims experienceDay-to-Day ResponsibilitiesCollaborate with business and technology partners to deliver solutionsManage multiple project ETL implementations of the claims productResearch and resolve issues independently while working in a supportive and transparent team environmentEngage multiple business analysts and developers/dev leads and influence teams across Claims technology and the businessCompany Benefits & CultureSupportive and transparent team environmentOpportunities for professional growth and developmentFlexible work arrangements with an expectation of 3 days in the office