Senior Data Specialist – ETL
IBM
مجموع سنوات الخبرة :15 years, 4 أشهر
o Orange CRM Data Migration Project:
a. To get the Functional Requirement Specifications from customer and understand the same
b. Understand the Telecom domain functionality
c. Interaction with business users and requirement gathering
d. High level & low-level ETL flow design
e. Analysis & fix on QA defects made by QA team
f. Lead the ETL team and provide gaudiness for Develop and design ETL jobs / Sequences using IBM DataStage
g. Create mappings employing various transformations, filters, joiners, lookup, SQL overrides etc to load data from multiple databases into Warehouses
o Etihad Airways Loyalty Project
a. Serve as development lead on Solution Design and Delivery team with Airlines measurement and engagement portfolio
b. Manage, mentor and develop development resources and provide project related directions
c. Identify opportunities in business processes, system capabilities and delivery methodologies for continuous improvement
o ENPO DWH Project
a. Act as Data Architect and BI Tech Lead
b. Interaction with business users and requirement gathering
c. High level Design, Data modeling and ETL mapping sheets
d. Manage, mentor and develop development resources and provide project related directions
o Standard Bank Data Quality Project
a. Acting as Data Architect
b. Leading the discovery phase with the client, Contributing in the Solution architecture docs.
c. Preparing and performing Demos
d. Understand the running systems and gathering the business needs and the quality rules
e. Implementing the quality rules using IBM Information Server
f. Implementing the De-Duplication to generate customer golden records using IBM Quality Stage.
• Work with business users to define data requirements.
• Design and implement reporting solutions using Microsoft BI suite and Microsoft SQL Server RDBMS
• Develop ETL/ELT processes using SQL Server Integration Services (SSIS)
• Develop, Manage & Enhance SSAS Cubes and provide necessary support to assure their Availability and Best Performance
• Use set based processing to construct SQL scripts that transform information obtained from source systems and load that information into the data warehouse.
• Develop reports using MDX
• Managing Cloud Big Data Solution (Amazon Redshift, Pipeline)
Develop, enhance and maintain in-house tools and Dashboards to satisfy business needs across Technology using the available allocated Resources. Participate with Network Management Planning & Support Team as well as Service Management members to study, recommend, and implement solutions proactively using efficient available techniques that help in improving our services and products. Synergy in-house and strategic tools through establishing common interfaces that improve, automate, simplify, and speed up the corrective/preventive action process time as per our local customers’ needs
* Responsible for the analyzing and designing of the software development life cycle.
* Studied the requirements and system specifications.
* Understand the current systems, coding and testing.
* Host the system on production server and train the user about the system.