Prashant Goel Email & Phone Number

Meerut, Up, In

Gurugram, Haryana, India

Worked on two key projects:1. Data Movement Pod: Leading data ingestion from diverse sources (Flat Files, SQL Server, DB2, Salesforce, IMS Segments, etc.) to a Data Lake. Utilizing Informatica IICS/IDMC and PowerCenter to build ETL pipelines for Bulk and CDC load, ensuring data is cleansed and formatted correctly.2. Canadian Dental Care Plan (CDCP): Developing SCD 1 & 2 ETL pipelines using IDMC (Informatica Cloud) based on business requirements. These pipelines are based on two layered architecture which load data into PostgreSQL for BI team dashboards.Key Contributions:- Successfully contributed to multiple Agile and DevOps projects, earning several Performance Excellence Rewards.- Documented HLDs, LLDs, Job Inventories & Data Lineage for project architecture and ETL flow, aiding operations teams post-deployment.- Collaborated with business partners, analysts & directors to design optimized ETL mappings and taskflows.- Provided performance tuning suggestions for Informatica ETL mappings and workflows.- Extensively used parameters, expression macros, source partitioning, and push-down optimization to enhance processing efficiency.- Developed cloud integration parameterized mapping templates for various load processes (Stage, Dimension, Fact).- Actively participated in hackathons and technical events within the organization.Notable Projects:- Smart Assignment Project: Created flows to assign leads to agents using IICS.- PDF Cluster Migration: Transferred PDF file names from GRS to FileNet using Informatica PowerCenter.- Trident Project: Generated CSV files in masked and non-masked forms for different users using IICS.- Project Script: Transitioned clients from TELUS to ESC (Express Scripts Canada) using Informatica PowerCenter.- DLM (Data Life-Cycle Management) POC: Tested and integrated a third-party application (Privitar) with IICS.Involved in development, unit testing, deployment, and support documentation phases of projects.

Gurugram, Haryana, India

Pune, Maharashtra, India

Client: T-Mobile Netherlands (Telecom)- Expertise: Proficient in data warehousing concepts and ETL processes.- Roles: Contributed to Application Operations for 6 months and Application Development for 2 years.- Environment: Worked in Agile and DevOps settings, receiving multiple appreciations from management and team.- Automation: Automated several day-to-day team processes, enhancing efficiency.Key Projects and Contributions:- TESS Architecture: Worked on TESS, a data warehouse serving as the single integration platform in the IT landscape. TESS features a classical layered architecture, including staging, history, key normalization, 3rd normal form model (CDM), dimensional modeling, and an access layer with 10 standardized data marts for reporting and analytics.- Data Validation: Validated data loaded into Teradata through Informatica ETL pipelines and the data warehouse.- Technical Support: Assisted the team with technical issues across different layers in TESS.- Collaboration: Coordinated with business owners for day-to-day ETL progress monitoring and assisted other ETL developers in solving complex scenarios.- Review and Accuracy: Reviewed Informatica ETL mappings/workflows and SQL to ensure the accuracy of data warehouse and data mart Dimension and Fact tables.- Development Lifecycle: Involved in development, unit testing, deployment to higher environments, and support documentation phases of projects.

Bachelor'S Degree, Computer Applications

12, Non-Medical Science