Gaurav Gupta

• Led the implementation of data governance frameworks and policies aligned with organizational data strategy and regulatory requirements.
• Partnered with business and IT stakeholders to define data ownership, stewardship roles, and responsibilities.
• Conducted assessments to identify data quality issues, gaps in metadata, and opportunities for data standardization.
• Designed and rolled out data governance operating models including workflows for issue management, policy enforcement, and escalation procedures.
• Facilitated Data Governance Council meetings and drove consensus on data definitions, KPIs, and governance priorities.
• Implemented data catalog and glossary tools (e.g., Informatica Axon, EDC and CDGC) to improve metadata visibility and business understanding.
• Developed and maintained business glossaries, data dictionaries, and lineage documentation to ensure consistent data use across the organization.
• Supported data classification, tagging, and access control initiatives to ensure compliance with privacy and security standards (e.g., GDPR, HIPAA).
• Created training materials and conducted workshops to raise awareness and adoption of data governance principles among business users.
• Collaborated with Data Quality teams to define critical data elements (CDEs) and establish validation rules and monitoring processes.
• Enabled self-service analytics by ensuring curated, trusted data assets were available to data consumers.
• Assisted in integrating governance practices into data integration, warehousing, and reporting environments.
• Role: Data Governance Consultant

• Acted as an ETL Consultant and Informatica SME for the Rapid Data Labs (RDL) team, supporting global delivery with both onshore and offshore resources.
• Led end-to-end development of ETL workflows using Informatica PowerCenter to extract, cleanse, transform, and load data from Microsoft SQL Server and Salesforce into target SQL Server environments.
• Created comprehensive documentation, including Business Understanding documents, Source System Analysis, and Logical and Physical Data Models, to support data integration efforts.
• Designed and implemented automated recovery mechanisms for approximately 600 Informatica jobs, including self-executing scripts to re-run failed jobs.
  Job monitoring scripts are designed to alert and log execution status, reducing manual intervention and error rates.
• Applied Slowly Changing Dimension (SCD) techniques for dimensional tables, and implemented incremental loading strategies for fact tables.
• Conducted data validation and quality assurance testing by comparing source and target systems to ensure data accuracy.
• Built interactive dashboards and reports in Microsoft Power BI; performed validation between dashboard data and source systems to ensure consistency.
• Delivered multiple enhancements and upgrades within client-imposed infrastructure restrictions, improving job stability, and reducing failures.

Role: Application Lead

• Delivered L2 support for production jobs, ensuring timely resolution of defects and monitoring of critical cycles.
• Acted as shift lead during night shifts, managing incident queues and coordinating resources to meet SLAs.
• Automated routine monitoring processes to enhance efficiency and minimize manual intervention.
• Conducted comprehensive handovers and knowledge transfer sessions for onboarding new team members.
• Utilized IBM DataStage for identifying ETL job failures and provided resolutions to maintain system integrity.
• Assigned daily tasks to team members, overseeing high-priority incidents for effective resolution.
• Performed root cause analysis (RCA) on defects, implementing fixes to restore job functionality promptly.
• Executed regular support tasks, including user request handling and health checks of ETL environments.

Role: Application Shift Lead

Project Name: L2 Production Support

• Migrated 1.8 million customers from legacy Copper to upgraded Fiber platform with customizations based on contracts.
• Developed ETL workflows in Informatica PowerCenter, creating mappings and complex transformations for business needs.
• Engaged with designers and stakeholders to clarify use case requirements through one-on-one sessions.
• Analyzed business logic for alignment with ETL capabilities and scalability of solutions.
• Conducted peer code reviews, documenting feedback to ensure code quality and consistency.
• Created Unit Test Case documentation with output snapshots for validation and traceability.
• Performed deployment activities using SVN for version control and release management.
• Managed defects using HP Quality Center, collaborating with testers to resolve issues efficiently.

Role: ETL Developer.

• Initiated career as ETL Developer, gaining expertise in Informatica PowerCenter and data integration practices.
• Designed and developed ETL mappings utilizing transformations including Source Qualifier, Lookup, Router, and Update Strategy.
• Created and managed workflows in Workflow Manager to facilitate end-to-end data pipeline execution.
• Conducted unit testing of developed components while documenting test cases for validation and traceability.
• Established a strong understanding of Informatica architecture, design patterns, and performance optimization strategies.

Role: ETL Developer