Oundrila Das

• Developed and maintained data pipelines using AWS Glue, ensuring efficient ETL processes for loading data into cloud-based data warehouses (Redshift, S3).
• Wrote and optimized complex SQL queries for data extraction, transformation, and loading (ETL) across multiple data sources into relational databases and data lakes.
• Utilized Python for data manipulation, automation, and integration with AWS services such as Lambda, S3, and DynamoDB.
• Designed and implemented seamless data integration workflows using Talend, ensuring efficient data extraction, transformation, and loading across various platforms.
• Collaborated in an agile environment using Jira to manage tasks, track progress, and deliver data engineering solutions on time.
• Automated data processing tasks, improving efficiency and reducing manual intervention through scripting and scheduling.
• Ensured high-quality data delivery for analytics and reporting through rigorous data validation and troubleshooting.
• Worked closely with stakeholders to gather business requirements and translate them into technical specifications for data solutions.
• Created and optimized stored procedures for automating periodic tasks in SQL Server.
• Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
• Implemented data visualization tools like Tableau and Power BI to create actionable dashboards and reports for business stakeholders.
• Monitored data system performance, identifying bottlenecks, and implementing solutions to ensure system efficiency.
• Provided technical mentorship to junior engineers, guiding them on best practices, and project execution.
• Applied best practices for data security and compliance, ensuring governance, and access control across data solutions.
• Streamlined data flow from diverse sources using ETL tools like Talend, Informatica, and Airflow.
• Conducted rigorous testing and validation of data pipelines to ensure data accuracy and completeness.

Digital Analytics and Web Development.

• Gained proficiency in essential digital analytics tools, including Google Analytics, and Google Tag Manager.
• Applied analytics skills to develop a bank loan website, implementing tracking mechanisms to measure user engagement, and website performance.
• Utilized Google Tag Manager for data collection, and created a KPI dashboard to visualize key insights and performance metrics.
• Gained a strong understanding of workplace best practices, ensuring compliance with industry standards, and regulations.