ETL With OAS Professional (Mumbai)

ETL With OAS Professional (Mumbai)

19 Nov
|
Proffer IT Consultancy
|
Mumbai

19 Nov

Proffer IT Consultancy

Mumbai

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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: etl with oas professional (mumbai) / mumbai

Subscribe to this job alert:

Get the latest job offers by email for: etl with oas professional (mumbai) / mumbai