TC Migration Architect

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

We are looking for Data engineer with strong expertise in Data warehousing to join our team.

Key skills : ab initio, ssis , Informatica, Hadoop and Teradata

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

Job Description

Roles & Responsibilities

• Lead project team members through all activities required to successfully deliver Informatica.
• Define technical specifications for workflows and business rules.
• Prepare detailed design documents for data migration.
• Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
• Train and mentor colleagues in Informatica implementation activities and best practices.
• Support integration, system, and user acceptance testing.
• Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
• Profile & Analyze Source Data usage using ETL tool.
• Automation, job scheduling, dependencies, monitoring.
• Configure/Script Business rules and transformation rules in ETL
• Data pipeline using IICS
• Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
• Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
• Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
• Experience in administering, supporting, and performance tuning using Informatica.

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 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.

Salesforce Metadata & Sybase Migration Specialist

Experience: 7+ years

We are looking for a senior Salesforce technical professional with deep expertise in Salesforce metadata and data migration to support a Salesforce-to-Sybase backend migration initiative.

Key Responsibilities

• Analyze Salesforce metadata and understand how it drives forms, objects, fields, layouts, and data structures.
• Extract and interpret Salesforce metadata for migration into the Sybase backend.
• Define and validate Salesforce-to-Sybase data and schema mappings.
• Support migration strategy, data extraction, transformation, and validation.
• Work closely with engineering and architecture teams to identify dependencies, gaps, and migration risks.
• 
  

Required Skills

• 7+ years of Salesforce technical experience.
• Strong hands-on experience with Salesforce Metadata API / Salesforce metadata.
• Deep understanding of Salesforce objects, fields, page layouts, record types, validation rules, and metadata-driven configurations.
• Experience with data migration, metadata extraction, schema mapping, and backend integrations.
• Strong Sybase / SQL knowledge preferred.
• Experience working on complex Salesforce migration or integration projects.
• 
  

Ideal Profile: Salesforce Technical Architect, Salesforce Technical Lead, or Senior Salesforce Developer with strong metadata and migration expertise.

Job Description

We are looking for an experienced Data Engineer with strong expertise in Python, ETL, SQL, CI/CD, and DevOps to design, develop, and maintain scalable data pipelines and data processing solutions.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Develop data processing solutions using Python.
• Write complex and optimized SQL queries, stored procedures, and data transformations.
• Build and maintain data ingestion and integration workflows.
• Implement data quality, validation, monitoring, and error-handling processes.
• Develop and maintain CI/CD pipelines for data engineering applications.
• Work with DevOps tools and practices for automated build, deployment, and infrastructure management.
• Collaborate with data analysts, data scientists, software engineers, and business teams.
• Optimize data pipelines for performance, reliability, and scalability.
• Troubleshoot production data issues and ensure timely resolution.
• Follow best practices for version control, code quality, testing, and deployment.

Mandatory Skills

• Python
• ETL
• SQL
• CI/CD
• DevOps
• Git / Version Control
• Strong problem-solving and debugging skills

Mandatory Skills (Must Have)

• SQL and Database Design (5+ years in enterprise data platforms)

• Python development for automation and platform services (5+ years)

• Linux administration and Shell Scripting in production environments

• Metadata-driven systems and data management platform experience

• Technical leadership of offshore or distributed development teams Wissen Technology

• System analysis, troubleshooting, and production support expertise

• Metadata onboarding, integration, and governance processes

• Stakeholder management and delivery ownership across multiple teams

Key Responsibilities

• Lead developers supporting the Pantheon Metadata platform and related services

• Own end-to-end delivery of metadata onboarding and enhancement initiatives

• Design scalable metadata management solutions and automation capabilities

• Collaborate with architecture, infrastructure, and application teams for enterprise integration

• Participate in solution design reviews and establish development best practices

• Prioritize enhancements with business stakeholders and manage delivery commitments

• Provide production support, troubleshooting, and platform stability improvements Wissen Technology

• Drive modernization initiatives related to metadata lifecycle management

About Solutionara

Solutionara is an AI-led IT Consulting and Technology Services organization delivering enterprise transformation through Cloud, Integration, Data Engineering, Digital Experience, AI, and Enterprise Applications.

Headquartered in the United States with a Global Delivery Center (GDC) in Noida, India, Solutionara partners with enterprise organizations across retail, manufacturing, distribution, consumer goods, and other industries to design, implement, and support scalable technology solutions.

As a rapidly growing consulting organization, we foster a culture of ownership, innovation, collaboration, and continuous improvement, empowering our teams to contribute beyond their immediate responsibilities while delivering exceptional value to our global clients.

Every team member is expected to think like a consultant and business problem solver—understanding client objectives, challenging assumptions when appropriate, leveraging AI responsibly, and continuously identifying opportunities to improve quality, productivity, and customer outcomes.

AI is embedded into how we work, but it is an enabler—not a replacement for expertise, critical thinking, or accountability.

Role Overview

Solutionara is seeking a Senior Data Engineer with strong data engineering and database expertise to design, build, optimize, and support enterprise-scale data solutions.

This is a hands-on engineering position requiring strong SQL, Python, ETL/ELT, database, cloud, and troubleshooting capabilities. The engineer will work closely with technical leads and client stakeholders while taking ownership of major engineering components.

Location: Noida, India – Onsite | Employment Type: Full-Time | Experience: 6–9 Years

Key Responsibilities

Data Engineering

• Design, develop, test, deploy, and support scalable ETL/ELT pipelines.
• Build ingestion and transformation solutions across databases, APIs, files, and enterprise applications.
• Develop high-quality SQL and Python-based data processing solutions.
• Implement batch and incremental data-processing patterns.
• Develop reusable engineering components and frameworks.
• Support complex data migration and transformation activities.
• Perform source-to-target mapping and technical data analysis.
• Implement pipeline logging, monitoring, exception handling, and recovery mechanisms.

Database & Platform Engineering

• Design and optimize relational database schemas and data structures.
• Analyze and improve SQL/query performance.
• Support indexing, partitioning, storage optimization, and database performance.
• Implement appropriate database security and access controls.
• Support database monitoring, availability, backup/recovery, and operational requirements in collaboration with infrastructure/platform teams.
• Troubleshoot database and pipeline performance issues.
• Contribute to cloud data-platform configuration and optimization.

Data Quality

• Implement automated validation and data-quality controls.
• Develop reconciliation processes between source and target systems.
• Identify duplicate, incomplete, inconsistent, and invalid data.
• Implement cleansing, standardization, validation, and exception-management logic.
• Work with technical and business stakeholders to understand and implement business data rules.

Technical Delivery

• Convert technical designs into reliable production solutions.
• Participate in technical design and code reviews.
• Mentor junior/mid-level engineers.
• Support estimation and technical planning.
• Troubleshoot complex production and integration issues.
• Collaborate with technical leads, application teams, DevOps, QA, BI, and client teams.
• Document technical designs, mappings, configurations, operational procedures, and engineering decisions.

Consulting & AI-Led Working

• Understand the business purpose behind assigned engineering requirements.
• Raise risks, assumptions, dependencies, and potential improvements proactively.
• Communicate effectively with client and internal stakeholders.
• Use AI-assisted tools to improve coding, testing, analysis, documentation, and troubleshooting productivity.
• Independently verify AI-generated code and recommendations before implementation.
• Identify opportunities for engineering automation and process improvement.

Required Qualifications

• 6–9 years of experience in data engineering, database engineering, data integration, or related areas.
• Advanced SQL skills.
• Strong hands-on Python experience.
• Strong ETL/ELT development experience.
• Strong relational database knowledge, such as SQL Server, PostgreSQL, Oracle, or equivalent.
• Experience with data modeling and database design.
• Experience with AWS, Azure, or another major cloud platform.
• Experience with modern data technologies such as Databricks, Snowflake, Redshift, Synapse, Glue, ADF, Airflow, dbt, or equivalent.
• Experience with performance tuning and optimization.
• Experience with data validation and reconciliation.
• Strong troubleshooting and analytical skills.
• Ability to take ownership of engineering deliverables with limited supervision.

Preferred Qualifications

• Experience working with enterprise ERP, CRM, PIM, PLM, MES, or related systems.
• Experience with manufacturing, retail, distribution, or consumer-goods data.
• Experience with CI/CD and infrastructure/platform engineering practices.
• Experience with API and event-driven integrations.
• Previous consulting or technology-services experience.

What Success Looks Like

• Pipelines and databases perform reliably at enterprise scale.
• Engineering solutions are maintainable, reusable, and well documented.
• Data issues are detected and addressed systematically.
• Junior engineers receive effective technical guidance.
• Problems are owned through resolution rather than simply escalated.
• Engineering decisions reflect both technical requirements and client business objectives.

Technical Lead 

Job Description 

Role Overview 

We are seeking a highly skilled Data Engineering Lead with minimum of 5 years of hands-on experience in Azure data engineering, data warehousing, and automation-driven  integration. The ideal candidate should be a proven technical lead, capable of driving end-to-end 

project delivery and working closely with customer teams. This is a Work from Office / Customer Site role. 

Roles and Responsibilities 

• Lead the design, development, and delivery of data engineering and automation projects. 

• Architect and implement ETL/ELT pipelines using Azure Data Factory. 

• Design and manage enterprise data warehouses including dimensional modeling and 

schema optimization. 

• Manage Azure components including Storage Accounts, Data Lakes, Azure SQL, and Synapse. 

• Drive automation initiatives across data ingestion and transformation workflows. 

• Collaborate with business and technical stakeholders to translate requirements into scalable solutions. 

• Mentor team members and enforce engineering best practices. 

• Serve as the technical anchor responsible for ensuring high-quality, on-time delivery. 

Skills and Qualification 

• Strong hands-on experience with Azure Data Factory, Azure Storage, Azure SQL/Synapse. 

• Deep understanding of data warehousing concepts: star/snowflake schemas, fact/dimension modeling. 

• Experience with automation-led data engineering solutions. 

• Strong troubleshooting, optimization, and analytical skills. 

• Excellent communication and stakeholder management abilities. 

• Proven experience as a Technical Lead leading teams and delivery. 

Must Have 

• Min of 5 years of relevant data engineering experience. 

• Strong Azure Data Engineering and Data Warehousing expertise. 

• Proven Technical Lead experience. 

• Ability to work from office and customer site. 

• Strong ownership mindset with a focus on quality and delivery excellence.