Oracle PL-SQL Developer

Description :

- Enhance performance through SQL tuning, indexing, and efficient data modeling.

- Ensure code quality, maintainability, and adherence to best practices.

Informatica ETL Development :

- Work with ETL workflows to integrate data between systems.

- Support business intelligence (BI) and reporting requirements.

- Troubleshoot failed jobs and improve ETL efficiency.

Scripting :

- Develop and maintain Shell scripts (Unix/Linux) and Batch scripts (Windows).

- Automate recurring tasks, schedule jobs, manage file transfers, and support data processing workflows.

Cross-Functional Collaboration :

- Work closely with SCM, Manufacturing, and IT teams to gather requirements and deliver scalable data solutions.

- Participate in design discussions, requirement analyses, and solution planning.

Monitoring & Troubleshooting :

- Monitor end-to-end data workflows to ensure timely and accurate data movement.

- Investigate, troubleshoot, and resolve issues in ETL pipelines, scripts, and database processes.

- Provide production support as needed.

Required Skills :

- 5- 8 years of hands-on experience with Oracle PL/SQL (Expert).

- Intermediate-level scripting skills in Shell (Unix/Linux) and Batch (Windows).

- Solid understanding of data workflows, data integration, and system interoperability.

- Strong analytical, debugging, and problem-solving skills.

- Ability to collaborate with diverse teams (SCM, Manufacturing, IT).