BizTalk Developer at ScatterPie Analytics · Pune · 3 - 5 years · ₹3L - ₹15L / yr · Profitable · Posted 17 Dec 2024

- BizTalk Development:
- Design, develop, and deploy BizTalk solutions for integrating business processes.
- Build custom BizTalk maps, orchestrations, pipelines, and adapters to meet integration requirements.
- Troubleshoot and resolve issues with BizTalk applications, ensuring minimal downtime.
- Implement best practices for BizTalk development and integration.
- Create and maintain documentation related to BizTalk applications and processes.
- SQL Development & Management:
- Develop, optimize, and maintain SQL Server databases, including stored procedures, queries, and triggers.
- Write efficient SQL queries to extract, transform, and load data.
- Perform database tuning and optimization for performance improvements.
- Ensure database security, integrity, and backup.
- Conduct routine maintenance tasks such as patching and updates for SQL databases.
- Integration & Collaboration:
- Collaborate with business analysts and other developers to understand business requirements and integrate them into solutions.
- Participate in design and code reviews, ensuring quality and standards are adhered to.
- Assist in the deployment of BizTalk solutions and SQL database updates to production environments.
- Support Existing Systems:
- Provide ongoing support and maintenance for existing BizTalk applications, SQL databases, and integration processes.
- Troubleshoot, monitor, and optimize existing BizTalk integration workflows, databases, and related services.
- Ensure smooth operations by resolving issues and improving the performance of legacy systems.
- Monitoring & Support:
- Monitor the performance of BizTalk applications and SQL databases to ensure optimal performance.
- Provide ongoing support for BizTalk integrations and SQL database issues.
- Troubleshoot and resolve technical issues related to integrations and SQL queries.
- Provide 2nd/3rd line support for any issues that arise in the production environment.
Required Skills & Qualifications:
- Technical Skills:
- Strong experience with BizTalk Server (preferably BizTalk 2016 or later).
- Expertise in creating and managing BizTalk orchestrations, maps, and pipelines.
- Proficient in SQL Server (SQL Server 2012/2014/2016/2017/2019).
- Experience with T-SQL, stored procedures, triggers, views, and indexes.
- Familiarity with SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
- Knowledge of web services (SOAP, REST) and messaging formats (XML, JSON).
- Experience with BizTalk adapters and message brokers.
- Analytical and Troubleshooting Skills:
- Strong problem-solving skills with the ability to debug and troubleshoot BizTalk and SQL issues.
- Ability to quickly understand new systems and integrations and provide efficient solutions.

About ScatterPie Analytics
About
Similar jobs (10)
Navtech is a premier IT software and services provider. Our mission is to increase public cloud adoption and build cloud-first solutions that become trendsetting platforms of the future.
We have been recognized as the Best Cloud Service Provider by GoodFirms for delivering quality services and results. We strive to innovate and push technology and service boundaries to provide best-in-class technology solutions to our clients globally.
We are a fast-growing company serving clients across the United States, UK and Europe. You will work with a team of talented developers, quality engineers and product managers who are passionate about building impactful technology solutions.
About the Role
We are looking for an experienced Senior SQL Server / SSIS Engineer to design, develop, maintain and optimise database solutions and ETL workflows.
The ideal candidate should have strong hands-on experience with Microsoft SQL Server, SSIS package development, T-SQL programming, database performance tuning and data migration.
You should be comfortable working with existing database systems, troubleshooting complex issues, improving performance and ensuring data integrity, security and availability.
Key Responsibilities
- Design, develop and maintain SQL Server databases, database objects and logical data models.
- Develop, deploy and maintain SSIS packages for ETL processes and data integration.
- Build and optimise complex SQL queries, stored procedures, functions, views and triggers.
- Design and implement data extraction, transformation and loading workflows across multiple systems.
- Perform database migrations, data transformations and validation activities.
- Monitor and troubleshoot SQL Server databases, SSIS packages and SQL Server Agent jobs.
- Identify and resolve performance bottlenecks through query optimisation, indexing and execution plan analysis.
- Handle database administration activities, including upgrades, backups, recovery and maintenance.
- Ensure database performance, security, availability and data integrity.
- Troubleshoot database locking, blocking and resource utilisation issues.
- Collaborate with developers, QA engineers and other stakeholders to understand database requirements.
- Maintain technical documentation for database structures, ETL workflows and processes.
- Provide production support and proactively identify opportunities to improve database performance and reliability.
Who Are We Looking For?
- 6–10 years of experience in SQL Server development and database engineering.
- Strong hands-on experience with Microsoft SQL Server, preferably SQL Server 2016/2017 or above.
- Hands-on experience in developing, deploying and maintaining SSIS packages.
- Strong understanding of ETL processes, data integration and data migration.
- Advanced knowledge of T-SQL, stored procedures, functions, views and triggers.
- Experience in database performance tuning, query optimisation, indexing and execution plans.
- Experience in SQL Server monitoring, troubleshooting and resolving database performance issues.
- Good understanding of SQL Server Agent jobs, database backups, recovery and maintenance.
- Experience resolving database locking conflicts, blocking and resource utilisation issues.
- Knowledge of SQL Server system tables and Dynamic Management Views (DMVs).
- Experience with PowerShell scripting and automation is preferred.
- Exposure to AWS RDS, Azure SQL or other cloud database environments is an advantage.
- Knowledge of PostgreSQL or NoSQL databases is a plus.
- Experience leading or mentoring junior developers is preferred.
- Bachelor's or Master's degree in Computer Science, Software Engineering, IT or a related field.
- Excellent analytical, logical, troubleshooting and communication skills.
Good to Have
- Experience with SSRS or SSAS.
- Knowledge of AWS RDS or Azure SQL.
- Experience with PowerShell scripting.
- Exposure to PostgreSQL or NoSQL databases.
- Relevant Microsoft SQL Server certifications.
Why Navtech?
- Performance reviews and appraisals twice a year.
- Competitive compensation package with additional bonuses and benefits.
- Opportunities to work with renowned clients across the US, UK and Europe.
- Medical insurance coverage for self and immediate family.
- Opportunity to work with a culturally diverse and collaborative team.
- Opportunities for continuous learning and technical growth.
Hiring: Mainframe DB2 Developer / SQL Server Developer
Experience: 5+ Years
Role: IT Developer / Development Lead
We are looking for experienced developers with strong expertise in Mainframe technologies and SQL Server to design, develop, maintain, and optimize enterprise applications. The role involves database development, performance tuning, stored procedures, and backend application support within a Wealth Management Technology environment.
Must-Have Skills:
- Mainframe
- COBOL
- DB2
- SQL
- JCL
Key Responsibilities: Develop and maintain Mainframe applications, build and optimize database objects and complex SQL queries, troubleshoot performance issues, collaborate with global teams, and deliver secure, high-quality solutions.
Immediate-Joiner Only
We are looking for a Dedicated Candidate for the following role –
Role: .NET Tech Lead
Experience: 7+ Years
Location: Hybrid (Noida)
Duration: 6 Months
Required Skills:
Experience with React.
Strong knowledge of system design, scalable solutions, and application architecture.
Hands-on experience with SQL databases.
Expertise in .NET Core and backend development.
Solution Architect experience is preferred.
Experience with Azure DevOps and CI/CD pipelines.
Senior Software Engineer – .NET Full Stack Developer
Job Location: Pune (Hybrid)
Job Description
We’re seeking an experienced Senior Software Engineer with a strong command of .NET and Angular 18 and modern frontend technologies. The ideal candidate will excel in both technical execution and collaborative leadership, demonstrating excellent communication skills and an Agile mindset. You’ll play a critical role in designing, developing, and optimizing our web applications while mentoring junior developers and participating in technical discussions and contributing to design decisions.
Roles & Responsibilities
- Design and implement reusable components and responsive UI using Angular Material UI 14.2.5 and FAST.
- Design, develop, and maintain backend services and APIs using .NET 10.0 and .NET Core Microservices.
- Write clean, efficient, and maintainable code in C# 14 following best practices.
- Develop event-driven systems with Azure Service Bus for message brokering and Azure Data Factory for ETL processes.
- Implement logging, error handling, and monitoring using Serilog, NLog, and SonarCloud for static code analysis.
- Write unit and end-to-end tests with Jest to ensure reliable, high-quality software.
- Manage dependencies with NuGet and collaborate through CI/CD pipelines.
- Participate in Agile ceremonies — sprint planning, retrospectives, and daily stand-ups, while collaborating with frontend, DevOps, and product teams.
- Communicate technical ideas and solutions clearly to both technical and non-technical stakeholders.
- Ensure code quality with ESLint, Prettier, and SCSS for clean, maintainable styling.
- Work with CI/CD pipelines and support build/deployment troubleshooting; optimize performance using NPM, Gulp, and Webpack.
- Collaborate in an Agile environment, participating in sprint ceremonies, backlog grooming, and retrospectives.
- Support junior developers through code reviews and knowledge sharing, promoting best practices and technical excellence.
- Collaborate with team leads, product owners, and QA to understand requirements and deliver assigned features.
- Suggest and implement innovative solutions for better performance and maintainability.
Position-Specific Skills
- 4+ years of experience in frontend and backend development, with a strong portfolio showcasing Angular 18 projects and a strong focus on .NET Core Microservices.
- Proficiency in TypeScript, SCSS, Angular Material, and frontend design patterns.
- Proficiency in C# 14 and experience building RESTful APIs and GraphQL services.
- Strong understanding of unit testing and E2E testing frameworks: Jest, Cypress.
- Expertise in Azure services — Functions, Web Apps, Redis Cache, Service Bus, Cosmos DB, Azure SQL Database.
- Knowledge of containers and container orchestration tools (e.g., Docker, Kubernetes) is a plus.
- Proven leadership experience — mentoring developers and contributing to technical decisions.
- Excellent communication skills — ability to explain complex ideas to both technical and non-technical audiences.
- Agile mindset — comfortable working in sprints, adapting to changes, and collaborating cross-functionally.
- Excellent communication skills — able to explain complex backend concepts to technical and non-technical audiences.
- Strong problem-solving mindset with a passion for building high-performance, resilient systems.
- Good to have e-learning domain knowledge.
Location: Bangalore
Experience: 5+ years
Employment type: Full-time, permanent
Work Hours: 10.00 AM to 7.00 PM (General Shift)
website: www.amazech.com
Qualifications:
B.E./B.Tech/M.E./M.Tech in Computer Science, Information Technology, Electrical or Electronic with a good academic background.
Key Responsibilities:
· Develop and maintain backend services using ASP.NET Core (latest LTS), RESTful APIs, and microservices architecture
· Implement authentication and authorization using OAuth2 and Azure AD
· Design and maintain clean, scalable domain models and service layers
· Lead and execute .NET Framework to .NET Core migrations, ensuring stability and backward compatibility
· Optimize backend services for performance, scalability, and security
· Contribute to CI/CD pipelines using Azure DevOps with automated builds and deployments
· Support production environments, perform root cause analysis, and ensure operational stability
· Develop and maintain frontend applications using Angular or ReactJS, ensuring responsive and high-performance user interfaces
· Integrate frontend components with backend RESTful APIs and microservices
· Collaborate closely with UX/UI designers and backend teams to deliver end-to-end features
· Maintain high-quality technical documentation and API specifications
Required Skills and Experience:
· Strong hands-on experience with ASP.NET Core (latest LTS), REST APIs, and Microservices
· Minimum hands-on experience in frontend development using Angular or ReactJS
· Proficiency in HTML5, CSS3, JavaScript/TypeScript
· Experience integrating frontend applications with backend services
· Proficiency in Azure App Services, Azure SQL, and Key Vault
· Experience with Git and Azure DevOps CI/CD pipelines
· Solid understanding of unit and integration testing
· Strong performance tuning and secure coding practices
Other Requirements:
· Exposure to Node.js preferred
· Experience using GitHub Copilot and modern developer tooling preferred

Job Title: Xclarity Administrator Level 2 Product Field Engineer
Designation: Senior Software Engineer - Systems
Location: Bangalore
Experience: 4-8years
Job Summary:
The Xclarity Administrator (LXCA) is a centralized resource-management solution designed to simplify infrastructure management, enhance response times, and improve the availability of server systems and solutions. This role requires an experienced engineer to support Level 2 service cases related to LXCA. The primary responsibilities include managing customer case workloads and regularly reporting critical cases to team leads and upper management.
Responsibilities:
- Provide technical expertise to field teams for problem determination and isolation, and develop action plans to resolve client issues.
- Act as a technical interface between Level 1 Support and LXCA Development teams (Level 3 Development and LXCA Software Development).
- Develop and contribute to internal and external knowledge base articles.
- Support the product lifecycle from pre-product introduction to end-of-life, participating in pre-product activities and taking technical positions for defect deferrals when necessary.
- Collaborate with Software Development during the design phase to ensure product support, quality control, and client care are incorporated.
- Interface with client teams and customers to explain technical solutions and maintain high levels of customer satisfaction.
- Participate in regular case review meetings to discuss ongoing issues and solutions.
- Work collaboratively with virtual teams and management to ensure effective communication and problem resolution.
Mandatory Skills:
- Strong software skills in Unix Shell Scripts, Database Administration - Database Admin, T-SQL, and Operating Systems.
- Proficiency in MS Office, Power Shell, and POSTMAN.
- Experience with x86 server hardware, including SNMP, IPMI, Redfish API, and CIM.
- Networking knowledge, including TCP, SSL, HTTP, and SSH.
- Excellent spoken and written English communication skills.
Preferred Skills:
- Experience in product engineering support, IT departments, server services, or customer service.
- Familiarity with Xclarity Administrator and related infrastructure management tools.
- Ability to develop and maintain technical documentation and knowledge base articles.
Qualifications:
Bachelor's Degree in Engineering or Software is required.

Location: Bangalore (Hybrid)
Experience: 4–8 Years
About the Role
At Twenty20 Systems, we are looking for a Senior Software Engineer (Integration) who can build and support scalable integrations across enterprise applications, APIs, and data systems.
This role is ideal for someone who is hands-on, technically strong, and excited to solve real integration challenges in a fast-paced environment. You will work closely with engineering, product, and delivery teams to build reliable integration solutions while contributing to architecture and engineering best practices.
What You’ll Do
- Design, develop, and maintain enterprise integrations, APIs, and automation workflows across internal and third-party systems.
- Build and manage integrations using Workato and other iPaaS/middleware platforms.
- Develop and optimize API-based services, data pipelines, and workflow automations for business-critical use cases.
- Work with product, engineering, and business teams to understand requirements and build scalable solutions.
- Troubleshoot, monitor, and improve integration performance in production environments.
- Build reusable components, connectors, and automation logic to improve delivery efficiency.
- Ensure integrations follow security, reliability, performance, and governance standards.
- Support delivery teams in resolving integration issues and improving system performance.
Requirements
- 4–6 years of experience in software engineering, middleware, or enterprise integrations.
- Strong hands-on experience in Workato (Boomi, MuleSoft, WSO2, TIBCO experience is a plus).
- Good understanding of REST/SOAP APIs, webhooks, OAuth, and connector-based integrations.
- Strong skills in JSON, XML, SQL, JavaScript/Python, and data transformation logic.
- Experience working with enterprise applications like Salesforce, NetSuite, Workday, Snowflake, Shopify, etc.
- Exposure to cloud platforms (AWS/Azure/GCP) and automation architectures is a plus.
- Good debugging, troubleshooting, and problem-solving skills.
- Ability to work in a fast-paced delivery-oriented environment with strong ownership.
What Your First 3 Months Will Look Like
- Take ownership of assigned integration projects and support ongoing delivery pipelines.
- Work on API integrations, automations, and troubleshooting real-time production scenarios.
- Collaborate with senior engineers and product teams to improve integration quality and performance.
Where You’ll Be in 6 Months
- Independently handling multiple integration workflows and delivery requirements.
- Contributing to reusable frameworks and engineering best practices.
- Becoming a key technical contributor for integration design and production support.
- Driving faster delivery through automation and optimized integration patterns.
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.
Immediate-Joiner Only
We are looking for a Dedicated Candidate for the following role –
Role: .NET Solution Architect
Experience: 7+ Years
Location: Hybrid (Noida)
Duration: 6 Months
Required Skills:
Experience with React.
Strong knowledge of system design, scalable solutions, and application architecture.
Hands-on experience with SQL databases.
Expertise in .NET Core and backend development.
Solution Architect experience is preferred.
Experience with Azure DevOps and CI/CD pipelines.

Key Skills
Advanced hands-on experience in Alteryx Designer.
Strong knowledge of Alteryx workflows, Macros (Standard, Batch & Iterative).
Excellent SQL skills, including complex queries, joins, CTEs and aggregations.
Strong experience in ETL/ELT, data transformation and integration.
Alteryx workflow performance optimization and troubleshooting.
Experience with Alteryx Server / Alteryx One administration.
Production support, workflow scheduling and deployment.
Knowledge of Snowflake, SQL Server and PostgreSQL.
Microsoft Entra ID and SCIM provisioning knowledge is preferred.
Excellent communication and stakeholder management skills.
Mandatory Requirements
Valid Alteryx Designer Core Certification or higher is mandatory.
Strong hands-on experience in Alteryx workflow development.
Practical experience with Alteryx Macros.
Strong SQL and ETL/ELT expertise.
Experience in production support and performance optimization.
Excellent communication skills.
Good-to-Have Skills
Private Equity / Investment Management domain experience.
Alteryx Designer Advanced or Expert Certification.
Python (Pandas), Snowflake and REST APIs.
Microsoft Entra ID and SCIM 2.0.
Git, CI/CD and workflow automation.
Key Responsibilities
Design, develop and maintain enterprise-grade Alteryx workflows.
Build reusable macros and optimize complex ETL/ELT processes.
Manage workflow deployment, scheduling and monitoring.
Perform performance tuning and troubleshoot production issues.
Integrate multiple databases, APIs and enterprise data sources.
Ensure data accuracy, reconciliation and operational reliability.
Coordinate with business and technical stakeholders.










