Software Engineer - II - DataBase

MANDATORY TECHNICAL SKILLS

SSRS, PowerBI, SQL Server 2008/2012, TSQL, Stored Procedures, Views, UDF’s, Triggers, Charts

EXPERIENCE

• 7+ years professional experience in database development using SQL Server 2008/2012(T-SQL, SSRS)

• Strong analytical and critical thinking skills, with the ability to analyze business requirements to determine

• processing flow, user requirements and inter-dependencies of multiple information systems.

• Experience with SDLC required

• Excellent verbal and written communication skills.

• Strong in performance tuning especially tuning complex queries, procedures and indexing strategies

Job Description.

DB developer 

This position is for Oracle Golden Gate developer and DBA position. The Candidate will implement and support Oracle Golden Gate replication components across many databases. Working closely with many application teams and implementing near real time replications with golden gate. Candidate should provide operational support as well.

Roles and responsibilities :

Configure and build Golden Gate Extracts/replicate for multiple databases.

Configure error handling for restart, logging, production support and status reporting in Golden Gate.

Identify and produce documentation of best practices.

Trouble shooting and performance tuning Golden Gate replications.

Implementing necessary monitoring scripts for Golden Gate in UNIX/PERL scripting

Provide Golden Gate solutions :

- Working with Oracle on SRs for critical issues.

- Strong oral and written communication skills along with problem solving skills.

Individual with min experience of over 5+ years on SQL Server

• Good Experience in SQL Server Installation and Configuration
• Backup and Recovery
• Security management
• Troubleshooting & Monitoring
• SSIS/SSRS/SSAS

Work mode: Hybrid

Location: Siruseri

Job Description

• Act as a technical expert for CRM projects.
• Be responsible for working on D365 CRM development, support, and integration projects.
• Lead or participate in design and architecture sessions with key business users, gathering and documenting business processes and requirements for the system.
• Architect the CRM system, related customizations, and reports to model the business and organizational process.
• Advise business users on best practices for CRM, development, or integration processes.
• Writing technical specifications for planned work.
• Build and configure CRM forms, views, dashboards, and workflows.
• Develop SSRS reports using Microsoft SQL and FetchXML. Maintain code repository, VSTS backlog, and source control.
• Effectively utilize SDK and 3rd party tools such as XRM Toolbox for administration of CRM system. Support of the application including fixing application issues.

Eligibility Criteria:

• 5+ years’ experience with different versions of Microsoft CRM including D365 CRM.
• Experience in migrations, customizations, JavaScript, C#, .NET, HTML, SQL Server, and SSRS including plugins, scripting, and form creation.
• Experience in workflow development including complex ones.
• Experience with CRM API, REST/ODATA, and SOAP endpoints.
• Experience in integrating D365 CRM with other applications is preferred.

BI Developer

Roles and Responsibilities:

• Comprehensive knowledge of SQL
• Expertise as a Microsoft BI Developer (SQL Server, SSIS)
• Experience and understanding of build and deploy processes
• A structured approach to software development (agile or waterfall), and a thorough understanding of the full software development lifecycle
• Knowledge and experience in experience banking
• Contribute to planning and estimation of sprints, features and releases
• Integrate new data sources using SQL, SSIS and C#
• Contribute to the testing and UAT phases
• In addition SQL Server 2014, Integration Services, Analysis Services, and Reporting Services (SSIS, ), Microsoft .NET, Tableau, Power BI, Data warehouse design

Job Requirement – Sr. SQL _PBI Developer

• Minimum 6+ years of expertise in SQL Database Development including SQL queries, data structures, stored procedures, index etc.
• Excellent written and verbal communication
• Advanced knowledge and experience in T-SQL coding: query writing, stored procedures, triggers and user-defined functions.
• Advanced knowledge and experience in development and maintenance of SSIS and SSAS (Tabular and Multidimensional)
• Advanced knowledge and experience in creating dashboards and reports using PowerBI
• Advanced knowledge and experience in DAX
• Experience in creating and publishing reports using SSRS
• Experience in writing MDX queries
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Optimize and manage SQL server databases
• Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Flexible, team player, “get-it-done” personality
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams

Optional Skills (Good to have):

• Microsoft certification in Azure data engineering

What essential skills you need

• 4 -6 years’ experience in MySQL database development. You know your way around problems,logic & code but you occasionally need help with how to do things. That’s cool with us. We usestack overflow too.
• Expertise in database design & development (preferably on MySQL).
• Expertise in writing complex SQL queries, stored procedures, and functions, triggers.
• Expertise in performance tuning, query optimization, using performance monitor, SQL Profiler andother related monitoring and troubleshooting tools.
• BE/B.Tech ( or equivalent education), good written & communication Skills.

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/">https://neoquant.com/ 

MSBI Developer- 

We have the following opening in our organization:

Years of Experience: Experience of  3 - 8 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 - 8 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

• 3+ years’ experience developing and implementing enterprise-scale reports and dashboards.

• Proficiency with MS Power BI / SSRS.

• Knowledge of logical and physical data modeling concepts (relational and dimensional).

• Understanding of structured query language (SQL).