SQL Lead at DataMetica · Pune, Hyderabad · 6 - 12 years · ₹11L - ₹25L / yr · Profitable · Posted 9 Feb 2022

We at Datametica Solutions Private Limited are looking for an SQL Lead / Architect who has a passion for the cloud with knowledge of different on-premises and cloud Data implementation in the field of Big Data and Analytics including and not limiting to Teradata, Netezza, Exadata, Oracle, Cloudera, Hortonworks and alike.
Ideal candidates should have technical experience in migrations and the ability to help customers get value from Datametica's tools and accelerators.
Job Description :
Experience: 6+ Years
Work Location: Pune / Hyderabad
Technical Skills :
- Good programming experience as an Oracle PL/SQL, MySQL, and SQL Server Developer
- Knowledge of database performance tuning techniques
- Rich experience in a database development
- Experience in Designing and Implementation Business Applications using the Oracle Relational Database Management System
- Experience in developing complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
Required Candidate Profile :
- Excellent communication, interpersonal, analytical skills and strong ability to drive teams
- Analyzes data requirements and data dictionary for moderate to complex projects • Leads data model related analysis discussions while collaborating with Application Development teams, Business Analysts, and Data Analysts during joint requirements analysis sessions
- Translate business requirements into technical specifications with an emphasis on highly available and scalable global solutions
- Stakeholder management and client engagement skills
- Strong communication skills (written and verbal)
About Us!
A global leader in the Data Warehouse Migration and Modernization to the Cloud, we empower businesses by migrating their Data/Workload/ETL/Analytics to the Cloud by leveraging Automation.
We have expertise in transforming legacy Teradata, Oracle, Hadoop, Netezza, Vertica, Greenplum along with ETLs like Informatica, Datastage, AbInitio & others, to cloud-based data warehousing with other capabilities in data engineering, advanced analytics solutions, data management, data lake and cloud optimization.
Datametica is a key partner of the major cloud service providers - Google, Microsoft, Amazon, Snowflake.
We have our own products!
Eagle Data warehouse Assessment & Migration Planning Product
Raven Automated Workload Conversion Product
Pelican Automated Data Validation Product, which helps automate and accelerate data migration to the cloud.
Why join us!
Datametica is a place to innovate, bring new ideas to live, and learn new things. We believe in building a culture of innovation, growth, and belonging. Our people and their dedication over these years are the key factors in achieving our success.
Benefits we Provide!
Working with Highly Technical and Passionate, mission-driven people
Subsidized Meals & Snacks
Flexible Schedule
Approachable leadership
Access to various learning tools and programs
Pet Friendly
Certification Reimbursement Policy
Check out more about us on our website below!
www.datametica.com

About DataMetica
About
Company video


Photos
Connect with the team
Similar jobs (10)
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

Role: Technical Architect – Data & Cloud
We are looking for an experienced Technical Architect to lead the design and implementation of modern cloud-based data platforms. The ideal candidate should have strong expertise in Azure and/or AWS, Databricks, Snowflake, modern data architecture, and large-scale data engineering.
Key Responsibilities:
- Design enterprise-scale Data Lakehouse and Data Warehouse architectures.
- Define data ingestion, transformation, and serving architecture.
- Lead architecture discussions and technical governance.
- Design scalable ETL/ELT frameworks using Databricks and Snowflake.
- Define best practices for security, performance optimization, CI/CD, and DevOps.
- Provide technical guidance to engineering teams during implementation.
- Collaborate with business, product, architecture, and data governance teams.
Must-Have Skills:
- Azure and/or AWS
- Databricks
- Snowflake
- Data Lakehouse Architecture
- PySpark
- SQL
- Data Modelling
- ETL/ELT Architecture
- Performance Optimization
- CI/CD
- Terraform / Infrastructure as Code, preferred
Preferred Skills:
- Insurance domain experience
- dbt
- Unity Catalog
- Delta Lake
- Iceberg
- Azure Data Factory / AWS Glue
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.

Job Overview:
We are seeking an experienced Cloud Data Engineer to the architecture, development, Data migration, ETL pipeline in cloud and optimization of a next-generation data platform. This is a development role for an individual with over 4 years of deep data engineering and data migration, data pipeline in AWS expertise, capable of driving technical direction, and delivering high-impact solutions in a fast-paced
4+ Years of hands-on, progressive experience in Cloud Data Engineering, cloud ecosystems AWS, Data Architecture
• Deep conceptual understanding of core data engineering principles, ETL/ELT patterns, and metadata management
• Ability to translate complex business needs into actionable technical requirements.
• Strong troubleshooting and problem-solving skills in distributed systems.
• Agile/Scrum teamwork capabilities and version control practices
• Insurance industry experience preferred but not mandatory
• Tools:
o Cloud Environment: AWS (S3, IAM, VPC, Glue, Lambda etc.)
o Experience with dbt Core, Iceberg, AWS Glue Catalog, AWS lambda, Redshift, Athena, Splunk, AmazonQ, AWS streaming services, Git
o Strong SQL, Pyspark and Python
Lead Data Engineer – Databricks & Azure
- We are looking for a Lead Data Engineer with 5–7 years of experience in Azure, Databricks, and Microsoft Fabric to lead and mentor the data engineering team. The role involves implementing scalable data solutions using Databricks as the core platform, building modern data pipelines, and enabling seamless integration with Microsoft Fabric and Power BI.
Responsibilities & Requirements:
- Lead and mentor data engineers while driving hands-on technical delivery.
- Implement approved Databricks and Microsoft Fabric architectures and solutions.
- Develop metadata-driven bronze, silver, and gold data pipelines.
- Build reusable batch, incremental, CDC, and streaming ingestion pipelines.
- Strong hands-on experience with Azure Databricks, PySpark, SQL, and Delta Lake.
- Experience with Microsoft Fabric, OneLake, Direct Lake, and Power BI integration.
- Implement data quality checks, reconciliation, source-to-target mapping, and metadata management.
- Configure Unity Catalog for data governance, access control, auditing, and lineage.
- Implement CI/CD, automated deployments, and Datadog monitoring.
- Drive testing, documentation, operational readiness, and knowledge transfer.
Good to have:
- Experience with MDM and master data integration.
- Exposure to Azure DevOps or GitHub Actions.
- Experience with automated data testing and reconciliation frameworks.
- Experience working with onshore stakeholders and distributed engineering teams.
- Strong communication, problem-solving, and team leadership skills.
Position: Technical Architect – Data Engineering
Job Summary:
- We are looking for an experienced Technical Architect to lead the design and implementation of modern cloud-based data platforms.
- The ideal candidate should have strong expertise in Azure and/or AWS, Databricks, Snowflake, modern data architecture, and large-scale data engineering.
- The candidate will work closely with business stakeholders, architects, and engineering teams to deliver scalable, secure, and high-performance data solutions.
Key Responsibilities
• Design enterprise-scale data lakehouse and data warehouse architectures.
• Define data ingestion, transformation, and serving architecture.
• Lead architecture discussions and technical governance.
• Design scalable ETL/ELT frameworks using Databricks and Snowflake.
• Define best practices for security, performance, CI/CD, and DevOps.
• Guide engineering teams on implementation.
• Collaborate with business, product, and data governance teams.
Must Have Skills :
• Azure or AWS
• Databricks
• Snowflake
• Data Lakehouse Architecture
• PySpark
• SQL
• Data Modelling
• ETL/ELT Architecture
• Performance Optimization
• CI/CD
• Terraform or Infrastructure as Code (preferred)
Preferred
• Insurance domain
• dbt
• Unity Catalog
• Delta Lake
• Iceberg
• Azure Data Factory / AWS Glue

Key Skills:
Python & System Design: Strong expertise in Python and system design, with proven experience architecting scalable, production-grade systems.
LLM & Agentic AI: Proven experience building LLM-based and agentic systems from the ground up and evaluating them based on reproducibility, calibration, and cost.
Cloud & Data Architecture: Deep understanding of data and cloud architecture across AWS and Azure, including multi-store data design, distributed systems, streaming, security, and cost optimization.
Azure Databricks: Hands-on production experience with Azure Databricks architecture, including Unity Catalog, Delta Lake, cluster policy design, job orchestration, and Terraform provisioning.
Supply Chain & Inventory Management: Strong domain knowledge of supply chain and inventory operations, including demand planning, MRP logic, inventory parameters, and translating business planning decisions into data requirements.
System Architecture & Technical Decision-Making: Ability to make sound architectural decisions based on first principles, evaluate technical trade-offs, and avoid unnecessary complexity and abstraction.
LLM & Agentic AI: Proven experience building LLM-based and agentic systems from the ground up and evaluating them based on reproducibility, calibration, and cost.
Technical Leadership: Ability to influence teams without direct authority, establish technical standards, prepare technical specifications and documentation, and mentor team members.
Experience in pharmaceutical or regulated industries is highly valued.
Job Title: Senior Data Architect
Experience: 7+ Years
Location: India (Ahmedabad / Hybrid/Remote)
Job Summary
We are looking for an experienced Senior Data Architect to support the modernization and enhancement of Enterprise Analytic Data Warehouse (ADW). The candidate will be responsible for evaluating existing data architecture, designing scalable data models, assessing data integration across clinical, operational and financial domains, and establishing data governance and data quality standards.
Key Responsibilities
- Assess and review the existing Enterprise Analytic Data Warehouse architecture, database structures and data integration processes.
- Design and improve enterprise data models covering clinical, operational, financial and revenue-cycle information.
- Define data architecture standards, database structures, data relationships and integration strategies.
- Evaluate data flows between source systems and the data warehouse.
- Design and review source-to-target mappings and data lineage.
- Identify architectural gaps affecting data completeness, consistency, integrity and reporting accuracy.
- Establish standardized data definitions, data governance practices and metadata management.
- Ensure consistent patient, facility, payer and other critical identifiers across different datasets.
- Support integration of billing, claims, payment, denial and accounts receivable (AR) data.
- Work with SQL and Python-based data processing solutions to investigate and validate data structures.
- Recommend improvements to warehouse scalability, performance, reliability and maintainability.
- Develop a prioritized architecture and modernization roadmap for future implementation.
- Coordinate with data engineers, analytics engineers and business stakeholders.
Required Technical Skills
- Strong experience in Data Architecture and Enterprise Data Warehousing.
- Advanced SQL and relational database concepts.
- Experience with data modelling (conceptual, logical and physical).
- Knowledge of ETL/ELT pipelines and data integration.
- Experience with data profiling, data lineage and metadata management.
- Understanding of data governance, data quality and data validation frameworks.
- Experience working with large and complex datasets.
- Python knowledge for data analysis and validation.
- Experience with cloud-based data platforms or modern data warehouse technologies.
Preferred Skills
- Experience with Databricks, Azure, AWS or similar cloud data platforms.
- Experience with healthcare data warehouses.
- Knowledge of clinical, financial, billing and claims datasets.
- Understanding of HIPAA, PHI and healthcare data security principles.
- Experience with healthcare analytics, reimbursement and revenue-cycle data.

Designation: Data Architect
Reporting: VP, Engineering
Desired Experience: 12 – 18 Years
Qualification: BE/ B Tech/ M Tech/ MCA and any Graduate.
Job Location: Noida Sec-6 (Nearest Metro Station 15)
(WFH/Work from Home Available)
Total Employees: 100+ Members
Working Days: Monday to Friday
Key Responsibilities
- Define, own, and evolve the enterprise data architecture
- Design scalable, secure, high-performance end-to-end data platforms
- Establish data modeling standards (conceptual, logical, physical)
- Act as architectural authority for data pipelines, APIs, and integrations
- Ensure platform design meets security, compliance, availability, and cost-efficiency standards
- Define and enforce data governance, data quality, metadata, lineage, and master data principles
- Collaborate with Data Engineers for implementation of architecture designs
- Align data architecture with product roadmaps and business priorities
- Define standards for data sharing, data products, and external data exposure
- Contribute to long-term data platform roadmap and technology adoption
- Support leadership with architecture reviews and strategic decisions
Required Experience & Technical Expertise
Experience
- 12+ years in Data domain
- 3–5 years as Data Architect / Lead Data Role
- Experience designing enterprise-scale data platforms
Data Architecture & Modeling
- Deep expertise in Data Modeling & Data Warehousing
- Advanced SQL knowledge
- Strong experience with Snowflake & modern cloud data stacks
- Experience with relational and cloud-native databases
Security & Compliance
- Knowledge of Data Security (Dynamic Masking, Row-Level Security, Access Control)
- Strong understanding of GDPR & Data Privacy regulations
Integration & Engineering
- Experience with streaming & event-driven architectures
- APIs & integration patterns (REST, event-based systems)
- Familiarity with CI/CD, DevOps & Infrastructure-as-Code in data environments
- Architecture reviews & technology evaluations
Key Technical Skills (Must Have)
- Snowflake
- Matillion (or equivalent data integration tools)
- Python
- SQL
- REST APIs & Event-driven integrations
- Power BI / Qlik / Tableau
- Experience with CRM / Marketing Automation / PIM platforms
- Agile & Continuous Delivery practices
Personal Skills
- Strong architectural mindset with focus on scalability
- Collaborative leadership ability
- Analytical and business-oriented thinking
- Strong communication skills (technical & non-technical stakeholders)
- Proactive, autonomous, and accountable
Why Join Us?
- Work with best-in-class data & cloud technologies
- Influence core data architecture of a global digital platform
- Strong engineering culture focused on ownership & quality
- Hybrid work model (mostly remote)
- 25+ years of industry leadership with strong growth trajectory
Please fill the following details:
1) Current CTC
2) Expected CTC
3) Notice Period
4) Current Location
5) Reason of Change
6) Years of Experience
Kindly provide us the references for the same openings.
WhatsApp your CV at 7 5 0 3 8 6 6 1 9 6
As a Solutions Engineer/Sales Engineer, you will act as a trusted technical advisor to prospective customers in the US market. You will own the technical evaluation journey end-to-end, from the first discovery call to closing the deal, by demonstrating how our platform solves real-world data integration challenges. This role involves working closely with global customers (primarily North America ), designing scalable architectures, running tailored product demos, and building proofs-of-concept that showcase value.
Responsibilities:
- Run technical discovery calls with Heads of Data, Data Engineering Managers, and CTOs to understand their stack, pain points, and constraints. These are global conversations, primarily with customers in North America and Europe, and you will own them end-to-end.
- Design and present reference architectures showing how Hevo fits into their existing data stack (e. g., Salesforce, Postgres, GA4 Snowflake, dbt).
- Run live product demos tailored to the customer's stack. These are not scripted walkthroughs. You will need to read the room, adapt on the fly, and handle unexpected technical questions with confidence.
- Own the technical evaluation from the first conversation to the closed deal by addressing deep technical questions and earning trust with engineering teams.
- Build proofs-of-concept by configuring real pipelines from source systems (Salesforce, Outreach, Postgres, MySQL) into destinations like Snowflake or BigQuery.
- Develop deep expertise in the data integration landscape, including native solutions from AWS, GCP, and Azure (AWS Glue, Azure Data Factory, Google Cloud Dataflow) as well as other data pipeline and integration platforms, and articulate Hevo's technical advantages in a way that lands with both technical and non-technical buyers.
- Partner with Account Executives to drive technical wins and with Customer Success to ensure smooth handoffs after a deal closes.
- Share customer feedback and patterns with Product and Engineering to influence the roadmap.
Requirements:
- 2 to 6 years of hands-on experience as a Data engineer, Analytics engineer, ETL/ELT developer, or Data warehouse engineer.
- Experience building and operating real data pipelines in production, including handling source schema changes, failures, and reliability issues.
- Strong fundamentals in SQL and at least one cloud data warehouse (Snowflake, BigQuery, or Redshift).
- Experience with at least one orchestration or transformation tool (Airflow, dbt, or similar).
- Exceptional communication and presentation skills.
- This is non-negotiable. You will be the face of Hevo's technical capability to a global customer base. That means:
- Your spoken English is clear, confident, and easy to follow for an international audience.
- You are comfortable presenting to groups of 5 to 15 people, including senior technical leaders, over video calls.
- You can structure a technical narrative, not just answer questions but guide a conversation toward the right conclusion.
- You can hold your own when a customer pushes back or challenges your recommendation.
- You have presented or demoed something technical to an audience before, in any context: internal reviews, client calls, meetups, or conferences.
- Genuine interest in customer-facing work, even if you have not done it formally before.
Good to have:
- Experience with CDC tools or data integration platforms, whether cloud-native (AWS Glue, Azure Data Factory, or Google Cloud Dataflow) or third-party pipeline and integration tools.
- Exposure to multiple source system types such as CRMs, ad platforms, SaaS APIs, and OLTP databases.
- Public technical writing, conference talks, or open-source contributions.
- Prior experience in customer conversations, even informally. For example, presenting to internal stakeholders or analytics teams or working with international teams across time zones.


















