Senior Data Engineer
London, United Kingdom
• Gather and understand the business requirements from business and prepare the functional/technical specification documents. • Responsible for creation of high Level and low level ETL design. • Assist team in development of ETL jobs and performance tuning. • Experience on parsing and extracting data from the JSON and XML files. • Analyze the source data to... • Gather and understand the business requirements from business and prepare the functional/technical specification documents. • Responsible for creation of high Level and low level ETL design. • Assist team in development of ETL jobs and performance tuning. • Experience on parsing and extracting data from the JSON and XML files. • Analyze the source data to define the segmentation in Vertica target table to utilize the MPP. • Perform testing – Creating unit test cases and conducting Unit testing and also fix the defects raised by the testing team. • Suggest, use and Implement reusable routines and best practices.
What company does Mayank Gupta work for?
Mayank Gupta works for MoneySuperMarket.com
What is Mayank Gupta's role at MoneySuperMarket.com?
Mayank Gupta is Data Engineer
What industry does Mayank Gupta work in?
Mayank Gupta works in the Information Technology and Services industry.
Who are Mayank Gupta's colleagues?
Mayank Gupta's colleagues are Nina Tanner, Philip Thompson, Glenn Sutton, Marta Biłas, Harry Chow, Gareth Monk, Jake Rigby, Michele Giardi, John Underwood, and Mikey Moran AMBCS
📖 Summary
DW/BI Developer having more than 6 years of experience on ETL/ELT tools and technologies.Data Engineer @ • Gather and understand the business requirements from business and prepare the functional/technical specification documents. • Responsible for creation of high Level and low level ETL design. • Assist team in development of ETL jobs and performance tuning. • Experience on parsing and extracting data from the JSON and XML files. • Analyze the source data to define the segmentation in Vertica target table to utilize the MPP. • Perform testing – Creating unit test cases and conducting Unit testing and also fix the defects raised by the testing team. • Suggest, use and Implement reusable routines and best practices. From May 2015 to Present (8 months) London, United KingdomSenior DW/BI Developer @ • Close to 6 Years of IT Experience as Informatica/Netezza/SQL Developer in Accenture. • Experience in business requirement analysis, design, development, implementation and testing of Data Warehousing using Data Extraction, Transformation and Loading. • Experience on Database/ETL level performance tuning, Pushdown optimization and Netezza integration with Informatica. • Working on Netezza/SQL scripts development through Framework (ELT). Also, have strong experience on UNIX shell scripting. • Trained on Data Science with R and Qlikview for Statistical data analysis. • Providing solutions and suggesting improvements to the current application architecture. • Experience with projects using both the traditional Waterfall and Agile methodologies. • Working in client facing roles for major global corporations across diverse domains with multi location teams. • Data Warehouse development experience with both Relational and Dimensional model. • Did Proof of concept for using SAP R/3 and SAP BW Powerexchange with Informatica Powercenter. • Designed the batch scheduling process using Tidal Enterprise scheduler. • Developed the automation tool that has been used to apply Informatica functions to String/Datetime columns with very less manual effort. (The tool is now matured and is part of Accenture Reusable Tools Library) • Completed Red Hat Certified Engineer program and performed role of Linux administrator in B.Tech(Final Year) for my Institution. From July 2009 to May 2015 (5 years 11 months) DW/BI Developer @ • Experience in Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading. • SAP R/3 and SAP BW Powerexchange experience with Informatica along with development of Stored Procedures. • Datawarehouse development cycle experience from scratch i.e. Staging, Relational, Dimensions, Fact and Warranty support. From July 2009 to February 2013 (3 years 8 months) Associate Software Engineer @ Informatica Developer responsible for creation of Mappings/Sessions. From July 2009 to August 2010 (1 year 2 months) B.Tech, Electronics & Communication @ Hindustan College Of Science & Technology From 2004 to 2008 Senior Secondary, Science @ CBSE, Delhi From 1992 to 2004 Mayank Gupta is skilled in: Informatica, Data Warehousing, Unix Shell Scripting, Unix, ETL, Business Intelligence, Oracle, Requirements Analysis, SQL, Integration, PL/SQL, Agile Methodologies, Testing, Microsoft SQL Server, Netezza
Introversion (I), Intuition (N), Thinking (T), Judging (J)
2 year(s), 10 month(s)
Unlikely
Likely
There's 88% chance that Mayank Gupta is seeking for new opportunities
Issued by Accenture India · February 2012
Enjoy unlimited access and discover candidates outside of LinkedIn
Trusted by 400K users from
76% of Fortune 500 companies
The most accurate data ever
Hire Anyone, Anywhere
with ContactOut today
Making remote or global hires? We can help.
No credit card required