Chen Pal

About Chen Pal

over13+ years of extensive experience Proven expertise in requirements analysis, architecture design, development, implementation, testing, optimization, and production support of large-scale data platforms. Strong background in ETL architecture, metadata-driven frameworks, data modeling, OLAP, and performance tuning, with a deep understanding of SDLC best practices and evolving technology trends.Currently operating as a Data Engineer / Data Architect, designing scalable cloud-native data platforms, leading on-prem to cloud migrations, and building robust ETL frameworks across Azure and AWS, including Databricks, Azure Data Factory, Synapse Analytics, AWS Glue, and Snowflake.Experienced in designing secure, governed, and AI-ready data pipelines, enabling analytics, reporting, and AI/ML workloads through high-quality, trusted datasets. Passionate about applying modern data engineering practices—lakehouse architectures, CDC, SCDs, automation, and governance—to power advanced analytics and Generative AI use cases.

Experience

1. Sr Lead Etl Developer Sr Data Engineer

   Adventist Health

   Mar 2025 — Present

   Designed and developed a metadata table framework for specific interfaces into the database to run the queries and loaded them into the stage and core layer of Snowflake data warehouses.Led migration of critical ETL workflows from Informatica IICS to Talend Cloud, re-architecting jobs using metadata-driven frameworks and dynamic schema loading to optimize maintainability.Automated legacy PowerCenter workflows using Talend, implementing reusable job lets and centralized configuration for column-level transformation tracking and reduced onboarding time.Tuned migrated ETL processes by applying push-down optimization and parallel execution in Talend, achieving up to 30% improvement in execution time.Designed and developed scalable ETL pipelines to ingest and transform large-scale datasets into Google Big Query using Python and SQL, Created Generic and Repository schemas and masking the database. Performed Data Manipulations using various Talend Components like TMAP. TJAVAROW, TJAVA, TORACLEROW, TORACLEINPUT, TORACLEOUTPUT, TMSSQLINPUT and many more.

Education

• Osmania University

  Bachelor's degree, Computer Science