Richa Mishra
Perth
Summary
Highly skilled Data Engineer with over 8 years of experience in designing, developing, and managing full-cycle data solutions from raw data ingestion to business insights. I have built and optimized data pipelines, ETL workflows, interactive dashboards enabling organizations to derive meaningful insights.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Software Engineer
Indium Software
10.2022 - Current
- Gathered business requirements from stakeholders and translated them into technical specifications.
- Designed and Built robust ETL pipelines using AWS glue, Azure Data Factory, Talend, SSIS, and Python to extract, transform, and load large datasets from diverse sources, ensuring data integrity and scalability.
- Expertise in Azure and AWS, working with modern data warehouses like Snowflake and BigQuery to enable advanced analytics.
- Proficient in writing complex SQL queries for data extraction, transformation, and analysis, optimizing query performance for large datasets
- Designed and developed end-to-end data pipelines using Azure Data Factory (ADF) for data ingestion, transformation, and integration from multiple sources
- Developed interactive dashboards using Power BI and Tableau, enabling stakeholders to explore data independently and make data-driven decisions.
- Created stored procedures,functions,views,triggers and dynamic SQL queries to handle complex business logic and reporting needs.
- Automated data workflows and scheduled data refresh processes using Azure Data Factory and Azure Automation
- Collaborated with cross-functional teams to ensure alignment of data strategies with business objectives
Senior Software Engineer
Indium Software
10.2022 - Current
- Company Overview: Shark Ninja is an American designer, marketer, and distributor of home devices and appliances, focusing on products like vacuum cleaners, blenders, multicookers, air fryers, and coffee makers
- Designed and implemented complex stored procedures, dynamic queries, recursive CTEs, and triggers to handle business requirements
- Debugged stored procedures and fixed bugs to ensure smooth operations
- Optimized query performance using advanced SQL tuning techniques
- Migrated data from SQL Server to Snowflake using AWS S3 buckets
- Developed transformations and macros in DBT, creating incremental models, views, and snapshots
- Built complex SSIS packages , python code for ETL processes to migrate data and implement business logic
- Documented the lifecycle of customer orders and sales, providing insights from order placement to bill generation
Data Engineer
CitiusTech Healthcare Solutions
09.2021 - 09.2022
- Created full and incremental load packages using SSIS and Python.
- Optimized long-running SQL queries using indexing and partitioning techniques, reducing runtime by 80%
- Developed stored procedures with exception handling and SQL transaction management
- Automated JSON data parsing and implemented row-level security
- Handled deployment of SSIS packages and created SQL Server jobs for scheduled operations
- Delivered end-to-end implementation, including design, coding, and production deployment
Xcaliber Infotech
09.2020 - 09.2021
- Company Overview: Supply chain analytics project focusing on forward and reverse logistics to optimize inventory management and ensure timely deliveries
- Developed incremental ETL pipelines using SSIS
- Optimized SQL queries and views for enhanced performance
- Deployed SSIS packages and set up SQL Server jobs for operational workflows
- Enhanced stored procedures to meet changing business requirements
- Supply chain analytics project focusing on forward and reverse logistics to optimize inventory management and ensure timely deliveries
Accenture
11.2017 - 09.2020
- Gathered and analyzed business requirements to design workflow and execute tasks
- Implemented over 200 business rules using SSIS and SQL stored procedures
- Built drill-down and drill-through reports using SSRS for policy monitoring
- Managed schema updates and provided rigorous training to new team members
- Led the project from scratch to production deployment
Education
Bachelor of Engineering -
Mumbai University
01.2017
Skills
- Azure Data Factory
- SQL Server
- Python
- PySpark
- AWS Glue
- Snowflake
- Power BI
- Data Warehousing BigQuery ETL Pipelines Azure Synapse Cloud Data Engineering Data Governance Data Security Business Intelligence ADF Redshift Azure Blob Storage Data Analytics KPI Reporting
Certification
- Microsoft SQL Server 2012/2014, 70-461
- Snowflake and DBT Certification, in progress
Attributes
- Strong analytical and problem-solving mindset.
- Excellent communication and stakeholder engagement skills.
- Ability to work in agile, fast-paced environments and drive process automation.
- Strong team collaboration and leadership experience.
Timeline
Senior Software Engineer
Indium Software
10.2022 - Current
Senior Software Engineer
Indium Software
10.2022 - Current
Data Engineer
CitiusTech Healthcare Solutions
09.2021 - 09.2022
Xcaliber Infotech
09.2020 - 09.2021
Accenture
11.2017 - 09.2020
Bachelor of Engineering -
Mumbai University
Similar Profiles
VEENA LEKSHMI SVEENA LEKSHMI S
Manual Test Associate at Indium SoftwareManual Test Associate at Indium Software
Sivagar BalasundaramSivagar Balasundaram
Software Engineer at Indium SoftwareSoftware Engineer at Indium Software
Vishal RanaVishal Rana
Senior Data Engineer at Indium SoftwareSenior Data Engineer at Indium Software