Anjana Nair Email & Phone Number

Amsterdam, NH, NL

Netherlands

Led the design and development of complex ETL processes using Informatica PowerCenter to extract, transform, and load data from various sources into the Snowflake and Oracle data warehouses.Architected and implemented Data Vault models to support scalable data warehousing solutions, ensuring data integrity, traceability, and accessibility for reporting and.

Amsterdam Area, Netherlands

Designing the ETL solution to ingest the raw source data into a Staging Area and the downstream Foundation layer which provides an Enterprise Data Store (in 3NF model) that specifically for access / reporting

Thiruvananthapuram, Kerala, India

* Align with Business to elicit requirements for initial design and change requests in future Implement ETL solution using Informatica PowerCenter 10.2 and Unix shells scripting* ETL code unit testing and do defect analysis and fix activities* Create Deployment Documents* Production support for the Informatica process, troubleshoot and debug any errors

Thiruvananthapuram Area, India

* Designed the ETL solution for integrating WiFree hotspots data for 11 countries from disparate sources into a single repository, geo-coding the addresses via Carto geo-coding service, identifying delta, uploading hotspots on to cloud platform and maintaining history of each hotspot using SCD Type 2 logic* Implemented ETL solution using Informatica.

• Core Adherence program is to identify patients who have received Patient Care Initiativesinterventions from client Pharmacy; at the time that patient is not a member of this pharmacy.RxDW (Prescription data warehouse).
• On-call Production Support for Data warehousing and Business Intelligence jobs andapplications
• Managing DWH Unix/Informatica ETL load Production issues and its recovery steps
• Implementation of Bug fixes and Service Improvement Plans
• Managing team in responding and resolving end user’s service requests within SLA
• Major and minor enhancements around Whole and retail business chains for the Customer

India

• Oracle RMS is a centralized system for managing and tracking inventory, an enterprise solutionthat integrates items, suppliers, and locations for the life cycle of the items. The project involvedcapturing item data.
• Worked closely with client for the entire project duration
• Development and Unit Testing using Informatica PowerCenter and Toad for Oracle
• Creation Detailed design documents
• Participated in code and design reviews and also used check style tool for code qualityimprovements.

Netherlands

• The objective of this project was to retrieve the Talkmobile Pay Monthly Upgrade salesinformation which included both automated eligibility checks and activations through the BOreportsRoles and Responsibilities:
• Analyzed business requirements document and prepared estimates
• Presented High Level Design (HLD) Workshop with client Solution Architect
• Created HLD document and presented an HLD walkthrough with development team beforecode commencement
• Development and Unit Testing using Informatica PowerCenter and Toad for Oracle
• Creation Detailed design documents

Thiruvananthapuram Area, India

* Analyzed business requirements document and prepared estimates* Presented High Level Design (HLD) Workshop with client Solution Architect* Created HLD document and presented an HLD walkthrough with development team before code commencement* Development and Unit Testing using Informatica PowerCenter and Toad for Oracle* Creation Detailed design documents*.

India

• The objective of this project was to build ETL components for loading UNICA Campaign Martwhich will enable client business users to set up and execute effective marketing campaignsRoles and Responsibilities:
• Creation Detailed design documents
• Worked with a team of 5 to develop the ETL solution using Informatica that would enabletransition from Epiphany to Unica.
• Created and tested Unix shell scripts transfer and to validate files between various hosts
• Managed communication with third party teams to align the solution with businessrequirements.
• Engaged in the different phases of internal and User acceptance testing of the developedsolution.