11+ Transact-SQL Jobs in Pune | Transact-SQL Job openings in Pune

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

We are hiring for a Python Developer at Wissen Technology!

📍 Location: Pune (Hybrid)

💼 Experience: 3–6 Years

⏱️ Notice Period: Immediate / 15 days preferred

🔧 Key Skills:

• Strong experience in Python

• Hands-on with Pandas & NumPy

• Experience with AWS (S3, Lambda preferred)

• Good understanding of data processing & APIs

• SQL knowledge

🏢 About Wissen Technology:

Wissen Technology, part of the Wissen Group (est. 2000), is a fast-growing technology company specializing in high-end consulting across Banking, Finance, Telecom, and Healthcare domains.

✔️ Global presence – US, India, UK, Australia, Mexico & Canada

✔️ Certified Great Place to Work®

✔️ Trusted by Fortune 500 clients like Morgan Stanley, Goldman Sachs, and more

✔️ Strong growth with 400% revenue increase in recent years

🌐 Website: www.wissen.com

🔗 LinkedIn: https://www.linkedin.com/company/wissen-technology/

If you’re interested or have relevant candidates, please share your resume at [your email].

#Hiring #PythonDeveloper #PuneJobs #AWS #ImmediateJoiner

While you may already know about Wissen and the company history, here is a quick rundown for you.

About Wissen Technology:

·        The Wissen Group was founded in the year 2000. Wissen Technology, a part of Wissen Group, was established in the year 2015.

·        Wissen Technology is a specialized technology company that delivers high-end consulting for organizations in the Banking & Finance, Telecom, and Healthcare domains. We help clients build world class products.

·        Our workforce has highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like Wharton, MIT, IITs, IIMs, and NITs and with rich work experience in some of the biggest companies in the world.

·        Wissen Technology has grown its revenues by 400% in these five years without any external funding or investments.

·        Globally present with offices US, India, UK, Australia, Mexico, and Canada.

·        We offer an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation.

·        Wissen Technology has been certified as a Great Place to Work®.

·        Wissen Technology has been voted as the Top 20 AI/ML vendor by CIO Insider in 2020.

·        Over the years, Wissen Group has successfully delivered $650 million worth of projects for more than 20 of the Fortune 500 companies.

·        We have served client across sectors like Banking, Telecom, Healthcare, Manufacturing, and Energy. They include likes of Morgan Stanley, Goldman Sachs, MSCI, StateStreet, Flipkart, Swiggy, Trafigura, GE to name a few.

De

Job Title: Application Development Engineer (Python – Backtesting & Index Platforms)

Role Overview

Key Responsibilities

Engine Development: Design and implement modular, reusable Python components for index construction, rebalancing, and backtesting.

Large-Scale Simulation: Use Pandas, NumPy, and PySpark to run historical calculations across long time horizons and multiple index variants.

Workflow Integration: Integrate engines with orchestrators such as Airflow or Temporal using parameterized, config-driven execution.

Reference Data Consumption: Query and utilize pricing, security master, and corporate action data from Snowflake.

Quality & Reconciliation: Build automated test harnesses to validate outputs, compare against benchmarks, and guarantee reproducibility.

Performance Optimization: Improve runtime efficiency through vectorization, caching, and distributed computing patterns.

Cross-Team Collaboration: Partner with Business, Index Ops, and Platform teams to accelerate research-to-production onboarding.

Required Technical Capabilities

Python Expertise: Strong proficiency in Python application development with emphasis on clean architecture and maintainable design.

Data & Numerical Libraries: Deep experience with Pandas and NumPy; working knowledge of PySpark for distributed workloads.

Financial Computation: Ability to implement portfolio mathematics, weighting algorithms, and time-series transformations.

Config-Driven Systems: Experience building rule-based or metadata-driven processing frameworks.

Database Skills: Strong SQL and experience consuming structured data from Snowflake.

Testing Discipline: Expertise in unit testing, regression testing, and deterministic replay of calculations.

Orchestration Integration: Familiarity with Airflow, Temporal, or similar workflow engines.

Cloud Infrastructure: Solid understanding of AWS ecosystem services (S3, Lambda, IAM) and how they integrate with the Snowflake Data Cloud.

Microsoft Azure Data Integration Engineer

Job Description: 

Microsoft Azure Data Integration Developer who will design and build cutting-edge user experiences for our client’s consumer-facing desktop application. The Senior Software Developer will work closely with product owners, UX designers, front-end, and back-end developers to help build the next-generation platform. 

Key Skills:

• 3+ years of experience in an enterprise or consumer software development environment using C# and designing and supporting Azure environments
• Expert level programming skills in creating MVC and Microservices architecture
• Experience with modern frameworks and design patterns like .Net core
• Strong knowledge of C# language
• Hands-on experience using the Azure administration portal and iPaaS
• Demonstrable experience deploying enterprise workloads to Azure
• Hands-on experience in Azure function apps, app service, logic apps and storage, Azure Key vault integration, and Azure Sql database.
• Solid understanding of object-oriented programming.
• Experience developing user interfaces and customizing UI controls/components

·      Microsoft Azure Certification, Business Continuity, or Disaster Recovery planning experience is a plus

Responsibilities:

• Architect, design & build a modern web application for consumers
• Explore configuring hybrid connectivity between on-premises environments and Azure, and how to monitor network performance to comply with service-level agreements.
• Collaborate with UI/UX teams to deliver high-performing and easy-to-use applications
• Participate in code reviews with staff as necessary to ensure a high-quality, performant product
• Develop a deep understanding of client goals and objectives, and articulate how your solutions address their needs
• Unit testing/test-driven development
• Integration testing
• Deploying Azure VMs (Windows Server) in a highly available environment
• Regularly reviewing existing systems and making recommendations for improvements.
• Maintenance
• Post-deployment production support and troubleshooting

Technical Expertise and Familiarity:

• Cloud Technologies: Azure, iPaaS
• Microsoft: .NET Core, ASP.NET, MVC, C#
• Frameworks/Technologies: MVC, Microservices, Web Services, REST API, Java Script, JQuery, CSS, Testing Frameworks
• IDEs: Visual Studio, VS Code
• Databases: MS SQL Server, Azure SQL
• Familiarity with Agile software development methodologies.
• Advanced knowledge of using Git source control system.
• Azure, AWS, and GCP certifications preferred.

• Experience in designing & developing systems/software for large business environments (Java, J2EE).
• Strong design and coding skills in Enterprise Java, REST & SOAP web services, ORM (JPA/Hibernate), Spring, Maven, JMS (ActiveMQ), Caching, XML, JSON.
• Experience with multiple integration technologies / frameworks.
• Must have good experience in Unix/Oracle/SQL.
• Experience in Agile Development, Scrum, and Iterative approaches.
• Experience and exposure to AWS Cloud Services and DevOps mindset and expertise is a plus Experience with Mule or any ESB (Enterprise Service Bus) is a plus.

Must-Have Technology Skills:

• OOP Concept, Java 8+, Spring Boot, API development, Agile Scrum knowledge, Strong Databases design concepts of RDBMS, and capable of writing and optimizing complex queries.
  Good understanding of any Database tool e.g. Postgres, MySQL, etc.,
• DevOps basic knowledge e.g. implementation of logging in the code, Application Performance Management.
• Basic API & Application security, and Basics of tuning application performance.
• Basic Understanding of DevOps concepts e.g. CI & CD, Deployment lifecycle, Basic understanding of unit testing concepts e.g. TDD (test-driven development).
• A basic understanding of Microservices patterns
• A basic understanding of Java scripting.
• Good understanding of UI Frameworks like Angular 8+

Must-Have Soft Skills:

• Verbal & Written English communication, Good Problem-solving skills,
• Good Planning skills,
• Team Player,
• Good leadership skills
• Good written and verbal communication

Job Description

• Good experience as a full-stack developer in DB-centric applications and should be able to write and optimize complex database queries
• Requirement gathering & understanding, effort estimation, technical design, project planning, and monitoring in an Agile environment.
• Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks.
• Providing expertise in technical analysis and solving technical issues during project delivery.
• Customer interfacing - understand customer requirements, and propose technical solutions.
• Full Software Development Lifecycle (Agile).
• Code reviews, test case reviews and ensure code developed meets the requirements.
• Component Design/ Coding/ Unit Testing/ Debugging / Test Driven Development / Continuous Integration.
• Carry out adaptive changes necessitated by changes in Business Requirements and Technology

Responsibilities

• Determines technical feasibility of medium to low complexity features or solutions by evaluating problem, customer requirements, possible solutions and technology requirements.

• Exercises judgment in prioritizing tasks and selecting methods and techniques for obtaining solutions.

• Create a low-level design of modules of a software application through proper documentation and diagrams.

• Develops software solutions by studying requirements, clarifying customer/user needs, analyzing data and processes, and following established software development practices and processes.

• Develops proof of concepts for technical evaluation and early customer feedback.

• Updates and shares knowledge by studying state-of-the-art development tools, programming techniques, and computing technology; reading professional publications.

• Networks with internal and external personnel in their area of expertise.

Requirements

• B.Tech/B.S. or M.Tech/M.S. in Computer Science, IT or related field.

• 3-5 years of experience

Visit us on :

Mandatory Skills

• Should be proficient in the following areas of .NET (.NET 4.5 or above, .NET Core)

• Expert in C# and ASP.NET

• Knowledge of JavaScript/TypeScript is a plus

• Development of Windows and Web services

• Parallel and Asynchronous programming

• Unit testing, Linq, ORM

• Debugging/troubleshooting in .Net

• Should be proficient in SQL Server 2012 and above in the following areas

• T-SQL Stored Procedures

• Transaction in SQL

• Should have the following design skills

• Expert in OOPs

• Proficiency in Design Patterns

• Proficiency in Unit testing Patterns

• Understanding of Algorithms and Data structures.

• Experience on Requirement/Design/Code Review & Inspections

• Excellent problem-solving and analytical skills.

Desirable Skills

• Hands-on experience with using Git (handling branching and merging), any DevOps pipeline

• Experience with Agile methodologies

• Design the architecture of new services to deliver timely communication from server to
• client and server to server, while still functioning alongside existing server components
• Describe and implement the communications across multiple network layers, considering
• performance, reliability, and flexibility with respect to the underlying infrastructure
• Enhance and expand the ORM layer of the studio’s in-house web framework
• Craft software solutions for supporting flexibility in resource allocation, from compute to storage
• Consult with technical operations on appropriate Kubernetes-based infrastructure design
• Design for performance, and measure the effects
• Review your colleagues’ code, and learn from their reviews as well
• Identify, document, and communicate best practices for the engineers who use the fruits of your labour
• Requirements:
• 7+ years professional work experience
• BS or MS degree in Computer Science or a related technical field
• Must be proactive, self-directed, detailed and organized
• Proficient in PHP, C++, or Go
• Knowledge of relational databases and SQL, preferably MySQL
• Experience with in-memory NoSQL databases, such as Redis
• Ability to debug issues within custom code quickly
• Passion for developing scalable and maintainable software systems

Minimum of 4+ years of experience in Java development

• Experience delivering Services (REST, SOAP) and Web applications in Micro services architecture
• Experience developing and deploying Java solutions to cloud
• Experience in Spring Boot and components of Spring framework
• Experience in a JavaScript framework such as Angular or React
• Experience in TDD using Junit or similar frameworks

·       Experience in Design Patterns and service oriented architectural principles, Data structures and Algorithms.

·       Individual should be an active participant in the product design and code reviews for self and team and can competently review any aspect of their product or major sub-system.

·       Experience in SQL, Unix skills.

·       Good communication Skill

• As a polyglot developer Ideally, you should have:
• 1.5+ years of development experience using any of technology java, scala, python or any similar exciting technologies.
• Hands-on experience in coding, and implementation of complex, custom-built applications Working knowledge of build tool like maven/sbt and code versioning systems like git/bitbucket/cvs/svn
• Familiarity with few databases, like MySQL, Oracle, PostgreSQL, SQL Server, NoSQL etc Great OO skills, including strong design patterns knowledge
• Good communication and ability to work in a consulting environment is essential

• Think through hard problems in a consultancy environment, and work with amazing people to make the solutions a reality Work in a dynamic, collaborative, non-hierarchical environment where your talent is valued over your job title or years of experience
• Build custom software using the latest technologies and tools Craft your own career path

• Providing solution to real problems in Bigdata world.
• RnD on using the latest tools,techniques and cloud services.
• Automating the manual-timetaking tasks.
• Hands-on coding, usually in a pair programming environment.
• Working in highly collaborative teams and building quality code
• Working in lots of different domains and client environments
• Understanding the business domain deeply