Developer Informatica
Resume:
Deepak Mittal Email: ****.******@*****.*** Informatica Mapping Designer Mobile: 704-***-****
Teradata Certified Master V2R5
AWS Certified Developer/Architect
Summary
More than 13 years of strong experience in Data Warehousing, ETL development using Informatica and Teradata BTEQ scripts, Real time data streaming using Kafka & C# .NET programming.
Informatica Certified Mapping Designer and Teradata Certified Master V2R5.
Experience in end-to-end database ETL development using Informatica, MS SQL Server, BTEQ (Teradata), Fastload, FastExport, Multiload, TPump, Netezza and Oracle.
Experience in designing Logical/Physical Data Model and creating High Level Design, Low Level Design, Detailed Design, Application Interface Design, Table and ETL specifications.
Developed applications using Web Forms and Windows Forms using C#.
Provided solutions for better performance of Teradata, Informatica, SQL and C# based applications.
Involved in various stages of software development life cycle like requirements gathering/analysis, feasibility analysis, design, coding, testing and deployment.
Team player, quick learner, motivated and dynamic with excellent oral and written communication skills.
14 years of experience with Fortune 500 client in USA, involving direct customer interaction during specifications, development and product implementation phases.
Self learning AWS Cloud and become AWS Certified Cloud Practitioner, Developer & Solutions Architect Associate
Rewards & Recognitions:
Received ‘Rookie of the Year’ award in Infosys.
Developed various tools like Database Migration Tool, Cab Review Automation Tool and Data Validation Automation Tool - got accolades from higher management.
Received ‘Thank you’ and ‘Spirit’ card from Bank of America business team.
Project received ‘Customer Delight and Branding’ award for the excellent work on performance remediation in Teradata.
Received ‘Most Valuable Player’ award in Infosys.
Received ‘Star’ award
Education
University of Pune – Army Institute of Technology
Bachelor of Engineering, Computer Branch: July 2003 – May 2007
First Class with Distinction
Technical Skills
Database: Teradata V2R5 (Certified Teradata Master), Oracle,
SQL Server 2008, Netezza, DB2, Sybase
Data Access Tools: Teradata Queryman, BTEQ, Teradata SQL Assistant,
SQL * Plus, TOAD for Oracle, TOAD for SQL server, Netezza Aginity, TOAD for Data Analyst, SQL Developer, SQL Management Studio
Data Modeling Tool: ERWIN, Microsoft Visio
Database Utilities: Fastload, Fastexport, BTEQ Import, BTEQ Export, Multiload, TPump
Reporting Tools: SSRS, SSAS, Hyperion, Power BI
ETL Tools: Informatica Powercenter 8.6.1/9.0.1/9.5.1/10.2.0/10.4, SSIS, Confluent Kafka
Languages: SQL, PL/SQL, T-SQL, JCL, C, C++, C#, VB, VB.NET
Scheduling Tools: Autosys, CA7, CRON, CA Workload Automation (CAWA)
Operating Tools: Microsoft Windows, UNIX. Mainframe
Office Tools: Microsoft Word, PowerPoint, Excel, Access
Certifications -
Informatica Basic Mapping Design
Informatica Advanced Mapping Design
Introduction to Oracle 9i SQL
Advanced Teradata Certified Professional V2R5
Teradata Certified Administrator V2R5
Teradata Certified Application Developer V2R5
Teradata Certified Design Architect V2R5
Teradata Certified Implementation Specialist V2R5
Teradata Certified Master V2R5
Teradata Certified Professional V2R5
Teradata Certified SQL Specialist V2R5
Confluent Certified Developer for Apache Kafka
Confluent Kafka Certified Developer Course
AWS Certified Cloud Practitioner
AWS Certified Developer Associate
AWS Certified Solutions Architect - Associate
Project Profile
Natural Gas Data Core, Duke Energy Oct 2020–Till Date
Technology SQL Server, Oracle, Informatica 10.4, SSRS, SSAS (MultiDimensional & Tabular), SSIS, CA Workload Automation
Project Description Integration of Customer, Customer Account, Survey, Meters and Locates data into enterprise data warehouse using Informatica and SSIS.
Role Senior ETL Developer
Responsibility
Requirements Gathering and Impact/Feasibility Analysis, Design and Creation of High Level Design, Application Detail Design, Application Interface Design, Table Specs, Data Model.
Design and Development of complex Informatica mappings to integrate data from various systems into Data Mart and Data Warehouse for several different modules.
Performance improvement of various ETL processes; reducing load time from 64 hours to 4 hours.
Built multiple data cubes for ad-hoc reporting using SSAS and complex reports using SSRS.
Automated business processes to reduce IT support overhead by building several tools.
Managed Production deployments requiring co-ordination among internal and external teams.
Performed Unit and System Integration testing, and provided SIT/UAT support.
On-call rotation (24x7) involving resolving various critical issues and worked on several Service Disruption Events.
Troubleshooting and resolution of operational problems and issues.
Implementation and Support of various vendor applications, building of custom code to enhance the applications.
Environment Health & Safety Delivery & Support, Duke Energy Oct 2013–Oct 2020
Technology SQL Server, Oracle, Informatica 10.4, SSRS, Power BI, SSAS (Multi-Dimensional), .NET 4.5.2, CA7, Confluent Kafka
Project Description It involves bringing Emissions, Incidents, Chemical, Compliance data and integrating into corporate data warehouse and data mart.
Role Senior ETL Developer
Responsibility
Requirements Gathering and Impact/Feasibility Analysis, Design and Creation of High Level Design, Application Detail Design, Application Interface Design, Table Specs, Data Model.
Design and Development of complex Informatica mappings to integrate data from various systems into ECOM Data Mart, IMA Data Warehouse for several different modules.
Built multiple data cubes for ad-hoc reporting using SSAS and complex reports using SSRS.
Automated business processes to reduce IT support overhead by building several tools.
Single handedly designed, developed and presented solution for converting nightly data warehouse batch into near real time data streaming using Confluent Kafka platform.
Managed Production deployments requiring co-ordination among internal and external teams.
Performed Unit and System Integration testing, and provided SIT/UAT support.
On-call rotation (24x7) involving resolving various critical issues and worked on several Service Disruption Events.
Troubleshooting and resolution of operational problems and issues.
Implementation and Support of various vendor applications, building of custom code to enhance the applications.
Worked on various Kanban agile, Confluent Kafka and several other organization wide pilot initiatives.
Financial Accounting Control System, Wells Fargo Jun 2012–Oct 2013
Technology SQL Server, Oracle, Sybase, Informatica 9.1.0, Autosys
Project Description It involves bringing Fixed Income, Equity, TBA and other transaction data from various source system to FACS data warehouse and make it available for various downstream users after consolidation.
Role Senior Informatica Developer
Responsibility
Requirements Gathering and Analysis, Design and Development of complex Informatica mappings, Migration and Support during Users Testing.
Interacting with end users to clarify the requirements.
Doing unit testing and system integration testing.
Providing support during various test cycles.
Customer Proprietary Notification Information, AT&T Oct 2011–May 2012
Technology Oracle, Informatica
Project Description It involves bringing customer notification data from various sources and consolidating it into Oracle.
Role Senior Informatica Developer
Responsibility
Requirements Gathering and Analysis, Design and Development of complex Informatica mappings, Migration and Support during Users Testing.
Interacting with end users to collect the requirements.
Performance Tuning of existing Informatica mappings.
Creation of High Level Design, Application Detail Design, Application Interface Design, Table Specs.
Doing unit testing and system integration testing.
Providing support during various test cycles.
Personalized Course of Action, AT&T Oct 2011–Jan 2012
Technology Informatica, Teradata, ERWIN
Project Description It involves bringing data from T-Mobile to AT&T for purposes of servicing and/or migrating customers to AT&T and performance tuning of existing BTEQ scripts.
Role Technology Architect/Lead
Responsibility
Requirements Gathering and Analysis, Design and Development of Teradata scripts using BTEQ, MLOAD, FastLoad and FastExport utilities, Code Migration and Support during Users Testing.
Planning and providing technical guidance to the team.
Interacting with end users to collect the requirements.
Creation of High Level Design, Application Detail Design, Application Interface Design, Table Specs, Data Model and Teradata BTEQ/ FastExport scripts.
Doing end to end database development on Teradata using Teradata utilities like BTEQ, FastLoad, MLOAD, FastExport and TPump.
Performance tuning of existing BTEQ scripts.
Information Payment Rewrite, Bank of America Feb 2011–Sep 2011
Technology Informatica, Netezza, SQL Server and Oracle
Project Description It involves collation of commercial banking data from various Source Systems in SQL Server/Oracle to single Netezza Data warehouse. It involves creation of 60-80 Informatica mappings.
Role Team Lead/Developer
Responsibility
Requirements Gathering and Analysis, Design and Development of Informatica Mappings, Code Migration and Support during Users Testing.
Planning and providing technical guidance to the team.
Interacting with end users to collect the requirements.
Doing feasibility analysis and creating design documents.
Doing unit testing and system integration testing.
Providing support during various test cycles.
Data Mining and Metrics, Bank of America Feb 2011–Sep 2011
Technology Oracle and Informatica
Project Description It involves Performance Remediation of existing procedures in Oracle by converting them to Informatica and adding few data elements as per the business requirements.
Several hours per day were saved in this highly critical project for the bank, which helped in meeting SLAs. Received accolades from bank’s higher management for taking ownership and successful deliveries.
Role Team Lead/Developer
Responsibility
Requirements Gathering and Analysis, Design and Development, Code Migration and Support during Users Testing.
Interacting with end users to collect the requirements.
In-depth analysis of ETL scripts and implementation of remediation solutions.
Performance Tuning, Bank of America Mar 2010–Sep 2011
Technology Teradata
Project Description Performance Remediation of existing ETL scripts in HR Space of the bank. 2.3 billion CPU cycles per month were saved in this highly critical project for the bank. Received accolades from bank’s higher management for taking ownership and successful deliveries.
Role Lead Developer
Responsibility
In-depth analysis of ETL scripts and implementation of remediation solutions.
Technical guidance to the team.
Tuning ETL scripts
Compensation-Point in Time Reporting, Bank of America Aug 2009-Mar 2010
Technology Teradata
Project Description Using Teradata and Hyperion, this project reported on the compensation details of associates of bank at any point of time.
Role Developer/Team Lead
Responsibility
Development of ETL Scripts using Teradata.
Perform requirement gathering, coding, code review, testing and Performance Tuning of the ETL Jobs and database.
Used BTEQ, MultiLoad and FastLoad utility for loading the Teradata
Troubleshoot and tune SQL using EXPLAIN PLAN and prepared Test cases for the Project and debugging of code.
Staffing, Bank of America Jan 2009-May 2009
Technology Teradata
Project Description Using Teradata and Hyperion, this project reported on recruitments done by bank. It involved reporting on all the stages in the recruitment process of bank.
Role Developer
Responsibility
Development of ETL Scripts using Teradata in tight timelines.
Preparation and designing of ETL specs including furnishing of joining condition and Teradata SQL for MLOAD scripts and loading strategies.
Design mapping documents, which include details of field-to-field mapping between sources and target, Business (Transformation) Rules.
Total Rewards, Bank of America Dec 2008-Feb 2009
Technology Teradata
Project Description Using Teradata and Hyperion, this project reported on rewards facilities given by bank for childcare and adoption. Implemented complex logic for calculation of various measures.
Role Developer
Responsibility
Development of ETL Scripts using Teradata in tight timelines.
Report Usage, Bank of America Sep 2008-Dec 2008
Technology Teradata
Project Description Using Teradata and Hyperion, this project reported on usage of various application reports by bank associates. It tracked the usage and frequency to help in further decision-making. Suggested design changes for various critical tables to make it more effective for reporting purposes.
Role Developer/Team Lead
Responsibility
End to end development of ETL Scripts using Teradata in tight timelines.
Talent Management, Bank of America Jul 2008-Sep 2008
Technology Teradata
Project Description Using Teradata and Hyperion, this project reported on bank associates’ key skills, years of experience, ratings etc. This was critical for management of bench strength and skills of the employees.
Role Developer
Responsibility
End to end development of ETL Scripts using Teradata in tight timelines.
LaSalle PeopleSoft, Bank of America Feb 2008–May 2008
Technology Oracle
Project Description Oracle and Hyperion Intelligence based application for viewing data of LaSalle’s Employees like Deduction, Payment, Taxes, High Education and Personal Information based on their Employee IDs. Received recognition from client for taking sole responsibility and delivered the project much before timelines.
Role Developer
Responsibility
Analysis of client requirements and proposal of solution and development of PL/SQL Scripts using Oracle.
Associate Learning Program, Bank of America Aug 2007–Jun 2008
Technology Teradata
Project Description This project used Teradata for its data warehouse and Hyperion for front end reporting. It had information about various courses offered to bank’s associates and involved complex calculations for further decision making by management.
Role Developer
Responsibility
Development of ETL scripts using BTEQ and MLOAD utilities and enhancement of code quality & standards.
Contact this candidate