ETL Developer Resume Sample
Jayda Klein
713 Larry Orchard,
Philadelphia,
PA
+1 (555) 189 3191
Work Experience
Senior Manager, ETL Developer
02/2016
-
PRESENT
San Francisco, CA
- Experience with UNIX shell scripting
- Experience with Data warehousing techniques (Star Schema, snow flaking, denormalization, Normalization, Aggregations)
- Oversees the data load production process and the implementation of new data load files in accordance with the department’s change management process
- Create, execute, and document unit test plans for ETL and data integration processes and programs
- Perform tasks required to conform to the company’s configuration management and software release processes
- Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance
- Dedicated to excellence in one’s work; detail-oriented and thorough
ETL Developer
04/2012
-
01/2016
Boston, MA
- Review proposed mappings with relevant personnel, e.g. Business Analyst, Data Stewards, Business System and Data Analyst
- Generate detailed design documentation for the source-to-target transformations
- Create test scenarios and be responsible for their execution
- Support the efforts of the Data Staging Developer(s)
- Work with enterprise application integration personnel to anticipate and resolve data integration issues across applications and technical infrastructures
- Applies in-depth or broad technical knowledge to maintain one or more technology areas (e.g. Database Administration, ETL Design)
- Applies technologies to software solutions of high complexity
- Strong database (Oracle) skills including database design, development (packages, functions, procedures)
Junior ETL Developer
06/2006
-
11/2011
New York, NY
- Solid hands-on experience in using IBM DataStage / Information Server
- Performs tasks required to conform to the company’s configuration management and software release processes
- Business Analyst(s) to understand informational requirements
- Data Administrator and Data Stewards to understand information quality definitions and expectations of end users
- Data Modeler and Database Designer in the design of target environment data structures
- Business System and Data Analyst to understand source system data and structures
- Detail design of source to target data mappings
Education
Lawrence University
2002 - 2006
Bachelor's Degree in Computer Science
Professional Skills
- Excellent functional, analytical, interpersonal and communication skills, including strong listening skills
- Strong written communication skills; outstanding interpersonal and oral communication skills
- Exceptional verbal and written communication skills desired along with strong interpersonal skills to interact with internal customers and third party vendors
- Strong experience on RDBMS (preferably DB2) with good PL/SQL concepts & strong SQL skills
- ETL Development experience with strong ETL and SQL programming skills (required); MySQL experience (desired)
- Strong ETL testing experience and verification utilizing SQL querying skills (PL/SQL, Toad or other tool) and formal testing methodologies
- Demonstrated strong coding skills in one or more high-level languages such as Python, R, Java, Smalltalk or Perl
How to write ETL Developer Resume
ETL Developer role is responsible for sql, analytical, etl, technical, development, design, interpersonal, business, analysis, database.
To write great resume for etl developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For ETL Developer Resume
The section contact information is important in your etl developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your ETL Developer Resume
The section work experience is an essential part of your etl developer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous etl developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular etl developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative ETL Developer resume experience can include:
- Demonstrated strong data visualization skills and strong attention to detail
- Good knowledge of analytical and logical conceptual level programming skills, data analysis, data mapping, data loading, and data validation
- Excellent analytical, mathematical, and creative problem-solving skills. Excellent understanding of the organizations goals and objectives
- Organizational skills, problem-solving skills with close attention to detail
- Experience working with cross functional teams, with strong interpersonal and written communication skills
- Excellent analytical and troubleshooting skills with a good track record of successful ETL application development
Education on an ETL Developer Resume
Make sure to make education a priority on your etl developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your etl developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in ETL Developer Resume
When listing skills on your etl developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical etl developer skills:
- Good interpersonal skills and good customer service skills
- Excellent time management skills – ability to effectively prioritise workloads and to meet business expectations
- Excellent analytic skills, attention to detail, and problem-solving skills
- Good communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment
- ETL Development experience with strong ETL and SQL programming skills (required); MySQL experience (desired)
- Demonstrate effective organizational and time management skills while managing multiple priorities and projects
List of Typical Experience For an ETL Developer Resume
1
Experience For Junior ETL Developer Resume
- Strong collaboration skills with the ability to work in a team-based environment including employees, vendors, and third party contractors
- Effectively prioritize and execute tasks in a high‐pressure environment
- Prior experience designing and building complete ETL processes, including moving and transforming data for ODS, Staging, and Data Warehousing, required
- Experience designing and implementing effective data strategies in enterprise level data stores, data marts or data warehouses
2
Experience For SQL / ETL Developer Resume
- Strong ETL development experience using ETL tool Informatica - Data warehousing environment
- Has experience incorporating API’s into data reporting experience
- Database code performance tuning skills required
- Experience: 5+ years of programming/systems analysis experience
- Good understanding of RDBMS concepts and development experience in Oracle
- Experienced in using Talend would be a strong advantage
- Proven experience and working knowledge of database management systems and standards
3
Experience For Ssis ETL Developer Resume
- Strong experience in SQL ETL or other comparable programming language
- Strong customer service orientation. Experience working in a team-oriented, collaborative environment
- ETL experience including experience with ETL tools
- Trong data design, data modeling and facilitation skills
- Skills with Oracle and SQL for tuning large-volume queries
- Exceptional skills managing through conflicts
- Provide functional expertise within his/her skills to assist delivery team members, and foster collaboration within Technology
- Strong experience in SQL / T-SQL
4
Experience For ETL Developer / Analyst Resume
- Proven ability to provide technical leadership and guidance to less experienced team members
- Strong command and experience on Oracle database (including DDL, DML, DCL, TCL, data modelling, query optimisation, database instance tuning)
- Experience or Equivalent Project development experience using ETL Technologies like DataStage, Informatica with any Database, UNIX, Autosys
- Effectively translate technology terms and functionality into a business vocabulary understandable by non-technical staff
- Applies analytical skills to profile and work with travel data
- Working technical experience with designing, building and supporting data warehouses
- Understanding of ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation
- Experience in leading and developing data warehousing applications / Costing applications in financial and banking domain
- Two to three years of data warehousing experience including dimensional modeling, implementation and support
5
Experience For Database / ETL Developer Resume
- Software development experience using (Java, Python, Shell scripting, API designing ) are required
- Highly skilled in SQL development (writing, troubleshooting, optimizing)
- Experience using scheduling tools like Autosys, Tivoli etc. creating jobs for design
- Experience with scheduling ETL jobs using SQL Agent, and external scheduling tool
- Five years of experience developing, maintaining and supporting ETL programs with various target/source types and ETL transformations
6
Experience For Oracle ETL Developer Resume
- Data analysis, data mapping, data loading, and data validation; - Understand reusability, parameterization, workflow design, etc.
- Experience using a full life cycle methodology for ETL development utilizing IBM’s InfoSphere suite, DataStage, QualityStage, etc
- Experienced in query profiling and performance tuning
- Experience in dimensional data modeling, ETL development, and Data Warehousing or data-mart environment
- Five or more years of experience in full lifecycle ETL processing using DataStage and related tools
- Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
- Deep experience troubleshooting, and constructing performance improvements in Informatica Powercenter
- Experience developing DB schemas, creating ETLs, and familiar with Hadoop/MPP systems
7
Experience For Senior Manager, ETL Developer Resume
- Design, Development & Implementation experience using ETL tool Datastage, Talend, Abnitio in Banking industry
- Recent experience with development process; including requirements, design, construction, testing and implementation required
- Experience in developing best practices, unit testing and developer code reviews
- Experience leading, mentoring ETL staff in data warehouse domain
- Experience in data profiling, sub setting, obfuscation, and test data fabrication
- Programming experience using SQL, PL/SQL, shell scripts on windows server
- Strong proficiency with reading and writing SQL
- Experience using Informatica including mappings, workflows, etc
- Experience using Oracle RDBMS including PL/SQL development and ability to design and tune complex queries
8
Experience For Digitalisation ETL Developer Resume
- Experience of working closely with a marketing department
- Strong understanding of data modeling techniques
- Experience in managing data lineage and performing impact analyses
- Two to three years of experience using ETL tool SAP Data Services
- Demonstrated ability to communicate complex technical information to non-technical personnel both verbally and in writing
- Experience in systems analysis, design or programming and the associated development methodologies
- Solid understanding of relational and dimensional database structures, theories, principles, and practices
- Experience with data warehouse architecture, extract/transform/load (ETL) and business requirements gathering and analysis
9
Experience For Business Intelligence ETL Developer Resume
- Strong Knowledgeable in ETL & BI development and implementations, data architecture and data warehousing
- Knowledge on concepts and experience writing SQL and ETL code with the ability to analyze, diagnose, and tune for scale and performance
- Strong understanding and adherence to IT SDLC and operational best practices
- Less than 1 year of experience in a data warehousing environment
- Follow managers’ direction regarding project priorities, milestones and initiatives
- More than 4-6 years of experience in systems analysis, design, or programming, and the associated development methodologies
- Substantial development experience in creating stored procedures, PL/SQL Packages, Functions, Cursors, and Triggers
- Experience in integration of various data sources like DB2, SQL Server, and Flat Files into the staging area
10
Experience For Microsoft ETL Developer Resume
- Perform tests and validate the data flow, prepare all ETL processes according to business requirements
- Strong knowledge of dimensional data modeling
- Experience working with databases (Greenplum, KDB, DB2, Sybase, Oracle, etc)
- Proven track record for data driven decision making
- Enterprise Reporting Tool Experience, such as Cognos or Business Objects
- Data Modeling and Data Warehouse experience
- Experience in Data Warehousing and Business Intelligence
List of Typical Skills For an ETL Developer Resume
1
Skills For Junior ETL Developer Resume
- Excellent interpersonal and communications skills necessary to work effectively with all levels of the organization as well as geographically disbursed teams
- Demonstrated skills in developing and maintaining good interpersonal relationships
- Experience of solid SQL Server/Oracle database skills including the ability to write complex SQL and stored procedures
- Evidence of strong leadership and communication skills at a senior level
- Demonstrate strong communication, organization, and data analysis skills
- Differentiating factors: Experience with Oracle E Business Suite. Greater number of overall years of experience. Experience in finance industry
2
Skills For SQL / ETL Developer Resume
- Advanced skills in RDBMS, Data Modeling and Design, and building data warehouses, data marts using Star Schema for faster and effective querying
- Strong skills in testing individual processes, integration testing and data quality testing
- Demonstrated team-building skills, including leadership, personnel recruitment, retention, hiring, delegation and development
- Experience Writing shell scripts Experience producing effective reports
- Proven strategic thinking and problem-solving skills
- Strong critical thinking and problem-solving skills and a desire to take initiative
3
Skills For Ssis ETL Developer Resume
- Strong Perl programming skills, PERL DBI module & multithreaded
- Strong Oracle SQL programming skills
- Strong data analysis and modelling skills
- Experience working effectively with small groups of highly talented data scientists
- Strong interpersonal, problem solving and verbal communication skills
- Familiarity with reporting tools and good analytical skills
- Experience with Informatica tool set with good working experience in Informatica 8.6.1
4
Skills For ETL Developer / Analyst Resume
- Effectively communicate with people from many different disciplines with varying degrees of technical experience
- Strong SQL skills & understanding of FTP processes
- Demonstrated skills in leadership, organization, and team building
- Excellent listening, interpersonal, written and oral communication skills. Logical and efficient, with keen attention to detail
- Solid programming development skills with emphasis on modular code that is well tested and maintainable
5
Skills For Database / ETL Developer Resume
- Standard ETL Informatica development experience of 3-5 years. Also, strong Oracle knowledge and working experience of Informatica+Oracle
- Good hands-on experience in UNIX/Solaris OS along with a good exposure to shell scripting
- Demonstrated ETL skills using SSIS to access data in Flat File, SQL, and MS Access
- Good oral and written communication, analytical, and problem-solving skills
- Good interpersonal skills and collaborative style to include team-working ability
6
Skills For Oracle ETL Developer Resume
- Strong skillsets working within Talend ETL framework
- We need candidates with strong SSIS and strong Informatica experience
- Strong critical and creative reasoning skills
- Attention to detail and strong organization skills essential
- Demonstrated ability to interact effectively across capability group boundaries
- Work as a team with good communication skills
7
Skills For Senior Manager, ETL Developer Resume
- Strong analytical skills and the ability to work within a group
- Database experience, data analysis and analytical skills
- Excellent, proficient SQL skills
- Work effectively in short-cycle, team oriented environment, managing multiple priorities and tasks
- Skill in documenting processes and procedures effectively
- Excellent writing and analytical skills; ability to work well independently and in a team environment
- Strong analytical and problem-solving skills along with the ability to explain solutions from a technical and a business point of view
- Excellent communication skills and ability to work independently and in a team is required
8
Skills For Digitalisation ETL Developer Resume
- Strong experience in design and development of SQL Server SSIS packages and extensive experience in writing TSQL queries, stored procedures and views
- Strong troubleshooting and risk highlighting skills
- Excellent Oracle & SQL skills
- Good client facing skills, ability to communicate with business and IT stakeholders, understand requirements and incorporate them into designs
- Strong performance-tuning, problems-solving and analytical skills
9
Skills For Business Intelligence ETL Developer Resume
- Possession of excellent oral and written communication skills, including providing recommendations on ETL plan and execution
- Prior experience building data warehouses – Teradata experience required
- Prior experience building data warehouses –SAP BW and/or Hadoop experience beneficial
- Excellent problem solving skills ? able to focus both on the big picture and finite details
- Strong communication and collaboration skills, focus on customer service
10
Skills For Microsoft ETL Developer Resume
- Experience with data analysis, mapping skills and the ability to understand and create data models
- Strong T-SQL knowledge and skills required
- Demonstrated independent problem solving skills and ability to develop solutions to analytical/data-driven problems
- Strong writing, documentation, and oral communication skills
- Strong analytical skills with the ability to collect, organize and analyze information with attention to detail and accuracy
- Excellent ETL/SSIS development skills
- Demonstrated advanced skills in Tableau visualization
List of Typical Responsibilities For an ETL Developer Resume
1
Responsibilities For Junior ETL Developer Resume
- Excellent interpersonal and communication skills, including presentation, written and oral
- Work independently, possess strong problem-solving skills and have a willingness to work with new technologies
- Strong quantitative, analytical, problem-solving and organizational skills
- Creative problem solver with excellent communication, leadership and collaboration skills
- Good time management and organizational skills, with a desire to improve
- Experience in data warehousing that includes job scheduling, data profiling, data cleansing, data quality validation and Testing
- Advanced SQL query-writing skills, Windows/Linux scripting, and automated job scheduling
2
Responsibilities For SQL / ETL Developer Resume
- Proven ETL/Data Integration experience using the following: IBM Data Stage, Shell scripting, Oracle PL/SQL, and Microsoft SSIS
- Demonstrated hands-on experience Developing and testing query solutions using Oracle PL/SQL query
- Extensive Experience on Data-warehousing Projects & strong understating of Data-warehousing concepts
- Create reporting specifications, including report creation, data validation, and report validation
- Olid hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle, and/or other databases
3
Responsibilities For Ssis ETL Developer Resume
- Experience in software development experience demonstrating depth of technical understanding with in ETL, BI/BO disciplines
- Demonstrated hands-on experience ETL design/Data Warehouse development using SQL and PL/SQL programming/IBM DataStage
- Demonstrated experience mentoring and assisting other developers
- Strong SQL knowledge; ability to write highly efficient queries and experience creating and modifying stored procedures, indexes, views
- Proven ETL/Data Integration experience using the following
- Demonstrated hands-on experience ETL design/Data Warehouse development using SQL and PL/SQL programming/ IBM Data Stage
- Demonstrated hands-on development experience using ER Studio for dimensional data modeling for Cognos or OBIEE 10/11g environment
4
Responsibilities For ETL Developer / Analyst Resume
- Excellent experience working with Oracle, PL/SQL and writing stored procedures and triggers
- Communicate effectively both verbally and in writing (Clearly and Succinctly)
- Proven experience in developing functional applications and systems of medium to high technical complexity
- Technical experience relating to ETL design, development, performance and validation
- Mainframe skills including MVS, JCL, CA7, TSO/SPF, COBOL S
- Proven recent experience of Performance Optimization and Tuning
- Balance high-priority work with lower priority maintenance work to ensure both success of projects and smooth operation of existing functions
5
Responsibilities For Database / ETL Developer Resume
- Critical thinking and analytical skills; ability to take loosely formed ideas, coordinate and evolve them
- Convert business rules into transformation logic 3+ years strong experience participating in multiple technical projects through a SDLC
- Experience developing ETL processes with SSIS in a data warehouse environment. Requires experience in Visual Studio, 2008, 2010, and 2012
- Experience with Shell scripts or other scripting experience
- Strong hands on experience in developing batch and real time integrations (Flat Files, EDI, XML)
- Strong hands on experience with data warehousing ETL projects
6
Responsibilities For Oracle ETL Developer Resume
- Skill at combining theoretical elegance with effective, practical approaches
- Demonstrated hands-on experience with UNIX Shell Scripting
- Strong problem-solving ability, and a strong customer service orientation
- ETL experience including experience with ETL tools
- Great communication skills and fluency in English as a working language
7
Responsibilities For Senior Manager, ETL Developer Resume
- Proven experience with one or more leading ETL tools and delivery of enterprise data integration solutions (i.e. Informatica power center, Oracle ODI..)
- Experience with Data modeling – ERWin experience is beneficial
- Prior experience with SQL coding languages
- Data Warehouse application developer with Informatica, Oracle, Netezza and UNIX Skills
- Understanding of Data encryption, TDE, and key management - Intermediate level knowledge/experience
8
Responsibilities For Digitalisation ETL Developer Resume
- Understanding of data replication capabilities – Informatica data replication and/or Teradata-TAS experience beneficial
- Understanding of source and target data structures and relationships – SAP experience beneficial
- Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing
- Experience in performance tuning of the SSIS packages, deploying and administering SSIS packages, proficient in utilizing scripting in SSIS
- Experience in Spark development including data frames, data transformations, performance tuning, memory sizing and tuning Spark Master and Executors
- Moderate to high-level scripting experience using any coding/scripting languages such as Unix Shell, C++, C#, Java, Python etc
- Knowledge of and experience in programming slowly changing dimension loads and update processes (ETL) including maintenance of existing ETL processes
9
Responsibilities For Business Intelligence ETL Developer Resume
- Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS). Capable of designing ETL mappings for flexibility
- Strong working knowledge of Databases ( Indexing, partitioning, space management)
- Extensive experience with securing sensitive data and systems, including firewalls, networking and infrastructure
- Related experience developing and implementing solutions using IBM datastage
- Some programming experience (scripting, C/C++ for data handling/manipulation)
- Experience gathering and documenting reporting requirements from stakeholders at both executive and operational levels
10
Responsibilities For Microsoft ETL Developer Resume
- Demonstrated working knowledge in designing reporting data sets, related meta-data, and reports
- Experience with scheduling ETL jobs using SQL Agent, and external scheduling tool
- Good understanding of data warehousing principles and modeling
- Experience with BI reporting development using MS SQL Server Reporting Services (SSRS), Tableau, and others
- Three years of experience using Unix Shell Scripting and developing Oracle and SQL Server stored procedures
Related to ETL Developer Resume Samples
ETL Application Developer Resume Sample
Work Experience
• Understands customers’ processes and products and how they fit within the goals of the business unit
• Oracle experience with working knowledge in performance and tuning, efficient SQL writing, stored procedures/PLSQL coding etc.
• Play a lead role to facilitate the full prod...
Professional Skills
• Autosys experience or experience with othe...
• Experience writing technical specification...
• Experience in performing general trouble s...
ETL Applications Developer Resume Sample
Work Experience
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentatio
• Overall 9+ years of IT experience
• Exper...
Informatica ETL Developer Resume Sample
Work Experience
• Background in investment banking
• Sub Ledger Systems experience
• A good understanding of MS SQL Server 2012/2014 or 2016 and intermediate skills in T-SQL
• Informatica development, Informatica repository, and Informatica Job scheduling
•&n...
Professional Skills
• Excellent interpersonal, oral and written ...
• Strong database experience, data analysis ...
• Excellent technical, logical, analytical a...
Senior Cyber Resume Sample
Work Experience
• Demonstration of deep technical understanding of Cyber/Network Security & Privacy, an Commercial and Technology Errors & Omissions, and Media. Utilizing risk expertise and knowledge of industry and insurance market place, reviews clients’ exposures and loss experience and develops solutions for complex clients’ n...
Professional Skills
• Passion for all things information technol...
• Project and case management skills
• Experience of using common security tools ...
Consultant CRM Resume Sample
Work Experience
• Identify the appropriate stakeholders for your area of work, considering the impact of your work and the broader cross-functional dependencies. Manage these relationships to meet stakeholders’ business needs and align expectations. Always strive to improve business partner satisfaction
• Implemente...
Professional Skills
• Strong Influencing skills and communicatio...
• Global team player, effective and reliable...
• Experience managing global CRM teams and w...
Lead SAP Resume Sample
Work Experience
• Application life cycle management for all Tate & Lyle’s application landscape including roadmaps and Software Asset Management where needed
• Comprehensive understanding of SAP’s customizing toolset
• Work independently as well as a part of a global team
•&nbs...
Professional Skills
• Experience in strong background in formal ...
• Business Analyst experience in functional ...
• Min of 6 to 8 years of experience required...