Job Description

Overview:
TekWissen Group is a workforce management provider throughout the India and many other countries inthe world. The below job opportunity is one of Our clients which is a leading Digital solution company for Business IT solutions.
Position: Oracle PL/SQL + ODI Developer
Location: Pune, Mohali
Job Type: Full Time
Work Type: Onsite
:
Responsible for Server administration and performing regular monitoring and maintenance activity.
Support and maintain production data and repository assets. Administer, support, and maintain the reporting toolset environment.
Define/Improve processes to improve system performance and efficiency.
Review and implement best practices within the team to maximize system potential.
Responsible for handling tier 3 support tickets and providing resolution within defined service level agreements.
Contributes throughout project life cycles, from planning to production implementation, including the creation of functional designs, technical designs and test plans for repository models and hierarchies.
Develop and execute reports, Bug fixes, optimizations and enhancement, document processes and generate required metadata.
Serves as technical expert for mission-critical BI applications including design, development, implementation, and support.
Should know how to write advance SQL, use Oracle\'s SQL aggregate and analytic functions.
Must have skill sets in writing complex SQL and PLSQL programs.
Must have Proficiency in tuning the SQL, PLSQL code for optimum performance.
Work with Business users to understand reporting requirement and provide optimal solution.
Work with functional mangers to provide optimal solutions to business problems.
Qualifications:
4-5 years of experience with SQL and PL/SQL
Ability to deliver complex business solution with minimal supervision
Experience working with various data source like Oracle, ODI, ETL,SQL Server etc.
Experience in ETL tool (Oracle Data Integrator 11g [ODI])
Proficient understanding of the job flow across all three phases, including source-dependent extraction, source-independent loading, and post-load processes
Extensive hands-on expertise in crafting PL/SQL packages, procedures, functions, triggers, materialized views, and adeptly handling exceptions
Good written and verbal communication skills
Good problem solving and analytical skills
Flexible to work in 24x7 environment
Working experience on SBM/SNOW and Agile Process is a plus
Knowledge of Data Analytics concepts is a plus
Knowledge of PowerBi is a plus
Knowledge of DevOps is a plus
TekWissen Group is an equal opportunity employer supporting workforce diversity