Job Title: Senior Software Engineer - SQL/PL-SQL & Oracle APEX Developer (Data Analysis)
Profile:
We are seeking a highly skilled Senior Software Engineer with 10+ years of hands-on experience in data analysis, Oracle SQL/PL-SQL development, and enterprise application delivery. The ideal candidate brings robust expertise in designing and optimizing ETL pipelines, developing scalable PL/SQL solutions, and building secure, user-friendly applications using Oracle APEX. You will work closely with cross-functional teams to deliver business-critical data solutions, streamline processes, and help drive the organization's digital transformation.
Key Responsibilities:
- Design, develop, and optimize complex SQL/PL-SQL code, including packages, procedures, triggers, functions, and performance-tuned queries for large-scale systems.
- Architect, build, and deploy secure, user-centric applications using Oracle APEX, incorporating advanced UI features and RESTful integrations.
- Lead efforts on data extraction, transformation, and loading (ETL), ensuring data integrity, quality, and alignment with business requirements.
- Analyze business and functional requirements, translate them into comprehensive ER models and effective database solutions.
- Implement automation for recurring manual tasks using shell scripting, PL/SQL, and Python-based ETL tools.
- Collaborate with stakeholders, DB architects, and cross-functional teams to deliver high-quality, scalable, and secure applications.
- Generate analytical reports and dashboards for end users using SQL, Oracle APEX, and Oracle Analytics tools.
- Oversee release support, data migration, and reconciliation efforts ensure robust test coverage and timely defect resolution.
- Mentor junior team members, advocate best practices, and contribute to team knowledge-sharing.
Technical Skills Required:
- Oracle SQL, PL/SQL, Oracle APEX (application development & RESTful integrations)
- Performance tuning, query optimization, and data modeling
- Shell scripting (Korn/Bash), C, Pro.C, Autosys, GitLab (CI/CD)
- Python (Numpy/Pandas), ETL tools, Informatica Power Centre
- Google Cloud Query (BQL), Cypher Query
- Data warehousing and analytics (Oracle Analytics Cloud, Materialized Views)
Education & Certifications:
- Bachelor's degree in Computer Science or related discipline.
- Professional certifications such as ISTQB Agile, Oracle, or Azure AZ900 are preferred.
Interpersonal Skills:
- Strong leadership, stakeholder engagement, and project management
- Excellent communication, problem-solving, and mentoring abilities
Responsibilities:
- Design, develop, and maintain complex SQL/PL-SQL code, including procedures, functions, and packages for enterprise-scale applications.
- Build secure, user-friendly enterprise applications using Oracle APEX, incorporating advanced UI features and RESTful integrations.
- Analyze business requirements and translate them into effective database solutions and data models.
- Develop and optimize ETL data pipelines to ensure accuracy and integrity of business data.
- Automate manual data processing tasks using PL/SQL, shell scripting, and Python-based ETL tools.
- Create and maintain reports, dashboards, and data reconciliation solutions in Oracle APEX and Oracle Analytics Cloud.
- Collaborate with cross-functional teams (business analysts, DB architects, QA) to ensure timely and high-quality software delivery.
- Support data migration, system integration, and release management activities.
- Mentor junior team members and promote best practices in software and database development.
- Troubleshoot, debug, and resolve database and application issues to ensure optimal performance and reliability.
Career Level - IC2
