Junior Programmer Analyst

Oracle’s interview process typically consists of three rounds: an online technical screening (aptitude and basic SQL), a deep‑dive technical interview focusing on SSRS, SSIS, Power BI, and data‑analysis scenarios, followed by an HR round that evaluates communication, cultural fit, and behavioral competencies. The technical round is moderately challenging, with emphasis on practical problem‑solving and tool‑specific knowledge. Preparation should include hands‑on practice with reporting tools and clear articulation of past projects.

Oracle promotes an innovative, collaborative environment where employees are encouraged to experiment and share ideas. The company offers flexible work‑from‑home options, robust learning platforms, and clear career progression paths, ensuring a healthy work‑life balance and continuous professional growth.

Bachelor’s or Master’s degree in Engineering, Computer Science, Information Technology or a related discipline; minimum 60% aggregate (or CGPA 6.5/10); graduating batch 2024‑2026; no active backlogs at the time of joining; strong foundation in programming concepts, data structures, and problem‑solving; basic knowledge of Microsoft technologies and exposure to Azure cloud services is a plus.

Round 1: Online Technical Screening (aptitude & basic SQL) → Round 2: Technical Interview (SSRS, SSIS, Power BI, DAX, problem solving) → Round 3: HR Interview (communication, behavioral fit)

Oracle is a global leader in enterprise software, cloud infrastructure, and data management solutions, serving customers across more than 175 countries. With a legacy of innovation spanning over four decades, Oracle has built a reputation for delivering robust, scalable, and secure technology platforms that empower businesses to transform digitally. The company’s culture emphasizes continuous learning, collaboration, and a strong focus on customer success, making it an attractive destination for fresh talent looking to grow in a cutting‑edge environment. As a Junior Programmer Analyst in the Product Development‑Product Development team, you will be at the heart of Oracle’s reporting and analytics engine. Your role will involve designing, developing, and maintaining SSRS reports, creating interactive Power BI dashboards, and building end‑to‑end ETL pipelines using SSIS. You will work closely with business users, QA teams, and leadership to translate business requirements into technical solutions, ensuring data accuracy, performance, and usability across the organization. **Key Responsibilities** 1. Develop and maintain SSRS reports (tabular, matrix, drill‑through, parameterized). 2. Design interactive Power BI dashboards with KPI cards, trend analysis, and RAG indicators. 3. Optimize report performance and usability for large data sets. 4. Build and maintain SSIS packages for data extraction, transformation, and loading from SQL Server, APIs, and flat files. 5. Schedule, monitor, and troubleshoot SSIS jobs for regular data refreshes. 6. Design data models for Power BI, create DAX measures, calculated columns, and define relationships. 7. Perform data validation, ensure metric accuracy, and generate insights for stakeholders. 8. Gather reporting requirements, convert them into technical specifications, and document solutions. 9. Deploy reports across DEV, QA, and PROD environments and maintain version control. 10. Provide post‑deployment support, troubleshoot issues, and continuously improve reporting solutions. **Tech Stack**: SQL Server, SSRS, SSIS, Power BI (Desktop & Service), T‑SQL, DAX, Power Query, Excel (Advanced), optional Azure Data Factory/Databricks, Microsoft Office suite. **Growth Path**: Starting as a Junior Analyst, you can progress to Senior Analyst, Reporting Lead, Data Engineer, or Business Intelligence Architect within 2‑4 years, depending on performance and skill acquisition. Oracle offers structured learning programs, certifications, mentorship, and exposure to global projects, enabling rapid career advancement. **Why Join Oracle?** - Work on industry‑leading BI tools and large‑scale data platforms used by Fortune‑500 companies. - Access to world‑class training, certifications, and a vibrant internal community of data professionals. - Competitive compensation, performance‑linked bonuses, and comprehensive benefits. - Flexible work arrangements, wellness initiatives, and a culture that values work‑life balance. - Opportunity to contribute to high‑impact projects that drive business decisions across multiple domains, including healthcare, finance, and cloud services.