Chandrika Landge

Migrated jobs from IICS to Google BigQuery using SQL Server, SAP, and Oracle databases. Integrated DBT models with Airflow to automate data pipelines, scheduling ETL process execution via DAGs. Coordinated with stakeholders to gather requirements and deliver data solutions that meet business needs.

Involved in conversion of data from Informatica to Google BigQuery, making data more accessible and efficient. Expertise in debugging the code. Solved challenging data integration problems by identifying root causes and developing practical solutions for data accuracy and reliability. Implement Cloud Composer (Apache Airflow) for workflow automation, automating data ingestion and transformation processes for a large-scale data warehouse migration project.

Proficient in utilizing the Raven tool. Mapped and integrated BigQuery equivalents for existing Informatica functions, optimizing data processing workflows and improving overall efficiency. Collaborated effectively with product teams, leading Jira ticket development and management to streamline communication and enhance project coordination for efficient code delivery. Developed and maintained comprehensive documentation for ETL processes, data mappings, and transformations.

Migration of Teradata and Oracle DDLs and DMLs for integration into GCP BigQuery. Tune BigQuery queries, optimize cost, and implement best practices for data processing. Validate data integrity, ensure consistency, and troubleshoot migration issues. Leverage GCP tools and services to efficiently migrate data and applications. Implement Cloud Storage, BigQuery for real-time data movement. Automate data ingestion using Cloud Composer (Apache Airflow) and scheduled.