Aneesh K S
Summary
Lead developer in ETL and MDM with a successful track record, focusing on Informatica MDM and data integration. Expertise in designing effective data solutions and improving data quality, alongside leading offshore teams. Demonstrated success in optimizing processes for enhanced efficiency and promoting collaboration across various stakeholders.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Specialist — MDM & ETL Lead Developer / Offshore Team Lead
Novo Nordisk
10.2018 - Current
- Serving as Offshore Team Lead, and Lead Developer across multiple concurrent MDM and ETL programs, owning end-to-end delivery from requirements through production.
- Act as primary liaison between onshore business stakeholders and the offshore delivery team, translating complex pharmaceutical data requirements into actionable MDM solutions.
- Design and implement Informatica MDM solutions (SaaS Hosted MDM & On-Prem) for HCP/HCO and Product data domains.
- Hands-on Informatica MDM Hub development experience spanning Hub Console configuration, Schema Manager, Landing/Staging/Base Object design, Match & Merge rules, Trust & Validation frameworks, Cleanse functions, IDQ integration, and Batch Job orchestration (Stage, Load, Match, Consolidate).
- Configured and customized Informatica MDM UI components including Product 360 (P360) and Informatica Data Director (IDD) — designing page layouts, relationship tabs, subject area configurations, and workflow-driven stewardship screens to deliver intuitive data stewardship experiences for business users.
- Architect and develop ETL/ELT pipelines using Informatica Data Integration to integrate data from diverse internal and external source systems into MDM hubs and Snowflake data layers.
- Implement Informatica IDQ data quality rules, profiling, and scorecards to enforce data standards and downstream data integrity.
- Migrated data pipelines from legacy SFTP-based transfers to a modern Informatica IDMC, Snowflake, and AWS S3 architecture, improving data security, throughput, and scalability.
- Designed and deployed an in-house scheduling solution to replace third-party scheduler, delivering significant cost reduction with no degradation in pipeline SLAs.
- Built a Python desktop automation tool to streamline a high-volume data request workflow — reducing manual effort by ~70% and eliminating process bottlenecks.
Senior Software Engineer — ETL & Data Integration
KPIT Technologies
11.2016 - 10.2018
- Delivered L3 SME support for enterprise IBM DataStage environments, owning incident resolution, performance tuning, and environment maintenance across production landscapes.
- Optimized DataStage jobs for throughput and reliability, reducing batch processing times and resolving recurring data pipeline failures.
- Scheduled and monitored job workflows using Control-M Workload Scheduler; coordinated with UNIX admins and DBAs to ensure environment stability.
- Analyzed complex data quality issues and collaborated with upstream source teams to implement root-cause fixes.
Project Engineer — ETL Developer
Wipro Technologies
03.2013 - 10.2016
- Developed and maintained ETL pipelines using IBM DataStage to load data from Oracle, MS SQL, and flat-file sources into enterprise data warehouses.
- Created source-to-target mapping documents and collaborated with business analysts to translate business requirements into technical ETL specifications, ensuring alignment with project goals.
- Enhanced OBIEE reporting layers in response to business data requests and scheduled job flows via Control-M to ensure timely processing within SLA-driven windows.
Education
Master of Computer Applications -
Rajiv Gandhi Institute of Technology
KottayamSkills
- Informatica MDM
- IDMC
- Informatica PowerCenter
- MDM implementation
- Data modeling
- Data quality
- IBM DataStage
- Snowflake and Oracle SQL
- PL/SQL scripting
- Python scripting
- Control-M scheduling
- Cloud DevOps
Certification
- Certified SAFe 6 Product Owner / Product Manager
- AWS Certified Cloud Practitioner
- IBM Certified Solution Developer — InfoSphere DataStage v9.1
Projects
- Product Master — MDM Implementation, Implemented Informatica MDM SaaS to manage a hierarchical Product Master for Novo Nordisk's pharmaceutical portfolio, integrating IDMC, IDQ, and Cloud Application Integration services. Designed product hierarchy data models, enrichment workflows, and data quality rules to ensure consistent product data across ERP, regulatory, and commercial systems. Utilized Snowflake as the primary Stage and Publish layer with AWS S3 for file-based data sourcing; coordinated integration with multiple downstream distribution channels. Designed and configured Product 360 (P360) pages to provide business users with a unified, relationship-driven view of product master data — including custom page layouts, relationship tab filters, and workflow-driven data stewardship screens.
- Customer Data Master — Migration & Modernization, Led migration of a large-scale US-region Customer MDM (HCP/HCO/MCO) from Informatica PowerCenter + On-Prem MDM to Informatica IDMC (IICS) + Informatica Hosted MDM. Headed the Data Integration workstream: re-architected all ETL pipelines, orchestration logic, and scheduling for the cloud-native target platform. Migrated Pre-MDM and Publish layers from Oracle to Snowflake and transitioned all file-based transfers from SFTP to AWS S3, enhancing performance and security posture. Replaced a proprietary third-party scheduler with an in-house orchestration framework — reducing operational licensing costs while maintaining 100% SLA adherence. Coordinated integration testing, UAT, and cutover planning with 10+ source and downstream teams, ensuring zero data loss during go-live.
- NNCI MDM — HCP/HCO Master Data (Canada), Implemented an Informatica MDM solution to centralize HCP and HCO master data for the Canada region, covering data ingestion, match/merge configuration, and golden record publication. Configured match rules and survivorship strategies aligned to business needs. Designed data integration workflows using Informatica IDMC for sourcing from internal CRM, ERP, and external reference data providers. Leveraged Snowflake and Oracle for staging and analytics layers, enabling downstream Salesforce and reporting consumers.
- Org Manager — DataStage to PowerCenter Migration, Served as Senior Developer for the end-to-end migration of Data Integration components from IBM DataStage to Informatica PowerCenter, driving technical design decisions and hands-on development throughout. Spearheaded the database redesign and independently executed the Oracle-to-Snowflake migration for the Org Manager data layer, ensuring architectural integrity and uninterrupted data flows post-cutover.
Timeline
Specialist — MDM & ETL Lead Developer / Offshore Team Lead
Novo Nordisk
10.2018 - Current
Senior Software Engineer — ETL & Data Integration
KPIT Technologies
11.2016 - 10.2018
Project Engineer — ETL Developer
Wipro Technologies
03.2013 - 10.2016
Master of Computer Applications -
Rajiv Gandhi Institute of Technology