Title: Oracle SQL and Python Developer
Duration: 6+ Months
Location: PAN India
Onsite/Hybrid/Remote: Hybrid
Shift in IST – Please be specific : IST around 4 US hours
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.
Required Technical Skills
|
Skill Category |
Key Requirements |
|
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. |
Qualifications:
Experience Level
• 8–12+ years overall
• 8+ years of software development experience, focusing on relation databases and backend logic