I’m Shweta Rokade, a senior ETL/Data Engineer with 10+ years of experience building and optimizing enterprise data pipelines for trading, telecom, equities, retail, claims, and finance. I’ve worked across Talend, Informatica PowerCenter, Azure Databricks, Azure Data Factory, and Snowflake, turning raw data from APIs and databases into reliable, analytics-ready datasets with strong data quality and performance. I enjoy leading migrations and modernization efforts—like Teradata to Snowflake and on-prem to cloud—while improving throughput, reducing processing time, and strengthening orchestration using tools such as Control-M/Autosys patterns and structured dependency/retry handling. I’m also passionate about maintainable engineering practices, including modular pipeline design, logging/validation, and automation that supports business reporting and regulatory use cases.

SHWETA ROKADE

I’m Shweta Rokade, a senior ETL/Data Engineer with 10+ years of experience building and optimizing enterprise data pipelines for trading, telecom, equities, retail, claims, and finance. I’ve worked across Talend, Informatica PowerCenter, Azure Databricks, Azure Data Factory, and Snowflake, turning raw data from APIs and databases into reliable, analytics-ready datasets with strong data quality and performance. I enjoy leading migrations and modernization efforts—like Teradata to Snowflake and on-prem to cloud—while improving throughput, reducing processing time, and strengthening orchestration using tools such as Control-M/Autosys patterns and structured dependency/retry handling. I’m also passionate about maintainable engineering practices, including modular pipeline design, logging/validation, and automation that supports business reporting and regulatory use cases.

Available to hire

I’m Shweta Rokade, a senior ETL/Data Engineer with 10+ years of experience building and optimizing enterprise data pipelines for trading, telecom, equities, retail, claims, and finance. I’ve worked across Talend, Informatica PowerCenter, Azure Databricks, Azure Data Factory, and Snowflake, turning raw data from APIs and databases into reliable, analytics-ready datasets with strong data quality and performance.

I enjoy leading migrations and modernization efforts—like Teradata to Snowflake and on-prem to cloud—while improving throughput, reducing processing time, and strengthening orchestration using tools such as Control-M/Autosys patterns and structured dependency/retry handling. I’m also passionate about maintainable engineering practices, including modular pipeline design, logging/validation, and automation that supports business reporting and regulatory use cases.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Language

Japanese
Intermediate
English
Advanced

Work Experience

Data Engineer at SMART TECH SKILLS LLC (Contract – Knights of Columbus)
July 1, 2025 - November 1, 2025
Architected end-to-end ETL/ELT pipelines using Talend, Azure Databricks, and Azure Data Factory to ingest APIs, RDBMS, and flat files into Snowflake and data lakes for finance, operations, and compliance reporting. Developed Databricks notebooks with Spark SQL and Delta Lake for scalable transformations, incremental loads, and curated analytics-ready datasets. Improved pipeline performance by 30% through SQL tuning, cluster/warehouse optimization, partitioning, and workflow refactoring. Implemented automated data quality checks, schema validations, and logging across Talend, Databricks, and Snowflake achieving 99% data accuracy. Designed Star/Snowflake dimensional models and views to support BI, analytics, and enterprise reporting.
App Dev Intermediate Programmer Analyst at CITI Corp Services India
February 1, 2023 - March 1, 2025
Built ETL/ELT solutions using Talend, Azure Databricks, Snowflake, Python, and SQL to integrate trading, broker, and execution data for cost analytics and regulatory reporting. Developed scalable Databricks/Spark pipelines and Snowflake transformations for broker fee calculations, spread analytics, and dashboard reporting. Optimized high-volume workloads by tuning Netezza SQL, refactoring Spark jobs, and designing performant Snowflake models. Improved reliability by mapping legacy Autosys workflows to Databricks job structures with dependency and retry handling. Strengthened maintainability with modular design, Delta Lake optimizations, error handling, and systematic performance tuning.
Technology Lead Consultant at VIRTUSA INDIA PVT LTD
January 1, 2021 - January 1, 2023
Led Teradata-to-Snowflake migration for sales and telecommunications analytics, building Snowflake SQL scripts, data models, and transformation logic with Talend and PostgreSQL. Automated sales and telecom ETL processes using Informatica, Talend, Teradata, PostgreSQL, and Snowflake, reducing month-end processing from 2 days to 1 hour. Implemented Control-M orchestration with structured scheduling, dependencies, and retry logic for reliable delivery of telecom usage, billing, and sales data. Developed and optimized 40+ Informatica mappings and migrated key workflows to cloud environments for improved scalability and performance. Collaborated with business teams across 30+ products to define KPIs and analytical solutions for pricing, revenue assurance, usage, and sales reporting.
Technical Lead (Contract then Full-time) at INFOSYS PVT LTD (Client: Equatex)
December 1, 2019 - January 1, 2021
Set up and managed Talend Administration Center (TAC) for enterprise job scheduling, orchestration, and production monitoring of equities and trade/share-related data pipelines. Developed and automated Talend workflows to migrate and transform trade, market, and reference data into warehouses and analytics layers for reporting and risk use cases. Designed source-to-DWH mappings, data flow diagrams, and technical specifications to support scalable and auditable equities data handling. Created deployment scripts, runtime configurations, and support documentation to streamline production releases and troubleshooting. Managed SVN-based version control to ensure traceability and collaboration across the ETL team.
Senior Developer at SWIFTWIN TECHNOLOGIES (Client: Michael)
August 1, 2018 - November 1, 2019
Built and maintained Talend ETL jobs processing 100GB+ of retail and stationery data from diverse sources for reporting and analytics. Performed data mapping and transformation to integrate transactional data into the enterprise data warehouse for unified reporting. Orchestrated, monitored, and managed ETL workflows using Control-M for reliable, SLA-driven delivery of operational data. Migrated data from SQL Server to Hadoop (HDFS) using Talend and Sqoop to enable scalable storage and analytics. Ensured data quality and integrity through validation, reconciliation, and error handling for trustworthy reporting.
Senior Software Developer at PRGX INDIA PVT LTD
September 1, 2015 - July 1, 2018
Engineered Talend ETL and Informatica workflows to migrate large retail and claims datasets from SQL, flat files, Excel, and EBCDIC sources into HDFS. Designed ETL logic for positional, delimited, and EBCDIC formats with custom parsing and validation for secondary claims analytics. Transformed complex SQL scripts into HiveQL and optimized performance using Hive on Spark for high-throughput processing. Used Sqoop for SQL-to-HDFS transfers with robust exception handling and fault tolerance. Built a centralized Metadata Repository (MDR) to automate configuration management and reduce manual intervention, and managed SVN version control.

Education

Bachelor of Engineering (Electronics & Telecommunication) at Pune University
January 1, 2008 - January 1, 2012

Qualifications

Microsoft Fabric Data Engineer Associate (DP-700)
January 1, 2026 - September 2, 2026
JLPT N4 – Japanese Language Proficiency
January 11, 2030 - September 2, 2026

Industry Experience

Financial Services, Telecommunications, Retail, Other, Professional Services