Reading: Enjoy exploring a wide range of books, especially science-fiction that sparks imagination and soft romance novels that offer thoughtful, emotional storytelling
Sahana Lokesh
Senior Executive - Data Engineer
Mysore,KA
Summary
Experienced Senior Executive leading a 9-member engineering team at Infocepts for client Petsmart, architecting and managing scalable, cloud-native data platforms on GCP using Databricks and Snowflake. Driving AI-driven solutions for Databricks compute optimization, with proven expertise in designing robust data pipelines, optimizing cloud infrastructure, and managing end-to-end data ops and batch processing workflows with a focus on reliability, efficiency, and continuous improvement.
Overview
4
4
years of professional experience
7
7
Certifications
Work History
Senior Executive - Data & Platform Engineering
InfoCepts | PetSmart
01.2025 - Current
- Leading a 9-member engineering team responsible for end-to-end data and platform operations at Petsmart.
- Designing and managing ETL workflows and pipelines for core domains - Sales, Digital Supplychain, Stores, Merchandising, and Customer Analytics.
- Driving Informatica to Databricks migration, including utility development for automated job and pipeline transitions.
- Built automation tools using Databricks REST APIs for job migration, scope/secrets management, and deployment standardization.
- Implemented Medallion Architecture where applicable to enable modular, scalable data design.
- Orchestrating DataOps and BatchOps, managing deployments across Databricks, Snowflake, and Tidal.
- Creating and maintaining streaming pipelines, ensuring resilience and minimal latency.
- Led Databricks upgrade from 10./11.3 LTS to latest LTS, including validation and production deployment.
- Enforcing RBAC, cluster policies, and workspace-level governance controls.
- Conducting detailed cost analysis on workflows across both Databricks and GCP to optimize spend.
- Managing DBFS, mount points, and secure access mechanisms.
- Analysed for the data mishap within the inventory (HMS) and worked to fix it to maintain resilience and data integrity across the pipeline.
- Enforcing PII/non-PII classification and masking policies to meet compliance requirements.
- Implementing Row-Level Security (RLS) and managing delta sharing and external table integrations.
- Developed a Snowflake write utility for seamless Databricks-to-Snowflake data movement.
- Leveraging Terraform for infrastructure provisioning, CI/CD automation, and policy enforcement.
- Leadings with tools such Cleo Harmony and Tidal batch scheduling, managing deployment windows, execution chains, and SLA adherence.
- Coordinating incident response through ServiceNow and JIRA during failures across GCP, Databricks, Snowflake, and Git, ensuring workflow continuity.
- Maintained platform stability during code freezes, handled dependency conflicts, and ensured safe release cycles.
- Contributed actively to SQL development and debugging across transformation layers and validations.
Data EngineerInformatica Developer
IBM | Xcel Energy ltd.
06.2022 - 01.2025
- Designing and Implementing Data Warehouse and Datamart applications, mainly involved in understanding and developing ETL processes using Informatica Power Centre ETL tool (9.6, 10.,10.5), IICS-IDMC data integration services (CDI), Application Integration service (CAI), Oracle, Teradata, SQL Server, Unix, Databricks.
- Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, Teradata, SAP ABAP, SAP BW, SQL server, CSV and Flat files.
- Expert in analyse, design & developing ETL solutions using Informatica Power centre 9.6, 10.5 (Repository Manager, Informatica Designer, Workflow Manager, Workflow Monitor) and IICS
- Extensively worked on Informatica Power Centre Designer Components- Source Analyzer, Mapping Designer & Mapplet's Designer, Transformation Developer and Workflow Manager.
- Experience in all phases of Data warehouse development from requirements gathering to develop the code, Unit Testing and Documenting.
- Hands-on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions for better performance.
- Experience in SCD Type 1/Type 2 mapping implementation to maintain the Data history.
- Proficient in Designing the Automation Process of Workflows and configuring/scheduling the Workflows for load frequencies.
- Creating on demand SQL connections using SQL Developer for script testing and Experience in Make complex SQL source queries to fetch data from different database/tables/source system.
- Experience in REST and SOAP API services of IICS.
- Experienced in informatica to Databricks migration project. I have experience in Python, Apache spark and REST API.
- Ensured all the workflows and ETL Jobs were processed with the scheduled time and rectified any errors in SQL(Oracle/Teradata) and Connectivity problems.
- Addressed Various Incidents and ADR Tickets raised by the client to ensure the smooth process of BO Reporting.
- Extensively worked on tools such as JIRA and ServiceNow. To Create Incidents or modify Incidents and to take respective actions on it.
- Worked with SQL, PL/SQL (stored procedures, functions, packages) within the mappings and to Help support team Investigating and fixing the bugs occurred in the production environment
- Confirming availability of Integration services, repository services & nodes
- Switching workflow connections from production to DR and vice versa at the time of DR Drills of applications.
- Worked with the Informatica Upgrade Testing and environment check from 9.6/10.0.1 to 10..0.
Data EngineerETL Production Support and Admin
IBM | Xcel Energy ltd.
09.2021 - 06.2022
- Hands-on experience in Error Handling and optimization process as part of ETL Production Support team.
- Experience in working as an Informatica Admin providing access control to all the teams and team members.
Education
M.Sc. - Data Science, Machine Learning
Manipal Academy of Higher Education
Bengaluru, India11-2025
B.E. - Electronics and Communication
Visvesvaraya Technological University
Bengaluru, India01-2021
Skills
Bigdata Stack/Technologies: GCP/Microsoft Azure - Databricks, PySpark, Snowflake
Database: Teradata, Oracle, MYSQL, Hive Meta Store
Data Engineering & Pipeline Orchestration: Databricks, Snowflake, Azure Data Factory, Google Dataproc Edge Node, Informatica, Cleo
Business Intelligence & Data Visualization: Power BI, Microstrategy
Programming & Scripting: Python, PySpark, Unix-Shell Scripting, SQL
Cloud based database: Azure Data Lake Storage, Azure Blob, GCP, Snowflake,HMS
Monitoring and Miscellaneous tools: Tidal Automation, Cleo Harmony, ServiceNow, JIRA, Confluence
Accomplishments
- Received Certificate of Appreciation from PetSmart for demonstrating strong customer centricity and delivering consistent value through data engineering initiatives.
- Honored to receive the IBM Growth Award 2023, recognizing my contributions towards driving innovative solutions and fostering business growth at IBM.
- Commended for Cross-team Collaboration, partnering with data science and analytics teams to deliver insights.
Certification
IBM CLOUD ADVOCATE -V1
Interests
Music: Love listening to music, discovering new artists, and exploring different genres
Cooking: Passionate about exploring diverse cuisines and trying out new recipes, enjoying the process of preparing flavorful dishes from different cultures
Cinematic Exploration: Keen interest in films and series to explore diverse storytelling techniques and cultural contexts
Declaration
I hereby declare that the information provided in this resume is accurate and true to the best of my knowledge. I understand that any discrepancies or false information may lead to disqualification from the hiring process or termination of employment.
Timeline
Senior Executive - Data & Platform Engineering
InfoCepts | PetSmart
01.2025 - Current
Data EngineerInformatica Developer
IBM | Xcel Energy ltd.
06.2022 - 01.2025
Data EngineerETL Production Support and Admin
IBM | Xcel Energy ltd.
09.2021 - 06.2022
M.Sc. - Data Science, Machine Learning
Manipal Academy of Higher Education
B.E. - Electronics and Communication
Visvesvaraya Technological University