Senior PLSQL Developer

Senior PLSQL Developer 

Uni Tencys Systems Private Limited | Addison, TX • Bangalore, IN 

Experience Required: 5+ Years 

Location: Hybrid (Hyderabad / Bangalore/ Chennai/ Mumbai/ Pune/ Delhi) 

Job Summary 

We are looking for a highly skilled PL/SQL Expert with at least 5 years of hands-on experience in developing and managing complex data interfaces and integration processes. The ideal candidate will have deep expertise in PL/SQL development, data migration strategies, and working with large enterprise systems (such as ERP, EHR, or SCM platforms). The role involves collaborating with cross-functional teams to ensure seamless data flow and business continuity across systems. 

Key Responsibilities 

• 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. 

Basic Requirements 

• 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. 

Preferred Qualifications 

• 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.