Aakash Deep Aggarwal

• Led presales solutioning for Azure-based data platforms, showcasing capabilities in Data Factory, Synapse, Purview, and governance tools.
• Designed scalable architectures integrating Informatica MDM, CDI, ETL pipelines, and DQ frameworks tailored to client domains.
• Conducted stakeholder workshops and discovery sessions to align technical solutions with business goals and compliance needs.
• Authored winning RFP/RFQ responses with detailed scope, effort estimation, and delivery timelines.
• Presented demos and technical walkthroughs to CXOs and IT leads, driving confidence in proposed data modernization strategies.

• Led end-to-end implementation of Informatica MDM solutions, from client requirement gathering to production deployment.
• Designed and configured data models, match & merge rules, and workflows using MDM Hub, CDI, and CAI.
• Integrated IDQ for profiling, cleansing, and validating master data across domains.
• Collaborated with business and IT stakeholders to ensure scalable, governed, and high-quality master data architecture.

• Led a development team in implementing end-to-end Informatica MDM solutions, including CDI, CAI, and IDQ components.
• Gathered and analyzed client requirements to design robust data models, match & merge logic, and workflow orchestration.
• Oversaw development and integration of data quality rules, profiling, and cleansing using IDQ and governance tools.
• Coordinated with cross-functional teams to ensure timely delivery, scalability, and compliance of master data architecture.

• Working as a Senior Developer, implemented and optimized Informatica MDM solutions with seamless integration of PowerCenter and IDQ for robust data processing and quality.
• Led development of match & merge logic, data cleansing rules, and ETL workflows to ensure high-integrity master data across systems.

• Worked as a Senior Developer leading Informatica PowerCenter migration projects, ensuring seamless transition of ETL workflows to modern platforms.
• Handled impact analysis, mapping logic redesign, and performance optimization to maintain data integrity and minimize downtime during migration.

• Engineered and launched warehouse database structures.
• Monitored loading jobs on daily basis to ensure that all ETL jobs are running as scheduled.
• Migrated existing code base from lower version of informatica to higher version.
• Implemented error handling logic for failed ETL loads using error log tables in Oracle Database or flat files generated by Informatica PowerCenter.
• Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
• Detected and resolved data quality issues and discrepancies for integrity and quality control.
• Performed unit testing of mappings, sessions and workflows developed in Informatica PowerCenter.
• Worked closely with Business Analysts and End Users for gathering requirements and providing technical solutions during design phase .
• Tested and validated the loaded data in the target system for accuracy and completeness.
• Developed shell scripts to schedule the execution of ETL jobs through Cron scheduler on UNIX platform.
• Automated the scheduling process of executing multiple concurrent tasks within an application environment utilizing Workflow Manager feature of Informatica PowerCenter 8.x and 9.x versions.
• Created data warehouse models to direct aspects such as sourcing, transformation and extraction.