Amit Tyagi
Senior DWH Architect
New Delhi
Summary
Dedicated and results-oriented Data Warehouse Architect with over 16 years of experience in designing and implementing robust data warehousing solutions. Proven expertise in leading end-to-end data warehouse development, from requirement analysis to deployment. Skilled in optimizing data architectures for high performance, scalability, and business intelligence.
Overview
17
17
years of professional experience
2
2
Languages
Work History
Sr DWH Architect
OakNorth Bank
01.2020 - Current
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Created sets of pre-fabricated systems architecture models for deployment at multiple facilities across enterprise-class organizations.
- Drafted conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.
- Authored full Center of Enablement (CoE) design plan optimized for governance and performance metrics sought by client.
- Collaborated with business analysts and data scientists to define data requirements for advanced analytics and machine learning projects.
- Implemented data modeling best practices and conducted regular training sessions to ensure data governance across the organization.
- Oversaw the migration of legacy data systems to modern cloud-based platforms, resulting in improved performance and cost savings.
- Implement and manage data integration strategies, overseeing ETL processes and ensuring data quality and consistency.
- Spearhead initiatives to enhance data security and privacy, ensuring compliance with industry regulations and internal policies.
SA L2
Publicis sapient
07.2015 - 01.2020
- Played a key role in designing and implementing data models for various business units, improving data consistency and accuracy for ETL processes.
- Conducted data profiling and analysis to identify opportunities for data quality improvements.
- Collaborated with IT teams to implement and optimize ETL processes for efficient data integration.
- Served as Data Engineering Lead to create a Data pipelines for cloud based data lake solution using ETL tools and AWS cloud platform.
- Implemented data Engineering best practices and conducted regular training sessions to ensure updated tech stack across the Team.
Assistant Manager(Architect CATE)
CitiBank
09.2014 - 07.2015
Sr Software Engineer (SME TALEND)
Accenture India
04.2013 - 09.2014
SSE
Viom Networks Ltd
05.2008 - 04.2013
Service Engineer
Siemens Communication
06.2007 - 12.2007
Education
B.Tech (IT) -
Dehradun Institute of Technology
SSC (Science) - undefined
SBD public School, New Delhi
HSC - undefined
Jyoti Model School, New Delhi
Skills
NoSQL Databases
undefinedTechnical Summary
Informatica PowerCenter, Informatica BDM, Talend Data Integration , Talend Big Data, MySQL, Oracle, DB2, PL/SQL, MS SQL Server, MongoDB, Autosys, Crontab, IBM Tivoli, Apache HADOOP, HDFS, HIVE, IMPALA, SPARK, MAP REDUCE, YARN, Unix Shell Scripting, C, SQL, Java, Python, Amazon S3, Cloudwatch, Lamda, GCP,AWS, BigQuery, Power BI, Jasper, OBIEE
Personal Information
- Date of Birth: 08/03/85
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Projects
Oak North DWH, Managing a DWH Vertical within the organization, Architect the Integration solution (ETL/Middleware) between downstream and upstream systems, Creation of the technical document of the ETL architecture, data migration and data validation process, Model front end and backend data source to enable powerful data analysis, Design Data pipelines that can be used to make predictive analysis, Solving Data related complex business problem, Designing Lending and Deposit Dashboards for daily and monthly reporting using Power BI, Evaluation of different Solutions for enterprise data need and finalize the best suited product, Help in evaluating RFP for multiple solutions CG Advance Reporting, Understand the requirements, Understand Source systems data and do data analysis, Create ETL architecture for data migration and data validation, Creation of the technical document of the ETL architecture, data migration and data validation process, Creation and migration of ETL pipelines and workflows from informatica powercenter 9.6 to Informatica BDM 10.2.1, Create Hive query for source and target definition, Optimize custom hive and spark query OV Agile, SME for Talend Development, Designing Talend Job and new solution to integrate with cloud, Performance optimization and Code review, Architect the new job flows and data modeling for new requirement, Setting up of Talend environment which involves installation of Talend Components, Perform Talend Admin activities like Upgradation of Talend Version, Upgradation of license, and Migration from one Talend version to another, User Creation, Project Creation etc., Architect the new cloud based technique i.e. ELB, ALB and auto scaling to optimize the performance of Talend Jobs Talend Optimization, Requirement gathering about the functionality of application, Individual contributor role for solution designing and testing, Create ETL jobs for Talend, Talend Installation and GPFS integration, Performance optimization and Code review, Architect the new job flows and data modeling for new requirement, Setting up of Talend environment which involves installation of Talend Components Operative Big data, Lead the team for Reporting module, Create Functional and technical Document, Create Wireframes and design document, Create Data model and test data, Define rules, workflow and procedures, Guide the team for creating MDX query and OLAP cubes, Guide the team for creating Adhoc View, Custom reports, Dashboards and Domains using Pentaho 5.5 Going Analytics a Jasper Way, Create Data model and test data, Define rules, workflow and procedures, Create Jobs for Data integration and Data Quality to build data warehouse, Create MDX query and OLAP cubes, Create Adhoc View and Custom reports in I report Designer and Jasper studio, Creating Dashboards and Domains, Testing and deployment on Jasper BI Server Big Data Asset Development, Create SCEMA and ETL architecture, Design Transform, Clean and Load JOBS using Talend, Integration with Hadoop and load the data into Hive, Performance testing and Optimization Big Data Integration with MDM, Requirement analysis and feasibility study, Create SCEMA and Data Model and Data Container design, Creating Roles and Workflow, Implementation of Triggers and Processes, Design Transform, Clean and Load JOBS using Talend Open studio, Security implementation, Documentation of User Manuals and User Training
Timeline
Sr DWH Architect
OakNorth Bank
01.2020 - Current
SA L2
Publicis sapient
07.2015 - 01.2020
Assistant Manager(Architect CATE)
CitiBank
09.2014 - 07.2015
Sr Software Engineer (SME TALEND)
Accenture India
04.2013 - 09.2014
SSE
Viom Networks Ltd
05.2008 - 04.2013
Service Engineer
Siemens Communication
06.2007 - 12.2007
B.Tech (IT) -
Dehradun Institute of Technology
SSC (Science) - undefined
SBD public School, New Delhi
HSC - undefined
Jyoti Model School, New Delhi
Similar Profiles
Ishita SaxenaIshita Saxena
NA at OakNorth Credit IntelligenceNA at OakNorth Credit Intelligence
Knarik Inna AghajanyanKnarik Inna Aghajanyan
Customer Service Representative III at HomeStreet Bank Bank, formerly Bank of OswegoCustomer Service Representative III at HomeStreet Bank Bank, formerly Bank of Oswego
Frank Gracia IIIFrank Gracia III
Preferred Bank Advisor at Western Alliance Bank (Alliance Bank of Arizona & Bridge Bank)Preferred Bank Advisor at Western Alliance Bank (Alliance Bank of Arizona & Bridge Bank)