Database Developer

🚀 Job Opening: Senior ETL / Informatica Developer (Oracle PL/SQL) 📍 Location: Jersey City, NJ / Plano, TX/ Hybrid 💼 Job Type: Contact (Possibility for extension or Conversion) 🏦 Industry: Banking & Financial Services 👨 💻 Experience: 6+ Years About the Role We are seeking a highly skilled Senior ETL/Informatica Developer with strong Oracle PL/SQL expertise to join our Data Engineering team supporting enterprise-scale banking applications. The ideal candidate will be an ETL-first developer with hands-on experience in Informatica PowerCenter, Oracle Database, Advanced SQL, and PL/SQL development. You will be responsible for designing, developing, optimizing, and supporting high-volume data integration and ETL solutions that power critical business processes. This role requires expertise across the complete data lifecycle, including data extraction, transformation, loading (ETL), source-to-target mapping, data validation, performance tuning, database development, and production support. Key Responsibilities • Design, develop, test, and maintain complex ETL workflows using Informatica PowerCenter. • Develop and enhance Informatica Mappings, Mapplets, Workflows, Sessions, and Transformations. • Develop complex Oracle PL/SQL procedures, packages, functions, triggers, cursors, and SQL queries. • Perform data validation, reconciliation, and quality assurance checks across source and target systems. • Optimize ETL workflows and SQL queries for performance, scalability, and reliability. • Tune Oracle database objects include indexes, partitions, and large-volume tables. • Troubleshoot ETL failures, production issues, and data discrepancies. Required Skills & Experience ETL & Informatica • Strong hands-on experience with Informatica PowerCenter. • Extensive experience in ETL Development and Data Integration. • Expertise in developing: Database & PL/SQL Data Engineering Operating Systems & Scheduling