About

Swati Dogra is a Data Engineer with over 9 years of IT experience in all phases of software development life cycle. She has 5+ years of industry experience in Data Warehouse as a Data Engineer, involved in design and development of distributed systems using Hive, Spark, and Python. Swati has experience in developing SQL scripts to Upload, Retrieve, Manipulate and handle sensitive data in MySQL and SQL Server Management Studio. She has used SQL and Excel to ensure data quality and integrity and identified and eliminated duplicates and inaccurate data records. Swati is experienced with different Python module libraries, and packages like NumPy, matplotlib, SciPy, and Pandas data frame. She has expertise in creating optimized Hive tables using proper partitioning, Bucketing for faster I/O, implementing Change Data Capture (CDC), Dedup, Incremental load, Data quality governance, balance, and control. Swati has developed a tableau dashboard to monitor real-time monthly & quarterly transactional patterns of clients based on business unit, transaction type, and sector. Swati is proficient in AWS services like EC2, S3, ELB, RDS, IAM, CloudFormation, Route 53, CloudWatch, Lambda, CloudFront. She has experience in functional/database testing using selenium/webdriver, pytest, and created test scripts using python scripting methodologies. Swati has strong experience in creating CI/CD pipeline for continuous integration testing and performing Database/Backend testing by writing SQL/Oracle Queries for data validation and integrity. She has strong knowledge of Software Development Life Cycle and expertise in detailed design documentation, Experience in working with an agile team. Currently, Swati is working as a Data Engineer at Suniksha Infotech. She is responsible for collaborating with various teams to gather all the information needed for data analysis and involved in all aspects like data collection, data cleaning, developing models, and visualization. She has developed, modified, and managed databases, schemas, and tables and used Joins and Sub-Queries to simplify the complex queries involving multiple tables. Swati has performed Data profiling, and preliminary data analysis and handled anomalies such as missing, duplicates, outliers, and imputed irrelevant data. Swati has worked with Espire Infolabs as a Data Analyst and NIIT as a Software Engineer. She holds a Master of Computer Applications (MCA) degree from IEC-CET Greater Noida and a B.Sc degree from Hindu Girls College, Jagadhri. Swati has a strong tech stack