ตัวอย่าง Resume นักพัฒนา ETL (ETL Developer) ฉบับที่ 150
Resume Example ETL Developer #0150 ประมาณ 981 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Data Engineer (Snowflake Developer) ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 8 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 4 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 8 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 4 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
Professional Summary
Over 8 years of IT experience in Data warehousing and Business intelligence with an emphasis on Project Planning & Management, Business Requirements Analysis, Application Design, Development, testing, implementation, and maintenance of client/server Data Warehouse. Seeking to have a challenging career in Data Warehousing and Business Intelligence with growth potential in technical as well as functional domains and to work in critical and time-bound projects where can apply technological skills and knowledge in the best possible way. SKILLS Cloud Technologies: Snowflake, AWS. Programming Languages: PL/SQL, Python(pandas), SnowSQL Dashboard: Elastic Search, Kibana. Data Warehousing: Snowflake Teradata DBMS: Oracle, SQL Server, MySql,Db2 Operating System: Windows IDES: Eclipse, Netbeans. Servers: Apache Tomcat Data Integration Tool: NiFi, SSIS
Experience
Data Engineer (Snowflake Developer)01/2020 - Current
JNTU UNIVERSITY - INDIA HYDERABAD Brown & Brown, Inc.
- Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.
- Loading data into snowflake tables from the internal stage using snowsql.
- Used COPY, LIST, PUT and GET commands for validating the internal stage files.
- Used import and Export from the internal stage (snowflake) from the external stage (AWS S3).
- Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.
- Used FLATTEN table function to produce a lateral view of VARIANT, OBJECT, and ARRAY column.
- Used SNOW PIPE for continuous data ingestion from the S3 bucket.
- Developed snowflake procedures for executing branching and looping
- Created clone objects to maintain zero-copy cloning.
- Data validations have been done through informationschema.
- Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake
- Experience with AWS cloud services: EC2, S3, EMR, RDS, Athena, and Glue
- Cloned Production data for code modifications and testing
- Perform troubleshooting analysis and resolution of critical issues
ETL Developer04/2018 - 11/2019
Ihs Markit
- Expertise in identifying and analyzing the business need of the end-users and building the project plan to translate the functional requirements into the technical task that guide the execution of the project.
- Served as a liaison between third-party vendors, business owners, and the technical team.
- Proven ability in communicating highly technical content to non-technical people.
- Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage, ODS, and Mart.
- Involved in Design, analysis, Implementation, Testing, and support of ETL processes for Stage, ODS, and Mart.
- Designed and developed Informatica's Mappings and Sessions based on business user requirements and business rules to load data from diverse sources such as source flat files and oracle tables to target tables.
- Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Java, Lookup, Filter, Joiner, Rank, Router, and Update Strategy.
- Developed reusable Mapplets and Transformations. Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
- Involved in monitoring the workflows and in optimizing the load times. Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
- Involved in writing procedures, functions in PL/SQL
SQL Developer03/2016 - 05/2018
Cognizant Technology Solutions
- Participated in client business need discussions and translating those needs into technical executions from a data standpoint. Translated business requirements into BI application designs and solutions.
- Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
- Developed highly optimized stored procedures, functions, and database views to implement the business logic also created clustered and non-clustered indexes.
- Involved in performance monitoring, tuning, and capacity planning.
- Tuned the slow performance queries by looking at Execution Plan
- Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, Slowly Changing Dimension etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse from Flat Files, Excel and XML Files.
- Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in the complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both environments (Development and Production).
- Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS). - Created reports to retrieve data using Stored Procedures that accept parameters. Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions
- Created Parameterized Queries, generated Tabular reports, sub-reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports
ETL Tester10/2010 - 08/2014
Education
- Bachelor of Science: Information Technology · Snowpro core · Aptiva Corp - City, STATE · Worked as a Team of 14 and system tested the DMCS 2 Application. · Worked on HP Quality Center (QC)/Application Life Cycle Management (ALM) testing technology to test System. · Actively participated in all phases of the testing life cycle including document reviews and project status meetings. · Participated in daily Scrum meetings and weekly project planning and status sessions. · Involved in creating test cases after carefully reviewing the Functional and Business specification documents · Used Rational Manager and Rational Clear Quest for writing test cases and for logging the defects. · Performed Functional, Regression, System, Integration and end to end Testing. · Extensively used SQL (Inner joins, Outer Joins, subqueries) for Data validations based on the business requirements. · Performed file, detail level validation and also tested the data flown from source to target. Involved in testing of Pervasive mappings using Pervasive Designer · Tested Standard and ad-hoc SQL Server reports and compared the results against the database by writing SQL Queries. · Tested 3 websites (borrower website, Partner website, FSA website) and performed Positive and Negative Testing.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Data Engineer (Snowflake Developer) ประสบการณ์ 8 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 4 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ