Now you can Instantly Chat with Deepak!
About Me
- ETL architect with 12 and a half years of experience in implementing ETL solutions for Retailer/Banking/ Govt. Institution clients.
- Designed database for warehousing solutions.
- Documented ETL Designs, ETL Standards and ...
- Documented ETL Designs, ETL Standards and Source to Target mapping.
- Ensured data is clean, consistent and synchronized across source platforms.
- Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
- Enforced naming standards and data dictionary for data models.
- Experience in IBM DataStage Development tool and MS SSIS to design, develop and ETL Jobs.
- Gained Hands on experience in Information Analyzer.
- Extensive work experience on Web based and Windows applications using C# , VB. NET, ASP. NET, MVC, ADO. NET, AJAX, JavaScript, VBScript, XML, CSS, HTML, Browser compatibility, DHTML Technologies, Web API, XSLT, XML.
- Experience performing Unit and Integration Testing in the Development environments and experience in Bug Reporting and Fixing using Nunit and MSTest
- Hands on experience in Windows Communication Foundation WCF for rapidly building service-oriented applications that communicate across the web and the enterprise.
- Experience in using LINQ to SQL, LINQ to XML and LINQ to Objects for retrieving the data.
- Worked on performance tuning on application level and database level.
- Good experience in OOPs concepts. Extensive experience in SQL Server Database, developing T-SQL queries, stored procedures, views, functions, and triggers using SQL Server
Skills
Positions
Portfolio Projects
Description
I am the ETL lead for the project and designed solution for Initial Load and Delta Load.
ETL had 3 components which will load source to MDM, Source to DWH , MDM to DWH.
I have designed each component and assigned the some of the works to my team mates.
We have also designed the Data Warehouse.
Show More Show Less