Lead Data Engineer /Solution Architect - Chennai & Bagalore
Teamplus Staffing Solution
Job Description & Responsibilities
Lead Data Engineer /Solution Architect - Chennai & Bagalore
Company: Teamplus Staffing Solution
Job Location: Chennai, Tamil Nadu, India
Employment Type: Full-time
Experience Required: 8+ years
Salary: 32L36L a year
About Teamplus Staffing Solution
Hi,We are having opening for Data Engineer Solution Architect / Lead
Job Summary
We're looking for a Senior Data Engineer with strong data architecture and system design skills to design, build, and own end-to-end production pipelines powering analytics and decision-making across the org. The role centers on deep Python + SQL expertise, robust transaction-level fact tables, and rigorous data quality and auditability, ideally within a finance, risk, or compliance data domain
Working Days
Monday Friday
Job Timing: 9AM 6PM
Position / Designation
Data Engineer Solution Architect
QualificationBachelor's degree in Computer Science, Information Technology, Engineering, or a related technical field
Years of Experience8+ Years Permanent / Contract (If contract, period )Permanent Full Time
Office / Remote / Hybrid
Bnagalore & chennai
Number of post2Gender
Male / Female
Annual CTC / Salary 32 L.p.a Selection Process1- Total 3 Technical round 2- 2 rounds evaluation with LV (we can plan to take this together based on panel availability) & 1 with client
Job Role & ResponsibilityOwn data architecture and system design decisions for pipelines and data models - grain, partitioning, schema evolution, and scalability tradeoffs.
Take end-to-end ownership of pipelines in production: design, build, deploy, monitor, and operate.
Design and build transaction tables (append-only, immutable event/transaction-grain fact tables) alongside standard fact/dimension models using medallion (bronze/silver/gold) architecture.
Build and support pipelines for finance, risk, or compliance use cases where accuracy, auditability, and data lineage are critical.
Implement data quality and auditability controls
validation checks, reconciliation logic, anomaly detection, and audit trails for every pipeline you own.
Write complex, cross-dialect SQL (MySQL + PostgreSQL): window functions, multi-layered CTEs, CASE-driven logic, COALESCE/NULLIF, type casting, and date/timestamp handling.
Build idempotent reload patterns (DELETE+INSERT), UNION ALL/set operations, and templated (Jinja-style) SQL including handling for late-arriving/corrected transaction records without double-counting.
Orchestrate Airflow-style DAGs (Pipeline/Base
Task, External Task
Sensor for cross-pipeline deps) with secure credential handling via uSecret.
Build Python ETL tooling
pandas (CSV DB), SQLAlchemy + raw drivers (MySQLdb, psycopg2), type hints/dataclasses, class-based pipeline design.
Integrate with Google Drive/Sheets APIs; build YAML-driven pipeline configs; handle Piper staging/user_staging quirks.
Own CI/CD for pipelines via standard Git workflows.
Skills
Strong data architecture and system design skills to make sound tradeoffs on modeling, partitioning, and scalability, not just write queries.
Demonstrated end-to-end production ownership of data pipelines from design through deployment, monitoring, and operational support.
Expert-level Python + SQL as the primary toolset.
Hive/Hadoop is a nice-to-have only.
Robust data quality and auditability practices - validation, reconciliation, anomaly detection, audit trails.
Experience working with finance, risk, or compliance data - comfort with the heightened accuracy, auditability, and data-lineage requirements typical of these domains.
Proven experience designing and building transaction/fact tables.
Expert SQL (window functions, CTEs, CASE logic, cross-dialect MySQL/PostgreSQL).
Strong Python (pandas, SQLAlchemy, type hints/dataclasses, class-based pipelines).
Airflow-like orchestration experience (Piper/uWorc a plus).
Solid data modeling fundamentals (fact/dim, normalization, medallion architecture).
YAML-based config experience; standard CI/CD and Git workflows
Joining Date
Need Immediate to 1 Month .
About Teamplus Staffing Solution
Required Skills
Job Details
Posted by
N/A
Posted on:
23 Oct 2026
About Teamplus Staffing Solution
More open roles
- Senior Software Engineer (Python/Node.JS , AWS)Autodesk · India
- IT Intern - Software Development, Python & AI/MLAI SAMRAT · India
- Ansible & Python Open-source Developer for GamingHartbridge Evergrove Placements · Farrukhabad, Uttar Pradesh, India
- Senior Full Stack Developer (Python, React.js & Azure, AI)Robert Bosch · India
- Specialist System Engineering (Devops Engineer, CICD, Kubernetes, containers, React, Python, API, Deployment + Development + Automation, GitHub PipelinesAT&T · Bengaluru, Karnataka, India
- Data Scientist (Python, ML, SQL) (Bhilai)Workers Town · Raipur, Chhattisgarh, India