Senior PL/SQL Developer

Requirements

• Design, develop, and maintain PL/SQL packages, procedures, functions, and triggers for data integration and transformation.

• Build and manage batch jobs, data interfaces, and ETL workflows between source and target systems.

• Ensure data accuracy, consistency, and performance across heterogeneous systems.

• Analyze business requirements and translate them into technical specifications for data movement and interface solutions.

• Monitor interface jobs and troubleshoot integration failures or performance issues.

• Collaborate with stakeholders including business analysts, system architects, and QA teams to support project delivery.

• Create and maintain comprehensive technical documentation for data flows and integration points.

• Perform data validation, reconciliation, and quality checks post-integration.

• Minimum 5 years of experience in PL/SQL development with a focus on data integration/interface design.

• Strong command over Oracle databases and performance tuning techniques.

• Proven experience working with large volumes of data and complex business logic.

• Hands-on experience with developing interfaces between ERP systems (Oracle EBS, Fusion, SAP, etc.) and third-party applications.

• Proficiency in Unix/Linux shell scripting and job schedulers (like Control-M or Autosys).

• Solid understanding of relational databases, data modeling, and data integrity principles.

• Good communication and documentation skills.

• Ability to work independently and manage tasks in a fast-paced environment.

• Experience in Oracle Fusion or other cloud-based ERP integration scenarios.

• Exposure to APIs, Web Services (SOAP/REST), and middleware tools (like Oracle Integration Cloud, Oracle Fusion).

• Familiarity with Agile methodologies and tools like JIRA or Azure DevOps.

• Oracle Certified Professional (OCP) certification is a plus.