Priyanka
Cincinnati,OH
Summary
Experienced data engineer with a proven track record of five years specializing in ETL development and data pipeline architecture. Proficient in a variety of cloud platforms, including AWS, Azure, and Informatica Cloud. Skilled in optimizing data workflows and leveraging data to drive business insights.
Overview
7
7
years of professional experience
Work History
Data Engineer
Dataflake LLC
01.2023 - Current
- Designed, implemented, and maintained ETL pipelines using tools such as DataStage, ensuring efficient and reliable data extraction, transformation, and loading processes.
- Managed and optimized databases on Snowflake, including schema design, performance tuning, and query optimization to support data analysis and reporting needs.
- Developed and implemented data quality checks and validation procedures to ensure accuracy, completeness, and consistency of data across different systems and sources.
- Worked closely with data analysts, business stakeholders, and other team members to understand data requirements, provide technical support, and deliver data-driven solutions.
- Implemented data quality checks and monitoring processes, reducing data errors by 79%.
- Created complex visualizations, including heat maps, scatter plots, and tree maps, to highlight trends and patterns in data.
- Identified key performance indicators (KPIs) and developed visualizations to track and analyze them effectively.
- Implemented new features and techniques in Tableau and Power BI to improve the efficiency and effectiveness of visualizations.
- Worked with cross-functional teams to understand data requirements and design data models using Azure Databricks and Azure Synapse Analytics, enabling effective data analysis and reporting.
- Optimized data processing performance by tuning SQL queries, implementing indexing strategies, and leveraging Azure Data Lake Analytics and Azure SQL Data Warehouse.
Graduate Assistant
Southern New Hampshire University - On Campus
08.2021 - 12.2021
- Managed administrative tasks such as grading, scheduling, and record-keeping to ensure smooth operations within academic departments.
- Served as a liaison between faculty members and students for addressing concerns or issues related to coursework or academic policies.
- Facilitated student success by identifying areas of improvement and providing constructive feedback on assignments and exams.
- Developed and managed organized, orderly student databases and tracking systems.
- Updated departmental websites and social media accounts with relevant, engaging content.
- Conducted relevant research and gathered valuable resources for faculty members'' ongoing projects and publications.
ETL Developer
ICICI Bank
09.2019 - 12.2020
- Designed, developed, and maintained ETL processes to extract, transform, and load data from various sources into the data warehouse, ensuring data quality and integrity.
- Implemented complex data transformations using SQL, Python, or other ETL tools to meet business requirements and improve data usability.
- Collaborated with business stakeholders to understand their data analysis needs and translated them into ETL requirements and Power BI reports and dashboards.
- Developed and maintained Power BI reports and dashboards to visualize data trends, patterns, and insights, enabling informed decision-making.
- Developed and maintained complex ETL workflows in Informatica Cloud to process large volumes of data with high accuracy and efficiency.
- Optimized performance of Informatica Cloud jobs by fine-tuning mappings, workflows, and configurations, resulting in significant time and cost savings.
Software Engineer
MaxPi Technologies Private Limited
12.2016 - 09.2019
- Implemented best practices for data warehousing and ETL development, ensuring scalability and maintainability of the solution.
- Conducted data analysis to identify data quality issues and implemented solutions to improve data accuracy and completeness.
- Provided technical support and training to end-users on Tableau and ETL processes, enabling them to make data-driven decisions.
- Worked closely with cross-functional teams to integrate Tableau visualizations into business applications, enhancing user experience and data accessibility.
- Stayed updated with the latest trends and technologies in ETL and Tableau, incorporating new tools and techniques to improve processes and deliverables.
- Contributed to the development of data governance policies and procedures, ensuring data security and compliance with regulatory requirements.
- Utilized Tableau to create interactive dashboards and reports, providing valuable insights into business performance and trends.
- Designed and implemented scalable data pipelines on AWS using services such as Amazon S3, Glue, EMR, and Redshift, resulting in improved data processing efficiency and reduced costs.
- Implemented data governance policies and procedures on AWS to ensure data quality, security, and compliance with regulatory requirements.
Education
Master of Science - Information Technology
Southern New Hampshire University
Hooksett, NH01.2023
Bachelor of Science - Electrical, Electronics And Communications Engineering
Sridevi Womens Engineering College
India05.2016
Skills
- ETL
- Python
- PySpark
- AWS
- Azure
- Power BI
- Tableau
- Snowflake
- DataStage
- Kafka
- Github
- JIRA
- Datastage
- Kafka
- Github
- JIRA
Timeline
Data Engineer
Dataflake LLC
01.2023 - Current
Graduate Assistant
Southern New Hampshire University - On Campus
08.2021 - 12.2021
ETL Developer
ICICI Bank
09.2019 - 12.2020
Software Engineer
MaxPi Technologies Private Limited
12.2016 - 09.2019
Master of Science - Information Technology
Southern New Hampshire University
Bachelor of Science - Electrical, Electronics And Communications Engineering
Sridevi Womens Engineering College
Similar Profiles
Sabrena LangstonSabrena Langston
Self Employed Owner/Operator at Bree'z Triple Care Transport, LLC/EAYC, LLCSelf Employed Owner/Operator at Bree'z Triple Care Transport, LLC/EAYC, LLC
Ravishekhar GeerRavishekhar Geer
Managing Director/Owner at Hope Medical Center LLC and Hope Pharmacy LLCManaging Director/Owner at Hope Medical Center LLC and Hope Pharmacy LLC
Amanda Lea PreauxAmanda Lea Preaux
Administrative Assistant/Realtor at Pittsburgh Home Girls LLC/eXp Realty LLCAdministrative Assistant/Realtor at Pittsburgh Home Girls LLC/eXp Realty LLC