We are seeking a highly skilled Lead - SQL Developer to manage database development, optimize performance, and lead a team of SQL developers. The ideal candidate will have expertise in SQL Server, database design, stored procedures, query optimization, and ETL processes, along with strong leadership capabilities.Responsibilities: Responsible to work with development team to develop, implement, and manage data base models for core product development. Responsible to write SQL database views, tables, and stored procedures to support engineering product development. Responsible for designing and maintaining SSIS, T-SQL, and SQL jobs. Responsible for developing and maintaining complex stored procedures for loading data into staging tables from OLTP, and other intermediary systems. Responsible for analysis, design specifications, development, implementation, and maintenance of DB. Responsible for designing partitioning of DB for Archive data. Responsible to ensure that the best practices and standards established for the use of tools like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated in Data Analytics solutions design. Responsible for documenting complex processes, business requirements and specifications.Skills:Minimum 8years of experience.Experience in database design, normalization, query design, performance tuning Proficient in writing complex Transact SQL code. Proficient in MS SQL Server query tuning. Experience in writing stored procedures, functions, views and triggers. Experience in Indexes, column store index, SQL server column storage, Query execution plan.Provide authentication and authorizations for Database. Develop best practices for database design and development activities. Experience in database migration activities. Strong analytical, multi-tasking and problem-solving skills

Key Responsibilities:Integration Solution Development: Design, develop, and maintain integration solutions using .NET technologies, including C#, ASP.NET, and .NET Core, to facilitate data flow and interoperability between systems. Build APIs, web services (RESTful and SOAP), and microservices to enable efficient and secure data exchange across applications and platforms. Implement and manage ETL (Extract, Transform, Load) processes to support data migration and synchronization. Requirements Analysis and Solution Design: Collaborate with business analysts and stakeholders to gather and analyse integration requirements, understanding the data flows and technical needs. Design integration solutions based on best practices, ensuring they meet functional requirements, scalability, performance, and security standards. Create technical documentation and solution designs that outline system architecture, data flow, and integration points. System Integration and Testing: Develop and maintain code for system integration, testing thoroughly to ensure solutions are robust, secure, and meet performance standards. Conduct unit, integration, and system tests to verify the functionality of integration solutions, using automation testing where possible. Troubleshoot integration issues, debug errors, and implement fixes to improve system reliability and performance. API Management and Development: Develop, publish, and maintain APIs for internal and external consumption, ensuring secure access and version control. Implement API gateways and management tools (e.g., Azure API Management, API Gateway) to monitor usage, control access, and ensure scalability. Document APIs, providing comprehensive guides for users and other developers to facilitate seamless API adoption. Data Transformation and Mapping: Design and implement data transformation and mapping logic to ensure that data is accurately translated between source and target systems. Utilize tools such as SQL, XML, JSON, and XSLT for data transformation and processing. Ensure data integrity and consistency across systems, addressing discrepancies or mismatches in data formats or structures. Cloud Integration and Deployment: Work with cloud platforms (e.g., Azure, AWS) to design and deploy integration solutions, leveraging cloud services for scalability and reliability. Implement serverless architectures (e.g., Azure Functions, AWS Lambda) and message queues (e.g., Azure Service Bus, AWS SQS) to streamline data flow. Utilize DevOps tools and CI/CD pipelines for deployment and monitoring of integration solutions. Performance Optimization and Monitoring: Continuously monitor integration solutions for performance and system health, identifying opportunities for optimization and scalability improvements. Implement logging, monitoring, and error-handling mechanisms to ensure integration reliability and troubleshoot issues in real-time. Analyse performance data and make recommendations to optimize response times, data throughput, and processing efficiency. Security and Compliance: Implement security best practices for integration solutions, including encryption, authentication, and authorization controls. Ensure compliance with relevant standards (e.g., GDPR, HIPAA) and internal security policies, particularly for handling sensitive data. Regularly update integration solutions to address security vulnerabilities and stay current with .NET security practices.Skill Requirements: Strong understanding of xml/json/csv/flat file/excel data reading and parsing. Experience in REST/SOAP API development. Experience in consumer service writing for REST/SOAP API. Experience in RMQ producer/consumer service writing. Experience in Multitasking/Multi-threading service writing in C#. Experience on RDBMS: MS-SQL Server, TSQL, Procedures, Views, Triggers, Cursors. Experience in Microsoft Technologies: C#.Net, ASP.Net (Core application). Very Strong experience in SQL server (Writing queries in SQL server). Work independently with minimal supervision. Good Debugging skills. Contribute to technical design documentation & User Manual. Postproduction support to the Project for future upgrades and bug-fix.

Our dynamic and growing company is actively seeking an experienced PostgreSQL Database Developer to join our team. As a PostgreSQL Database Developer, you will play a crucial role in designing, implementing, and maintaining our database systems. The ideal candidate should have a strong background in database development, performance optimization, and data modeling. Role & responsibilities Responsible to design, implement, and maintain database schemas in PostgreSQL and perform data modeling to ensure efficiency, reliability, and scalability. Responsible to optimize and tuneSQL queries for improved performance , and also identify and resolve performance bottlenecks in database systems.Responsible to manage-data migration and integration processes between different systems and ensure data consistency and integrity during the migration process. Responsible to develop and maintain stored procedures, functions, and triggers to support application requirements and Implement business logic within the database layer.Responsible to Implement and maintain database security policies and manage user roles, permissions, and access control within the database. Responsible to implement and oversee database backup and recovery processes and also ensure data availability and reliability. Responsible to collaborate with cross-functional teams, including application developers, system administrators, and business analysts, to understand database requirements.Responsible to create and maintain documentation related to database design, processes, and best practices. Preferred candidate profile Experience with PostgreSQL replication and clustering.Familiarity with NoSQL databases.Knowledge of cloud database solutions (e.g., AWS RDS, Azure Database for PostgreSQL).Understanding of Dev-Ops practices and tools. Qualification Bachelors degree in Computer Science, Information Technology, or a related field. Proven experience as a Database Developer with a focus on PostgreSQL. In-depth knowledge of database design principles, normalization, and data modeling. Strong proficiency in writing and optimizing SQL queries. Experience with performance tuning and query optimization techniques. Familiarity with database security best practices and access control. Hands-on experience with data migration, integration, and ETL processes. Proficiency in scripting languages (e.g., Python, Bash) for automation tasks. Knowledge of backup and recovery processes. Excellent communication and collaboration skills. Ability to work independently and as part of a team.

We are seeking a talented and motivated React Developer with expertise in React JS, and Next JS to join our dynamic team in Kolkata. The ideal candidate will have a strong foundation in front-end development and a passion for building scalable and high-performance applications.Responsibilities:Develop, test, and maintain responsive, high-quality front-end applications using React and Next.jsCollaborate with designers and backend developers to implement and enhance UI/UX across projectsOptimize front-end performance, ensuring applications are performant, accessible, and SEO-friendlyTroubleshoot, debug, and resolve issues across browsers and devicesParticipate actively in code reviews and cross-functional engineering team meetingsCommit to (and implement where necessary) standards of code quality and consistencyRequired Skills:Expert knowledge of & experience with React and Next.jsExpertise with state management libraries (e.g., Redux, Zustand) and/or React QueryTroubleshoot, diagnose issues, and solve problems with existing codeHTML, CSS, Bootstrap, Material UI and JavaScript experienceVersion Control (Git)Problem Solving and CommunicationOptional Skills:Responsive Design and Cross-Browser CompatibilityFamiliarity with TypeScript and experience using it in a Next.js environmentKnowledge of front-end testing frameworks, such as Jest or Cypress