Hema Pathapatti

Background

About Hema Pathapatti

Experienced data professional with 13+ years of expertise in Data Warehousing, Business Intelligence, AWS Cloud, and Big Data environments, specializing in ETL, reporting, and data visualization. •Experienced in Retail, Banking, Healthcare, and Finance domains, handling large and complex datasets to support end-to-end data warehousing needs with a focus on scalability, optimization, and performance tuning. •Led multiple projects as a Data Engineer, delivering robust and high-performing data solutions. •Skilled in data modelling, ETL pipeline development, and building reporting and analytics solutions. •Proficient in end-to-end project management, from design to deployment and support. •Strong collaboration and communication skills, working effectively with stakeholders, business partners, cross-functional teams, and development teams. •Adaptable and quick learner, with a proven ability to adopt new technologies and take on challenging assignments. CORE COMPETENCIES Cloud Platform: AWS ETL: AWS Glue, Spark ETL, Informatica PowerCenter, IICS Informatica Intelligent Cloud Services, SSIS Databases & Analytics: Oracle, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Postgres, Snowflake, Teradata, Sybase, Netezza, Vertica, AWS RedShift, AWS Athena Scripting languages: SQL, PL/SQL, UNIX Shell Scripting Programming skills: Apache Spark, Python Data Warehousing: Data Modeling, Data Analysis Reporting: SAP Business Objects, SAS Enterprise Guide, SSRS, MicroStrategy Data Visualization: Tableau, Power BI, Amazon Quicksight Data Virtualization: Denodo Data Modelling: Erwin Scheduling tools: Active Batch, Autosys, Control-M CI / CD tools: Jenkins, Jules, Liquibase Version Control tools: Tortoise Git, SVN Other skills: Jira, Confluence, Sharepoint Operating Systems: Linux, Windows Server, Unix Soft skills: Effective Communication Methodologies: Agile & Waterfall