Core Requirements:
∙Highly proficient in writing and analyzing complex SQL queries from the OLTP systems.
∙proven hands-on in the Database management systems (DBMS).
∙Should be expert in one or more of the following: MS SQL/Oracle PLSQL/MYSQL/DB2 etc.
∙Must have strong knowledge in troubleshooting performance bottlenecks and optimize the SQL
Queries wherever applicable.
∙Designing, testing and documenting the development and modification of the reports.
∙Develop reporting standards and best practices to ensure data consistency and standardization
∙Work with the business to complete the UAT and get the sign-off.
∙Strong client management skills with willingness to work across different technologies.
Good to have:
o Working knowledge of Power BI and SSRS/Power BI paginated reports.
o Implement row-level security (RLS) to restrict data access based on approved role access in the PBI paginated reports.
o Optimize SSRS/Paginated report performance to render the reports efficiently.
o Implement data driven subscriptions to share the reports outside the organization
o Prior migration experience from other BI tools to Power BI
This position requires on immediate joining from 7-10 days.