Show more filters
Banner image for PibyThree

Technical Lead - Python/ETL

PibyThree

PibyThree
Job Type   /   Job Level
Full-time   /   Junior Executive
Job Location
Pune, Maharashtra, India
A free Jobstore account is required to proceed to the employer site.
Description

About the job :

Key Responsibilities

  • Lead the design, development, and optimization of end-to-end data pipelines and ETL workflows.
  • Architect data integration solutions leveraging Snowflake, Informatica PowerCenter, and Teradata.
  • Collaborate with business and technical teams to gather requirements and translate them into technical designs.
  • Drive performance tuning, error handling, and automation across ETL and data warehouse layers.
  • Provide technical leadership to developers, mentor junior engineers, and enforce best practices.
  • Ensure data quality, consistency, and security across data environments.
  • Support migration and modernization initiatives from legacy systems to cloud-based data platforms.
  • Participate in Agile/Scrum ceremonies, sprint planning, and code reviews.

Required Skills & Experience

Core Expertise (Must-Have) :

  • Snowflake (3+ years) : Hands-on experience with SnowSQL, Time Travel, cloning, query profiling and optimization, and secure Data Sharing. Able to design schemas and implement performance-tuned solutions.
  • Informatica PowerCenter (3+ years) : Proficient with Designer, Workflow Manager/Monitor, mappings and transformations, session/workflow tuning, error handling and deployments.
  • Teradata (3+ years) : Strong SQL skills including BTEQ scripting, stored procedures, performance-tuned joins, indexing/collect stats, and utilities such as FastLoad, MultiLoad, TPT.
  • SQL & Data Modeling : Demonstrated ability to design normalized and dimensional models (3NF, Star, Snowflake) and write complex, performance-oriented SQL for analytics.

Required Supporting Skills

  • Shell scripting (Bash/Ksh) : Practical experience automating ETL jobs, log handling, and job orchestration (typically 2+ years).
  • Python for data engineering : Proficient in writing production-quality Python scripts for ETL and data processing (typically 2+ years).
  • Familiar with commonly used libraries (e.g., pandas, SQLAlchemy), exception handling, basic unit testing, and performance considerations.

Preferred / Nice-to-Have

  • Experience with CI/CD and version control : Git (branching strategies) and building/maintaining pipelines (Jenkins, GitLab CI, Azure DevOps).
  • Familiarity with cloud data platforms and migrations (AWS/GCP/Azure) and cloud-native storage/compute services.
  • Experience with orchestration tools (Apache Airflow, Control-M) and monitoring/alerting solutions.
  • Prior experience working in Agile/Scrum teams, performing code reviews, and mentoring team members.

Skills : (ref:hirist.tech)
A free Jobstore account is required to proceed to the employer site.
Jobs in India   »   Jobs in Maharashtra   »   Jobs in Pune   »   Technical Lead - Python/Etl

More jobs

People also search