Title: Oracle SQL and Python Developer
Duration: 6 Months Contract with a possibility for an extension
Work Location: PAN India, Hybrid and Remote
Work Timings: 12:00 – 9:00 pm IST (First 3 months while working from Office) & 2:00 – 11:00 pm IST (Overlap with US Team)
Job Description:
Oracle SQL and Python Developer typically focuses on bridging the gap between high-performance database management and flexible, automated data processing. This role is central to building scalable backend systems, ETL pipelines, and data-driven applications.
Core Responsibilities:
- Database Development: Design and develop Oracle-based applications using SQL and PL/SQL, including the creation of stored procedures, functions, packages, and triggers.
- Python Integration: Build and enhance Python-based data processing components for scalable workflows and develop scripts for automation of daily tasks.
- Performance Optimization: Conduct performance tuning for high-volume workloads and identify sub-optimal queries to improve system responsiveness.
- Data Pipeline Management: Design and maintain ETL pipelines and load processes to manage datasets exceeding 100 TB with complex workloads.
- API & Backend Services: Develop and maintain backend services and APIs using frameworks like FastAPI to serve up data to UI/UX developers.
Experience Level Required:
- 8–12+ years overall
- 8+ years of software development experience, focusing on relation databases and backend logic
Required Technical Skills:
- Oracle Database: Expert-level SQL and PL/SQL; proficiency with Oracle 11g/12c/19c features.
- Python: Strong proficiency in Python 3.x, including libraries for data manipulation (e.g., Pandas) and RESTful API development.
- Data Architecture: Experience in logical and physical data modelling and designing database schemas.
- Environment Tools: Working knowledge of Unix/Linux shell scripting, version control like Git, and job schedulers such as Autosys.
