Sunny Joon
Gurugram,HR
Summary
A result-oriented data engineer with broad-ranging experience of 12+ years in all phases of software development lifecycle like requirement gathering and analysis, system design and development, build, unit testing, code reviews, and deployment. Currently, helping DXC Technology (Client: Bright Horizons) modernize multiple legacy systems to a single system to process eligibility files for 1500+ clients. Working as a Team Lead/Information Design Engineer and managing distributed teams.
Overview
13
13
years of professional experience
Work History
Information Design Engineer
DXC Technology India
Gurugram, India
01.2022 - Current
- Developed/Supported an ETL system to replace an existing legacy systems using IICS, IDMC - CDI, CAI, B2B and API Manager and Azure tools.
- End to end implementation of project from designing to the development.
- Migrated 1500+ clients to configurations/partner profiles to Informatica B2B with the existing mappings and transformations which involved working with unstructured data and data parsing.
- Project Management Experience using AGILE framework as Team Lead and PM tools like JIRA, ITSM for effective Incident, Change and Problem Management.
Technical Lead
Ameriprise Financial
Gurugram, India
01.2018 - 01.2022
- Responsible for on-going development, implementation and adherence to the quality review process for deliverables produced by the ETL team and the delivery processes.
- Ensure that technical designs produced by the Development team will meet the requirements from a business and technical level.
- Worked on different Informatica performance tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
- Reduced incident count by 50% and job runtime by 90% for multiple jobs by removing bottlenecks through IICS and IDMC.
Senior Analyst
Sopra Steria
Noida, India
01.2017 - 01.2018
- Implementing GDPR (General Data Protection Regulation) regulation to strengthen and unify data protection for all individuals within the European Union (EU).
- Creating various reports which provided insights about the Data/Table load and deletion.
- Responsible for technical design, development & delivery of tasks assigned for Informatica.
- Worked on implementation of GDPR for 1000+ tables with 7 years of data retention.
Software Engineer
HCL Technologies
Noida, India
01.2013 - 01.2017
- Worked with ETL and DW SME's to manage the development of new report subject areas as needed.
- Providing expertise in technical analysis and solving technical issues during defect resolution.
- Production Informatica workflows monitoring, failure debugging and fixing.
Education
B.Tech - IT
Amity University
PG Diploma - DS & AI
IIIT
Skills
- IICS, IDMC (CDI, CAI, B2B, API)
- Informatica PC, MFT, B2B, DT
- Azure - DP 203, DP 900, Power BI, Azure Data Factory, Datalake
- Python, SQL, Shell Scripting
- Agile Methodology - ADO, JIRA, ServiceNow
- Oracle, SQL Server, PostgreSQL, Teradata
- Data Warehousing/Modeling
- Batch/API Processing
Websites
Language
English
Hindi
Timeline
Information Design Engineer
DXC Technology India
01.2022 - Current
Technical Lead
Ameriprise Financial
01.2018 - 01.2022
Senior Analyst
Sopra Steria
01.2017 - 01.2018
Software Engineer
HCL Technologies
01.2013 - 01.2017
PG Diploma - DS & AI
IIIT
B.Tech - IT
Amity University