Summary
Overview
Work History
Education
Skills
Certification
Passportno
Personal Information
Languages
Projects
Timeline
Generic
Irfana S

Irfana S

Data Integration Lead

Summary

Experienced data migration developer with a diverse background across multiple domains, including telecommunications. Seeking opportunities to leverage expertise in designing and executing seamless data migration strategies. Dedicated to driving efficiency and accuracy in data management processes to support organizational growth and success.

Overview

16
16
years of professional experience
1
1
Certification

Work History

System Analyst

Hexaware Technologies
11.2023 - Current
  • Analyzed Electronic Data Capture (EDC) systems
  • Developed and optimized data pipelines using Apache Spark
  • Collaborated with cross-functional teams for Databricks solutions
  • Integrated Kafka APIs for real-time data streaming and processing
  • Conducted performance tuning and optimization of Spark jobs and SQL queries
  • Conducted unit testing and integration testing of Databricks code.

Technology Analyst

Infosys Limited
11.2022 - 11.2023
  • Migrated on-premise ETL to Google Cloud Platform using Google BigQuery
  • Developed complex mappings in IICS Data Integration Service
  • Created parameters and variables for incremental data loading
  • Debugged mappings and traced errors using session log files
  • Involved in unit testing, integration testing, and resolving downstream dependencies.

Senior Software Engineer

UST Global
08.2013 - 07.2015
  • Developed enterprise data warehouse solutions
  • Created Informatica mappings, Teradata tools like BTEQ, MLOAD, and FAST EXPORT
  • Developed shell scripts for automation
  • Performed requirements gathering, design documentation, and testing
  • Handled production failures and batch schedule monitoring.

Software Engineer

Accenture Services Pvt Ltd, Chennai
08.2008 - 07.2012
  • Developed ETL code in Informatica for various projects
  • Responsible for solving tickets using Remedy Management Tool
  • Managed user groups and communicated with users regarding issues
  • Developed data mart and ETL routines for Celcom Telco Analytics.

Education

B-Tech -

SCT College of Engineering

HSC - undefined

Govt V&HSS

SSLC - undefined

Carmel GHSS

Skills

Informatica Powercenter (Versions 91, 1041)

Certification

Academy Accreditation - Databricks Lakehouse Fundamentals

Passportno

W5078918

Personal Information

Date of Birth: 04/07

Languages

English
Tamil
Hindi
Malayalam

Projects

EDC Archiver
Client: Parexel
Platform: Azure Databricks, Azure Data Lake, Informatica, Pyspark, Python, Kafka, Postman API
Role: Developer
Duration: Nov 2023 - Present

  • Developed and optimized data pipelines.
  • Integrated Kafka APIs for real-time data processing.

GPC Migration
Client: Genuine Parts Company
Platform: Informatica PowerCenter 10.4.1, IICS, Oracle SQL Developer 4.1, Google BigQuery
Role: Developer
Duration: Nov 2022 - Nov 2023

  • Migrated on-premise ETL to Google Cloud Platform.
  • Developed complex mappings and debugged mappings.

ODW/ QTG
Client: PepsiCo
Platform: Informatica PowerCenter 9.X, Teradata SQL Assistant
Role: Developer
Duration: March 2014 - July 2015

  • Developed and supported enterprise data warehouse.
  • Created Informatica mappings and Teradata tools.

EPDS V2
Client: Wellpoint
Platform: DB2, Informatica 9.1
Role: Developer
Duration: Aug 2013 - March 2014

  • Migrated source systems to central database.
  • Developed mappings and prepared documentation.

Symphony
Client: Ascension Health
Platform: Oracle 9i, Informatica 8.x, Unix
Role: Team Member
Duration: March 2010 - July 2012

  • Developed, tested, and debugged ETL code.
  • Prepared necessary documents.

myOrders
Client: Nokia Siemens Networks
Platform: .NET Framework 3.5, C#, SQL SERVER
Role: Team Member
Duration: March 2009 - Feb 2010

  • Developed intranet workflow solutions for order processing.

Celcom Analytics Project
Client: Celcom
Platform: Oracle 9i, Informatica 7.x
Role: Team Member
Duration: Dec 2008 - Feb 2009

  • Developed ETL code and performed unit testing.


Timeline

System Analyst

Hexaware Technologies
11.2023 - Current

Technology Analyst

Infosys Limited
11.2022 - 11.2023

Senior Software Engineer

UST Global
08.2013 - 07.2015

Software Engineer

Accenture Services Pvt Ltd, Chennai
08.2008 - 07.2012

B-Tech -

SCT College of Engineering

HSC - undefined

Govt V&HSS

SSLC - undefined

Carmel GHSS
Irfana SData Integration Lead