About

Venkateswar Thatikonda is a Senior Data Engineer with over 9 years of experience in developing, managing, and supporting database-centric solutions. He has worked with multiple domains including Microsoft, Healthcare (HEDIS & Quality Reporting), and Financial domains. Venkateswar has 4+ years of experience in building applications using Spark, Hadoop ecosystem components like HDFS, MapReduce, Pig, Hive, HBase, Sqoop, Oozie, and Kafka. He also has 3+ years of experience on AWS cloud technologies like S3, EC2, Glue, RDS, AWS EMR, Redshift, Databricks, and Code Deploy. With 6+ years of experience on Microsoft technology stack (T-SQL, SSIS, SSAS, MDX, DAX, PowerPivot, and Power BI reports), ETL/ ELT tools, Venkateswar has worked on several relation databases including SQL Server, MySQL, and PostgreSQL. He has 3+ years of experience on MPP database system Greenplum. Venkateswar has expertise in creating, debugging, scheduling, and monitoring jobs using Airflow. He is also experienced in performing various performance tuning activities at both the database level. Venkateswar has a good understanding of Dimensional Modelling techniques and is well-versed with Star and Snowflake schemas, slowly changing dimensions, Junk dimensions, Role-playing dimension, and Degenerated dimension. He has experience working in multiple projects utilizing Agile methodologies and Scrum. Venkateswar has implemented Drill down, Drill through, and several complex Power BI, Tableau, and SSRS reports. He has also performed code reviews and encouraged coherent and high-quality code. Currently working as a Senior Data Engineer at AARP, Venkateswar has gathered requirements and designed solutions to migrate Informatica Pipelines to Spark using Python. He has created a Cloud Formation template for AWS EMR cluster, EC2, Route53, Redshift, and EFS resources. Venkateswar has migrated the legacy Map Reduce and Pig jobs to Spark with Python. He has developed Custom operators in Airflow to spin up and spin down the AWS EMR Cluster. Venkateswar has also developed spark UDFs and Aggregated functions to transform and enrich data. He has automated AWS Infrastructure creation using AWS CFT APIs. In his past roles, Venkateswar has worked as a Senior Data Engineer at CMFG Life