SQL Technical Lead

2 weeks ago


Pune, India Response Informatics Limited Full time

Role : SQL Technical Lead.

Location : Pune (Onsite).

Worked in Big data/ Hadoop ecosystem.

Exp range 6 to 8 yearsTech lead with some management exp - 8-10 experience


Strong relevant experience of 8 years in pySpark, Bigdata with ADLS Gen 2.

Key Responsibilities :


- Lead and mentor a team of SQL developers.


- Provide technical guidance and solutions to complex SQL problems.


- Oversee the design, development, and implementation of SQL solutions.


- Ensure adherence to best practices, coding standards, and performance optimization techniques.


- Strong proficiency in PySpark for data processing and analysis.


- In-depth knowledge of the Hadoop ecosystem (HDFS, YARN, MapReduce, Spark).


- Experience with Azure Data Lake Storage Gen2 (ADLS Gen2) for data storage and retrieval.


- Write efficient and optimized SQL queries for data extraction, transformation, and loading (ETL).


- Develop complex SQL procedures, functions, and triggers to automate data processes.


- Perform data quality checks and validation to ensure data accuracy and integrity.


- Identify and resolve performance bottlenecks in SQL queries and data pipelines.


- Implement indexing strategies and query optimization techniques to improve query performance.


- Collaborate with business analysts, data engineers, and other stakeholders to understand requirements and deliver solutions.


- Work closely with the team to ensure smooth project execution and timely delivery.


Required Skills and Experience :


- Strong proficiency in SQL, including advanced SQL concepts and functions.


- In-depth knowledge of PySpark for data processing and analysis.


- Experience with the Hadoop ecosystem (HDFS, YARN, MapReduce, Spark).


- Hands-on experience with Azure Data Lake Storage Gen2 (ADLS Gen2).


- Strong understanding of data warehousing and data modeling concepts.


- Experience with ETL processes and data pipelines.


- Excellent problem-solving and analytical skills.


- Strong communication and interpersonal skills.


- Ability to work independently and as part of a team.


Preferred Skills :


- Experience with cloud platforms like Azure or AWS.


- Knowledge of data visualization tools (Power BI, Tableau, etc.).


- Experience with machine learning and AI techniques.


- Certifications in relevant technologies (e.g., Azure Data Engineer, Hadoop Developer).

(ref:hirist.tech)
  • Technical Lead

    2 weeks ago


    Pune, Maharashtra, India SGS Technical Services Pvt. Ltd Full time

    We are seeking an experienced Technical Lead to join our team at SGS Technical Services Pvt. Ltd. in Pune. This is a fantastic opportunity for a seasoned professional to lead our software engineering efforts and drive innovation.About the RoleThis is a challenging role that requires strong leadership skills, technical expertise, and experience in managing...

  • Technical lead

    4 weeks ago


    Pune, India InCommon Full time

    Job Type: Full-Time Location: Pune, On-site Company: Wednesday Solutions Annual Compensation: INR 20,00,000 - 25,00,000 LPA ️ Experience Required: 4 to 6 Years of relevant experience ⌛ Hiring Timeline: 15 days Hiring Process: Resume review - Initial screen - Interviews (2) About the company: We are hiring on behalf of an India-based...

  • Technical lead

    4 weeks ago


    Pune, India InCommon Full time

    Job Type: Full-TimeLocation: Pune, On-siteCompany: Wednesday SolutionsAnnual Compensation: INR 20,00,000 - 25,00,000 LPA️ Experience Required: 4 to 6 Years of relevant experience⌛ Hiring Timeline: 15 daysHiring Process: Resume review - Initial screen - Interviews (2)About the company:We are hiring on behalf of an India-based Webflow design and...

  • Technical lead

    2 weeks ago


    Pune, India Peoplefy Full time

    About the Company - US Healthcare- Product based company About the Role - this role involves technical project leading, requirement & functional analysis & near- shore support. Responsibilities - This senior level individual contributor is primarily responsible for serving as the lead technical expert on project teams Contributing to...

  • Technical lead

    2 weeks ago


    Pune, India Peoplefy Full time

    About the Company - US Healthcare- Product based companyAbout the Role - this role involves technical project leading, requirement & functional analysis & near- shore support.Responsibilities -This senior level individual contributor is primarily responsible for serving as the lead technical expert on project teamsContributing to technical direction for...

  • Technical Lead

    4 weeks ago


    pune, India InCommon Full time

    Job Type: Full-TimeLocation: Pune, On-siteCompany: Wednesday SolutionsAnnual Compensation: INR 20,00,000 - 25,00,000 LPA️ Experience Required: 4 to 6 Years of relevant experience⌛ Hiring Timeline: 15 daysHiring Process: Resume review - Initial screen - Interviews (2)About the company:We are hiring on behalf of an India-based Webflow design and...

  • Technical Lead

    4 weeks ago


    Pune, India InCommon Full time

    Job Type: Full-Time Location: Pune, On-site Company: Wednesday Solutions Annual Compensation: INR 20,00,000 - 25,00,000 LPA ️ Experience Required: 4 to 6 Years of relevant experience ⌛ Hiring Timeline: 15 days Hiring Process: Resume review - Initial screen - Interviews (2) About the company: We are hiring on behalf of an India-based...

  • Sr Technical Lead

    6 months ago


    Pune, India BirlaSoft Full time

    . Python Technical Lead 7 to 9 years of experience Essential: •Experience working with Python (Pandas, NumPy, Openpyxl, logger, Asynchronous methods, CSV, CSV to DF) •Good understanding on Data Structures •Basic knowledge on Insurance domain. •Create and maintain technical documentation, design documents, and code documentation •Conduct...


  • pune, India Fusion Practices Full time

    About Us: Fusion Practices is a leading IT consultancy delivering HR and finance transformations across financial services, insurance, banking, construction, and the public sector. Our expertise lies in Oracle Cloud ERP, HR & Payroll. We have won several awards. Fusion Practices won the ERP Innovation of the Year award for our GrantsNOW SAAS product....


  • Pune, India Fusion Practices Full time

    About Us: Fusion Practices is a leading IT consultancy delivering HR and finance transformations across financial services, insurance, banking, construction, and the public sector. Our expertise lies in Oracle Cloud ERP, HR & Payroll. We have won several awards. Fusion Practices won the ERP Innovation of the Year award for our Grants NOW SAAS product....


  • Pune, Maharashtra, India exl Full time

    Job Overview: We are seeking a seasoned Senior .NET Engagement Lead to oversee and manage the end-to-end delivery of .NET-based projects. This role involves collaborating with cross-functional teams to deliver high-quality software solutions that meet client needs and align with business objectives.About the Role: As a Senior Technical Project Lead, you will...


  • Pune, Maharashtra, India Virtusa Full time

    Job Title: Pega CDH Technical LeadAbout the Role:Virtusa is seeking a highly skilled Pega CDH Architect to lead our technical team in developing innovative solutions.Key Responsibilities:10+ years of software development experience specifically in Pega CDH, with expertise in multiple programming life cycles such as Waterfall, Agile, and Scrum.6+ years of...


  • Pune, India Virtusa Full time

    Technical Lead with Cloud GCP - CREQ193209 Description Mandatory Skills Technical Lead with Cloud GCP Experience 8 to 12 Years Experience in working within an agile, multidisciplinary devops team Hadoop knowledge, NiFi/Kafka experience Expert in Python, Data Flow, Pubsub, Big Query Expert in SQL Must have good Experience/knowledge on GCP components like GCS,...


  • Pune, India Fusion Practices Full time

    About Us:Fusion Practices is a leading IT consultancy delivering HR and finance transformations across financial services, insurance, banking, construction, and the public sector. Our expertise lies in Oracle Cloud ERP, HR & Payroll.We have won several awards. Fusion Practices won the ERP Innovation of the Year award for our GrantsNOW SAAS product....


  • pune, India Fusion Practices Full time

    About Us:Fusion Practices is a leading IT consultancy delivering HR and finance transformations across financial services, insurance, banking, construction, and the public sector. Our expertise lies in Oracle Cloud ERP, HR & Payroll.We have won several awards. Fusion Practices won the ERP Innovation of the Year award for our GrantsNOW SAAS product....


  • Pune, India Fusion Practices Full time

    About Us:Fusion Practices is a leading IT consultancy delivering HR and finance transformations across financial services, insurance, banking, construction, and the public sector. Our expertise lies in Oracle Cloud ERP, HR & Payroll.We have won several awards. Fusion Practices won the ERP Innovation of the Year award for our Grants NOW SAAS product....

  • Technical Architect

    1 month ago


    Pune, Maharashtra, India SGS Technical Services Pvt. Ltd Full time

    About the Role:This is a challenging and rewarding opportunity for an experienced Technical Lead to join our team at SGS Technical Services Pvt. Ltd. As a Tech Lead, you will be responsible for providing technical guidance and support to our development team, ensuring the delivery of high-quality software solutions that meet our customers' needs.Key...


  • Pune, Maharashtra, India LTIMindtree Full time

    At LTIMindtree, we're seeking a seasoned ServiceNow technical lead to spearhead our ServiceNow practice team.We're looking for an expert in customer service management processes, with a strong understanding of Case, Incident, Problem, Change, and Configuration Management.The ideal candidate will have at least 5 years of experience working with the ServiceNow...

  • Technical Lead

    3 months ago


    Pune, India Alphanext Technology Solutions Full time

    JobDescription Welcome to Alphanexta leading provider of talent solutions headquartered in London withoperational bases in Pune and Indore. With a strong focus on theglobal technology community we are dedicated to connectingexceptional talent with innovative organisations around theworld. JobDescription We are seeking anexperienced and selfmotivated ...

  • Technical Lead

    7 days ago


    Pune, Maharashtra, India Stackave Solutions Full time

    **Job Title:** Technical Lead - Java DeveloperAt Stackave Solutions, we are seeking a highly experienced Technical Lead - Java Developer to join our team.**Estimated Salary:** ₹45,00,000 - ₹60,00,000 per annum, depending on experience and qualifications.Company OverviewStackave Solutions is a leading provider of software solutions, with a focus on...