19 Nov
|
Proffer IT Consultancy
|
Mumbai
19 Nov
Proffer IT Consultancy
Mumbai
Job highlights
- Qualifications: As per requirement . Disclaimer: This job posting has been aggregated from external source
- Experience:8+years . About BinQle
Position Name:ETL With OAS Location: Bangalore / Chennai / Mumbai / Pune
Experience:8+years
About BinQle
BinQle is a global delivery and execution partner supporting enterprises across the US, India, Singapore and Australia. We specialize in structured hiring, managed teams, and long-term delivery support.
Role Summary
Lead the end-to-end migration of legacy Microsoft Access and Oracle reporting solutions to Oracle Analytics Server (OAS), BI Publisher, and Python-based automation. Assess current state, design target architecture, and deliver modernised reporting platforms.
What Youll Do
- Assess and inventory existing Microsoft Access databases, objects, and reporting processes
- Document current report execution, data refresh, and distribution steps
- Map Oracle database objects and migrate reports to OAS, BI Publisher, or Python automation
- Develop and tune Oracle SQL, PL/SQL, and performance for reporting workloads
- Convert Access SQL/VBA logic into Oracle SQL, PL/SQL, or Python
- Build OAS analyses, dashboards, and BI Publisher reports with security and scheduling
- Design and implement Python reporting jobs using relevant libraries
- Automate report execution with enterprise schedulers
- Create and execute test plans comparing legacy and recent outputs
- Prepare implementation, rollback, and support documentation
- Provide knowledge transfer and post-implementation support
What We re Looking For (Must-Haves):
- Experience with Microsoft Access databases, linked Oracle tables, pass-through queries, macros, VBA, forms, and reports
- Proficiency in Oracle SQL, PL/SQL, views, materialised views, performance tuning, and execution plans
- OAS (Oracle Analytics Server) dashboards, analyses, repository/subject area concepts, prompts, filters, and security
- BI Publisher data models, templates, bursting, scheduling, and output formats
- Python 3.x for data/reporting automation, using pandas, oracledb/cx_Oracle, SQLAlchemy, openpyxl, XlsxWriter, and logging frameworks
- Experience with Git, Azure DevOps/GitHub, CI/CD, and deployment documentation
Good to Have (Optional - only if mentioned):
- Experience working in financial services or another controlled enterprise environment
- Ability to work independently with business, DBA, infrastructure, security, and reporting teams
Qualifications:
As per requirement
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 ETL With OAS Professional (Mumbai)
🏢 Proffer IT Consultancy
📍 Mumbai