Talent.com
Tech Lead (Snowflake, Informatica PC, and Teradata)
Tech Lead (Snowflake, Informatica PC, and Teradata)Confidential • Pune, India
Tech Lead (Snowflake, Informatica PC, and Teradata)

Tech Lead (Snowflake, Informatica PC, and Teradata)

Confidential • Pune, India
17 days ago
Job description

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 : etl,powercenter,bteq,teradata,snowflake

    Skills Required

    snowflake , Shell Scripting, Informatica Powercenter, Teradata, Python

    Create a job alert for this search

    Tech Lead • Pune, India

    Related jobs
    Azure Tech Lead

    Azure Tech Lead

    Orbia Pune • pune, maharashtra, in
    The Azure Tech Lead plays a pivotal role in driving technical strategy, agile delivery, and platform excellence across enterprise data initiatives. This role is accountable for leading the end-to-en...Show more
    Last updated: 13 days ago • Promoted
    EduFund - Technical Lead

    EduFund - Technical Lead

    EduFund • Pune
    Description : We are seeking a Technical Lead to drive the technical vision and hands-on delivery of EduFund's core product platform.Responsibilities : &l...Show more
    Last updated: 30+ days ago • Promoted
    Technology Lead

    Technology Lead

    WPP • Pune, IN
    WPP OPEN is WPP's proprietary, AI-powered operating system designed to connect our people, data, and technology to deliver integrated, creative, and effective solutions for our clients.It is a stra...Show more
    Last updated: 30+ days ago • Promoted
    Data Integration Lead - ETL / Informatica

    Data Integration Lead - ETL / Informatica

    Reed and Willow • Pune
    Key Responsibilities : - Lead the design, development, and execution of enterprise-scale data integration strategies and architectures.Manage and gov...Show more
    Last updated: 30+ days ago • Promoted
    K2View Technical Lead

    K2View Technical Lead

    Confidential • Pune
    Implement new and changed applications in development, test, preproduction, and production environments.Ensure proper implementation in production environments by supporting the deployment team.Ens...Show more
    Last updated: 30+ days ago • Promoted
    Tech Lead

    Tech Lead

    Confidential • Pune
    Zinnia is the leading technology platform for accelerating life and annuities growth.With innovative enterprise solutions and data insights, Zinnia simplifies the experience of buying, selling, and...Show more
    Last updated: 30+ days ago • Promoted
    Vivid Edge Corp - Senior Data Engineer - Informatica IDMC

    Vivid Edge Corp - Senior Data Engineer - Informatica IDMC

    Confidential • Pune, India
    We are seeking a highly skilled Senior Data Engineer with hands-on experience in Informatica Intelligent Data Management Cloud (IDMC) and Informatica Intelligent Cloud Services (IICS).As a key memb...Show more
    Last updated: 17 days ago • Promoted
    Data Governance Architect - Informatica / AXON

    Data Governance Architect - Informatica / AXON

    ResourceTree Global Services • Pune
    Description : Job Summary : We are seeking a highly skilled Data Governance Architect with strong expertise in defining and lead enterprise-wid...Show more
    Last updated: 22 days ago • Promoted
    INSenior AssociateInformatica, IDMC, SQL, Python, Snowflake Data and AnalyticsAdvisoryPune

    INSenior AssociateInformatica, IDMC, SQL, Python, Snowflake Data and AnalyticsAdvisoryPune

    PricewaterhouseCoopers • Pune, Maharashtra, India
    At PwC our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. They play a crucial role in tran...Show more
    Last updated: 30+ days ago • Promoted
    Atgeir Solutions - Technology Lead - Big Data / Cloud Platform

    Atgeir Solutions - Technology Lead - Big Data / Cloud Platform

    Atgeir Solutions • Pune
    At Atgeir Solutions, we are pioneers in technological innovation, dedicated to achieving excellence in every endeavor.We are currently seeking a dynamic Technical Lead with a specialization in Big ...Show more
    Last updated: 30+ days ago • Promoted
    Sr Tech Lead

    Sr Tech Lead

    Confidential • Pune, India
    Join us a Sr Tech Lead at Barclays where you have to design, develop and improve software, utilising various engineering methodologies, that provides business, platform, and technology capabilities...Show more
    Last updated: 30+ days ago • Promoted
    Tech Lead - Azure Databricks Job

    Tech Lead - Azure Databricks Job

    Confidential • Pune, India
    YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences,...Show more
    Last updated: 30+ days ago • Promoted
    ArcOne - Team Lead - Advanced Data Systems

    ArcOne - Team Lead - Advanced Data Systems

    Confidential • Pune, India
    The Team Lead for Advanced Data Systems Delivery will lead a team responsible for delivering high-performance, scalable data solutions, with a focus on designing and optimizing data architectures f...Show more
    Last updated: 17 days ago • Promoted
    Technical Data Lead

    Technical Data Lead

    Confidential • Pune, India
    At Roche you can show up as yourself, embraced for the unique qualities you bring.Our culture encourages personal expression, open dialogue, and genuine connections, where you are valued, accepted ...Show more
    Last updated: 17 days ago • Promoted
    Technical Lead – Data Platforms

    Technical Lead – Data Platforms

    Zywave • Pune, Maharashtra, India
    Technical Lead – Data Engineering (Snowflake, SQL Server, Data Architecture).Kharadi, Pune (Work from Office – 5 Days a Week). Medallion Architecture, Data Mesh) to lead the design and implementatio...Show more
    Last updated: 4 days ago • Promoted
    Azure tech Lead

    Azure tech Lead

    Confidential • Pune, India
    Proven track record creating and responding to RFPs for data-centric projects and crafting HLDs that effectively guide development. Deep expertise in the Azure stack—Data Factory, Databricks, Synaps...Show more
    Last updated: 17 days ago • Promoted
    Tech Lead

    Tech Lead

    Entain • Pune, Maharashtra, India
    As a Tech Lead youll design develop deploy and maintain software features within your technical domain Backend or Frontend. Reporting to the Engineering Manager youll join the Product & Technolo...Show more
    Last updated: 5 days ago • Promoted
    AI Architect or Tech Lead

    AI Architect or Tech Lead

    Trigent Software Private Limited • Pune, Maharashtra, India
    AI / ML and Generative AI solutions.TensorFlow PyTorch Keras Spacy.RAG (Retrieval-Augmented Generation).Hugging Face OpenAI Google Vertex AI AWS Bedrock). Build scalable APIs using Python frameworks s...Show more
    Last updated: 30+ days ago • Promoted