Experience: 3-5 Years
Type: Full Time
Location: BLR/CHN/NCR/HYD/Pune
Notice-period: Immediate/15 days
Budget: 12 - 15 LPA
Technology: IT
Job Description:
We are currently seeking a highly skilled and experienced SQL/PLSQL Developer with a strong background in Finance and Supply Chain Management (SCM) data tables and joins. The ideal candidate will have extensive experience in creating complex reports using Business Intelligence Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), Infolets, and Dashboards. Additionally, knowledge of Financial Reporting Cloud (FRC) and Smart View Reports is highly desirable.
Key Responsibilities:
- SQL/PLSQL Development:
- Leverage strong SQL and PLSQL skills to design, develop, and optimize database queries and procedures.
- Ensure data accuracy and integrity while meeting performance standards.
- Data Modeling:
- Work with Finance and SCM data tables, understanding relationships and designing efficient database structures.
- Optimize data models for better performance and scalability.
- Business Intelligence:
- Create complex BIP reports to meet business requirements, ensuring data accuracy and visualization.
- Develop OTBI reports, Infolets, and Dashboards to provide actionable insights to stakeholders.
- Financial Reporting:
- Utilize knowledge of FRC (Financial Reporting Cloud) to design and create financial reports.
- Develop Smart View Reports to enhance financial analysis and decision-making processes.
- Collaboration and Communication:
- Collaborate with cross-functional teams to gather reporting requirements.
- Communicate effectively with business stakeholders to understand their needs and deliver solutions.
Qualifications and Skills:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Proven experience as an SQL/PLSQL Developer with a focus on Finance and SCM.
- Strong expertise in creating complex reports using BIP, OTBI, Infolets, and Dashboards.
- Knowledge of FRC and experience with Smart View Reports.
- Proficiency in database design, data modeling, and optimization techniques.
- Excellent problem-solving and analytical skills.
