An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
AI summary of this job
Beta Read in 10 secondsA Lead Database Engineer role at Fulcrum Digital in Pune for people with 10–12 years of experience. You'll lead database migration, consolidation, and data engineering using python, sql, databricks, etl, and ssrs.
- Pune
- Work from office
- 10–12 years
- DP-300 or DP-203
What you'll do
- Lead database migration and consolidation
- Perform data profiling and transformation
- Ensure data integrity and security
Good fit if you
- Have 10–12 years of experience
- Know python, sql, databricks, and etl
- Hold DP-300 or DP-203 certification
AI-generated from the job description. Check the full description before you apply.
Job Description
Job Title: Lead Database Engineer
Job Summary
We are looking for a Lead Database Engineer with strong experience in database migration, consolidation, and data engineering. The role will lead the migration of multiple legacy databases into a unified target schema while ensuring data integrity, reconciliation, performance, and production readiness.
Key Responsibilities- Lead end-to-end migration and consolidation of multiple legacy databases into a single target schema.
- Perform data profiling, source-to-target mapping, transformation, and master data/entity resolution.
- Develop and execute full-load, incremental, delta, and CDC-based migration processes.
- Design reconciliation processes covering row counts, checksums, control totals, financial balancing, and exception reporting.
- Develop migration runbooks, rollback plans, rehearsal strategies, and production cutover plans.
- Execute migrations across DEV, QA, UAT, and Production environments.
- Develop and optimize complex T-SQL, stored procedures, functions, triggers, indexes, and queries.
- Work with SQL Server/MSSQL, IBM DB2, PostgreSQL, and Oracle databases.
- Utilize Azure SQL, Azure Data Factory, SSIS, Azure Storage, Azure Key Vault, DMA, and Azure Database Migration Service.
- Implement database CI/CD using SSDT/DACPAC, Flyway/Liquibase, Azure DevOps, or GitHub Actions.
- Ensure database security, data masking, encryption, RBAC, and audit requirements.
- Assess the impact of schema changes on Power BI, SSRS, batch interfaces, and downstream applications.
- Use Python/PowerShell and AI-assisted tools for migration automation, reconciliation, and engineering productivity.
- Provide technical leadership and communicate migration risks, data issues, and reconciliation results to stakeholders.
- 10–12 years of database/data engineering experience with at least 4 end-to-end production data migrations.
- Expert knowledge of Azure SQL, SQL Server 2016+, T-SQL, database internals, performance tuning, indexing, execution plans, statistics, and partitioning.
- Mandatory experience consolidating multiple independent databases into a single target schema.
- Strong experience in ETL, data migration, data reconciliation, master data management, entity resolution, and data quality.
- Hands-on experience with SQL Server/MSSQL, IBM DB2, PostgreSQL, and Oracle databases.
- Strong experience with Azure SQL, Azure Data Factory, SSIS, Azure Storage, and Azure Key Vault.
- Experience with DMA and Azure Database Migration Service is preferred.
- Experience with database DevOps, CI/CD, schema-as-code, and version control.
- Strong scripting skills in Python and/or PowerShell.
- Good understanding of database security, encryption, data masking, RBAC, and data privacy.
- Strong communication, documentation, troubleshooting, and stakeholder management skills.
- Practical experience using AI-assisted coding/data tools for SQL, mappings, migration scripts, and documentation.
- Experience in Insurance, F&I, vehicle service contracts, warranty, claims, billing, or dealer remittance.
- Experience with multi-tenant data models and complex business rules.
- Exposure to Azure Synapse, Databricks, or Microsoft Fabric.
- Experience with Redgate, ApexSQL, dbForge, or similar database comparison tools.
- Ability to understand Angular/.NET application code and trace data access paths.
- DP-300 or DP-203 certification mandatory.
Skills
PythonData IntegrityData MigrationData PrivacyData ProfilingEtlSsrsData ManagementAiSqlDatabricksIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
Fulcrum Digital is a leading IT service and business platform company. We partner with global companies from diverse industries, including banking and financial services, insurance, higher education, food services, retail, manufacturing, and eCommerce. With expertise in digital transformation, machine learning, and emerging technologies, we offer a consulting-led, integrated suite of enterprise-grade software products, services, and solutions.
Founded in 1999, Fulcrum Digital has over 1000 employees, empowering more than 100 global clients from its facilities in the US, LATAM, Europe, and India. Our baked-in agility, technology prowess, and innovation culture enable us to deliver business value to clients – rapid digital acceleration, faster products to the market, reduced cost of ownership, and scale businesses beyond geographies. As an expeditious company, we continuously adapt and mature our practice, striving to become the leading digital transformation authority in the global marketplace.
Fulcrum Digital is a leading platform and digital solution engineering company, uniquely positioned to deliver on the end-to-end transformation process from technology consulting, enterprise application & platform provision, and full-scale implementation.
As a technology agnostic digital partner, the Fulcrum Digital Group is comprised of six industry-specialized consortiums designed to offer deep expertise and tailored offerings to each vertical, whilst maintaining a connected global Centre of Excellence to allow clients to benefit from our multi-industry vantage point.
Similar Jobs
View allLooking for something similar?
New Data Science Analytics & Machine Learning roles in Pune.
One email a day. Unsubscribe any time.

