Shylaja Nagarajan
About Shylaja Nagarajan
Shylaja Nagarajan is a Senior Data Engineer at Expedia, Inc. with extensive experience in ETL, data warehousing, and BI tools.
Title
Shylaja Nagarajan holds the position of Senior Data Engineer. She is currently working at Expedia, Inc. in the Greater Chicago Area, having started this role in 2016.
Education and Certifications
Shylaja Nagarajan holds a Bachelor of Technology (BTech) in Information Technology from Anna University. Additionally, she is certified as an Informatica PowerCenter developer and holds the certification of Teradata SQL Specialist.
Professional Experience at Expedia, Inc.
Shylaja Nagarajan has been with Expedia, Inc. as a Senior Data Engineer since 2016. She is based in the Greater Chicago Area. During her tenure, she has implemented complex business rules using reusable transformations and robust mappings/mapplets.
Previous Roles and Responsibilities
Before joining Expedia, Inc., Shylaja worked at Orbitz Worldwide as a Senior BI/ETL Software Engineer (2014-2016), The Allant Group as a Technology Lead / Senior Oracle / BI / ETL Developer (2012-2014), Thomson Reuters as a Senior ETL Consultant (2011-2012), Hyatt Hotels Corporation as a Senior ETL Consultant (2011), PepsiCo as an ETL Consultant (2010), and Bank of America as an ETL/BI Consultant (2007-2010). In these roles, she gained extensive experience in developing ETL objects using Datastage and Informatica and utilized Teradata tools for data warehousing tasks.
Technical Skills and Expertise
Shylaja Nagarajan is skilled in optimizing SQL queries and fine-tuning long-running SQL using Oracle's EXPLAIN plan and DBMS_STATS package. She is proficient in writing UNIX shell scripting and BTEQ scripting for data engineering tasks. She also has experience writing PL/SQL stored procedures and using Oracle partitions to enhance data storage and performance. Additionally, she has worked extensively with MicroStrategy to create and integrate reports and objects with data warehouses and possesses thorough knowledge of relational and dimensional data modeling for OLTP and OLAP applications.