Janhavi C.
Data Engineer @Citian
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @Citian
US
Developed efficient ETL pipelines using Python to transform raw data into valuable insights, supporting transportation management decisions across public sector teams at Citian. Designed and optimized complex SQL queries for DDL and DML operations, significantly improving database performance and query execution times for critical public sector transportation datasets. Architected scalable data models and warehouse solutions, accommodating growing data volumes on platforms like Snowflake and AWS, supporting real-time urban transportation analytics. Created interactive data visualizations and exploratory analyses using Jupyter notebooks, effectively communicating insights to technical and non-technical stakeholders in transportation planning. Implemented automated data quality checks and monitoring systems to maintain data integrity throughout the ETL process, ensuring reliable data for critical transportation applications. Migrated on-premise database infrastructure to cloud-based platforms, including Snowflake and AWS, enhancing scalability and optimizing data storage for public sector solutions. Developed reusable Python scripts for data aggregation and transformation, significantly reducing development time for new data integration projects within public transportation systems. Optimized PostgreSQL and MySQL database configurations to handle high-volume transaction processing, maintaining system stability and data responsiveness for public transportation operations. Implemented data governance policies and documentation standards, improving cross-team understanding of data assets and their appropriate usage for transportation analytics. Built analytical workflows that combined spatial and tabular data for urban planning initiatives, integrating complex findings to improve public sector transportation strategies.
EDUCATION
Florida Institute of Technology
Master's degree, Computer Science
K S School of engineering and management
Bachelor of Engineering - BE, Computer Science
ABOUT JANHAVI C.
Data Engineer with 3+ years of experience designing and deploying scalable data pipelines, cloud platforms, and AI-integrated analytics solutions. Proficient in Python, SQL (T-SQL, PostgreSQL, MySQL), and cloud technologies including Azure (Data Factory, Data Lake Gen2, Synapse, Purview, Monitor), AWS (S3, RDS, EC2), and Snowflake. Skilled in implementing medallion architecture, data lakehouse patterns, and modular ETL/ELT workflows across batch and real-time data streams.Hands-on experience with Microsoft Fabric for unified data engineering, and Power BI for dynamic reporting with DAX, M, AI visuals, and Copilot integration. Adept at deploying ML models into production using Azure Machine Learning and OpenAI APIs for predictive analytics, anomaly detection, and intelligent automation.Expertise in data governance, metadata management, and lineage tracking using Microsoft Purview. Strong focus on performance optimization, query tuning, and implementing robust data quality checks and monitoring with Azure Monitor, Log Analytics, and GitHub Actions.Additional skills include: PySpark, Pandas, NumPy, Jupyter Notebooks, REST APIs, CI/CD for data, Git, GitHub Actions, Agile/Scrum, Confluence, and cross-functional collaboration with data scientists, GIS developers, and business stakeholders.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.