MOHAMMAD IRFAN KHAN
Hyderabad
Summary
ETL IICS Developer with 7+ years of experience in the Media & Entertainment, Life Sciences Healthcare and Insurance domains. Skilled in application integration, data integration, data migration and data warehousing projects utilizing IICS/IDMC. Capable of owning projects end to end, developing, unit testing, optimizing performance, analyzing, and handling production code releases.
Overview
1
1
Language
8
8
years of professional experience
Work History
Integration Developer
Warner Bros. Discovery
Hyderabad
07.2024 - Current
- Developing a robust IDMC CDI - CAI assets connecting multiple batch and real-time applications , such as Workday, Unifier, Ariba, Snowflake etc.
- IDOC SAP / S4HANA data parsing and converting to semi-structured JSON/XML and pushing it to endpoint URLs
- Efficient with xQuery / XPath requiring parsing of JSON/XML structures.
- Building an end-to-end real-time CAI process.
- Developing and supporting the existing MFT transfers setup.
- Creating CAI - CDI pipelines from connecting various boundary system REST / SOAP APIs to Oracle Snowflake.
- Efficient with Go Anywhere MFT tool for file transfers.
- Creating unix / python script as when required.
- Created python for managed file transfer to SharePoint path, enhanced existing processes for efficient execution
- Ownership of multiple projects and interacting with stakeholders from development until production release.
Data Engineer
IBM
Pune
10.2021 - Current
- Company Overview: SquareTrade is an extended warranty service provider, for which we developed mappings, MCTs, and processes to establish a warranty lifecycle flow
- This involved ingesting data from various source systems – SFTP, Flatfiles, JSON/XML, etc.) into OLTPs and subsequently into the data warehouse
- Successfully developed and migrated CAI processes to Amazon SPAPI–RDT authorization from the deprecated MWS authentication method
- Able to handle production release related activities as release coordinator
- Participated and suggested ideas for onboarding new merchants like MediaMarkt BeLux and Iberia, resulting in successful production releases that garnered accolades from the client
- Implemented adhoc immediate changes within the timeframe
- Worked on setting up new environments – QA, Stage for BAPI & SFTP merchants
- Provided support during the Testing & QA regression
- Worked on the defects raised during the QA testing, coordinating with prod-ops
- Represented team during data engineering team meetings.
ETL IICS Developer
Cognizant
Pune
03.2019 - 10.2021
- Company Overview: Built data warehouse, where initial & ongoing data load was staged from various sources to AWS S3 and eventually moved to Amazon Redshift DWH utilizing IICS CDI built framework
- Implementation of data warehouse system
- Understood business requirements and actively participated in all stages of project development and deployment, contributing to the seamless execution and successful delivery of projects
- Design mappings, mapping tasks, and task flows, alongside monitoring, log verification, and implementing SCD–1,2, and reprocessing logic using custom queries
- Proficient in scheduling diverse task flows, mapping tasks, and scripts through tidal automation
- Having good knowledge on ETL data of a business process including development, unit testing, and support during SIT
- Worked with different sources like flat files & databases – AWS S3, Redshift – Spectrum, Oracle, Salesforce
- Experience in batch scripting and STTM document preparation
- Built data warehouse, where initial & ongoing data load was staged from various sources to AWS S3 and eventually moved to Amazon Redshift DWH utilizing IICS CDI built framework
Education
B.Tech - EN
Shri Ram Murti Smarak Institutions
Bareilly07.2018
Intermediate -
St. Aloysius High School
Kanpur03.2013
High School -
St. Aloysius High School
Kanpur03.2011
Skills
- IDMC/IICS Data integration, Application integration
- IDOC SAP / S4HANA
- File transfer automation
- JSON/XML parsing
- xQuery / XPath
- ETL/ELT IICS Data warehousing
- API development
- SQL (PostgreSQL, Oracle, MySQL, SQL Server, AWS Redshift)
- AWS S3
- AWS Spectrum
- Unix / Batch / Python scripts
- Tidal Automation / Redwood Scheduling
- GitHub , JIRA, Servicenow
- Postman , Putty, WINSCP
- GoAnywhere MFT
Hobbies and Interests
- Playing Football
- Chess
- FIFA
Languages
English
Proficient (C2)
C2
Timeline
Integration Developer
Warner Bros. Discovery
07.2024 - Current
Data Engineer
IBM
10.2021 - Current
ETL IICS Developer
Cognizant
03.2019 - 10.2021
B.Tech - EN
Shri Ram Murti Smarak Institutions
Intermediate -
St. Aloysius High School
High School -
St. Aloysius High School