Monika Thepale-Senior Technical Lead
Check rate
Experience
Senior ETL Lead
Takeda GmbH
- Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
- Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
- Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
- Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
- Designed scalable data foundations suitable for downstream analytics and AI workloads.
- Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.
Senior consultant
Infosys Ltd.
- Lead and developed multiple ETL projects from inception to completion, ensuring timely delivery and quality. Played a pivotal role in designing, developing, and implementing robust and scalable data extraction, transformation, and loading (ETL) solutions.
- Worked on legacy system migration projects, converting existing C/C++, SAS, and legacy ETL processes into Informatica workflows, Oracle database solutions, and Shell scripts while ensuring data integrity and business continuity.
- Extensively worked on SSRS reporting for L'oreal Project to develop reports related to Commercial sales sector on Sell-In/Sell-Out and Forecast. Used SSAS cube and MDX queries for report development.
- Developed detailed data mapping and transformation logic and technical documentation, performance tuning standards. Implemented optimization approach to reduce execution time from hours to secs.
Teradata India Pvt. Ltd., and Infosys Technologies Pvt. Ltd.
- Held various technical roles at Teradata India Pvt. Ltd., and Infosys Technologies Pvt. Ltd., designing and developing data integration solutions using ETL frameworks, data profiling and data quality analysis, automation, and collaborated with cross functional data stakeholders.
- Developed and Optimized ETL/ELT pipelines for FIFA gaming project to improve large volume telemetry data processing using pushdown optimization, ETL parallelism, data partitioning and multithreading approaches ensuring efficient data processing and minimizing data latency.
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Cosmetics, and Pharmaceutical.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, and Project Management.
Summary
- Senior Data Engineer & Technical Lead with 15+ years of experience architecting, scaling, and operating production-grade data platforms across highly regulated and data-intensive sectors, including Pharmaceuticals, Fintech, and Media.
- Expertise across Hybrid & Cloud Ecosystems, specializing in designing resilient batch/ELT pipelines, implementing scalable data warehousing solutions (AWS, Azure, Databricks, Informatica, Redshift, Teradata, Oracle, Python, Shell scripting), and modernizing legacy infrastructures.
- Data-Intensive Product & Telemetry Specialist, with proven experience handling high-volume telemetry data processing, utilizing multithreading and data partitioning to optimize data-driven product analytics.
- Advanced Query & Performance Optimization expert, with a track record of slashing processing latencies through advanced parallelism, pushdown optimization, and database tuning (PostgreSQL, T-SQL, ANSI-SQL).
- Deep Data Architecture & Modeling Foundation, skilled in designing robust enterprise architectures using Star/Snowflake schemas, OLAP/OLTP systems, and emerging Lakehouse concepts.
- Champion of Data Trust, with hands-on experience embedding rigorous data quality frameworks, observability, lineage, and governance strategies into production environments.
- Cross-Functional Leader who bridges the gap between complex engineering realities and business-driven data strategies, establishing standards and leading engineering streams from inception to delivery.
Skills
Technical Skills
- Data Integration Tools: Informatica Pwc, Informatica Cloud (15+), Adf, Aws Glue, Databricks
- Cloud Platforms: Aws, Azure
- Relational Databases: Teradata, Oracle, Mysql, Ms Sql Server, Redshift
- Languages: Postgresql, Sql, T-Sql, Ansi-Sql, Pl/Sql
- Programming & Frameworks: Python (Data Pipelines & Automation), Pyspark, Shell Scripting
- Reporting Tools: Ssrs, Bo
- Schedulers & Scrum Tools: Tidal, Control-M, Jira, Autosys, Airflow
- Data Modeling: Erwin Tool, Olap/Oltp, Star/Snowflake
- Data Architecture & Lakehouses: Data Warehousing, Cloud Lakehouse Architectures, Data Mesh
Additional Skills And Specialization
- Consulting & Leadership: Customer Engagement, Technical Stream Leadership, Cross-Functional Team Collaboration, Stakeholder Management
- Analytical & Problem-Solving: Strong Ability To Analyze Complex Data Challenges And Deliver Effective Solutions
- Etl & Data Engineering: Proficient In Etl Design, Development, And Scripting
- Teamwork & Independence: Able To Work Effectively Both Independently And Within Collaborative Teams
Languages
Education
Pune University
Bachelor of Engineering · Computer Science · Pune, India · Distinction
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Salary / Daily Rate Distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Senior ETL Lead
Nearby freelancers
Professionals working in or nearby Frankfurt am Main, Germany
