ตัวอย่าง Resume นักพัฒนา ETL (ETL Developer) ฉบับที่ 186
Resume Example ETL Developer #0186 ประมาณ 1771 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Informatica ETL/SQL Developer ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 4 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 4 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Tableau, Power BI ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา ETL ให้ความสำคัญ
- ประสบการณ์ 5 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 40+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Diverse experience in IT industry with emphasis on ETL Development, Data Modeling, Data Analysis and SQL Development. Worked on multiple domains like Data Integration, Data Mining, and Database Security industries across various clients. Currently working on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, Workflow Monitor. Enhanced in transforming SSIS packages from different sources to destination servers. Above 4 years of total IT experience in Data Analysis, System Application Analysis, Data Architecture, and Development, Testing and Deployment of Business Intelligence using Data Warehousing and Database Business Systems in the areas of banking and insurance Industries. Strong Experience in Data Analysis, Data Cleansing, Data Validation, Data Verification, and Identification of Data Mismatch. Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources, and scheduling. Experience in designing Data marts, Star Schema, Snowflake Schema for Data Warehouse concepts like ODS, MDM architecture.
Experience
Informatica ETL/SQL Developer02/2017 - Current
- Working on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, Workflow Monitor, Business glossary, Informatica Lineage, DVO Analyzing customized package, PL/SQL code provided by Informatica to provide a solution for Lineage automation.
- Converting the store Procedure to ETL using Informatica.
- Created the Incremental Aggregated Transaction Fact.
- Used Type 1, Type 2 SCD mappings to update slowly Changing Dimension Tables.
- Involved in Performance tuning at source, target, mappings, sessions, and system levels.
- Prepared migration document to move the mappings from development to testing and then to production repositories.
- Using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Union and SQL transformation to develop robust mappings in the Informatica Designer.
- Process the data load by using the ETL tool Informatica, which is grouped into 4 batches of initial load to the staging area, initial load to the facts and dimensions, incremental data from source systems to the staging area and incremental load from staging to the fact and dimensions, and few independent sessions.
- Creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
- To generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to the data warehouse.
- Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
- Creating shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Generating periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
- Creating SSAS OLAP Cubes and Partitioning Cubes, monitored and full and incremental load using cube wizard.
- Gathering functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
- Designing and developing SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
- Environment: Informatica Power Center 8.6 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), OBIEE 10.1.3.4 SQL Query Analyzer 8.0, Oracle 10g/11g, MS SQL Server, SQL Developer, Windows, Unix/Linux, putty.
SQL MSBI Developer11/2017 - 02/2018
Amazon.com, Inc.
- Designing conceptual, logical & physical data models, data dictionaries and metadata repositories.
- Working with the Project Management team to prioritize business, information and reporting needs.
- Working with Enterprise Data Architects to drive acceptance of an enterprise view of data and its use.
- Coordinating with DBA's in creating and managing Tables, Indexes, and Table spaces, Sequences, Views and Materialized Views.
- Generating DDL scripts using Forward Engineering technique to create objects and deploy them into the databases.
- Partnering with the Data Governance and other data committees to ensure to implement common vocabulary and understanding of business entities and relationships between entities.
- Providing thought leadership in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization, text mining, data discovery, statistical methods, database design and implementation.
- Developing and documented data requirements and design specifications in the form of data models, data mappings and data quality metrics.
- Mapped out structure and organization of the relevant data for Aflac.
- Working with internal customers and business units to understand the business requirements and business processes to design data warehouse schemas and define extract-translate & load (ETL) processes for data teams.
- Assisting with the analysis, design, development and implementation of logical data models, physical database objects, data conversion, integration, and loading processes, query and reporting functions, data management and governance and data quality assurance processes. - Working in collaboration with the Data Analysts & ETL developers to provide source to target ETL requirements and ensured efficient transformation and loading.
- Assisting in maintaining and enhancing the metadata infrastructure, the data dictionary and business metadata, and facilitate publishing the information to the business and technical communities.
- Partnered with the business to create the appropriate business rules for data usage.
- Environment: Informatica PowerCenter 9.5.1, Oracle, Windows 7, IDQ, SQL Developer 2005, UNIX, PL/SQL, Autosys, Business Objects, AIX, SVN, Tidal, Wave Analytics.
SQL BI Developer06/2013 - 11/2014
- Determine the appropriate research projects, data collection, and methodologies.
- Identify, retrieve, manipulate, relate and/or exploit multiple structured and unstructured data sets from various sources, including building or generating new data sets as appropriate.
- Demonstrated leadership and adaptability, with a willingness to readily and voluntarily take ownership of challenging task and problem, even beyond the initial scope of responsibility.
- Thorough analytical skills, with the capability to apply data mining, text analytics, and optimization skills to solve business problems.
- Improve our bidding strategy technology (e.g., more accurate and efficient price, volume, and auction-rate estimation) Design and building tools for scaling campaign management, including automation.
- Design methodology for extracting user insights for location data.
- Develop & maintains expertise with MSBI tools including Excel/PowerPivot, SSIS, PerformancePoint, SSAS & SSRS.
- Analysis of large volumes of transactional data to speed collection cycles and identify operational opportunities.
- Have to use advanced programming skills in Java, Python or any of the major languages to build software solutions/services, including robust data pipelines and dynamic systems.
- Environment: Oracle 10g/91/8i/7.x, MS SQL Server, UDB DB2 9.x, Teradata, Quality Center, SQL Queries., Siebel Analytics, Oracle BI, UML, OLAP, Teradata SQL Assistant, DBMS.
Jr. Software Developer12/2010 - 03/2013
- Expertise in Java/J2EE development, and use related technologies/frameworks to develop and optimize applications.
- Will perform relation database development employing Oracle or PL/SQL Provide strong Big Data design, development and coding expertise on large, complex projects.
- Design, code, and unit-test application code using software development life cycle (SDCL) best practices.
- Design, develop, debug and support complex data integration interfaces and processes (Including stored procedure and queries) using
- various tools and technologies including SSIS, SSAS, SSRS, T-SQL, MSBI, SQL Server technology.
- Complete estimates and work plans collaboratively for design, development, implementation, and rollout tasks.
- Create technical system documentation and ensure that this documentation remains current throughout all phases of the SDLC.
- To be able to work with Business Users, understand the requirement and convert into Technical Design.
- Responsible for coordinating design, code reviews.
- Environment: C#, .NET, WPF, Windows Forms, MS SQL Server, MS Access, XML, Entity Framework.
MASTERS / Bachelor's Degree: Computer Science Engineering / Computer Science Engineering
Master's: Information Technology Management Information Technology Management Master's: Computer Information Systems Computer Information Systems
Skills
Data Extractionstored proceduresnormalizationdatabase designcreating indexesfunctionstriggersMS ExcelCSV filesSQL ServerExtensively used V-LOOKUP'salso created Pivot graphsreports and dashboards.Agile/Scrum development environment.TablesStored ProceduresDDL/DML TriggersViewsSSIS.OLAPDimensional modelingtransformation and loading (ETL) process.SQLPL/SQLTeradataFlat FilesMS Access and Sybase.Good in analysisrequirements gatheringdesigndevelopmentimplementationSybaseMS AccessUNIXWindows XP/NT.ToolsMSBISSIST-SQL
Languages
and professional speaking abilities (and experience).
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Informatica ETL/SQL Developer ประสบการณ์ 4 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ