Imran Khan profile photo 1 on Tal

Imran Khan

ETL/IICS & Informatica Developer | IICS/IDMC |SQL server | Oracle| Netezza | Redshift |Informatica Power Center| |Ex Capgemini | Ex proc DNA analytics Pvt Ltd| Quess Corp Pvt Ltd | Immediate Joiner

Bengaluru

3+ years of work experience

Quess Corp Limited
Aug 20242 yrs 1 moPresent

Chennai, Tamil Nadu, India

As an ETL Developer, I worked extensively on production support and data issue resolution. I implemented fixes for various data issues in IICS CDI mappings and mapping tasks, ensuring smooth and accurate data processing. I focused on performance tuning and optimization of mappings and task flows to enhance efficiency. I also worked on the Automic Scheduler to schedule, monitor, and maintain jobs, and resolved ServiceNow incidents based on priority to minimize business impact. Additionally, I mentored a team of eight to ten members and collaborated with cross-functional teams to identify root causes and implement long-term solutions for recurring issues.
ProcDNA analytics pvt ltd
Jul 20233 mosSep 2023

Guargon

As a Data Engineer Specialist at Proc DNA analytics Pvt Ltd, I worked on Informatica Intelligent Cloud Services (IICS) to build mappings and mapping tasks that moved data from flat files to staging tables. My responsibilities included managing different data transformations, optimizing performance, and resolving data issues. I also used Redshift and Toad for SQL query optimization and to maintain data synchronization between development and production environments. In addition, I created task flows, worked closely with clients, and led a team of six members.
Capgemini
Dec 20225 mosApr 2023

Hyderabad, Telangana, India

I successfully led a team of 8-10 members during this project.
Capgemini
Jan 20221 yrDec 2022

Hyderabad, Telangana, India

During my time at Capgemini, I worked with VOLVO MOBIL as an ETL/IICS Developer. My responsibilities included preparing ETL design documents, developing mappings and sessions in Informatica Intelligent Cloud Services (IICS) for incremental data loading, and working with different data transformations. I was also involved in creating test scripts for User Acceptance Testing (UAT) and System Integration Testing (SIT), and I performed ETL testing using DVE and Query Search Tool. In addition, I contributed to performance testing, data issue resolution, and ensured a smooth transition to production. collaborated closely with clients while mentoring a team of eight members.

Imran’s AI Stack

gemini
gemini
ChatGPT
ChatGPT

Education

Saveetha Engineering College

Bachelor of Engineering - BE, Electronics and communication engineering

Saveetha Engineering College

20165 yrs2021

Join Imran and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Imran Khan on Tal

Headline

ETL/IICS & Informatica Developer | IICS/IDMC |SQL server | Oracle| Netezza | Redshift |Informatica Power Center| |Ex Capgemini | Ex proc DNA analytics Pvt Ltd| Quess Corp Pvt Ltd | Immediate Joiner

About

In my previous role as an ETL/IICS Developer at Capgemini and Proc DNA (from January 31, 2022, to September 29, 2023) and in my current role as an ETL Developer at QUESS CORP Pvt ltd (from August 2024 to present), I have worked on designing and developing Enterprise Data Warehouse applications using Informatica and IICS while following industry best practices. I have experience working in both Waterfall and Agile methods, with a strong focus on performance tuning, monitoring, and SQL optimization. I am also skilled in troubleshooting and fixing data issues in mappings, mapping tasks, and task flows.

Location

Bengaluru

AI stack

gemini

ChatGPT

Work experience

ETL Developer at Quess Corp Limited, Aug 2024 - Present · 2 yrs 1 mo, Chennai, Tamil Nadu, India, As an ETL Developer, I worked extensively on production support and data issue resolution. I implemented fixes for various data issues in IICS CDI mappings and mapping tasks, ensuring smooth and accurate data processing. I focused on performance tuning and optimization of mappings and task flows to enhance efficiency. I also worked on the Automic Scheduler to schedule, monitor, and maintain jobs, and resolved ServiceNow incidents based on priority to minimize business impact. Additionally, I mentored a team of eight to ten members and collaborated with cross-functional teams to identify root causes and implement long-term solutions for recurring issues.

Data engineering specialist at ProcDNA analytics pvt ltd, Jul 2023 - Sep 2023 · 3 mos, Guargon, As a Data Engineer Specialist at Proc DNA analytics Pvt Ltd, I worked on Informatica Intelligent Cloud Services (IICS) to build mappings and mapping tasks that moved data from flat files to staging tables. My responsibilities included managing different data transformations, optimizing performance, and resolving data issues. I also used Redshift and Toad for SQL query optimization and to maintain data synchronization between development and production environments. In addition, I created task flows, worked closely with clients, and led a team of six members.

Associate Consultant at Capgemini, Dec 2022 - Apr 2023 · 5 mos, Hyderabad, Telangana, India, I successfully led a team of 8-10 members during this project.

Senior Analyst at Capgemini, Jan 2022 - Dec 2022 · 1 yr, Hyderabad, Telangana, India, During my time at Capgemini, I worked with VOLVO MOBIL as an ETL/IICS Developer. My responsibilities included preparing ETL design documents, developing mappings and sessions in Informatica Intelligent Cloud Services (IICS) for incremental data loading, and working with different data transformations. I was also involved in creating test scripts for User Acceptance Testing (UAT) and System Integration Testing (SIT), and I performed ETL testing using DVE and Query Search Tool. In addition, I contributed to performance testing, data issue resolution, and ensured a smooth transition to production. collaborated closely with clients while mentoring a team of eight members.

Education

Bachelor of Engineering - BE, Electronics and communication engineering, Saveetha Engineering College