Venkatesh Lingutla

About Venkatesh Lingutla

12+ Years of total IT experience and Technical proficiency in the Data Warehousing and Big Data space,involving Business Requirements Analysis,Use case evaluation,Solution Architecting,Application Design,Data Modelling,Development,testing and documentation.•Strong understanding of the principles of Data warehousing,slowly changing Dimension techniques,Fact Tables,Dimension Tables,snowflake schema,star schema,Conceptual,Physical and Logical Data modelling.•As a Tech Lead leading couple of resources and Involved in full lifecycle of various Data Science and Data Engineering projects,including use case/vendor evaluation,vendor/software onboarding,requirement gathering,system designing,application development,enhancement,deployment,execution and support. •Expertise in Architect/Designing Big Data solutions using various tools & technologies including but not limited to Apache Spark,Python,Hadoop,Graph Databases(RDF,LPG),Azure cloud,kafka streaming,PowerBI/ Tableaue solutions.•Working experience in addressing various cyber security/PII concerns raised by internal security personnel.•Experience with AWS Services like S3,Redshift,EMR,EC2 and DMS and good understanding of other AWS cloud services•Design and Developing Data Engineering platform in Microsoft Azure Cloud and experience with services like EventHub,Data Factory,Data bricks,Blob storage.•Hands on experience in Azure and Data bricks admin activities to grant and revoke permissions to team members.•Excellent in designing and developing Data Ingestion pipelines into HDFS,AWS S3,Azure Blob from heterogenious data sets like json,RDBMS,flat files,and real time data sets.•Experience in streaming data ingestion using Kafka and stream processing platforms like Apache Spark Streaming•Outstanding Experience in Teradata Database design,implementation and maintenance mainly in large scale Data Warehouse environments,experience in Teradata RDBMS using FastLoad,MultiLoad,TPump,FastExport,TPT,Teradata Parallel Transporter and BTEQ utilities.•Certified Teradata consultant with experience in Teradata Physical implementation and Database Tuning,technical and functional applications of RDBMS,Data Mapping,Data management,Data transportation and Data Staging.•Extensive database experience and highly skilled in SQL in Oracle,MS SQL Server,Teradata,Mainframe Files,Flat Files,MS Access.•Technical expertise in ETL methodologies,Informatica 9.1 - Power Center,Client tools – Mapping Designer,Workflow Manager/Monitor and Server tools – Repository Server Manager.

Experience

1. Consultant, Data Engineering

   Dell Technologies

   Apr 2022 — Present · Round Rock, TX, US

   Applied Data Science and Engineering

Education

• Anna University Chennai

  Bachelor of Engineering (B.E.), Electrical, Electronics and Communications Engineering

  2003 — 2007

Skills

• Teradata
• Teradata Data Warehouse
• Teradata Sql
• Informatica
• Powercenter
• Performance Tuning
• Agile Project Management
• Hadoop
• Hive
• Apache Pig
• Sqoop
• Flume
• Shell Scripting
• Unix
• Bteq
• Mload
• Fastload
• Tpt
• Fastexport
• Control-M
• Wlm
• Opswise
• Viewpoint
• Jira
• Mapreduce
• Mysql
• Oracle
• Healthcare
• Scrum
• Data Modeling
• Uc4
• Kalido
• Media Production
• Rally
• Sdlc
• Business Intelligence
• Requirements Analysis
• Python
• Apache Spark
• Scala