The JD is as below
7+ years of on-hands expertise in the following skill sets…
• Oracle 10g or later
• Oracle PL/SQL packages
• Oracle SQL Loader
• Shell Scripting (ksh)
• Advanced SQL or PL/SQL scripting skills
• Advanced SQL Queries on hands experience
•Relational, Dimensional, OLTP and OLAP database experience
•Understanding of data modeling, dimensional modeling, relevant data concepts, and schemas
• Will be an individual contributor in the expertise outlined below.
• Generate SQL code that performs and scales based on volume
•Quickly and efficiently write (or generate) PL/SQL code that adheres to internal technical guidelines
•Contribute to the design and development of all internally developed SQL Job
•Assist internal resources during the QA cycle and client resources during the UAT cycle by executing jobs, monitoring for errors, and researching suspected data issues
•Provide accurate level of effort estimates based on functional requirements
•Provide impact analysis and solution design for all change requests after reviewing all related documentation
•Be a key player on new client implementations
•Support high-priority production issues or other issues that junior resources are unable to resolve
•Assist end users with understanding the data model and writing efficient queries
Ensure Performance of these SQL Queries are optimum and continuously fine-tune the SQL objects.
•Contribute to overall process improvement for the team
• Telecom knowledge and experience will be preferred.