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.• Conducted root cause analysis for data discrepancies, implementing solutions to maintain data integrity across environments.• Developed REST API integrations for real-time data ingestion, efficiently handling JSON responses to streamline data flows.• Configured and monitored data pipelines using AWS CloudWatch, improving system reliability and proactively managing alerts.• Enhanced reporting capabilities by creating Power BI and OBIEE dashboards, providing interactive, user-friendly insights.• Automated infrastructure deployments with CloudFormation, ensuring rapid, consistent environment setups for ELT processes.• Collaborated with data scientists and analysts to optimize data processing workflows, improving the accuracy of analytics outputs.

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.• Participated in the on-call rotation to support ETL operations, promptly addressing data discrepancies to minimize downtime.• Built self-service Power BI dashboards, enabling end-users to filter data, generate insights, and create reports independently.• Developed and optimized SQL queries for reporting systems, including stored procedures, triggers, and JSON handling for external API calls.• Worked closely with project stakeholders to align ELT processes with business requirements, ensuring data solutions met end-user needs.• Integrated AWS Postgres for structured data storage, enhancing query speed and reducing resource costs by 15%.• Established automated error handling mechanisms within Matillion, improving data consistency and process reliability.

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.• Assisted in developing security protocols for data storage and access, ensuring compliance with organizational standards.• Collaborated with cross-functional teams to define data requirements, delivering solutions aligned with business objectives.• Created and optimized SQL queries and stored procedures, supporting high-speed data retrieval for reporting.• Deployed Power BI dashboards for self-service reporting, enabling teams to filter and analyze data independently.• Implemented CI/CD pipelines using GitHub and Jenkins, ensuring smooth code integration and deployment.• Conducted data validation processes to maintain high data quality, setting up automated checks and alerts for discrepancies.

Master'S Degree, Computer Science, 3.22

Bsc, Computer Science, 8.55 Cgpa