Gangidi Sikindhar Reddy

• About 6 years Professional experience working as Data Engineer/Python Developer. • About 4 years of experience with snowflake and strong experience in migrating other databases to Snowflake. • Have good exposure with the star, snowflake schema, data modelling and work with different data warehouse projects. • Expertise in Data modeling for Data Warehouse/ Data Mart development, Data analysis for Online Transaction Processing (OLTP) and Data warehousing (OLAP)/ Business Intelligence applications. • Experience in design and development of Big data applications using Hadoop ecosystem frameworks and tools like Spark,Python, Scala, Storm HBase, Kafka, Flume HDFS, MapReduce, Sqoop, NiFi. • I have 6 years of experience with specialization in Data warehousing, Decision support systems and extensive experience in implementing the full life cycle data warehousing projects. • Familiarity with standard vocabularies such as SNOMED CT, RxNorm, LOINC, and ICD-10-CM within the OMOP CDM, facilitating semantic interoperability and accurate representation of clinical data. • Experience in Data Analysis writing complex SQL's. • Experience developing script using Python and Scala. • Demonstrable experience designing and implementing complex applications and distributed systems into public cloud infrastructure (AWS, Azure, etc…) • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. • Track record of collaborating with multidisciplinary teams within the OHDSI network and contributing to peer-reviewed publications advancing the field of observational research and real-world evidence generation. • Worked with various file formats such as CSV, JSON, XMLfile formats. • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. • Expertise in writing DDLs and DMLs scripts in SQL and HQL for analytics applications in RDBMS. • Good Experience in implementing and orchestrating data pipelines using Oozie and Airflow. • Experience in working with various build and automation like Maven, SBT, GIT, SVN, Jenkins. • Experience in understanding of the Specifications for Data Warehouse ETL Process and interacting with the designers and the end users for informational requirements.