Durgesh Gupta
Toronto,Canada
Summary
Collaborative and results-driven Data Engineering Leader with nearly 18 years of experience in data engineering, analytics, data warehousing, and business intelligence, primarily within the telecommunications domain. Proven expertise in designing and implementing cloud-native data solutions on Google Cloud Platform (GCP) and Informatica Cloud, with a strong focus on cost optimization, scalability, and performance.
- Deep experience in data modeling (Erwin, Star Schema, Snowflake), data governance, and data quality frameworks to support AI and reporting initiatives.
- Skilled in data ingestion from diverse sources including NoSQL (MongoDB) and APIs (e.g., JIRA, Lumen billing systems).
- Proficient in GCP tools such as Datastream, Dataflow, Datatransfers, Airflow, and Composer.
- Led CI/CD pipeline implementations using Git and Jenkins.
- Successfully architected and delivered solutions for major telecom platforms, including MMDL, CDW, PCM, CCDW, PANS, and PRISM.
- Strong background in reporting tools like Business Objects, QlikView, and Excel, including end-to-end migrations and security configurations.
- Adept at cross-functional collaboration with AI, product, and platform teams to deliver actionable data solutions that drive business performance.
Overview
2026
2026
years of professional experience
1
1
Certification
Work History
Data Engineering Manager/Architect
Lumen
01.2022 - Current
- Managed design and development of Billing, Customer/Account, and Product domains on GCP-BigQuery using Informatica Cloud Suite as ETL tool.
- Outlined strategies for Domain team to adhere to guidelines and best practices.
- Delivered near real-time data solutions for Marketing team to execute campaigns.
- Explored various CDC tools, including Mass Ingestion and GCP Data Stream, for efficient data processing.
- Designed integration of JIRA API data into BigQuery GCP, enabling on-demand reporting for executives.
- Led Lumen initiative focused on data quality and profiling utilizing Informatica tools.
- Oversaw Mongo DB ingestion processes into BigQuery to enhance data accessibility.
- Facilitated data governance initiatives to empower business with self-service data lineage understanding.
Data Engineering Manager/Architect
Lumen
01.2020 - Current
- Designed service and product activity flows for Mass Market business using Informatica, PL/SQL, and Unix shell scripting.
- Executed CRIS to ENSEMBLE conversion for Lifeline and PMP measures reported to Regulatory.
- Developed BlueMarble-Multiline solution for Lifeline and PMP initiatives.
- Implemented RAD ID changes for Lifeline reports distributed to USAC.
- Incorporated national verifier updates for Lifeline program.
- Created new reporting process in SSRS, triggered on-demand via PowerShell post-ETL completion.
- Identified improvements in information delivery and data capture through technical solutions.
- Prepared data model with standardized fact and dimension tables utilizing Erwin.
System Architect
CenturyLink
01.2017 - Current
- Gathered requirements from SMEs across various source systems and documented in Caliber.
- Estimated effort for application completion through Level of Effort assessments.
- Developed data models with standard fact and dimension tables using Erwin.
- Conducted data profiling to identify hit ratios and gaps in datasets.
- Provided logic changes to enhance matching processes for service location dimension ID.
- Documented fallout details for all non-matching records.
- Created service requests for one-time and ongoing data loads.
- Designed STTM for ETL processes and requirement specifications for reports.
Business Objects/QlikView Developer
CenturyLink
- Gathered requirements from SMEs across various source systems and documented in Caliber.
- Estimated effort for application completion through Level of Effort (LOE).
- Prepared high-level and low-level designs, including User Test Cases (UTCs).
- Processed and maintained documentation using SharePoint tool.
- Developed Campaign Management and Initiative Management dashboards in QlikView.
- Utilized Basecamp to source details for SFDC leads and opportunities.
- Analyzed metrics like Lead to Opportunity conversion and win rates for campaign management.
- Created reports on product activity, order status, customer churn, and opportunities.
Business Objects Developer
Silicon Valey Bank
- Recommended hardware and software configurations for Business Objects environment setup.
- Established new BO R3 environments, including DEV, QA, and UAT.
- Created detailed reports for data clean-up utilizing Audit database of BO.
- Managed user creation and access rights to ensure secure operations.
- Configured security roles to align with project requirements.
- Developed regression test cases to validate system functionality.
- Troubleshot issues encountered during report testing to enhance reliability.
- Assisted team members with technical challenges for seamless project execution.
Business Objects Developer
Johnson & Johnson
- Provided maintenance and support for ETL logic in PL/SQL to ensure optimal performance.
- Developed procedures and triggers to introduce new functionalities.
- Generated simple and cross-tab reports based on client requirements.
- Collaborated with sorter, rank, and alerter applications to enhance report generation.
- Created ad hoc reports to address specific client needs.
- Designed UNIX scripts to automate exception reporting.
- Enhanced existing reports to improve usability and accuracy.
- Conducted testing of existing reports and created test cases for regression validation.
Education
Bachelor’s degree - information technology
U.P Technical University
Skills
- Requirements Development: Use Cases, Identifying System Gaps, Source to Target Mappings
- Cloud and Data Architecture: GCP – BigQuery, Informatica (IICS), Azure
- Database Skills: Google – BiqQuery, Oracle, SQL Server, Mongo DB, Hive, Snowflake
- Data Engineering: Informatica Cloud, Informatica PowerCenter, Mass Ingestion, Data Integration, Data Quality, Data Profiling, Data Governance, Data modeling, Erwin, Master Data Management (MDM)
- Data Visualization: QlikView, PowerBI, Looker, Business Objects, SSRS, Webfocus
- Scripting: Bash shell programming, PL/SQL, SAS, PowerShell, Python
- IT Processes: JIRA, Caliber, Quality Center, Dimensions, Remedy
Certification
- Business Objects XI R2
- OCI 9i
Timeline
Data Engineering Manager/Architect
Lumen
01.2022 - Current
Data Engineering Manager/Architect
Lumen
01.2020 - Current
System Architect
CenturyLink
01.2017 - Current
Business Objects/QlikView Developer
CenturyLink
Business Objects Developer
Silicon Valey Bank
Business Objects Developer
Johnson & Johnson
Bachelor’s degree - information technology
U.P Technical University
Similar Profiles
Patrick McMahonPatrick McMahon
Network Technician at LumenNetwork Technician at Lumen
Alvaro RodriguezAlvaro Rodriguez
Lead Enhanced Premise Technician at LumenLead Enhanced Premise Technician at Lumen
Jennifer AndersonJennifer Anderson
HR Shared Services Coordinator II at LumenHR Shared Services Coordinator II at Lumen
Andrea Lira SanmiguelAndrea Lira Sanmiguel
AUDIO MIXER & BOOM OPERATOR at Toronto Film SchoolAUDIO MIXER & BOOM OPERATOR at Toronto Film School
Alireza KhoshgouAlireza Khoshgou
Sales Representative at Rogers / Fine Sight SolutionsSales Representative at Rogers / Fine Sight Solutions