5+ years of experience in database development.Office Location: Goregaon Mumbai Primary Responsibilities: Understand requirements from front end applications developers Write advanced queries, stored procedures, cursors, functions & triggers Conduct code reviews Work with high-traffic application servers Manage people and projects on a day-to-day operational level Effective client interaction Required Skills: Functional: MSSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers, Performance Optimization, Database Design, Indexes, Joins, DB Administration, ETL tools like SSAS, SSIS, High Data Volume Processing, Data Integrity Management, DB Backup/Recovery, Cloud Services. Mandatory: Passionate about sports, Problem-solving, Team player, Target & Result oriented. Additional: Team Management, Decision Making & Client Management.
NeoQuant Solutions Pvt Ltd NeoQuant Solutions is a Software Application Development and Software Services company that uses cutting edge technologies in developing software. We provide software solutions and custom products in the domain of Insurance, Banking and Media sector that are known for the use of the latest technology. We believe in innovations and simplicity to solve the business problems of our clients and partners. Website: https://neoquant.com/ MSBI Developer- We have the following opening in our organization: Years of Experience: Experience of 3 - 7 years Location- Mumbai (thane, BKC, Andheri) Educational Qualification: MCA/ME/Msc-IT/BE/B-Tech/BCA/BSC IT in Computer Science/B.Tech Requirements: 3 - 7 years of consulting or relevant work experience Should be good in SQL Server 2008 R2 and above. Should be excellent at SQL, SSRS & SSIS, SSAS, Data modelling, Fact & dimension design, work on a data warehouse or dw architecture design. Implementing new technology like power BI, power bi modeling. Knowledge of Azure or R-programming is an added advantage. Can scope out a simple or semi-complex project based on business requirements and achievable benefits Evaluate, design, and implement enterprise IT-based business solutions, often working on-site to help customers deploy their solutions
Responsibilities 1. Design & develop detail ETL specification based on the business requirement using SSIS & Oracle Procedures. 2. Good understanding of Data Warehousing & Dimensional Modelling concepts. 3. Develops, tests and implements enterprise data movement (ETL and CDC) solutions. 4. Design, develop & test SSRS reports & dashboards based on large amount of data sourcing from multidimensional analysis cube. 5. Ability to translate business needs into the technical solutions by working with business and IT stakeholders 6. Assist in the effort estimation and planning for SSIS & SSRS implementations 7. Troubleshoot & provide solutions based on the priorities for any issues being reported by client in ETL loads and reports. 8. Optimization of ETL processing time using industry best practices & standards to provide the report in timely manner. 9. Support in documenting solution design, user guide, troubleshooting guide wherever required. 10. Design & development ETL using SSIS. Required Skills 1. Minimum 3+ years of working experience in ETL, Data Warehousing using MSBI (SSRS, SSIS, Power BI) 2. Extensive experience working with SSIS, Power BI for developing management dashboard. 3. Experience in working with large scale data warehouse implementation project using MSBI & SQL Server. 4. Extensive experience in design and development of SSIS & automation of its processing. 5. Extensive experience in design and development of SSRS visualization & reports considering multiple sources. 6. Experience in working with SQL / PLSQL scripting using SQL Server. 7. Extensive experience to optimize the performance of ETL to match the assigned execution windows. 8. Experience in handling large amount of data coming from disparate systems. 9. Good to have the working experience in the Insurance Brokerage Domain.
We conceptualize, architect, build and run scalable and complex, modern day full stack technology platforms