Back to Browse Jobs
TeamPlus Staffing Solution
Create a free account
One signup unlocks everything for this job:
- See your personalized profile match score
- See the skills this role is missing for you
- Apply to this job and track your application
- Generate an AI cover letter for this role
Chennai · Hybrid · 5-8 Yrs · 5 days ago
Unknown · Pune, India
2 open roles1 posted in 7d2 in 30d
Work-life balance 4.8Compensation & benefits 5.0Culture & values 4.8
Hiring: Engineering
What employees say
+ Supportive environment, friendly staff, Good place to start as freshers
− Nothing, Everything is great about this company. May it thrive
More reviews on the company profile.
Job description
Hybrid
Overview
Lead Data Engineer /Solution Architect - Chennai & Bagalore
Responsibilities
- Teamplus Staffing Solution
- Chennai, Tamil Nadu, India
- design, build, deploy, monitor, and operate.
- window functions, multi-layered CTEs, CASE-driven logic, COALESCE/NULLIF, type casting, and date/timestamp handling.
Qualifications
- 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:
- 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.
- Build Python ETL tooling:
- Integrate with Google Drive/Sheets APIs; build YAML-driven pipeline configs; handle Piper staging/user_staging quirks.
- 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 .
Verify Python for this role
Free PRACTICE for Python adds a verified skill signal that can boost how roles like this rank for you — optional, not required to browse or apply.
Sign up — verify Python free →Want match scores and deeper insight? Create a free candidate profile
Job application FAQ
Last updated 27 October 2026
- How do I apply for Lead Data Engineer /Solution Architect - Chennai & Bagalore at TeamPlus Staffing Solution?
- Open this job on Feedback AI and sign up free (or sign in). You can apply from the job detail page; match scores and skill gaps appear when your profile is complete. TeamPlus Staffing Solution may attach structured assessments to interview rounds after you apply.
- Does Feedback AI show a match score for this Lead Data Engineer /Solution Architect - Chennai & Bagalore role?
- Yes after you add a resume or skills. Match score ranks this role against your profile — skills met, gaps, level, and location — so you prioritise applications where fit is strongest.
- Is Lead Data Engineer /Solution Architect - Chennai & Bagalore remote or on-site in Chennai, Tamil Nadu?
- This listing is marked hybrid with location Chennai, Tamil Nadu. Confirm details on the job description before applying.
- What skills matter for this Lead Data Engineer /Solution Architect - Chennai & Bagalore role at TeamPlus Staffing Solution?
- This is a lead Lead Data Engineer /Solution Architect - Chennai & Bagalore role. Key skills include Hybrid. Feedback AI highlights matched vs missing skills on your profile after signup.