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 DeveloperLocation: Pune, MohaliJob Type: Full TimeWork 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/SQLAbility to deliver complex business solution with minimal supervisionExperience 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 processesExtensive hands-on expertise in crafting PL/SQL packages, procedures, functions, triggers, materialized views, and adeptly handling exceptionsGood written and verbal communication skillsGood problem solving and analytical skillsFlexible to work in 24x7 environmentWorking experience on SBM/SNOW and Agile Process is a plusKnowledge of Data Analytics concepts is a plusKnowledge of PowerBi is a plusKnowledge of DevOps is a plusTekWissen Group is an equal opportunity employer supporting workforce diversity

TekWissen