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 clients

View all jobs at WNS Global Services

Apply now Apply later

Company 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

  1. Key Features of Power BI
  2. Data Integration Techniques
  3. Data Refresh in Power BI
  4. Data governance and security in Power BI
  5. Active and Inactive Relationship
  6. Filters in Power BI
  7. Function in Power BI
    1. DAX
      1. CALCULATE
      2. SUMX
      3. AVERAGEX
    2. Time Intelligence Functions (ex : YTD)
    3. Filter Functions
    4. Text Functions
    5. Logical Functions (ex: AND)
    6. Date and Time Functions(ex: Month)

SSRS

  1. Key Components of SSRS Paginated Reports
  2. Creating Parameters in SSRS
  3. Best Practices for SSRS Paginated Reports
  4. Best Practices for Parameters
  5. Change the sequence of report parameters in SSRS

SQL

  1. DML & DDL
  2. Primary key, Unique key, foreign key
  3. Types of Joins
  4. Date & Aggregate function
  5. String functions
  6. Set Operators
  7. Windows function
  8. CTE
  9. Temp table in SQL
    1. Local
    2. Global
  10. Performance tunning
  11. Sample query based on above topics
    1. Query to identify and remove data redundancy in table
    2. Number of records based on joins

Additional Information

  • 100% Work from Office
  • No Mobile Phones/storage devices allowed within the floor
Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0

Tags: Banking Data governance Data quality DDL Finance Power BI Security SQL

Region: Asia/Pacific
Country: India

More jobs like this