Informatica Cloud & Databricks Data Engineering Lead

JAYASRI CHUNDURU

Senior Data Engineer Informatica Cloud Technical Lead IICS CDI / CAI Databricks Data Engineering

+1-949-***-**** ***************@*****.*** linkedin.com/in/jayasrichunduru L2 Visa valid until Jan 2028

PROFESSIONAL SUMMARY

Senior Data Engineer and Informatica Cloud Technical Lead with 11.5+ years of experience across enterprise data integration, application integration, ETL, batch processing, API orchestration, and CRM/data warehouse integration.

Hands-on expertise in Informatica Intelligent Cloud Services (IICS/IDMC), Cloud Data Integration (CDI), Cloud Application Integration (CAI), Secure Agent, PowerCenter, SQL, UNIX, REST/SOAP APIs, Oracle, DB2, SQL Server, Dynamics 365 CRM, and GCP file-based integration.

Databricks Certified Data Engineer Associate with certification-aligned skills in Databricks Lakehouse, Apache Spark, PySpark, Spark SQL, Delta Lake, medallion architecture, batch pipelines, data quality checks, Python, and SQL.

Designs AI-ready data pipelines through structured ingestion, JSON processing, metadata capture, audit logging, exception classification, validation controls, and curated datasets for analytics, AI/ML, and generative AI consumption.

Independently owned complex Ford integration projects as sole Informatica SME, including design, development, testing, deployment, production stabilization, stakeholder communication, JIRA delivery activities, and SLA-based support.

TECHNICAL SKILLS

Informatica Cloud: IICS/IDMC, CDI, CAI, Secure Agent, mapping tasks, taskflows, service connectors, process flows, API orchestration, Informatica Monitor, PowerCenter 10.x, Informatica Developer.

Databricks / Data Engineering: Databricks Lakehouse, Apache Spark, PySpark, Spark SQL, Delta Lake, medallion architecture, Python, SQL, data pipeline design, batch processing, data quality validation.

Cloud / Databases / Applications: Google Cloud Platform file sources, PL/SQL,Oracle 11g/12c, SQL Server 2019, DB2, Netezza, Microsoft Dynamics 365 CRM, flat files, Excel, enterprise data warehouse platforms.

APIs / Integration Patterns: REST APIs, SOAP APIs, XQuery, JSON processing, Dynamics 365 CRM integration, synchronization, replication, CDC-style integration, batch ETL, near-real-time API processing.

DevOps / Delivery Tools: Azure DevOps Pipelines, Jenkins, GitHub, CI/CD, Control-M, Autosys, JIRA, HP ALM, SoapUI, Postman, WinSCP, PuTTY.

CORE STRENGTHS

Technical leadership, SME ownership, solution design, HLD/LLD, mapping specifications, architecture review support, stakeholder management, Agile Scrum delivery, sprint planning, acceptance criteria review, and production handoff.

AI-ready data engineering, metadata-driven observability, data quality controls, anomaly-review data signals, curated CRM/customer datasets, model-consumption-ready outputs, auditability, and operational traceability.

Production support governance, SLA support, root-cause analysis, release readiness, defect triage, deployment coordination, run monitoring, and support documentation.

CERTIFICATIONS

Informatica Cloud Data Integration and Application Integration Certification (IICS / IDMC CDI and CAI).

Databricks Certified Data Engineer Associate.

AI for Managers — Microsoft / LinkedIn Learning.

AI White Belt — LinkedIn Learning.

PROFESSIONAL EXPERIENCE

Tech Mahindra, India Client: Ford Motor Company Dec 2019 - Jun 2026

Technical Lead / Informatica Cloud Developer

Facebook Automation Project - IICS CDI/CAI Automation Lead Dec 2019 - Jan 2022

Owned the complete automation solution from design through production deployment using IICS CDI and CAI to process source JSON, transform business content, and publish approved outputs to Facebook Pages through API-based automation.

Led requirement analysis, solution design, CDI mapping development, CAI process orchestration, testing, deployment, monitoring, and production support as the sole Informatica developer.

Built JSON ingestion and transformation logic to standardize payload structures, validate required fields, handle exceptions, and prepare downstream-ready content for automated publishing workflows.

Designed CAI workflows using service connectors, decision logic, assignments, error paths, and API orchestration patterns to improve reliability of automated publishing processes.

Captured metadata, content attributes, validation results, and exception categories to support downstream analytics, operational insights, and AI-ready content-quality review.

Tech Stack: IICS/IDMC, CDI, CAI, JSON, REST APIs, Facebook Pages automation, SQL, UNIX, Informatica Monitor

Ford Credit Batch Processing - IICS Batch Data Engineering Lead Jan 2022 - Mar 2024

Served as primary SME and Technical Lead for high-volume batch processing of approximately 40,000-record input files, splitting data into controlled 100-record output batches for Oracle and Dynamics 365 CRM loading.

Designed IICS CDI mappings and taskflows for file intake, file-splitting logic, transformation rules, target formatting, control totals, exception-routing workflows, and operational run traceability.

Implemented validation and reconciliation checkpoints to improve confidence in batch completeness, downstream loading, defect triage, and production support analysis.

Structured error categories, quality signals, run metadata, rejected-record handling, audit outputs, and exception patterns for downstream analytics and anomaly-review readiness.

Supported SIT, UAT, deployment readiness, production stabilization, run monitoring, root-cause analysis, and SLA-driven support for recurring batch workloads.

Tech Stack: IICS/IDMC, CDI, CAI, Oracle, Dynamics 365 CRM, flat files, SQL, UNIX, Control-M, Autosys, Informatica Monitor

Netherlands Data Processing Integration - GCP to Dynamics 365 CRM Mar 2024 - Feb 2025

Delivered an end-to-end Informatica Cloud integration to receive source files from Google Cloud Platform, process and validate records, transform datasets, and load curated data into Microsoft Dynamics 365 CRM.

Owned solution design, development, testing, deployment, production support, stakeholder coordination, and support handoff as the sole Informatica SME.

Built CDI mappings and taskflows to ingest GCP-originated files, apply validation rules, transform records, classify exceptions, and prepare CRM-ready output datasets.

Created reliable CRM load patterns with audit logging, rejected-record handling, data-quality checks, operational monitoring checkpoints, and production support traceability.

Aligned transformation outputs, metadata capture, validation results, and support evidence to make CRM datasets more analytics-ready and AI-consumption-ready.

Tech Stack: IICS/IDMC, CDI, CAI, Google Cloud Platform, Dynamics 365 CRM, SQL, UNIX, flat files, Informatica Monitor

Databricks Lakehouse & AI-Ready Data Engineering Enablement 2025 - 2026

Built certification-aligned Databricks data engineering capability across Lakehouse architecture, Spark, PySpark, Spark SQL, Delta Lake, medallion architecture, data transformation, and data quality validation.

Created reusable notebook-style patterns for bronze, silver, and gold processing concepts, schema validation, transformation logic, audit columns, curated outputs, and downstream analytics readiness.

Mapped Informatica ETL design patterns to Lakehouse-oriented data processing concepts, including ingestion, cleansing, enrichment, exception handling, and curated analytical datasets.

Organized AI-ready pipeline patterns for feature-readiness, metadata-driven observability, anomaly-review signals, Python/SQL transformation logic, and model-consumption-ready outputs.

Tech Stack: Databricks, Apache Spark, PySpark, Spark SQL, Delta Lake, Python, SQL, medallion architecture, data quality, AI-ready data pipelines,Azure

Enterprise IICS Integration Delivery & Production Support Feb 2025 - Jun 2026

Supported enterprise-scale Ford integration delivery across IICS CDI/CAI, Oracle, DB2, SQL Server, Dynamics 365 CRM, REST/SOAP APIs, flat files, data warehouse environments, Agile release coordination, and production support governance.

Architected and supported integration workflows across 15 applications and 35+ enterprise interfaces spanning databases, CRM, flat files, data warehouse assets, and APIs.

Standardized reusable IICS components including Lookup, Expression, Router, Aggregator, Filter, Normalizer, and Hierarchy Processor transformations to improve delivery consistency.

Automated operational and release activities using Jenkins, Azure DevOps Pipelines, GitHub, UNIX utilities, Control-M, Autosys, and Informatica Monitor for stronger deployment traceability.

Led bi-weekly Agile delivery coordination with business analysts, QA, developers, architects, and stakeholders across design, build, testing, deployment, stabilization, and support.

Managed JIRA backlog grooming, requirement analysis, user story refinement, acceptance criteria reviews, stakeholder communication, and production-support prioritization.

Tech Stack: IICS/IDMC, CDI, CAI, Oracle, DB2, SQL Server, Dynamics 365 CRM, REST/SOAP APIs, Jenkins, Azure DevOps, GitHub, Control-M, Autosys

Cognizant Technology Solutions, India Client: Excellus BlueCross BlueShield Aug 2016 - Dec 2019

Technical Associate / Team Lead

Delivered healthcare ETL solutions using Informatica PowerCenter 10.x, UNIX, and SQL Server by converting business transformation rules into maintainable mappings for flat-file and Excel-based source data.

Improved recurring data-load reliability by isolating bottlenecks across sources, targets, mappings, sessions, and workflows and applying targeted performance tuning.

Coordinated onsite/offshore delivery across estimates, test preparation, integration testing, troubleshooting, release support, and production handoff activities.

Prepared test execution plans and validated ETL outputs with delivery teams to improve integration-testing readiness and production transition quality.

Tech Stack: Informatica PowerCenter 10.x, UNIX, SQL Server

Cognizant Technology Solutions, India Client: AT&T Communications Jan 2016 - Aug 2016

Programmer Analyst

Engineered telecom ETL mappings using Informatica 9.x to extract data from flat-file and SQL-table sources and apply business transformation logic for downstream consumption.

Configured workflows, worklets, and sessions in Informatica Workflow Manager while documenting mapping specifications and delivery traceability notes.

Resolved mapping defects through data-flow review, transformation-logic validation, SQL checks, and requirement alignment before downstream handoff.

Tech Stack: Informatica 9.x, Oracle 9i

Cognizant Technology Solutions, India Client: AMEX Jan 2015 - Jan 2016

Programmer Analyst Trainee

Implemented banking ETL components under Data Architect guidance across analysis, mapping creation, workflow planning, data cleansing, exception routing, and defect response.

Built flat-file extraction, transformation, data-cleansing, exception-table, and error-handling logic using Informatica 9.x, SQL Server, and Netezza environments.

Tech Stack: Informatica 9.x, SQL Server 2005, Netezza

EDUCATION & WORK AUTHORIZATION

Bachelor of Technology — Audisankara Institute of Technology, Gudur, India, 2014.

Work Authorization: L2 visa valid until January 2028.

Contact this candidate