ตำแหน่ง ETL Developer

บริษัท Chilindo

ที่อยู่บริษัท

เงินเดือน สำหรับสมาชิกเท่านั้น

ลักษณะงานที่ทำ
• Taking overall responsibility of the Warehouse data that is pulled frequently from the Production database to the Development database
• Building SSIS packages and SSRS reports
• Involved in Server migration, deployment of SSIS packages and jobs from old server to the new server
• Building Free items audiences and preparing the reports based on the campaign result
• Monitoring SSIS packages and SSRS reports
• Documentation of the existing SSIS packages

ตำแหน่ง Oracle Consultant

บริษัท NIIT Technologies

ที่อยู่บริษัท

เงินเดือน สำหรับสมาชิกเท่านั้น

ลักษณะงานที่ทำ
• Taking responsibility of Storage module for the containers that has been stored in any Terminal or Depot
• Fixing bugs/issues for any discrepancy between cost calculated by DCS(Dolphin carrier system) and Invoice printed by Depot/Terminal
• Weekly report generation and supporting User’s request related to the module

ตำแหน่ง Consultant

บริษัท Cognizant Technology Solutions

ที่อยู่บริษัท

เงินเดือน สำหรับสมาชิกเท่านั้น

ลักษณะงานที่ทำ
• Interacted with End user community to understand the business requirements and in identifying data sources.Involved in the Knowledge Acquisition process of understanding the delta load, Technical architecture & Implementation strategy.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Studied the PL/SQL code developed to relate the source and target mappings.
• Helped in preparing the mapping document for source to target.
• Worked with Datastage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Used QualityStage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used Autosys job scheduler for automating the monthly regular run of DW cycle in both production and UAT environments.
• Participated in weekly status meetings.