Power BI ( SSRS + SQL + Paginated)- WFO- Bangalore- 5+ yrs only DM - RNA
Bangalore, KA, India
WNS Global Services
WNS is a digital-led business transformation services company that combines deep industry knowledge in technology, analytics and business process expertise to deliver transformational solutions for clientsCompany Description
WNS (Holdings) Limited (NYSE: WNS), is a leading Business Process Management (BPM) company. We combine our deep industry knowledge with technology and analytics expertise to co-create innovative, digital-led transformational solutions with clients across 10 industries. We enable businesses in Travel, Insurance, Banking and Financial Services, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Healthcare, and Utilities to re-imagine their digital future and transform their outcomes with operational excellence.We deliver an entire spectrum of BPM services in finance and accounting, procurement, customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client. We co-create and execute the future vision of 400+ clients with the help of our 44,000+ employees.
Job Description
Design and create compelling data visualizations, dashboards, and reports that provide actionable insights to support decision-making.Hands on experience in writing complex SQL queries and creating the stored procedure to create SSRS paginated reporting.Good understanding of Reporting.Working closely with data engineers and data analysts.Continuously optimize existing reports, ensuring performance, accuracy, and responsiveness, and addressing any data quality issues.SkillMinimum Experience – 3 to 8 YearsT-SQL/PL-SQL, SSRS Paginated Report, Sap BI , Power BIGood CommunicationStrong Aptitude
Qualifications
Power BI
- Key Features of Power BI
- Data Integration Techniques
- Data Refresh in Power BI
- Data governance and security in Power BI
- Active and Inactive Relationship
- Filters in Power BI
- Function in Power BI
- DAX
- CALCULATE
- SUMX
- AVERAGEX
- Time Intelligence Functions (ex : YTD)
- Filter Functions
- Text Functions
- Logical Functions (ex: AND)
- Date and Time Functions(ex: Month)
- DAX
SSRS
- Key Components of SSRS Paginated Reports
- Creating Parameters in SSRS
- Best Practices for SSRS Paginated Reports
- Best Practices for Parameters
- Change the sequence of report parameters in SSRS
SQL
- DML & DDL
- Primary key, Unique key, foreign key
- Types of Joins
- Date & Aggregate function
- String functions
- Set Operators
- Windows function
- CTE
- Temp table in SQL
- Local
- Global
- Performance tunning
- Sample query based on above topics
- Query to identify and remove data redundancy in table
- Number of records based on joins
Additional Information
- 100% Work from Office
- No Mobile Phones/storage devices allowed within the floor
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Banking Data governance Data quality DDL Finance Power BI Security SQL
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.