Razia

About Razia

• Around 8 years of IT experience in Data Analysis, Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server/Legacy applications using Data Modeling, Data Extraction, Data Transformation, Data Loading and Data Analysis. • ExpertiseintranslatingbusinessrequirementsintoDataWarehouseandDataMartdesignanddevelopingETLDesignbasedontherequirementsusingData Stage. • Workedwithdimensionalmodeling,StarSchemamodeling,andSnowflakemodeling,andfactanddimensiontabledesign,physicalandlogicalDatamodeling • Extensive experience in loading and maintaining Data Warehouses and Data Marts using DataStage Client Components like Manager, Designer, Director, Administrator • WorkedextensivelyondifferenttypesofstageslikeODBC,Aggregator,Transformer,Merge,Join,Lookup,Sort, SAP ABAP stage,XML Input/Output, CFF, Pivot, FTP,Shared Containers(Parallel)fordevelopingjobs. • Extensively worked on designing, compiling, testing, scheduling DataStagejobs • Experienced in debugging, validate, schedule, run and monitor jobs using DataStage Director. • Worked on Control-M, DataStageDirector for designing batch jobs for scheduling. • Experienced in performance tuning and troubleshooting by performing the root cause analysis. • Highly knowledgeable in Database management systems, UNIXshell scripting, Client/Server application development, Software Testing. • Knowledge on Agile method of SDLC, Sprint and JIRA • Experience in integration of various data sources like Oracle, SQL Server and Flat Files using Active/Passive Stages available in Data Stage Tool. • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader. • Excellent communication, interpersonal, analytical skills and strong ability to perform as a team