Data Engineer Quality

Mitrabarna Sarangi

SUMMARY

Results-driven Data Professional with over 3 years of experience in data engineering, data analysis, and database management. Proven expertise in SQL, Python, Matillion, Data Quality, Data Governance and Data Warehousing for implementing robust ETL/ELT workflows and delivering analytics-ready datasets. Experienced in data transformation, and orchestration using AWS Step Functions, with hands-on exposure to Redshift. Adept at collaborating with cross-functional teams in Agile Environments, continuously enhancing data solutions to support critical business intelligence and analytics use cases. EDUCATION

Bachelor of Technology

C.V. Raman Global University, Bhubaneswar, India

KEY SKILLS

CERTIFICATIONS

WORK EXPERIENCE

Data Engineer, Tata Consultancy Services

Project 1: ETL Development with Matillion : GE Healthcare TECHNICAL SKILLS

Matillion ETL Foundation Certification – 2025

Demonstrated ability to design efficient Matillion workflows with performance tuning and load strategies. Platform: Matillion

Cloud Platforms: AWS (Redshift, S3, RDS, EC2, Glue, Step Functions) Databases & Data Warehousing: PostgreSQL, MySQL, Snowflake, Teradata Programming & Scripting: SQL, PySpark

Data Engineering & ETL: Databricks, Matillion, SQL Scripts, Pipeline Optimization Data Concepts: ETL, ELT, Data Warehousing, Data Modeling (Star/Snowflake), OLTP/OLAP, Data Quality, Data Governance, Database Management

BI & Visualization: Power BI, Spotfire, Power Query, KPI Reporting, Dashboard Development CI/CD & DevOps: Git, GitHub, UAT, Agile

Tools: JIRA, Confluence, ServiceNow, Outlook, Box

Methodologies: Agile Development, Stakeholder Collaboration, Documentation, Critical Thinking ETL & Data Pipeline Development: Built and maintained parameterized ETL workflows using Matillion and SQL for cloud-based data ingestion and transformation.

Cloud Integration & Orchestration: Hands-on experience with AWS Redshift, S3, Step Functions, and EC2 for data processing, automation, and orchestration.

SQL Development & Optimization: Proficient in writing complex queries, stored procedures, views, and implementing indexing strategies across PostgreSQL, MySQL, and Redshift. Data Warehousing & Modeling: Experience in designing scalable star and snowflake schema models to support analytics and dashboard reporting.

Data Validation & Quality: Performed data profiling, validation, and maintaining data lineage for large-scale migration projects, ensuring consistency and accuracy.

BI & Visualization Tools: Developed interactive dashboards and reports using Power BI and Spotfire; implemented KPI tracking and dynamic filtering.

Version Control & Agile Delivery: Experienced in Git-based version control, UAT support, and Agile delivery using tools like GitHub, ServiceNow, and Sprint Planning boards.

Built end-to-end ETL pipelines using Matillion, leveraging components like Input Table, Output Table, Calculator, Filter, Join, Distinct, Rename, Aggregate, and Unite to perform incremental loads into AWS Redshift. Designed reusable and parameterized Matillion transformation jobs following best practices for reusability, parameterization, error handling, and performance optimization.

Managed AWS Step Functions-based workflows with alerting mechanisms, ensuring seamless data availability for Spotfire dashboards while reducing execution time by 20%+ through performance tuning and orchestration improvements. Project 2: Teradata to AWS Redshift Data Migration : GE Healthcare Migrated 10M+ records from Teradata to AWS Redshift, ensuring data validation, profiling, and reconciliation. Designed and optimized SQL-based ETL workflows to load over 1M financial records into Redshift. Developed schemas, views, and stored procedures in Redshift and PostgreSQL implementing Star and Snowflake schemas best practices to improve query performance and execution times. Integrated Snowflake as a downstream analytics and reporting layer by designing stored procedures, views, and time-travel-enabled audit frameworks; enhanced performance using clustering keys, and result caching. Automated pipelines with AWS Step Functions, enhanced query performance, and built Power BI dashboards for insights. Managed CI/CD with GitHub and supported UAT cycles to ensure business alignment and data integrity. Partnered with cross-functional teams to resolve data discrepancies and ensure high data quality. Phone:- +91-965******* Email:- ***********@*****.*** LinkedIn:- https://www.linkedin.com/in/mitrabarna-sarangi/ 2016-2020

MAR 2022 - Present

AWS Certified Cloud Practitioner– 2025

Achieved AWS certification covering cloud concepts, service models, architecture, security and cost fundamentals. Platform: AWS

Databricks Fundamentals Accreditation – 2025

Accredited in core Databricks concepts covering Lakehouse architecture, notebooks, and data processing. Platform: Databricks

Contact this candidate