Deepak Gupta Email & Phone Number

Noida, Uttar Pradesh, India

Noida Area, India

• Around 11+ years of IT experience in ETL Development, Enhancement, Maintenance, Production support, Data Modeling including Business requirement, system requirement gathering of Enterprise Data warehouses
• Worked at various client facing roles with extensive experience of working at client side.
• Sound experience as ETL Lead with active participation in Project Assessment, Project planning, Task creation, execution and monitoring, Estimation and managing stakeholder communication.
• Experience in Extraction, Transformation and Loading of data using Informatica and UNIX from heterogeneous source systems like Flat files, XML, Mainframe Files, Oracle, SQL Server, Teradata Netezza,TOAD
• Automation, Scheduling and monitoring of jobs with scheduler Control-M
• Hands on experience using Informatica Power Center 9.x/8.x and Business Objects.

• Interaction with Client to understand the Business Requirements and data model.
• Suggest Improvement to the existing data model to have enhanced functionalities.
• Performance tuning of legacy ETLs.
• Worked as Techno functional lead, attended requirement gathering sessions and meetings.
• Involved in Data profiling and data quality team work.
• Responsible for monitoring all the sessions that are scheduled for run, investigation of failed session and debugging the corresponding mappings.

Noida Area, India

• Assessment to identify gaps between existing HRIS Data Warehouse and newly new HRIS DW.
• Interaction with Client to understand the Business Requirements and data model.
• Determined organizational strategies for data integrity validation processes.
• Established policies and best practices for optimizing ETL data throughput/accessibility.
• Prepare Work Breakdown Structure.
• Played a key role in mentoring other staff members and a proven track record in knowledge transfer to other team members