Shashidhar K Email & Phone Number

St Louis, Missouri, United States

• Led development of Matillion-based data pipelines, integrating AWS S3 and RDS to handle high-volume data ingestion and transformation.
• Implemented Change Data Capture (CDC) using AWS tools, ensuring consistent, up-to-date data across platforms for analysis and reporting.
• Built event-driven architectures using AWS Lambda, reducing latency in data processing for near real-time updates.
• Designed Kimball dimensional models for reporting needs, enabling efficient data slicing and dicing for business insights.
• Established thorough ELT documentation, including source-to-target maps, data dictionary, and ETL procedures for seamless knowledge sharing.
• Optimized SQL code and stored procedures, improving the speed and reliability of data retrieval from AWS Postgres and Oracle Database.

Hyderabad, Telangana, India

• Designed and implemented Matillion ETL workflows, automating data extraction, transformation, and loading processes for financial reporting.
• Developed AWS Lambda functions to streamline data processing, reducing overhead and accelerating transformation times.
• Utilized Change Data Capture (CDC) strategies to keep data updated across multiple reporting systems, enhancing data accuracy.
• Applied Kimball dimensional modeling to structure financial data warehouses, improving query efficiency and scalability.
• Created comprehensive ELT documentation, including source-to-target mappings and ETL process guides for project transparency.
• Assisted in data analysis for project-specific needs, analyzing and mapping data requirements for accurate data transformations.

Hyderabad, Telangana, India

• Maintained ELT documentation, detailing transformation logic, ETL mappings, and data flow diagrams for project stakeholders.
• Configured real-time data streaming using Kafka and Spark, enabling rapid data ingestion from IoT devices.
• Developed Power BI dashboards to provide real-time analytics, allowing end-users to explore and generate insights on demand.
• Improved SQL performance through optimized stored procedures and functions, enhancing query efficiency across databases.
• Automated deployments with Terraform, ensuring consistent, scalable environments for data engineering projects.
• Coordinated with data scientists to support data availability for machine learning models, improving predictive analytics capabilities.

Master'S Degree, Computer Science, 3.22

Bsc, Computer Science, 8.55 Cgpa