I am assigned to Vodacom as an ETL Developer, a telecom company in South Africa. The technologies used are ODI as an ETL tool and Teradata IFX appliance for data warehousing. Working as an ODI developer. Analysts would create a prototype script based on business requirements, which I would then translate into ODI development.

SDM for MS(Managed Services) on the Ooredoo Qatar project. Managing 10 resources

Assigned to Altron Group South Africa to provide ETL Developer services to Standard bank (SBSA). Technologies are DataStage and teradataGot appreciation from client

Design, develop, maintain, monitor and execute production ETL processes using Informatica Power Center, Teradata and OracleInvestigate production ETL issues / problemsMapping database sources to specified data formatsVerify and validate ETL deliverablesLead troubleshooting episodes and communicate solutions/resolutions to the teamTranslate concepts to requirements, and development into an automated production process.Act as a subject matter expert and resource for others on assigned ETL processes.Complete projects and development activities timely and accurately while following the System Development Life Cycle (SDLC), CI/CDSuggest changes and enhancements for ETL processes.Upgraded Informatica Dev enviorment to 10.4Major Project:  The major project involved the migration of an ETL system from SLJM to Informatica .This migration required the development of ETL processes using Informatica transformations and PDO (PowerCenter Data Objects) Another project included upgrading CBS from version 1.2 to version 5.7 in 2021.As part of this upgrade; mappings were developed to meet the specific requirements of the upgraded version. Overall, the project involved both ETL migration and system upgrade tasks, showcasing expertise in Informatica Callobrated With Circles(Telco disruptor) in developement of ONIC brand of ufone.Oracle 19c was the source.Developed pipelines from Oracle to teradata using Informatica 10.4 powercenter . Used Source, Target,Expression and joiner Transformations.Also developed Core and Sementic for reporting purpose

Team LeadPlanning to transition of Operations from vendor to In houseETL Operations both Ufone and PTCL Teradata Administration/DBARollout new releases/patches to production rollout after standard impact analysis

Providing Professional Services Clients i.e:1)Vodacom a Telecom CompanyETL Application SupportTeradata Administration, D-Series, Ab initio, ODIRollout new releases/patches to production rollout after standard impact analysis3 months onsite experience, currently working offshore2)ABSA a renowned Bank in African RegionProvided Teradata Administration,DBA, Backups support using NetVault, Teradata Decomissioning

• Performance Monitoring of Hadoop through Ambari. • Monitoring Data Warehouse ETL Operations and ensuring timely availability of data.• Follow up with Telenor source teams like BSS and Network Element Systems to ensure data integrity and completeness.• Implementation of Change Requests as per business requirement.• Analysis and Investigation of abnormal Data Trends and carry out reconciliation activities with source teams.• Developed Recon for major Business KPIs in order to ensure data quality and timely issue investigation.• FASTLOAD, BTEQ, MULTILOAD, TPT Scripts Development.• Automation of daily reports and processes using Shell Scripting.• Entertaining ad-hoc requests from RA and Fraud Control.• Played a significant role in the Successful Rollout of DPI deployment in Production, also involved in optimization of its time consuming Scripts.• Played a significant role in the optimization of BVS time consuming Scripts.• Created DEV Environment on 680 Teradata machine.

Day to day operations of DWH which includes Troubleshooting ETL jobs, Jobs scheduling and SLJM , ODI and Informatica.Backup/Restore Administration on NETVAULT.Responsible for Back end Reconciliation with all data sources interfaced with data warehouse.Managing Data Warehouse Up-Stream and Down-Stream Operations.ETL troubleshooting.Data migration,Shell scripting for job automation requirements for the EDW environment.Rollout new releases/patches to production rollout after standard impact analysis.Monitoring of BI Reporting Tool (MSTR).

Client: JAZZProvide Desktop and End User Support to ensure accessibility of client tools and applications for warehouses. Develop and maintain local procedures for networks, system operations and product assembly and installation (Windows XP, 7, 8.10); Evaluate system potential by testing compatibility of new programs with existing programs; Achieve computer system objectives by gathering pertinent data, identifying and evaluating options, and recommending a course of action; Maintain historical records by documenting hardware and software changes and revisions; Maintain client confidence and protect operations by keeping information confidential.MAC book configuration. Video conferencing by using HUAWEI and POLYCOM setup.

Client: JAZZProvide Desktop and End User Support to ensure accessibility of client tools and applications for warehouses. Develop and maintain local procedures for networks, system operations and product assembly and installation (Windows XP, 7, 8.10); Evaluate system potential by testing compatibility of new programs with existing programs; Achieve computer system objectives by gathering pertinent data, identifying and evaluating options, and recommending a course of action; Maintain historical records by documenting hardware and software changes and revisions; Maintain client confidence and protect operations by keeping information confidential.MAC book configuration. Video conferencing by using HUAWEI and POLYCOM setup.