Namratha Kotekani
Dubai,UAE
Summary
Accomplished data engineer with expertise in cloud and big data technologies, including Azure Data Factory, Azure Databricks, and Azure Data Lake Storage. Proficient in programming languages such as SQL, T-SQL, PL/SQL, and Python, with a strong focus on data engineering processes like ETL pipelines and data orchestration. Skilled in data modelling techniques such as star schema and snowflake schema, alongside optimisation strategies like partitioning and cluster tuning. Adept at using version control systems like Git and Azure DevOps for continuous integration and deployment. Experienced in creating insightful visualisations with Power BI and advanced Excel to drive data-driven decision-making.
Overview
16
16
years of professional experience
2022
2022
years of post-secondary education
1
1
Certification
Work history
Data Engineer
Drydocks World - A DP world Company
Dubai
03.2023 - 01.2026
- Cloud ETL Orchestration: Engineered scalable data pipelines in Azure Data Factory (ADF) utilizing Linked Services and Triggers to ingest data from diverse sources (SQL, Blob, SFTP, API) into Azure Data Lake.
- Big Data Processing: Utilized PySpark within Azure Databricks for large-scale data processing, cleansing, and transformation to meet complex analytical and business reporting requirements.
- Multi-Source Data Ingestion: Managed automated ingestion and processing for various formats (JSON, CSV, Excel) using Azure Storage and ADLS, ensuring data availability for downstream analytics.
- DevOps & CI/CD: Streamlined deployment workflows using Azure DevOps for version control and Continuous Integration/Continuous Deployment (CI/CD) of data pipelines.
- Stakeholder & Reporting Collaboration: Facilitated requirement gathering sessions with business leadership to translate goals into technical specs, partnering with reporting teams to deliver curated datasets and high-impact Power BI reports.
- Operational Continuity: Monitored and optimized cross-application data flows, engineering preventive database mechanisms to mitigate risks and ensure zero business disruption.
- Automated Error Tracking: Developed automated error-log processing frameworks using PL/SQL to ingest diagnostic data into databases for trend analysis and root-cause identification.
- Data-Driven Insights: Architected dynamic Power BI dashboards and visualizations tailored to ad hoc business requirements, transforming complex technical metrics into actionable insights for executive decision-making.
Data/BI Engineer
Galadari Brothers Co. L.L.C.
Dubai
09.2020 - 12.2020
- Advanced Analytics: Engineered complex DAX measures and aggregations to track high-level KPIs and deliver actionable business insights using Power BI
- ETL Architecture: Designed automated Power Query pipelines to consolidate disparate data sources, improving data integrity and reducing manual processing time.
- Database Performance: Optimized PL/SQL stored procedures and views, significantly reducing query latency and enhancing backend efficiency for real-time reporting.
Career Break for Maternity
Dubai
01.2017 - 08.2020
- Actively upskilled in Data Engineering, Power BI and Python during a planned career break.
IT Consultant
Intertec System L.L.C.
Dubai
03.2015 - 12.2016
- Techno-Functional Interface: Translated business needs into technical specs by leading requirement gathering sessions and defining Scopes of Work (SOW).
- ITSM Implementation: Managed the deployment and support of LANDesk Service Desk, standardizing incident management workflows.
- ERP Optimization: Engineered complex PL/SQL (Procedures, Packages, Triggers) and SQL views to boost system performance and reliability.
- Data Engineering: Led end-to-end Data Migration and cleansing initiatives, ensuring high integrity through custom transformation scripts.
- Business Intelligence: Designed custom reports and performed ad-hoc SQL analysis to drive executive decision-making.
- Advanced Support: Resolved critical ERP issues via Tier 2/3 support, root-cause analysis for inhouse ERP Syros.
Database Engineer
Thomson Reuters
Bengaluru
08.2013 - 11.2014
- Scalable Framework Development: Engineered a generic ingestion service and reusable framework, enabling seamless data integration from diverse sources (APIs, SQL databases, flat files) into the Content Marketplace ecosystem.
- Data Pipeline Engineering: Developed complex Data Transformation Pipelines utilizing advanced PL/SQL packages and stored procedures to automate data cleansing and movement logic.
- Process Automation: Optimized system efficiency by automating critical data workflows using Database Triggers and scheduled DBMS jobs, reducing manual intervention.
- Analytics & Insight Generation: Restructured high-volume raw data into actionable insights through the design of complex SQL queries, materialized views, and data aggregations.
- Agile Collaboration: Delivered high-priority features within a Jira-based Sprint environment, collaborating with cross-functional teams across global regions to meet project milestones.
Oracle Developer (E-Business Suit)
Infosys Ltd.
Bengaluru
11.2009 - 07.2013
- Advanced ERP Engineering: Engineered high-performance PL/SQL packages and tuned complex database objects to optimize data transformations and maintain system integrity in high-pressure environments.
- SDLC & Design: Authored HLD/LLD technical specifications and managed full-cycle delivery, from unit testing to production release documentation.
- Production Support: Ensured 24/7 system stability through proactive Tier 2/3 incident resolution and continuous functional enhancements.
Education
Post Graduate Diploma - Data Science, Data Engineering
IIIT, Bengaluru
BengaluruBachelor of Engineering - Computer Science
Visvesvaraya Technological University
Belgaum, IndiaSkills
- Cloud & Big Data: Azure Data Factory (ADF), Azure Databricks, Azure Data Lake Storage (ADLS), Azure SQL Database, AZURE Logic apps
- Programming & Querying: SQL, T-SQL, PL/SQL, PySpark, Python, EDA using NumPy & Pandas
- Data Engineering: ETL Pipelines, Data Ingestion, Transformation, Orchestration, Scheduling, Monitoring
- Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling
- Optimization & Performance: Partitioning, Caching, Cluster Tuning, Delta Lake Optimization
- Version Control & CI/CD: Git, Azure DevOps
- Visualization & Reporting: Power BI, Advanced Excel, JSON, Parquet, CSV
Websites
Certification
- Databricks Certified: Data Engineer Associate
- Microsoft Certified: Azure Data Fundamentals DP- 900
- Databricks Certified: Generative AI Fundamentals
- Databricks Accredited: Databricks Fundamentals
- DP World Tech4Women: Advanced Power BI
- NASSCOM Certification: Data Science CERTIFICATES Program
- HackerRank: 5 STAR coder SQL and Python
ADDITIONAL INFORMATION
Visa Status: UAE Residential Visa (Husband Sponsored)
Timeline
Data Engineer
Drydocks World - A DP world Company
03.2023 - 01.2026
Data/BI Engineer
Galadari Brothers Co. L.L.C.
09.2020 - 12.2020
Career Break for Maternity
01.2017 - 08.2020
IT Consultant
Intertec System L.L.C.
03.2015 - 12.2016
Database Engineer
Thomson Reuters
08.2013 - 11.2014
Oracle Developer (E-Business Suit)
Infosys Ltd.
11.2009 - 07.2013
Bachelor of Engineering - Computer Science
Visvesvaraya Technological University
Post Graduate Diploma - Data Science, Data Engineering
IIIT, Bengaluru