Solutionara is hiring 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. You will work closely with technical leads and client stakeholders while taking ownership of major engineering components.
Location: Noida, India (on-site). Experience: 6–9 years. Employment: full-time.
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 in Noida, India, we partner with enterprise organizations across retail, manufacturing, distribution, and consumer goods. Every team member is expected to think like a consultant and business problem solver. AI is embedded into how we work, but it is an enabler, not a replacement for expertise, critical thinking, or accountability.
What You’ll Do
Design, develop, test, deploy, and support scalable ETL/ELT pipelines across databases, APIs, files, and enterprise applications.
Develop high-quality SQL and Python data-processing solutions, including batch and incremental patterns.
Build reusable engineering components and frameworks, and support complex data migration and transformation work.
Implement pipeline logging, monitoring, exception handling, and recovery mechanisms.
Design and optimize relational database schemas, and improve SQL and query performance through indexing, partitioning, and storage optimization.
Implement database security and access controls, and support monitoring, availability, and backup/recovery with platform teams.
Troubleshoot complex database, pipeline, production, and integration issues.
Implement automated validation, data-quality controls, and source-to-target reconciliation.
Take part in technical design and code reviews, support estimation and planning, and mentor junior and mid-level engineers.
Document technical designs, mappings, configurations, operational procedures, and engineering decisions.
Raise risks, assumptions, and dependencies proactively, and communicate effectively with client and internal stakeholders.
Use AI-assisted tools to improve productivity, and independently verify AI-generated code and recommendations before implementation.
Required Qualifications
6–9 years of experience in data engineering, database engineering, data integration, or related areas.
Advanced SQL skills and 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.
AWS