22 Sql Query Jobs

Expert at using D3.JS (java scripting based) visualizations and Tableau, to develop interactive dashboards. Comfortable with deploying and operationalizing dashboard to optimize for performance also at middle-ware layer

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting. Only Immediate Joiners.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting. Only Immediate Joiners.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting. Only Immediate Joiners.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting.

Experience in C++. Oracle Exadata and SQL Query. Unix/Linux Operating system. Task scheduler within Unix/Linux OS. Unix Shell and Perl scripting.

About The Role WNS is hiring CAT Modeling professionals for a global reinsurance client acrossbelow mentioned skill-mix. Kindly refer to the job description mentioned against the desired skill-mix. 1.Portfolio Modeling (3+ years experience in end-to-end portfolio rollups) 2. Regulatory Reporting (4+ years experience in EDM/RDM/SCHEMA) 3. Model Validation (4+ years experience in Model Validation with tools like RMS/AIR) 4. Technical Solution (3+ years experience in SQL Query writing for CAT Modeling function) JOB DESCRIPTIONS: 1. Portfolio Modeling Good understanding Cat Modeling process and workflows Run vendor catastrophe modeling platforms (primarily RMS, AIR, Elements) for insureds and perform portfolio risk analyses. Working knowledge of RMS model scope across worldwide peril-regions regarding sub-perils, amplification, etc. along with basic understanding of cat-modelling four-box principle concerning exposure, hazard, vulnerability modules and translation of insurance and (re)insurance financial terms through coding in RMS and SQL. Assist clients in the understanding of catastrophe risk of individual insured through analytics based on catastrophe model results. Provide analytical support to catastrophe modeling team operations by sharing knowledge and information Develop processes and scripts for process improvements Provide timely and frequent feedback to team members. Preparing MIS reports Training and mentoring of team members inducted in the pricing process. Assisting in monthly post bind and portfolio rollup activities. Ensure all SLAs are met Communication with onshore SPOCs at regular intervals. 2. Regulatory Reporting Role and Responsibilities Good understanding Cat Modeling process and workflows. Run vendor catastrophe modeling platforms (primarily RMS, AIR, Elements) including accumulation analysis for reporting needs, whenever required Thorough knowledge of RMS EDM-RDM schema Ability to understand the requirements of regulatory submissions and further deliver them accordingly Understanding of RDS scenarios of Lloyds including Non-Modelled scenarios as well Working knowledge regulatory reports like LCM, RDS Scenarios, Terror Accumulations & reporting. Working knowledge of any other regulatory reports. Working knowledge of RMS model scope across worldwide peril-regions regarding sub-perils, amplification, etc. along with basic understanding of cat-modelling four-box principle concerning exposure, hazard, vulnerability modules and translation of insurance and (re)insurance financial terms. Provide analytical support to catastrophe modeling team operations by sharing knowledge and information Develop processes and scripts for process improvements Assisting in portfolio rollup activities. Ensure all SLAs are met Communication with onshore SPOCs at regular intervals. 3. Model Validation: : Perform model validation and provide recommendations on model use and/or required adjustments. Work with internal teams and external data providers on analysis, utilising available data including scientific information, claims and insured exposure Contribute to and lead Group projects as required, liaising with other teams globally. Produce customised reports on exposure and modelled results. Evaluate re/insurance pricing for individual accounts and product classes. Analyse catastrophe reinsurance structures and strategies to support reinsurance placements. Assist with the analysis of real time events and identify learnings from post-event reviews. Strong analytical and numerical ability, in order to interrogate large datasets Experience of working with re/insurance catastrophe data and/or catastrophe modelling software Excellent written and verbal communication skills, and the ability to explain technical concepts clearly Intermediate/Advanced Excel skills Pro-active attitude to identifying inefficient processes and developing improvementsDesirable Requirements Knowledge of commercial insurance and/or the catastrophe modelling industry Sound working knowledge of RMS/AIR and any other vendor modelling platforms Coding experience in a relevant language (e.g. SQL, VBA, R, C#) Experience in using mapping software (e.g. GIS) 4. Technical Solution (SQL query): Catastrophe Modelling Analyst in the Accumulation Management department, working with the Technical Solutions team The Technical Solutions team is focused on developing customized in-house tools and databases for the Accumulation Management team, to streamline processes and organize data in an efficient manner Technical role with large potential for growth in responsibilities Develop an understanding of existing Catastrophe Modelling processes, licensed software, and the various in-house tools used to automate processes Maintain existing Accumulation Management tools. Debug errors in the code when users experience issues Assist users with technical questions. Explain how tools work and deliver training sessions when required Test new functionality prior to launch to ensure that tools are working as intended Support team to design and develop new tools to automate processes. Update user guides when needed Work with colleagues around the globe on ad-hoc projects Qualifications Bachelors Degree in Mathematics/ Applied Mathematics/ Statistics/ Operations Research/ Actuarial Science Job Location Cookies Settings

Hi all, We are hiring for the role Azure Data Factory Experience : 7 - 9 Years Location: Bangalore Notice Period: Immediate Joiners only Skills: Design, develop, and maintain data pipelines using Azure Data Factory 2. Create and manage data models in PostgreSQL, ensuring efficient data storage and retrieval. 3. Optimize query performance and database performance in PostgreSQL, including indexing, query tuning, and performance monitoring. 4. Strong knowledge on data modeling and mapping from various sources to data model. 5. Develop and maintain logging mechanisms in Azure Data Factory to monitor and troubleshoot data pipelines. 6. Strong knowledge on Key Vault, Azure Data lake, PostgreSQL 7. Manage file handling within Azure Data Factory, including reading, writing, and transforming data from various file formats. 8. Strong SQL query skills with the ability to handle multiple scenarios and optimize query performance. 9. Excellent problem-solving skills and ability to handle complex data scenarios. 10. Collaborate with Business stakeholder, data architects and PO's to understand and meet their data requirements. 11. Ensure data quality and integrity through validation and quality checks. 12. Having Power BI knowledge, creating and configuring semantic models & reports would be preferred. If you are interested drop your resume at lakshmi.k@acesoftlabs.com .

We have an urgent opening for IT Engineer SAGE Software position with our esteemed client manufacturing automobile parts MNC at Pune - Khed location. experience on SAGE Software (ERP) is MUST Experience - 5+ Years Education - BE Computer Science Interested candidates mail your updated resume at unihr02@gmail.com Job Description - 5+ years of experience in Sage X3 ERP (support or implementation Projects). A consulting background with a record of delivering complex software solutions within defined timeframes and budgets. Strong business expertise, a keen understanding of business needs, and ability to ensure technical solutions. Experience in translating business requirements into solution specifications in Sage X3. Ability to effectively document business and technical designs. Ability to effectively prioritize and execute tasks in a high-pressure environment. Support, manage and maintain the organizations ERP and provide correct solution to end-users. Work closely with business stakeholders to define best practice standard operating procedures for all functional aspects of the business that are supported by the ERP and other open-source technology tools. Work closely with end users of sage, understand their requirements and execute the solution through successful development, testing, and training. Gather requirements and train users to effectively use the application Prepare user guides and manuals and required application related documentations. Demonstrate a strong technical platitude and understand both business and technical language and ideas. Excellent written and verbal communication skills, as well as organizational skills. Ability to collaborate and communicate effectively across the organization A creative self-starter, team player with the ability to multi-task and focus. Good problem-solving skills to move toward a projects successful completion. Knowledge of Warehouse Management System would be added advantage. Functional knowledge of Sales, Purchase, Manufacturing, Finance & Inventory module. Should understand 4GL Language of Sage X3. Must have experience in Crystal Report development & SQL Query tool. Should have experience in Table, Screen, Window, Object, Function creation. Experience in creating Sage Users & Assigning Roles to them. knowledge of SOAP Webservices would be added advantage. Technical Synopsis: Data base creation in SQL Server 2012. Creation & Customization of Data Types, Tables, Screens, objects, windows, Functions, views. Patch creations, patch integrations. Local Menus, Miscellaneous tables, inquires and requestors creations. Report generations, setting up workflows, Importing and Exporting data. Batch-process execution Creation of Dashboard for full business object lifecycle. Knowledge of SQL Query. Create reports using Business Objects and configure into Sage ERP X3 Creation of Subprograms, Web-Services & testing into Classic Soap Web service. Crystal Report Knowledge: Designing and developing Crystal and Business Intelligence reports for Sales, Purchase and financial data. Modify existing reports and develop new reports by analyzing databases, data sources, and structures. Ability to re-design or customizing the existing Views and Stored Procedures to suit the reporting needs. Create Report templates, Summary Reports, Master/Detail Reports and Parameterized Reports. Create Joins, Contexts and Aliases for resolving Loops and Universe Tuning. Design reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections. Experience in report customization via the use of Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects, Custom Formulas and Custom Functions (SQL Queries). Functional Synopsis: Creation of Users. Product categories, products, product sites. Assigning products to product categories and in turn assign the products to product sites. Creation of Purchase request, purchase orders, shipment request, receipt and Purchase Invoice. Creation of Quote, Sales Order, Sales Delivery, Sales Invoice. Positive attitude is a must Knowledge of WMS (Added advantage).

SQL Query, SQL server, SQL . ETL

Experience as a QA Engineer, strong SQL query skills, test automation tools (e.g., Selenium, JUnit, TestNG) and frameworks, scripting or programming languages (e.g., Python, Java) for test automation, bug- tracking tools Required Candidate profile Notice Period: 0- 30 days.(e.g., Jira, Bugzilla),Performance testing tools. EducationBE, B.Tech, ME, M.Tech, MCA LocationBangalore, Pune, Mumbai, Hyderabad, Chennai, Gurgaon

Job Title : Pega System Optimization Engineer / Pega Performance Specialist Experience Level : [Mid-Senior Level] Job Summary : We are seeking a highly skilled Pega System Optimization Engineer to join our team. The ideal candidate will have a strong background in optimizing Pega applications, database performance tuning, and identifying system bottlenecks. You will be responsible for ensuring the scalability, reliability, and efficiency of our Pega-based systems, working closely with development, infrastructure, and database teams to deliver high-performance solutions. Key Responsibilities : Pega System Optimization : Analyze and optimize the performance of Pega applications, including PRPC (Pega Rules Process Commander) and Pega Infinity. Identify and resolve performance bottlenecks in Pega rules, workflows, and decision logic. Conduct code reviews and recommend best practices for Pega development to ensure optimal performance. Optimize Pega configurations, including caching, threading, and logging settings. Database Optimization : Analyze and optimize database performance for Pega applications, including SQL query tuning, indexing, and partitioning. Collaborate with database administrators (DBAs) to ensure optimal database design and performance. Monitor and resolve database-related bottlenecks, such as slow queries, locking, and deadlocks. Implement database best practices for Pega applications, including schema design and data access patterns. Bottleneck Identification and Resolution : Use performance monitoring tools (e.g., PAL, SMA, DB monitoring tools) to identify system and application bottlenecks. Analyze system logs, performance metrics, and user feedback to pinpoint performance issues. Provide actionable recommendations to resolve bottlenecks and improve system performance. Performance Testing and Tuning : Conduct performance testing (load testing, stress testing) to identify potential issues before they impact production. Work with QA and development teams to ensure performance testing is integrated into the development lifecycle. Tune application and database configurations based on test results. Collaboration and Documentation : Collaborate with cross-functional teams, including developers, and infrastructure teams, to implement performance improvements. Document optimization processes, best practices, and performance metrics for future reference. Provide training and guidance to development teams on performance optimization techniques. Qualifications : Technical Skills : Strong experience with Pega PRPC and Pega Infinity (minimum 3-5 years). Expertise in database optimization (e.g., Oracle, SQL Server, PostgreSQL) and SQL query tuning. Proficiency in performance monitoring tools (e.g., PAL, SMA, Dynatrace, AppDynamics). Knowledge of Java, JVM tuning, and web application performance optimization. Familiarity with cloud platforms (e.g., AWS, Azure) and containerization (e.g., Docker, Kubernetes) is a plus. Analytical Skills : Strong problem-solving skills with the ability to identify and resolve performance bottlenecks. Experience with performance testing tools (e.g., LoadRunner, JMeter). Ability to analyze system logs, performance metrics, and user feedback to diagnose issues. Soft Skills : Excellent communication and collaboration skills. Ability to work independently and as part of a team. Strong documentation and training skills. Certifications (Preferred) : Pega Certified Senior System Architect (CSSA) or Pega Certified Lead System Architect (CLSA). Database certifications (e.g., Oracle Certified Professional, Microsoft SQL Server Certification). Key Performance Indicators (KPIs) : Reduction in system response time and improved application performance. Resolution of critical bottlenecks impacting system scalability. Improved database query performance and reduced latency. Positive feedback from stakeholders on system reliability and efficiency.

Job Shift: 12 PM 9 PM Mode: Hybrid [Work from Office We are currently operating in Hybrid model (3 days WFO and 2 days WFH). We shall be shifting to WFO all days.] Job Description for SQL Developer: Experience in data warehousing / reporting projects Projects in Financial services and capital markets domain. Expertise in developing SQL Reports, Stored Proc, Optimization Experience in developing SSRS reports Experience in gathering business requirements and performing functional testing (BA skills) Excellent communication skills; including written and oral. The ability to communicate with users in comprehensible terms is crucial Good attitude and willingness to learn and be positive Preferred qualification: Bachelors Degree in Computer Science/Engineering or Masters in Computer Applications (MCA) 6-12 years as SQL Developer Ability to collaborate effectively and work as part of team. Ability to work with minimum guidance. Excellent written, oral, and interpersonal skills. Ability to multi-task and thrive in an ambiguous environment.Strong attention to detail. Understanding of Fund Accounting, Fund structure, Capital Flows, PnL Allocations across funds, Master Feeder Funds, Asset Classes (Bank Debts, Swaps, FI Investments) and Tax Lots Prior experience with Hedge fund or Accounting systems Knowledge of SQL Query / Scripts/ Functions Knowledge of Unix Scripts / Python / or any scripting language

Role & responsibilities Good knowledge of execution plan. Performing database housekeeping, such as performance tuning (query optimization), indexing, etc. Knowledge of fragmentation/de-fragmentation in index. Knowledge of writing complex SQL query. Knowledge of statistics. Knowledge of Replication / Mirroring. Good knowledge of table partition (partition scheme, partition function, file group, logical file, size, maxsize, file growth and compression strategy). Knowledge of compress database (mdf / ldf / ndf) file. Good knowledge of Logical and physical read. Good knowledge of CPU and memory utilization for query. Good knowledge of database migration. Knowledge of Log Shipping. Good knowledge of database recovery. Knowledge of database archiving. Designing database backup and storage strategy with ndf file from query Creating and maintaining database standards and policies. Supporting database design, creation, and testing activities. Managing the database availability and performance, including incident and problem management. Administering database objects to achieve optimum utilization. Defining and implementing event triggers that will alert on potential database performance or integrity issues. Installing upgrades and patches to various apps. Candidates are required to work from office only.

Collect and consolidate data from call center systems, including ACD, CRM, and workforce management platforms Design and produce daily, weekly, and monthly MIS reports on key performance metrics Create visual dashboards and presentations Required Candidate profile Preferred Qualifications Experience working in a call center or customer service environment Expertise in SQL Query Development Familiarity with business intelligence tools (Power BI, Tableau, etc.)

Work Mode: Hybrid (3 days) Work Timing: 2 PM to 11 PM Primary: Core Java, ODBC Connectivity, Database, SQL Query Secondary: AWS, Database Migration JD Automation Tester with Java and Selenium Experience on cloud testing on AWS is a must Knowledge on AWS S3, Cloud Watch , AWS tools Knowledge on banking domain (Payment Gateway preferred) Experience of Regression Testing Responsibility Automation QA Lead for Regression Testing

We have an urgent opening for IT Engineer SAGE Software position with our esteemed client manufacturing automobile parts MNC at Pune - Khed location. experience on SAGE Software (ERP) is MUST Experience - 5+ Years Education - BE Computer Science Interested candidates mail your updated resume at unihr02@gmail.com Job Description - 5+ years of experience in Sage X3 ERP (support or implementation Projects). A consulting background with a record of delivering complex software solutions within defined timeframes and budgets. Strong business expertise, a keen understanding of business needs, and ability to ensure technical solutions. Experience in translating business requirements into solution specifications in Sage X3. Ability to effectively document business and technical designs. Ability to effectively prioritize and execute tasks in a high-pressure environment. Support, manage and maintain the organizations ERP and provide correct solution to end-users. Work closely with business stakeholders to define best practice standard operating procedures for all functional aspects of the business that are supported by the ERP and other open-source technology tools. Work closely with end users of sage, understand their requirements and execute the solution through successful development, testing, and training. Gather requirements and train users to effectively use the application Prepare user guides and manuals and required application related documentations. Demonstrate a strong technical platitude and understand both business and technical language and ideas. Excellent written and verbal communication skills, as well as organizational skills. Ability to collaborate and communicate effectively across the organization A creative self-starter, team player with the ability to multi-task and focus. Good problem-solving skills to move toward a projects successful completion. Knowledge of Warehouse Management System would be added advantage. Functional knowledge of Sales, Purchase, Manufacturing, Finance & Inventory module. Should understand 4GL Language of Sage X3. Must have experience in Crystal Report development & SQL Query tool. Should have experience in Table, Screen, Window, Object, Function creation. Experience in creating Sage Users & Assigning Roles to them. knowledge of SOAP Webservices would be added advantage. Technical Synopsis: Data base creation in SQL Server 2012. Creation & Customization of Data Types, Tables, Screens, objects, windows, Functions, views. Patch creations, patch integrations. Local Menus, Miscellaneous tables, inquires and requestors creations. Report generations, setting up workflows, Importing and Exporting data. Batch-process execution Creation of Dashboard for full business object lifecycle. Knowledge of SQL Query. Create reports using Business Objects and configure into Sage ERP X3 Creation of Subprograms, Web-Services & testing into Classic Soap Web service. Crystal Report Knowledge: Designing and developing Crystal and Business Intelligence reports for Sales, Purchase and financial data. Modify existing reports and develop new reports by analyzing databases, data sources, and structures. Ability to re-design or customizing the existing Views and Stored Procedures to suit the reporting needs. Create Report templates, Summary Reports, Master/Detail Reports and Parameterized Reports. Create Joins, Contexts and Aliases for resolving Loops and Universe Tuning. Design reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections. Experience in report customization via the use of Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects, Custom Formulas and Custom Functions (SQL Queries). Functional Synopsis: Creation of Users. Product categories, products, product sites. Assigning products to product categories and in turn assign the products to product sites. Creation of Purchase request, purchase orders, shipment request, receipt and Purchase Invoice. Creation of Quote, Sales Order, Sales Delivery, Sales Invoice. Positive attitude is a must Knowledge of WMS (Added advantage).

WNS is hiring CAT Modeling professionals for a global reinsurance client across below mentioned skill-mix. Kindly refer to the job description mentioned against the desired skill-mix. 1. Portfolio Modeling 2. Data Cleansing 3. Model Validation 4. Technical Solution (SQL Query) JOB DESCRIPTIONS: 1. Portfolio Modeling Good understanding Cat Modeling process and workflows Run vendor catastrophe modeling platforms (primarily RMS, AIR, Elements) for insureds and perform portfolio risk analyses. Working knowledge of RMS model scope across worldwide peril-regions regarding sub-perils, amplification, etc. along with basic understanding of cat-modelling four-box principle concerning exposure, hazard, vulnerability modules and translation of insurance and (re)insurance financial terms through coding in RMS and SQL. Assist clients in the understanding of catastrophe risk of individual insured through analytics based on catastrophe model results. Provide analytical support to catastrophe modeling team operations by sharing knowledge and information Develop processes and scripts for process improvements Provide timely and frequent feedback to team members. Preparing MIS reports Training and mentoring of team members inducted in the pricing process. Assisting in monthly post bind and portfolio rollup activities. Ensure all SLAs are met Communication with onshore SPOCs at regular intervals. 2. Data Cleansing: Understanding and preparing exposure data for multiple lines of business. Working on complex and large datasets using MS-Excel. Data cleansing and analysis of COPE information (Construction, Occupancy, Protection and Exposure) and secondary modifiers. Validating exposure data against set guidelines. Prepare import files for RMS modelling platform. Geo-Coding the exposure data using Risk Link. Modelling accounts in RMS/AIR platforms, prepare results and provide modelling insights, Ensure timely completion of all deliverables.Preferred Skills/Knowledge Knowledge of Insurance and Cat Modelling Knowledge of RMS RiskLink Good working knowledge of MS-Office Word, Excel and Access Working knowledge of SQL and Python is preferred Excellent communication skills 3. Model Validation: : Perform model validation and provide recommendations on model use and/or required adjustments. Work with internal teams and external data providers on analysis, utilising available data including scientific information, claims and insured exposure Contribute to and lead Group projects as required, liaising with other teams globally. Produce customised reports on exposure and modelled results. Evaluate re/insurance pricing for individual accounts and product classes. Analyse catastrophe reinsurance structures and strategies to support reinsurance placements. Assist with the analysis of real time events and identify learnings from post-event reviews. Strong analytical and numerical ability, in order to interrogate large datasets Experience of working with re/insurance catastrophe data and/or catastrophe modelling software Excellent written and verbal communication skills, and the ability to explain technical concepts clearly Intermediate/Advanced Excel skills Pro-active attitude to identifying inefficient processes and developing improvements Desirable Requirements Knowledge of commercial insurance and/or the catastrophe modelling industry Sound working knowledge of RMS/AIR and any other vendor modelling platforms Coding experience in a relevant language (e.g. SQL, VBA, R, C#) Experience in using mapping software (e.g. GIS) 4. Technical Solution (SQL query): Catastrophe Modelling Analyst in the Accumulation Management department, working with the Technical Solutions team The Technical Solutions team is focused on developing customized in-house tools and databases for the Accumulation Management team, to streamline processes and organize data in an efficient manner Technical role with large potential for growth in responsibilities Develop an understanding of existing Catastrophe Modelling processes, licensed software, and the various in-house tools used to automate processes Maintain existing Accumulation Management tools. Debug errors in the code when users experience issues Assist users with technical questions. Explain how tools work and deliver training sessions when required Test new functionality prior to launch to ensure that tools are working as intended Support team to design and develop new tools to automate processes. Update user guides when needed Work with colleagues around the globe on ad-hoc projects Qualifications Bachelors Degree in Mathematics/ Applied Mathematics/ Statistics/ Operations Research/ Actuarial Science.

P1-C1-STSMust have work experience in Azure Synapse, Python,Pyspark and ADF Hands-on in Azure Devops (ADO) , familiar with concepts like cherry picking, checking/merging code etc.Hands-on in SQL, SSIS and SSRS.Strong in writing SQL query, stored procedure and functions with hands-on in Power BI Experience in creating SQL Server Database tables, Indexes, Views and ETL scripts for data replication from non-relational database to SQL Database. Should have rich experience with design, build and deployment of SSIS packages.Work Experience in performance optimization techniques using MSBI tool set SQL Server, SSIS and SSRS Troubleshooting and debugging skills in SQL Agent Job,SSIS packages and complex T-SQL queriesGood in communication

Job Profile: 1. Optimize SQL Code as necessary. 2. Monitor performance of database systems resources and query throughput. 3. Process work accurately and in a timely manner. 4. Liaise with developers to improve applications and establish best practices. 5. Troubleshoot database related issues in a timely fashion. 6. Provide guidance and support to Application Developers. 7. Assist with schema design, code review, SQL query tuning. 8. Training and Capacity building in and out peer. 9. Pay attention to detail at all times. Candidate Profile: 1. Candidate should have very good technical skill in My SQL Database Administration. 2. Candidate should be able to work in team & manage team members, if required. 3. Communication skill should be excellent. 4. Candidate should be smart & personality should be very good.

Muthoot Microfin Limited (MML), the microfinance arm of Muthoot Pappachan Group is one of the leading and fast-growing microfinance institutions (NBFC-MFI) in India. The company is focused on providing micro-loans to women entrepreneurs with a focus on rural regions of India. We are looking for qualified Data Scientists with strong work experience in BFSI (preferably unsecured lending business in Indian market) for our Portfolio Quality Management team (PQM). An Ideal candidate should be proficient in advanced analytics techniques like data mining, predictive modelling, prescriptive modelling and customer segmentation. Experience in RDBMS, Dashboards and ETL is highly desirable. Immediate responsibilities would include but not limited to: Monitoring, evaluating and improving existing ML score cards of the organisation. End to end Development of custom data models to impact portfolio quality. Recommend best practices to improve existing dashboards and MIS reports. Data mining and Insight generation by exploiting the existing BI tool and DBMS. Initiate analytical practices at various business stages to improve overall process and save time and cost. Develop cross-sell and upsell models for the organisation as per the business strategies. Collaborate with business leaders and product managers to transform the organisation to a data driven environment. Skillsets required: Should have experience in developing and deploying end to end analytical solutions and ML score cards. Intermediate proficiency in SQL and Excel. Should have in hand experience working with huge flat files. Experience in any of the BI tools(Power BI/ Qlik Sense/ Tableau). Good understanding of Data Warehousing concepts and tools. Basic understanding of ETL processes and data wrangling. Basic understanding of lending business. Excellent presentation and story telling skills. Experience Required: 8+ years of domain experience. Experience in NBFC/Banking/FinTech is highly desired.