SQL Developer - Night Shift

Experience and Required Skill Sets: 

1      Solid experience in software design and development using Microsoft ASP.NET framework, C#, Visual Studio, and in writing clean, readable, and easily maintainable code

2      5+ years of experience in WCF, WPF, VB.NET, SQL Server, JQuery, Angular 10 and above.

3      5+ years of experience in developing highly scalable REST/Web APIs

4      5+ years of experience in developing highly efficient SQL/NoSQL Queries

5      5+ years of experience in Relational and Document databases

6      Strong understanding of object-oriented programming and possess strong fundamental design principles for building a scalable application.

7      Experience in using the MVC framework, working knowledge in APIs, and Service Oriented Architecture

8      Strong understanding of object-oriented programming and possess strong fundamental design principles for building a scalable application.

9      Experience in Angular version 10 and above is required 

10   Expert in SQL programming & Database Design (Stored procedure, Function, Trigger, Constraints, Replication) 

11   Strong ability in HTML and JavaScript (AJAX, DOM)

12   Development experience with data integration technologies including REST, SOAP, JSON, XML

13   Expertise in programming and usage of any unit testing framework. Expertise in integration testing and continuous integration.

14   Experience working in a DevOps environment will be an added advantage.

Responsibilities: 

•       Ability to create complex, enterprise-transforming applications that meet and exceed client expectations. 

•       Responsible for the bottom line. Strong project management abilities. Ability to encourage the team to stick to timelines.

•       Follow best-in-class coding practices and review the solutions vis-à-vis the requirements and technical specifications.

•       Should demonstrate strong client interfacing capabilities like emails and calls with clients in the US/UK

Job Description: SQL Developer – Mutual Fund / Capital Markets

Location: Noida, Uttar Pradesh

Work Mode: Hybrid

Experience Required: 10+ Years

Employment Type: Full-time

Job Summary

We are looking for an experienced SQL Developer with strong expertise in Microsoft SQL Server, T-SQL programming, complex query development, and database performance optimization. The ideal candidate should have hands-on experience designing, developing, maintaining, and optimizing database objects and handling complex data processing requirements.

Experience in the Mutual Fund or Capital Markets domain will be highly preferred, particularly in financial systems, transaction processing, data reconciliation, and financial reporting.

Key Responsibilities

• Design, develop, maintain, and optimize SQL Server database schemas and database objects.
• Develop and maintain complex T-SQL queries, stored procedures, functions, triggers, views, SQL Jobs, and scripts.
• Perform query optimization and database performance tuning to improve execution speed and efficiency.
• Analyze execution plans, implement indexing strategies, and work with partitioning and performance monitoring.
• Review existing SQL queries and identify performance bottlenecks and opportunities for improvement.
• Perform data extraction, transformation, migration, data porting, and data processing activities.
• Translate business and financial reporting requirements into effective SQL and database solutions.
• Troubleshoot database issues and provide timely resolutions.
• Support production and UAT environments for database-related issues.
• Perform data validation, reconciliation, and migration activities while ensuring data accuracy and consistency.
• Maintain database security, data integrity, and compliance with established standards.
• Collaborate with application developers, business analysts, QA teams, and other stakeholders.
• Take ownership of assigned tasks and deliver solutions independently.

Required Technical Skills

• Advanced knowledge of Microsoft SQL Server and T-SQL.
• Strong hands-on experience with stored procedures, functions, triggers, views, and SQL Server Jobs.
• Proven expertise in developing simple, medium, and complex SQL queries.
• Strong experience in complex data manipulation and data processing.
• Expertise in SQL query performance tuning and optimization.
• Hands-on knowledge of indexing, execution plan analysis, partitioning, and performance monitoring.
• Ability to analyze, debug, and optimize existing SQL queries.
• Strong database troubleshooting and problem-solving skills.
• Understanding of code versioning and version control systems.
• Knowledge of database security standards and best practices.
• Familiarity with data visualization tools will be an added advantage.

Domain Knowledge

• Good understanding of the Mutual Fund domain is preferred.
• Experience with Capital Markets data platforms and financial systems will be an advantage.
• Understanding of financial transactions, business processes, data reconciliation, and financial reporting requirements is desirable.

Educational Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Relevant certifications or advanced qualifications will be an added advantage.

Preferred Candidate Profile

• 10+ years of relevant experience in SQL Server development.
• Strong technical expertise in T-SQL development and database optimization.
• Ability to work independently and manage complex database requirements.
• Strong analytical, debugging, and communication skills.
• Candidates with relevant Mutual Fund or Capital Markets experience will be preferred.

Work Location: Noida, Uttar Pradesh | Work Mode: Hybrid

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

We are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.

Qualifications and Skills:

• Minimum 5 years of experience as a Data Engineer
• Hands-on experience with Azure cloud-based data solutions
• Expertise in database design and management, including SQL databases such as SQL Server
• Proficient in ETL (Extract, Transform, Load) design for data integration and processing
• Strong knowledge of data modeling principles and techniques
• Ability to analyze and translate data into actionable insights, reports, and visualizations
• Proficiency in Power BI for reporting and data visualization

Desirable Skills:

• Experience with Power BI Report Builder / Reporting Services
• Knowledge of statistical analysis or Data Science
• Experience within the UK Insurance industry is a plus
• Python or R coding skills

Responsibilities:

• Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
• Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
• Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
• Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
• Implement different methods of streaming data and create reconciliations for datasets
• Build analytical models to support reporting and analytics
• Collaborate with an agile delivery team to work on the backlog of specified work

Job Title: Senior Data Analyst

Location: Sharnam Metrolinks, Amraiwadi, Ahmedabad

Working Days: 6 Days a Week

Department: MDO

Reporting To: COO

Employment Type: Full-Time

Job Summary

We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization.

The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.

Key Responsibilities

1. Data Management & Reporting

● Collect, clean, validate, and consolidate data from multiple internal and external sources.

● Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.

● Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.

2. Database & Data Accuracy Management

● Manage and regularly update internal databases, spreadsheets, and reporting systems.

● Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.

● Implement best practices for data validation, version control, and audit checks.

3. Data Analysis & Business Insights

● Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.

● Translate data findings into clear, actionable insights and recommendations to support

strategic and operational decision-making.

4. Reporting Automation, System Recommendation & Implementation

● Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.

● Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.

● Proactively suggest new automation tools, system enhancements, or integrations to

improve efficiency, accuracy, and scalability.

● Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.

● Continuously monitor and optimize automated systems in line with business growth and evolving data needs.

5. Cross-Functional Coordination & Support

● Collaborate with Sales, HR, Finance, Operations, and other departments to understand

reporting and data requirements.

● Provide support for ad-hoc analysis, custom reports, and special data requests.

● Act as a data partner to department heads for decision support and performance tracking.

6. Documentation & Compliance

● Maintain complete and updated documentation for MIS processes, reports, data models,

automation logic, and system changes.

● Ensure compliance with company data governance policies and applicable data protection standards.

System Development & Data Structuring Responsibilities

● Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.

● Review existing manual and digital data systems to identify operational gaps, risks, and

mprovement opportunities.

● Recommend structured data models, reporting formats, and storage solutions aligned with

business requirements.

● Coordinate with department heads to define data structures, access levels, and reporting

standards.

● Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP

integrations) with minimal operational disruption.

● Design structured data formats and role-based access controls to ensure secure and

organized data management.

● Train employees on newly implemented systems and provide post-implementation

support.

● Monitor system performance, resolve issues, and continuously improve systems based on

user feedback and organizational growth.

Qualifications & Experience

● Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.

● 3–5 years of experience in data analytics, reporting, or system automation roles.

● Strong analytical thinking, logical reasoning, and problem-solving abilities.

● High attention to detail with excellent organizational and documentation skills.

Technical Skills (Must Have)

● Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts

● BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)

● Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization

● Vlook

Preferred Skills

● Strong verbal and written communication skills

● Ability to handle sensitive and confidential information responsibly

● Quick learner with a tech-savvy, improvement-driven, and solution-oriented mindset

Business Intelligence Analyst - 2

Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.

Job Summary:

The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products.

This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst – 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.

Key Responsibilities:

· Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.

· Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimization, stored procedures, views, and complex queries.

· Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security.

· Support and troubleshoot SSAS Tabular and Multidimensional models, including processing, calculations, relationships, security, and performance.

· Develop and troubleshoot advanced SSRS/paginated reports, including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats.

· Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.

· Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.

· Analyze and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.

· Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.

· Perform end-to-end root-cause analysis and performance optimization across the BI technology stack.

· Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.

· Provide technical guidance and mentoring to BI Analyst – 1 team members and contribute to BI best practices and documentation.

Required Skills & Qualifications:

·      5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.

·      Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modeling.

·      Advanced knowledge of SQL Server and T-SQL, including query optimization and performance tuning.

·      Strong experience with SSRS and enterprise reporting.

·      Experience with SSAS Tabular and/or Multidimensional models.

·      Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.

·      Experience working with OData and enterprise data integration.

·      Strong understanding of Data Warehousing, Datamarts, Automart, ETL/ELT, and data modeling.

·      Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.

·      Strong analytical, troubleshooting, and root-cause analysis skills.

·      Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.

·      Experience with tools such as DAX Studio, Tabular Editor, Performance Analyzer, Query Store, or SQL Profiler is an advantage.

• Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.

• Experience in Core Java, CXF, Spring. 
• Experience in spring boot, microservices. 
• Extensive experience in developing enterprise-scale n-tier applications for the financial domain. Should possess good architectural knowledge and be aware of enterprise application design patterns. 
• Should have the ability to analyze, design, develop and test complex, low-latency client-facing applications. 
• Good development experience with RDBMS, preferably Sybase database 
• Good knowledge of multi-threading and high volume server side development 
• Experience in sales and trading platforms in investment banking/capital markets 
• Basic working knowledge of Unix/Linux 
• Excellent problem solving and coding skills in Java 
• Strong interpersonal, communication and analytical skills. 
• Should have the ability to express their design ideas and thoughts.