We are hiring for SQL Developer for Pune location. Kindly go through the JD below and revert back with an updated resume @[HIDDEN TEXT] OR Call @9073074659 Role Description: This individual will be required to work as a SQL developer using SQL Server. The individual will be required to write extraction queries to support extraction & loading of data from / into SQL databases, should be well versed with ETL using Microsoft SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). The person would also be required to work extensively for generating reports as per the business requirements. Core activities are enumerated below -
Should have worked on SQL Server 2008 and 2012. Should be able to do work on Performance Optimization of Queries. Should have expertise in writing of SQL Queries, Stored Procedures and views. Able to perform DB Design. Implementing new data feeds into the data warehouse from flat files/other database platforms Develop data mart solutions from design to implementation Migrating and redeveloping legacy reporting in Excel/Access/SQL Server 2000 to the SQL Server 2005/2008 platform Configures and maintains business intelligence solutions to deliver data marts Develop new reporting solutions that enables the client team to effectively meet the requirements of the end business Partners with peers to design and develop an integrated approach to reporting through the use of an enterprise reporting system to enable end users to access data and reports in a timely and efficient manner via the appropriate interface Ensures effective change management controls are documented Ensures detailed documentation of report and KPI definitions is complete and signed off prior to delivery. Ensures that all data trails are suitably auditable and that all work is tested to ensure data integrity
Skill Sets: Expertise in Microsoft SQL Server 2005/2008 Experience with both OLAP & OLTP table design in SQL server, query design/optimization, stored procedures, views, and performance tuning Experience in monitoring and tuning database to provide high availability service Experience in programming languages like SQL, PL/SQL Practical experience in managing the internal and external MS SQL database security Expertise in writing VBA scripts, Excel reports automation and MS Access Expertise in SQL Loader Experience on writing UNIX and Windows Shell scripts Experience in BI/DW projects will be a huge advantage Experience in writing fuzzy logic scripts in Sql Experience in SQL Server Database Administration experience Experience in managing multiple MS SQL RDBMS on large systems
Desired Candidate Profile Please refer to the Job description above
Job Description :
To ensure customer service and support all operations. To create customer delight at every interaction.
Interacting with external customers and internal customers and addressing their queries, requests and complaints.
Committed TATs are met consistently
Complaints Management- addressing customer complaints at the branch, system updation, coordination with Sales/HUB/ other functions for resolution.
Refunds processing and dispatch
Undelivered policy documents tracking and management.
Maintenance of all files and registers.
New Business Processing:-
Handling end to end New business processing starting from creation of Client id,Case start up, New business login, Follow up for policy issuance, Quality Check
Follow up with HUB for policy issuance of pending cases