ตัวอย่าง Resume นักพัฒนา ETL (ETL Developer) ฉบับที่ 99
Resume Example ETL Developer #0099 ประมาณ 1109 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Data Engineer ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 1 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 1 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
- Data engineer with 7+ year of experience in data ingestion, processing pipelines and storage/retrieval optimized database systems to provide solution for data analytics - Experience in conversion and build of database programs and objects in Snowflake, Oracle, and Teradata - Worked on projects for wide range of data projects including data warehouse, software services and data migration - Ability to build processes using snowsql command line interface and Javascript stored procedures for near real time bulk batch loads. - Knowledge in creating Snowflake user defined functions, materialized views, Merge statements, query optimization using profiler - Created Snowpipe for continuous data load from AWS s3 buckets and Azure blob storage - Good knowledge in Snowflake virtual warehouse, internal and external stages, materialized view, zero copy cloning, query profiling, user defined functions, transient tables, advanced DML like merge and common table expressions - Good knowledge of various dimensional models like star schema and hybrid models - Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Metadata Manger) - Created complex mappings using mapplets and new transformations like sql, transaction control - Worked on data migration processes from files to database and across relational databases - Good experience working with various type of facts and slowly changing dimension (SCD) tables - Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing - Worked on scheduling tools like Autosys and Tivoli workload scheduler. - Well-developed verbal, written & communication skills - Ability to work cooperatively in a team environment to design, construct and deliver high quality deliverables - Database: Snowflake, Teradata, Oracle
Experience
Data Engineer09/2021 - Current
Lockheed Martin Corporation
- Developed batch process using SnowSQL scripts and automate it using shell script and Tivoli batch scheduler.
- Converted Mload Teradata scripts to Snowflake compatible SQL scripts and incorporated user defined functions for commonly used transformations
- Converted BTEQ scripts to Snowflake compatible scripts and utilized internal functions and created stored procedures for looping structures
- Create materialized views for faster data retrieval for reports.
- Created continuous dataflow using Snowpipe from Azure blob storage and change data capture using streams.
- Optimized copy statements for performance and built process using advanced DML like Merge statements.
- Created queries using common table expression for recursive data and window functions.
- Created and manage code versioning using Code Cloud and GIT cli tool
- Performed unit test for data validations and supported quality assurance teams for defect resolution and performance optimizations
- Collaborated with database administrators to optimize virtual warehouse sizing, reduce redundancy, manage cluster keys and query performance optimization.
- Integrated batch loads with Tivoli workload scheduler for batch process with schedule daily, weekly, monthly and on demand cycles.
- Created documents for data flow, production support run books, best practice documents, naming standards and unit test results.
- Conducted daily stand up, updated trackers, mentored Junior developers, participated in retrospect's, phase planning and other team activities.
- Environment: Snowflake, Azure, Snowsql, Red Hat Linux/Shell Scripts, Tivoli Workload Scheduler
Sr ETL Developer / Two95 International Inc. - Suitland, MD05/2019 - 08/2021
- Create batch jobs to load data using AWS s3 external stages and transformed data using Javascript stored procedure
- Developed jobs to load files to internal stage using put commands and used copy scripts to bulk load to tables
- Developed shell scripts using SnowSQL CLI utility to automate loads using Autosys
- Designed and developed Python programs to load data from $3 to Snowflake using connector for dimensional model for warehouse
- Collaborated with database administrators to create data shares between multiple accounts in Snowflake within the organization
- Evaluated virtual warehouse for usage and resizing based on compute requirements
- Analyzed data flow and business transformation to document the process
- Performed data profiles using SQL and Informatica data analyst tool
- Designed and developed extraction, transforming and load process using Informatica power center
- Optimized query performance using query profiler tool to remove bottlenecks.
- Integrated the existing systems within new RMS systems built in AWS cloud platform and Snowflake database
- Back feeding the data using Informatica power center and other necessary tools to POM systems
- Extracting, staging data, apply necessary transformation and supplying the data to the supply chain management report systems
- Extract and transform data from various heterogeneous sources like Mainframe, Oracle, DB2, others to the target environment using Informatica
- Worked on defects, issues, change requests, interface implementation in Agile methodology using Jira
- Created technical design document, Unit Test Results, Release Notes, Review Status and other project related documents, code versioning using SVN
- Environment: Informatica 10.6, Oracle 11g, Red Hat Linux, ESP, Snowflake, SnowSQL, SnowSight ETL Consultant, 07/2015 04/2019
Position
ING
- Prepared technical design specifications for data Extraction, transformation and load like source to target mapping documentation
- Worked on Informatica Utilities Source Analyzer, Designer, Mapping Designer, Mapplet Designer and Transformation Developer to create re-usable objects
- Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in Informatica using change data capture using Informatica powercenter designer
- Used various transformations like stored procedure, connected and unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic
- Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings
- Used Variables and Parameters in the mappings to pass the values between mappings and sessions
- Created mapping to read data from Mainframe EBCDIC files with copybook layout using normalizer and applied business logic to load to Oracle data warehouse
- Implemented restart strategy and error handling techniques to recover failed sessions
- Used Unix Shell Scripts to automate pre-session and post-session processes
- Enhanced performance to improve execution time for data extraction, data process using parallelizing techniques and others
- Played a key role in upgrading Informatica version 8.6 to 9.1 with minimum disruption to business process
- Scheduled jobs using Infacmd through shell scripts using Autosys boxes and Jobs
- Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process
- Environment: Informatica 8.6/9.1, Oracle 10g, Red Hat Linux, Autosys
- Master of Science: Computer Applications, 10/2008
Skills
Languages: Shell ScriptingSQLJIL (Autosys)DOS
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Data Engineer ประสบการณ์ 1 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ