Sowmya N

Sowmya N

Data Engineer
UAE
Kannada, Telugu, English, Hindi

نبذة عني

Data Engineer and Informatica Intelligent Cloud Services (IICS) Developer with 4 years of experience in ETL/ELT pipeline development, data migration, data quality, and cloud-based data integration. Proficient in Informat…

الخبرة

Data Engineer / Senior Software Engineer

HCL Technologies
Feb 2022 - Mar 2026 · 4 سنوات 1 شهر

Designed, developed, and maintained ETL/ELT pipelines using Informatica PowerCenter, Informatica IICS, and Fivetran.
Optimized SQL queries to improve data accuracy and reduce pipeline processing time.
Developed and maintained data quality scorecards and dashboards using Informatica Data Quality (IDQ).
Conducted deep-dive data profiling to detect patterns, outliers, and structural gaps within large datasets.
Utilized Fivetran automated ELT connectors to replicate data from multiple source systems into the enterprise data warehouse.
Enhanced data availability and reduced ingestion time.
Developed Python scripts for advanced data processing and automation on Informatica IICS servers.
Increased workflow efficiency and reduced manual intervention.
Created Azure Databricks notebooks using Python, SQL, and PySpark for large-scale analytics and distributed data processing.
Built and managed Azure Data Factory (ADF) pipelines for end-to-end data orchestration.
Developed Power BI dashboards providing actionable insights into customer behaviour trends.
Improved targeted marketing campaigns and increased customer engagement by 15%.
Implemented preventive monitoring and alerting measures to minimize system downtime by 15% and improve overall platform reliability.
Managed version control and collaborative code reviews using GitHub within Agile sprint delivery cycles.
Implemented Slowly Changing Dimension (SCD) Type 1 and Type 2 methodologies to track and manage historical data changes across the enterprise data warehouse.
Reduced incident resolution time by 30% through proactive root-cause analysis and automated alerting frameworks.

المهارات

Informatica IICS Informatica PowerCenter Informatica Data Quality (IDQ) Fivetran Microsoft Azure Azure Data Factory (ADF) Azure Synapse Analytics Azure Databricks PySpark Azure Data Lake Storage (ADLS) Oracle Microsoft SQL Server MySQL Python SQL Power BI Data Warehousing Data Modeling Data Pipeline Development Cloud Migration SCD Type 1 SCD Type 2 ETL/ELT Development Agile Scrum ServiceNow GitHub Generative AI Prompt Engineering
الإبلاغ عن هذا الملف الشخصي؟