SQL Developer at Fragma Data Systems · Remote only · 5 - 7 years · ₹10L - ₹18L / yr · Profitable · Remote only · Posted 22 Feb 2022

- Creating, designing and developing data models
- Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
- Validating results and creating business reports
- Monitoring and tuning data loads and queries
- Develop and prepare a schedule for a new data warehouse
- Analyze large databases and recommend appropriate optimization for the same
- Administer all requirements and design various functional specifications for data
- Provide support to the Software Development Life cycle
- Prepare various code designs and ensure efficient implementation of the same
- Evaluate all codes and ensure the quality of all project deliverables
- Monitor data warehouse work and provide subject matter expertise
- Hands-on BI practices, data structures, data modeling, SQL skills
Experience
| Experience Range |
5 Years - 10 Years |
| Function | Information Technology |
| Desired Skills |
Must have Skills: SQL
Hard Skills for a Data Warehouse Developer:
Soft Skills for Data Warehouse Developers:
|

Similar jobs (4)
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 seeking a skilled SQL Developer to join our team. This role serves as a key bridge between insurance operations and technical solutions, ensuring business requirements are accurately translated into efficient system functionality. The SQL Developer will play a critical part in maintaining and enhancing underwriting software products and system integrations—helping deliver reliable, high-quality solutions to clients in the insurtech space.
The ideal candidate possesses strong SQL expertise, advanced data mapping capabilities, and hands-on experience working with APIs, JSON, XML, and other data exchange formats. Experience with insurance technology platforms, such as ConceptOne or similar underwriting systems, is preferred. In this role, you will regularly develop, maintain, and troubleshoot stored procedures and functions, perform data validation, support integration efforts across multiple systems, and configure insurance workflows. You will work closely with business analysts, underwriters, and technical teams to ensure smooth product updates and continuous improvement of system functionality.
What We’re Looking For:
- 5+ years of experience in a technical, insurance, or insurtech-focused role
- Strong proficiency in writing SQL, including complex queries, stored procedures, and performance tuning
- Expertise in data mapping, data validation, and reporting
- Experience working with APIs, JSON, XML, and system-to-system integrations
- Strong analytical and problem-solving skills with the ability to troubleshoot and optimize complex workflows
- Clear and effective communication skills, able to translate technical concepts for non-technical stakeholders
- Ability to work independently and manage multiple tasks in a fast-paced environment
- Keen attention to detail and commitment to delivering accurate, high-quality results
Bonus:
- Hands-on experience with underwriting or policy administration systems (e.g., ConceptOne or similar platforms)
- Familiarity with core insurance processes, such as policy issuance, endorsements, raters, claims, and reporting
- Experience with the U.S. P&C (Property & Casualty) insurance
What You’ll Be Doing:
- Develop and optimize SQL stored procedures, functions, and triggers to support underwriting and compliance requirements
- Create and maintain reports, quote covers, and validations or map and configure forms, raters, and system workflows to ensure accurate data processes
- Set up, troubleshoot, and optimize underwriting platforms (ConceptOne/others) for performance and accuracy
- Manage integrations with APIs, JSON, and XML to connect external services and streamline data exchange
- Collaborate with BAs, QAs, and Developers to translate requirements, test outputs, and resolve issues
- Provide technical support and training to internal teams and clients to ensure effective system usage
This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.
Work Mode: WORK FROM OFFICE
Role Descriptions:
- Perform detailed data analysis and support business decision-making
- Gather and document business requirements and translate them into technical specifications
- Work closely with stakeholders to define data needs and reporting requirements
- Create user stories, functional specifications, and support UAT activities
- Ensure alignment between business objectives and data solutions
Required Skills:
- Strong expertise in SQL and data querying
- Proven experience in data analysis, requirement gathering, and stakeholder management
- Ability to translate business requirements into technical solutions and user stories
- Good understanding of data models, reporting, and analytics concepts
Skills: Business Analysis~ORACLE SQL
Locations: ~HYDERABAD~PUNE~
Desire candidate
- Candidate should have valid PF.
Role Overview
We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.
Key Responsibilities
- Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
- Build and maintain data models to support business processes, reporting needs, and integration workflows.
- Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
- Work closely with cross-functional teams to gather data requirements and understand business logic.
- Develop and execute integration test plans, including functional, data validation, and regression testing.
- Support data migration activities, including extraction, transformation, and loading (ETL).
- Monitor and troubleshoot integration issues, ensuring timely resolution.
- Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
- Ensure integration security, data integrity, and compliance with organizational standards.
Required Skills & Qualifications
- 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
- Hands-on experience with data mapping, data modelling, and database schema design.
- Proficiency in SQL (complex joins, stored procedures, performance tuning).
- Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
- Strong analytical and problem-solving skills.
- Experience with API-based integrations (REST/SOAP) is a plus.
- Familiarity with testing methodologies for integrations and data validation.
- Ability to work with business users, understand workflows, and translate requirements into technical solutions.
Preferred Qualifications
- Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
- Knowledge of JSON, XML, CSV transformation.
- Exposure to scripting languages (Python, Shell).
- Experience in Agile/Scrum environments.
- Prior involvement in ERP implementation or upgrade projects.
Competencies
- Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
- Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
- Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
- Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.
Why Join Us?
- Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
- Work on impactful projects that make a difference across industries.
- Opportunities for professional growth and continuous learning.
- Competitive salary and benefits package.
Application Details
Ready to make an impact? Apply today and become part of the QX Impact team!









