รายละเอียดงาน

• • Develop ETL processes for data extraction, transformation, and reporting (main tool: SSIS) with a solid understanding of ETL concepts.
• • Worked across the full analytics lifecycle: data exploration, modeling, validation, tuning, and deployment.
• • Designed experiments to evaluate model performance and quantify business impact.
• • Developed data models and pipelines to support analytics and reporting needs.
• • Analyzed customer and operational data to identify patterns, behaviors, and improvement opportunities.
• • Delivered actionable insights and recommendations to business stakeholders.
• • Created interactive dashboards and automated reports using Power BI.
• • Partnered with cross-functional teams to translate business requirements into data solutions.

รายละเอียดงาน

• • Work closely with the Project Manager (PM) and Software Developer to gather and understand user requirements.
• • Collaborate with PM to provide data for users and process ETL.
• • Design, develop, and maintain ETL processes to support data integration and reporting needs.
• • Utilize SQL databases and ETL tools to extract, transform, and load data.
• • Create and maintain reports using reporting tools such as Cognos (IBM).
• • Ensure data accuracy and integrity through thorough testing and validation.
• • Support system operations on Windows OS and ensure seamless integration of system components.
• • Load Data to development zone by SSIS flow.

รายละเอียดงาน

• • Develop professional deliverables such as Functional Specifications, Data Mapping, End to End Design, Business Rule.
• • Get requirements from customers, then design and create entity relationship diagram.
• • Extracts, transforms and loads source data into the SAS environment from multiple sources, including major DBMS and application system transaction files, third-party software packages, and spreadsheet applications.
• • Do unit test case of possible value to target column.
• • Prepare Unit and System Integration Test (SIT) on ALMQC and provide troubleshooting, Investigate defects and technical advice to clients.
• • Utilized GIT version control for uploading source code from local to Azure app service and deploying to production.
• • Support the team members involved in the project and perform knowledge sharing, knowledge transfer or training to new team member if requires