Ayush Pandey

Results-driven Senior Technical Officer with 10+ years of expertise in Data Warehousing, ETL Development, Cloud Integration, and Data Quality, specializing in Informatica PowerCenter, Informatica Cloud (IICS), and MDM Informatica. Adept at designing, implementing, and optimizing large-scale data pipelines across Healthcare, E-commerce, Education, and Telecom domains.

• Proven ability to extract, transform, and load data from Oracle, Salesforce, Flat Files, Snowflake, Databricks, ensuring high-performance data processing.
• Spearheaded CI/CD pipeline implementation for Automated Backup & Deployment of IICS assets using Jenkins, IICS Asset Management CLI, and Source Control.
• Expertise in Salesforce CRM Configuration, Customization, and API-driven integrations, enhancing business workflows.
• Experience in real-time streaming services within IICS, enabling near-instant data availability and analytics-driven decision-making.
• Proficient in MDM Informatica, ensuring data consistency, governance, and centralization across enterprise systems.
• Strong experience in Informatica Data Quality, implementing cleansing, validation, and profiling to enhance data accuracy and reliability.
• Skilled in dimensional modeling (Star & Snowflake Schema), OLAP & OLTP, and performance tuning to resolve bottlenecks across sources, targets, and mappings.
• Proficiency in Python, SQL, and PL/SQL (including Stored Procedures, Triggers, and Packages), along with strong expertise in Shell Scripting and core XML technologies such as XPath, XQuery, and XML Schema.
• Led initiatives to build security frameworks supporting data privacy in cloud-based data solutions.
• Experienced in leading cross-functional teams, mentoring junior developers, and managing end-to-end project lifecycles.