Job Title: Lead Data Engineer – Migration & Transformation (Enterprise Programs)
Location: Noida, India (On-site – Global Delivery Center, Sector 62)
Experience: 6 – 10 years (flexible for strong enterprise consulting profiles)Employment Type: Full-time
About Solutionara
Solutionara is a U.S.-based IT Consulting and Technology Services firm with a Global Delivery Center in Noida, India.
We partner with enterprises to deliver transformation across integration, data, and digital experience platforms.
As a fast-scaling consulting firm, we operate with high ownership, lean teams, and disciplined execution. We are also evolving toward an AI-enabled delivery model, where governance, reporting, and decision-making are increasingly driven by automation and data intelligence.
Role Summary
We are hiring a Lead Data Engineer to drive execution of data migration and transformation programs across enterprise systems.
This role combines:
- Hands-on data engineering
- Migration execution leadership
- Collaboration with architects and program teams
You will act as:
- Lead engineer for migration pipelines
- Execution owner across ETL and data transformation
- Key contributor to AI-enabled data workflows
Key Responsibilities
Data Engineering & Migration Execution
- Build and manage:
- ETL/ELT pipelines
- Data ingestion and transformation workflows
- Execute data migration across:
- ERP systems
- Data platforms
- PIM/DAM/CDP ecosystems
- Ensure:
- Data consistency
- Data validation and reconciliation
- High-performance pipeline execution
Transformation & Data Quality
- Perform:
- Data profiling and cleansing
- Data mapping and transformation
- Implement frameworks for:
- Data validation and error handling
- Data quality monitoring
AI-Driven Engineering Practices
- Use AI tools to:
- Automate data transformation logic
- Detect anomalies in datasets
- Improve data quality and consistency
- Contribute to:
- AI-enabled automation frameworks
- Intelligent data enrichment pipelines
Platform & Integration Work
- Work with:
- APIs, middleware, and integration services
- Support migration into:
- Cloud data platforms (Snowflake, Redshift, BigQuery)
Collaboration & Leadership
- Work closely with:
- Architects
- Program managers
- Data and AI teams
- Mentor junior engineers and ensure delivery quality
Required Qualifications (Screening Critical)
- 6 –10 years in data engineering/ETL/migration roles
- Strong hands-on experience with:
- ETL/ELT tools (Informatica,Talend, dbt, Databricks, etc)
- SQL and data transformation
- Cloud platforms (AWS, Azure, GCP)
- Experience in:
- Data migration projects
- Integration-heavy environments
- Strong debugging and problem-solving skills
Preferred Qualifications (Differentiators)
- Experience with:
- Snowflake / Databricks / modern data platforms
- Exposure to:
- AI tools in data workflows
- Experience in:
o PIM/DAM/CDP ecosystems
- Prior experience in consulting environments
Ideal Candidate Profile
You are:
- A hands-on builder who enjoys solving data challenges
- Comfortable working in fast-paced, evolving environments
- Strong in execution with attention to data quality
- Interested in applying AI to improve engineering efficiency
Success Metrics
- Accuracy and completeness of migrated data
- Stability and performance of pipelines
- Reduced manual effort via automation
- Timely delivery of migration milestones
Pay: ₹500,000.00 - ₹1,200,000.00 per year
Benefits:
- Cell phone reimbursement
- Internet reimbursement
- Paid sick time
- Paid time off
- Provident Fund
Ability to commute/relocate:
- Noida, Uttar Pradesh (Noida): Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
- Which ETL/ELT tools have you used in production? (Select all that apply)
Informatica
Talend
dbt
Azure Data Factory
AWS Glue
Custom pipelines (Python/SQL)
None
- Describe one data migration project you worked on. What was your role and what tools/technologies did you use?
- Which data platforms have you worked with? (Select all that apply)
Snowflake
Databricks
Redshift
BigQuery
Traditional RDBMS (Oracle, SQL Server, MySQL)
None
- Have you used AI tools or automation in your data engineering work? What tools have you used?
Work Location: In person
