Senior Oracle PL/SQL Developer – Data Analytics Domain

Cyient is a global engineering and technology solutions company. As a Design, Build, and Maintain partner for leading organizations worldwide, we take solution ownership across the value chain to help clients focus on their core, innovate, and stay ahead of the curve. We leverage digital technologies, advanced analytics capabilities, and our domain knowledge and technical expertise, to solve complex business problems.

With over 15,000 employees globally, we partner with clients to operate as part of their extended team in ways that best suit their organization’s culture and requirements. Our industry focus includes aerospace and defence, healthcare, telecommunications, rail transportation, semiconductor, geospatial, industrial, and energy.

Mandatory / Preferred Skills:

S No Technical Skills Mandatory or Preferred?

Min yrs of Exp

1 Oracle PL/SQL Mandatory 8

2 Data Warehousing Mandatory 4

3 Data Modelling Preferred 4

Technical Skills and Soft Skills Qualification

Data/ Dimensional modelling experience in data warehousing 2 Oracle SQL PL/SQL views, procedures, funtions 6

Experience extracting data (Oracle, SQL/ Excel) and creating data

model as per customer requirement 6

Be proficient in SQL and ETL processes, ETL and DB performance

tuning, table partitioning 5

Experience working in EDW projects, handling cross domain data

models 4

Programming

Languages

(Mandatory)

Backend application programs to be developed. Application

programs such as stored Procedures, Functions, Packages,

cursors, collections and triggers and materialized views using SQL

and PL/SQL. Know-how of Power BI reports and APEX.

6

Otherskills add to

advantage

Experience in understanding business requirement & work with

source system experts, platform owner etc to model the data to

get the desired end objective

5

(optional)

Soft skills

Review and approval of all product/solution architecture 5

proposals by Product Development Managers

Ability to work with central team for architectural approvals and

explaining business requirements 5

Ability to clearly communicate requirements to Oracle developer 5

during implementation

Communication & presentation skills

Strong coordination& inter-personalskills

Tasks and Deliverables

• Interact with customer to understand business requirement


• Create/ track open point list and co-ordinate with customer to clarify



Looking to get Placed? Try our Placement Guarantee Plan

Get Hired

AA

• Convert businessrequirement to concept/ technicalspecification


• Work along with source system experts in finalize the source to report mapping


• Work with requirementsspec in preparing the data/ dimensional models


• Coordinate with central team to replicate tablesfrom source system to data lake


• Support Oracle developer in design and development


• Creation of activity plan as per the agreed concept with timelines


• Design, Develop and Deploy solution


• Unit & Integration testing


• Hand holding key users in report utilization


• Support customers during the stabilization phase

Time & Material SOW/ Work Pack

Skills & Experience

Cyient is an Equal Opportunity Employer.

Cyient recruits, employs, trains, compensates, and promotes regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, veteran status, and other protected status as required by applicable law. We are proud to be a diverse and inclusive company where our people can focus their whole self on solving problems that matter.