Informatica / PL/SQL Developer

Overview In this role you will design and implement data solutions for CRM analytics within an Oracle-based repository on Unix. You will join the ECRM team to support CRM analytics and campaign operations, delivering robust ETL pipelines and 24/7 production support. You will shape data flows and performance tuning to handle large data volumes, contributing to a fast-paced, collaborative environment. This opportunity lets you impact data-driven marketing analytics at scale. ResponsibilitiesAnalyze, design, develop and provide 24/7 support for production data processes and applicationsSupport CRM analytics and Campaign operations; maintain analytical repository in Oracle on Unix (AIX)Design solutions and conduct data analysis to drive informed decisionsDevelop and tune ETL mappings and transformations, document root causes and provide specsCollaborate under the ECRM team lead to ensure high-quality deliverables Key requirements7+ years in data transformation and ETL developmentStrong Informatica design and development abilitiesETL performance tuning and complex transformationsRoot cause analysis documentation for ETL issuesExperience with ETL mappings, specifications, and loading large dataOracle PL/SQL: stored procedures, triggers, packages; SQL analyticsVLDB considerations, partitioning and parallel executionUnix (AIX) shell scripting experienceLarge-scale database design and data warehousing experience (plus)Motivated self-starterAbility to work in fast-paced environmentTeam-oriented with code/design review collaborationInformaticaOracle DatabasePL/SQL