To offer my services to a result oriented organization where hard work and commitment is honored and reward is given on the basis of performance and achievement, an organization offering challenging works environment and long term career.
Pakistan Telecommunication Company LTD (PTCL) (July 15, 2017 –Present)
Designation: Internship Fellow in Ops team of DWH/BI department
Major Responsibilities & Role:
-To handle and monitor complete operations of the business intelligence department
using tools like informatica,SLJM,Oracle Golden Gate,shell scripting and Teradata
sql assistant.
- My daily job is to monitor the jobs which are running for completion of data so that
data can be loaded into the dashboards and then can be represented.
-If there are any error in the jobs which are running we need to correct it so that the
system runs flawless.
Scripts Automation
Working on informatica powercenter workflow Monitor and informatica power center workflow manager
SLJM(Simple load job monitor) for ETL
Full deployment of groups from dev to prod environment in SLJM.
Informatica Prod Environment error investigation and resolution.
Oracle’s Golden Gate
Initial load, Fastload, load creation and execution.
Working on Teradata viewpoint.
DBA level 1 tasks
Performs MVC activity on large tables to save space.
Schedule jobs using crontab.
Data Reconciliation
Creating alerts on Unix for automation
Operations Management (24 x 7).