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.

Skill Minimum

Experience – 3 to 8 Years

T-SQL/PL-SQL, SSRS Paginated Report, Sap BI , Power BI

Good Communication

Strong Aptitude

Qualifications

Power BI

Key Features of Power BIData Integration TechniquesData Refresh in Power BIData governance and security in Power BIActive and Inactive RelationshipFilters in Power BIFunction in Power BIDAXCALCULATESUMXAVERAGEXTime Intelligence Functions (ex : YTD)Filter FunctionsText FunctionsLogical Functions (ex: AND)Date and Time Functions(ex: Month)

SSRS

Key Components of SSRS Paginated ReportsCreating Parameters in SSRSBest Practices for SSRS Paginated ReportsBest Practices for ParametersChange the sequence of report parameters in SSRS

SQL

DML & DDLPrimary key, Unique key, foreign keyTypes of JoinsDate & Aggregate functionString functionsSet OperatorsWindows functionCTETemp table in SQLLocalGlobalPerformance tunningSample query based on above topicsQuery to identify and remove data redundancy in tableNumber of records based on joins

Additional Information100% Work from OfficeNo Mobile Phones/storage devices allowed within the floor