نبذة عني
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 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 Informatica IICS, Informatica PowerCenter, Informatica Data Quality (IDQ), SQL, Python, Azure Data Factory (ADF), Azure Databricks, PySpark, and Power BI. Proven track record of optimizing data pipelines, reducing incident resolution time by 30%, and delivering actionable business intelligence. Experienced in Agile delivery, SLA management, and production support across enterprise-scale data warehousing environments.
الخبرة
Data Engineer / Senior Software Engineer
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.