Duration: May 2025 – June 2025
Institution: KLE Technological University, Hubballi (India) KLEMSSCET
Team Size: 3
Mentor: Prof. Anita Kenchannavar
Live Demo: abhs28.netlify.app
This project presents a unified customer analytics platform built using Informatica Intelligent Cloud Services (IICS). It integrates fragmented customer data across CRM, e-commerce, marketing, and support systems into a single, analytics-ready model.
Designed as part of an academic course project, the pipeline enables organizations to break down data silos and gain actionable insights from customer interactions across platforms.
-
🔁 Cloud-Based ETL(Extract Transform and Load) Pipeline
Built with Informatica IICS for scalable and reusable data integrations. -
🧼 Data Cleansing & Deduplication
Implemented data quality rules to ensure high consistency and eliminate redundancy. -
📊 KPI Generation
Extracted metrics like Customer Lifetime Value (CLV), Engagement Scores, and Support Trends. -
🔍 360° Customer View
Provided holistic insight into customer journeys for business teams. -
🤝 Team Collaboration
Developed in a team of three under expert supervision to simulate real-world enterprise data workflows.
| Tool/Tech | Description |
|---|---|
| Informatica IICS | Designed and orchestrated ETL workflows. |
| Cloud Storage | Managed large, scalable customer datasets. |
| Data Quality Framework | Applied rules to standardize and deduplicate records. |
| Netlify | Hosted the live dashboard/demo frontend. |
- Delivered an enterprise-grade, scalable customer analytics solution.
- Created BI-ready datasets, enabling better strategic decisions in marketing, support, and sales.
- Demonstrated skills in cloud ETL, data integration, and analytics enablement using Informatica Cloud.
While this project involves proprietary cloud tools (Informatica IICS), the demo and design concepts can be reviewed via the live site or documentation in this repo.
This project is for educational and demonstration purposes only.
Abhinandan Onajol
GitHub | LinkedIn