Proficient inSQL and PL/SQL development & BI reporting solutions
Design develop and maintain SQL queries stored procedures functions and triggers.
Responsible for handling production tier 3 support tickets and providing resolutions within defined service level agreements.
Develop and execute reports Bug fixes optimizations and enhancement.
Perform root cause analysis on production issues using data to diagnose bottlenecks and inefficiencies
Strong proficiency in Business Intelligence (BI) tools such as Power BI and other analytics platforms.
Document database structures processes and best practices.
Contribute 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.
Should know how to write advance SQL use Oracles SQL aggregate and analytic functions.
Must have skill sets in writing complex SQL and PLSQL programs and proficiency in tuning the code
Work with Business users to understand reporting requirements and provide optimal solution.
Good communication skills with the ability to convey technical concepts to both technical and non-technical customers.
Ability to work independently within a team environment.
Support strategic decision-making through comprehensive data analysis and recommendations
Microsoft certifications in data-related fields are preferred.
You show a tremendous amount of initiative in tough situations; are exceptional at spotting and seizing opportunities. You observe situational and group dynamics and select best-fit approach. You make implementation plans that allocate resources precisely. You pursue everything with energy drive and the need to finish.
The incumbent in this position would be responsible for PL/SQL support & development under Data Management & Insights projects. This would include handling Tier 3 support tickets and following change management process for development and this role one needs to interact with customers to understand requirements and provide optimal solution. Provide prompt support and development to assigned projects and other responsibilities.
Minimum of 7-10 years of experience working with SQL PL/SQL and any BI reporting tool
Strong proficiency in SQL and relational database systems (e.g. MS SQL Server MySQL)
Experience with database design normalization and optimization techniques.
Strong analytical abilities with a proven track record of resolving complex data challenges.
Understanding of Excel including formulas filters macros pivots and related operations.
Willingness to work flexible hours based on project requirements.
Advanced SQL skills including experience with complex queries data modeling and performance tuning.
Ability to deliver complex business solutions with minimal supervision.
Experience working with various data sources like Oracle SQL Server etc.
Working experience on SNOW and Agile Process is a plus.
Good written and verbal communication skills
Good problem solving and analytical skills.
Flexible to work in 24x7 environment.
Bachelors degree or equivalent in Science with a technical background (MIS Computer Science Engineering or any related field)
Good interpersonal skills using English both spoken and written as will be working with overseas team
At Emerson we prioritize a workplace where every employee is valued respected and empowered to grow. We foster an environment that encourages innovation collaboration and diverse perspectivesbecause we know that great ideas come from great teams. Our commitment to ongoing career development and growing an inclusive culture ensures you have the support to thrive. Whether through mentorship training or leadership opportunities we invest in your success so you can make a lasting impact. We believe diverse teams working together are key to driving growth and delivering business results.
We recognize the importance of employee wellbeing. We prioritize providing competitive benefits plans a variety of medical insurance plans Employee Assistance Program employee resource groups recognition and much more. Our culture offers flexible time off plans including paid parental leave (maternal and paternal) vacation and holiday leave.
Required Experience:
Senior IC
Emerson has refocused its business portfolio to deliver solutions that bring greater value to our customers. About Emerson We concentrate on the most complex, profound challenges facing the world in the process, industrial, commercial and residential markets. Our global talent, best-i ... View more