ETL Resume Sample
Eudora Schoen
683 Trantow Summit,
Dallas,
TX
+1 (555) 173 4114
Work Experience
ETL Administrator
10/2016
-
PRESENT
Chicago, IL
- Provides oversite for documentation of formal project deliverables such as high level Design document, detailed design document, test plan and implementation plan
- Consults with business and technical clients and application development areas in the design to implementation of small to medium projects
- Design and develop simple to highly complex ETL packages to meet the goals of the Student Data Governance Committee
- Interact and effectively communicate with the technology team and the data experts to collect and understand requirements
- Produce metrics, alerts, reports, and dashboards for UME administration, faculty and staff enabling them to gain insight into student success and take appropriate actions
- Design presentation layer(s)
- Design quality metrics to support and maintain existing data models
ETL Software Engineer
01/2012
-
07/2016
Detroit, MI
- Experience working in a large data warehouse environment
- Experience interfacing with C level employees
- Pentaho / Informatica / Datastage or relevant ETL experience
- Javascript / Python / C# / Shell scripting or relevant scripting/programming experience
- Windows and Unix platform
- SQL server experiencer
- ETL experience working with SSIS
ETL Software Engineer Intern
07/2007
-
07/2011
Los Angeles, CA
- Expertise with QA Deliverables tool set - (Quality Center, SharePoint, Microsoft Project/Excel)
- Excellent interpersonal skills, Communicates Effectively, builds relationships, Influences others
- Agile tools (Jira/Rally)
- Makes effective use of company collaboration and knowledge resource tools and resources
- Produces completed work requiring infrequent rework and little involvement of others to ensure quality
- Creates self monitoring processes and habits to ensure accuracy of work
- Demonstrates expertise in a variety of the field’s concepts, practices, and procedures related to ETL/Data design and development
Education
Wittenberg University
2003 - 2007
Bachelor's Degree in Computer Science
Professional Skills
- Analyze the feature requirements as presented by the business analyst and the delivery team, in context of the overall project feature set and existing implementation. Translate requirements to technical concepts
- Strong analytical skills; Solid interpersonal skills
- Software Engineering experience in a client server and ETL environment that demonstrates exceptional design, coding, testing and debugging skills
- Strong analytical, planning, organization and time management skills with a strong attention to detail
- Significant practical experience in PowerCenter version 8.6 or greater, with strong technical and communication skills
- Excellent problem-solving skills, with a demonstrated ability to identify and solve problems
- Three years or more experience in DataStage (9.1 or higher) administration with strong skills in installation, configuration & upgrade of software
How to write ETL Resume
ETL role is responsible for technical, software, etl, interpersonal, business, design, analytical, database, maintenance, engineering.
To write great resume for etl job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For ETL Resume
The section contact information is important in your etl 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 Resume
The section work experience is an essential part of your etl 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 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 position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative ETL resume experience can include:
- Distinctive problem-solving and analytical skills; demonstrated ability to multi-task and apply initiative and creativity on challenging projects
- Lead and work in groups - strong consultative and consensus building skills
- Relationship building and good communication skills
- Designing, developing and testing processes for validating and conditioning data prior to loading into a data warehouse
- Professional Experience In Coding, Designing, Developing And Analyzing Data and experience with IBM Rational Tools
- Prior Experience with consuming / Persisting data from and to Relational databases, S3 and Redshift using Python/PySpark
Education on an ETL Resume
Make sure to make education a priority on your etl resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your etl 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 Resume
When listing skills on your etl 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 skills:
- Strong Data warehousing concepts good Analysis skills
- Demonstrates good leadership skills and independenc
- Strong skills in ETL design and development – understanding the tradeoffs of various design options on multiple platforms using multiple protocols
- Work independently and have strong problem solving and analytic skills
- Good communication, leadership and team mentoring skills
- Excellent communication skills. Fluency in English required. (English is the working language)
List of Typical Experience For an ETL Resume
1
Experience For ETL Software Engineer Resume
- Possess an excellent interpersonal and communication skills (personal, written and presentation) to work cross-functionally with IT and non-IT staff
- Provide functional expertise within his/her skills to assist delivery team members, foster collaboration
- >4 years extensive Informatica experience related to creating workflows, scheduling jobs and troubleshooting
- Provides technical consulting and advises teams and customers on ETL and integrations resulting in an efficient and effective data ETL and integrations
- Dimensional Modeling experience using Kimball, Data Vault or Inmon methodologies (3+ years)
2
Experience For ETL Consultant Resume
- Experience designing and building complete ETL processes (2+ years)
- Significant experience troubleshooting data-related issues
- Significant experience operating a production ETL solution
- Experience working with NoSQL Databases (preferably MongoDB)
- Experience and/or willingness working with teams in other geographical locations and time zones are required
- Good working knowledge of data warehouse, database design, Microsoft Office Products and Microsoft Visio
- Strong understanding of Master Data Management, Operational Data Store, and DW/BI concepts
3
Experience For ETL Administrator Resume
- Experience with Informatica software and with implementing complex ETL solutions
- Experience with architecture, design, and development of ETL solutions using Informatica, release management, and performance optimization
- Experience in optimizing complex SQL queries
- Hands-on working experience with data on Hadoop data lake
- Passionate about delivering with quality with experience in practices like TDD and ATDD
- Direct experience in ETL software development and/or programming design and systems management
- Direct experience in Transmissions software development and/or programming design and systems management
4
Experience For ETL Database Developer Resume
- Database schema mapping experience
- Solid hands-on expertise deploying applications to end-users
- At least two years’ experience using Informatica
- Experience in software systems development and programming,
- Experience working with heterogeneous data systems (Oracle, SQL Server, AWS RedShift, XML,Json, flat file, etc.)
- Experience with real time oracle change data capture using Informatica power exchange
- Experience with programming languages such as Java and Python
5
Experience For ETL / Integration Analyst Resume
- Min 8+ years of experience in working with AbInitio as an ETL Tool
- Experience with various Ab initio parallelism techniques, Ab initio Graphs using Data, Pipeline & Component parallelisms
- Technology Enthusiast with clear and strong software programming fundamentals
- Proven track record for agile, test-driven development, continuous integration, and automated testing
- Programming experience in Informatica Powercenter 9.1 or other ETL tools
- Programming experience in Oracle PL/SQL and stored procedures
6
Experience For ETL Data Engineer Resume
- Experience in scripting and languages - perl, unix shell scripts - 3+ years
- Experience working with Agile Development - Scrum / Jira and Confluence
- Experience with any of these programming languages - Java, Scala, Python - 2+ years
- Experience in writing backend SQL queries, PL/SQL functions/procedures in Oracle database
- Experience in writing Unix shell scripts
- Experience utilizing the Data Management Book of Knowledge (DAMA - DMBOK)
7
Experience For ETL / Data Engineer Resume
- "hands-on" experience designing Data Integration solutions with the latest ETL and Analytic Tools
- · Hands on experience working with ksh and the Unix/Linux environment
- Experience designing databases
- UNIX scripting, Oracle SQL and PL/SQL experience
- Demonstrated proficiency in writing SQL
- Experience developing in .NET
8
Experience For ETL Tech Lead Resume
- Four (4) years of experience with database design, dimensional modeling, data warehouse, BI / analytic tools
- Experience in using team-based development and version control options within PowerCenter environment
- Technical experience in development using Web Services; XML based web service provides and consumers
- Data architecture experience: familiar with relational and dimensional data model, able to design solution based on existing data models
- Experience supporting SSIS and ETL
9
Experience For ETL Analyst Resume
- Experience working in a high volume Informatica Power Center environment
- Strong understanding of ETL fundamentals
- Experience in handling large and complex datasets
- Experience with Data Structures, Data Modeling, RDBMS
- Experience in working with Ford Agile Framework (backlogs, iterations, user stories, rally tool etc.)
- Experience implementing technical solutions under tight time, quality, and performance standards
- Experience in handling both on premise and on Cloud (AWS) ETLs
- Experience in using Apache Sqoop and Spark
10
Experience For ETL Data Analyst Resume
- Hands on Experience on ETL Testing
- Experience in working on Informatica,TIDAL and OBIEE
- Good at writing complex SQL queries
- Work experience with the following
- Experience working with big data technologies such as Hadoop, Hive, Pig, Spark, Presto, etc
- Experience working in a cloud-based infrastructure, such as Amazon AWS or Cloudera
- Experience working with NoSQL database technologies such as MongoDB, Cassandra, etc
List of Typical Skills For an ETL Resume
1
Skills For ETL Software Engineer Resume
- "hands-on" experience using Oracle PL/SQL, stored procedures, SQL optimization skills
- Very strong data modeling skills
- Excellent interpersonal and communication skills (personal, written and presentation) to work cross-functionally with IT and non-IT staff
- Good analytical, Communication Skills with Positive and Team Player Attitude
- Strong analytical and problem solving skills and ability to execute projects independently is required
2
Skills For ETL Consultant Resume
- Quality mindset and strong analytical skills
- Strong organizational skills with the ability to produce and maintain documentation to support activities
- Strong analytical, troubleshooting and diagnostic skills
- Solid experience designing and developing applications in SQL and PL/SQL
- Experience using Linux and shell scripting. Perl experience is desirable
3
Skills For ETL Administrator Resume
- Solid experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems
- Demonstrated experience using relational data architecture and reporting tools to design and develop reports to meet specifications
- 3+ solid years experience using the INFORMATICA ETL programming tool required
- Good working experience with all components of Ab Initio such as Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup etc
- Good working experience on generic graphs, continuous flows
- Advanced skills in ETL processing, automation, and tools (SSIS, Talend, Pentaho, bulk loaders)
- Work effectively in a team environment while also balancing independent work
- Strong experience in Data Ingestion and processing on big data
4
Skills For ETL Database Developer Resume
- Prior experience working with Bank data warehouse / data marts / data lakes
- Project Management skills – ability to plan, execute and forecast actions in advance
- Project management skills, along with some people management background
- Very good Excel, good SQL, IT sense, finance, capital markets knowledge
- Hands on with Python ,with prior experience in handling ETL/ELT workload using Python Scripts
- Good Understanding of other AWS services like S3 ,EC2 , IAM , RDS Experience with Orchestration and Data Pipeline like AWS Step functions/Data Pipeline/Glue
- Skillsets used. Informatica Powercenter; SSIS(SQL Server Integration Services); SQL Server; Teradata, .NET
5
Skills For ETL / Integration Analyst Resume
- Experience with ETL projects (data extract, transform and load) (good to have) This one is key
- Demonstrated experience with Java
- Strong hands-on SQL and relational Database technologies experience like Oracle, Mysql , Teradata
- Working knowledge of SSIS and job creation combined with experience in physical and logical database design
- Working experience with Crystal and WeBi Reports required
- Understanding Test Automation Strategy (good to have) This one is key
- Programming experience in Java, C/C++,Javascript
6
Skills For ETL Data Engineer Resume
- Ensuring to review and validate the data changes for SELAS Release
- Experience with Invoicing, Core Accounting, Consulting data, Project Accounting data, and/or associated transactional systems
- Experience in performance testing and tuning exercises involving Callidus grid computing, Informatica ETL processes, and Business Objects report generation
- Experience designing, developing, testing and implementing ETL solutions
- With 5-8years of Hands on experience in QA ( ETL Testing) / test case development, Creating Test Scripts,test Execution, Defect s&status reporting
- Review and analyze existing Integrations’ effectiveness and efficiency, and develop strategies for improving or leveraging these systems
7
Skills For ETL / Data Engineer Resume
- Experience with Extract, Transform, and Load (ETL) processes, including document parsing techniques and managing large complex data sets
- Hands-on working experience on creating/using logical and physical data models
- Experience performing data modeling, predictive analytics, and forecasting techniques
- Experience using any of the scheduling tools like Autosys, Control-M etc
- Demonstrated expertise in the Big Data Technology ecosystem, and data streaming technologies with enough programming proficiencies in these areas
- Database warehousing and performance tuning experience helpful
- Experience implementing data warehouses / data marts using SAS Data Management & SQL related to area of assignment
- ) SAP experience - working within software program moving data
- Experience using and optimizing SQL database queries
8
Skills For ETL Tech Lead Resume
- Experience with advanced SQL query writing, data retrieval, and data mining from relational databases, such as Microsoft SQL Server
- Experience working with and developing data warehouses and business intelligence solutions
- Experience in ETL (Datastage), Database programming and design, Oracle, Teradata, PL/SQL, Unix and Shell scripting
- Good knowledge of metadata, and using/managing metadata is required
- Experience with ETL/DW including 2 years working as a team lead
9
Skills For ETL Analyst Resume
- Good working knowledge of data mining and data visualisation
- Evidence of applied problem solving using analytics
- Engage fully in debugging and correcting historical and incremental ETL data loads and develop a good recovery procedure for exceptions
- Experience supporting and troubleshooting ETL and/or FTP related processes and jobs
- Experience managing and maintaining meta-data
- Experience using data cleansing, data quality tools
- Experience working on data integration and warehousing projects
- Experienced in complex SQL statements, Microsoft Access, SQL databases, VB programming language, Excel, Data Warehousing, ETL and possibly Crystal Reports
10
Skills For ETL Data Analyst Resume
- Experience in working with Mainframe environments, UNIX, Z/OS scripting
- Experience evaluating and purchasing commercial ETL tools
- Experience designing and maintaining business intelligence reports
- Demonstrate passion for anticipating and meeting the expectations and requirements of business partners
- Experience in Ab Initio tools such as Graphical Development Environment (GDE), Enterprise Metadata Environment including air commands (EME), and data profiling
List of Typical Responsibilities For an ETL Resume
1
Responsibilities For ETL Software Engineer Resume
- Strong communication, presentation and interpersonal skills are essential
- Good to have: Dimensional Modeling and Data warehouse concepts, such as star schemas, snowflakes, dimensions, facts etc
- Experience using out of box Data Service capabilities in SAP space
- Validate the data in the database and also responsible for testing the routines developed
- Benefits data mapping and transmission experience
- Experience developing database ETL environments with business intelligence applications
2
Responsibilities For ETL Consultant Resume
- Experience with one or more of the following: SSIS, SSMS, SSRS, Informatica
- Experience in migrating datastage projects & metadata from one version to another
- Experience developing database ETL environments with business intelligence applications
- Experience writing stored T-SQL, procedures, functions, and SQL queries
- Experience with Business Analysis, creating automation requirements
3
Responsibilities For ETL Administrator Resume
- Good understanding of any of the RDBS like Teradata, Oracle or DB2
- Experience with data mapping analysis and design is required
- Strong production support background with mandatory unix / linux shell & perl scripting
- Strong SQL / Database knowledge with performance tuning and storage maintenance
- Business analysis experience in Core Banking / Payments area
- ETL experience using Informatica Power Center 9.6 software within a structured systems development life cycle
- Experience in a systems engineering role with data management or data ingestion
- Highly skilled in SQL and capable of working with database administrator to enhance query performance
4
Responsibilities For ETL Database Developer Resume
- Experience with multiple OS including UNIX, Linux, and Windows
- Experience in implementation of data integration or large scale data conversions
- Hands on experience in ETL Tool Architecture and ETL products especially Informatica 8.6.1 or 9.1 or 9.6.1
- Hands on experience with database like Oracle, MSSQL Server and database languages like SQL, PL/SQL and TSQL
- Experience with Business Objects Data Services, Data Integration, Data Quality and Data Quality Management
- Experience of data usage for SAP data migrations
- Significant experience with data movement and transformation technologies
- Two years of college and 8 years of involvement in application development or in lieu of education 10 years of relevant experience
5
Responsibilities For ETL / Integration Analyst Resume
- Experience with Oracle, SQL Server in UNIX environment
- Five Years’ ETL experience
- Experience with SSIS, or equivalent tool (such as Informatica, Talend, Pentaho, etc)
- Experience with MS SQL Server stored procedures, functions, cursors, and dynamic SQL
- Implementation/ Deployment experience – Identify cross impacts, mitigate risks with parallel development etc
- Assist in on-the-job training of less experienced programmers
- Familiarity with Node.js, Flask, Express, micro services with containers, and .NET are strong pluses
6
Responsibilities For ETL Data Engineer Resume
- Experience with Structured Query Language
- Demonstrated knowledge of all phases of Software Development Lifecycle
- Demonstrates attention to detail, organization, and timeliness in order to meet customer service expectations
- Extensive technical tool/technique experience on ETL platforms
- Experience with Visio and MS Project or equivalents
- More than 7 years of experience in Informatica tools like PowerCenter along with a clear understanding of core best practices
7
Responsibilities For ETL / Data Engineer Resume
- · Experience in Agile methodology is recommended but not required
- Experience with SQL and Stored Procedure development
- Experience with Structured Query Language
- Knowledge & experience in InfoSphere Information Analyzer
- Experience with Microsoft SSIS version 2005 or later
8
Responsibilities For ETL Tech Lead Resume
- ETL (DM Express or Informatica) Tool experience
- Experience of work in financial institutions
- Experience with Microsoft SQL Server
- Experience with T-SQL development
- Hands-on integration development experience in a UNIX based environment
9
Responsibilities For ETL Analyst Resume
- Experience with any another ETL tool - 1 or 2 years
- Experience with Cloud technologies - AWS , Azure or Google Cloud - 1 to 2 years
- Experience with Databases - Oracle, HP Vertica/Redshift - 3+ years
- Experience with Enterprise Security - Encryption methods, Policy Enforcement, File Transfer Security, Web Services and REST API
- Experience in Dev-Ops practices
- Hands-on ETL development experience
- Experience in Ab initio ETL tool and in EME
- Experience and knowledge of Data Architecture principles and techniques and/or Medicaid Information Technology Architecture (MITA) principles
- Experience in using source code control system (like SVN)
10
Responsibilities For ETL Data Analyst Resume
- Experience using Microsoft word/PowerPoint/Excel/Visio
- Overall 8+ years of relevant experience
- Hands on experience with Informatica Power Center 9x, Oracle GoldenGate
- Hands-on experience with Business Intelligence tools preferably Cognos or Power BI
- Hands-on experience with SQL Server and Oracle databases
- Experience with various AWS EMR components ( Hive /HDFS/Spark/ EMFRS/Scoop) handling very large data sets in a large Data Lake setup
Related to ETL Resume Samples
ETL Architect Resume Sample
Work Experience
• Design the system components / ETL automation for the extract/transform or conversion of data from source systems to the target application (including historization, surrogation, data quality, error handling components ) based on company’s IBM DataStage based ETL framework
• Strong analysis and des...
Professional Skills
• Communication & presentation skills, Analy...
• Strong UNIX scripting and SQL skills required
• Strong interpersonal and communication ski...
ETL Engineer Resume Sample
Work Experience
• Expert knowledge of Terada platform and associated tools
• Expert design/coding skills, unit testing methodologies and techniques
• Demonstrated competency in all phases of business intelligence and data warehousing projects, from inception to production deployment
&nbs...
Professional Skills
• Experience documenting ETL mappings and go...
• Experience building reports with SSRS; inc...
• Hands-on skills in performance tuning, mon...
ETL Lead Resume Sample
Work Experience
• Understand the requirements, functional design document, ETL requirements from the BA/ onsite counterparts
• Analyze for gaps, check feasibility from the design perspective and seek any clarifications (iterative process)
• Understand the functional/ nonfunctional requirements...
Professional Skills
• Strong technical leadership and communicat...
• Strong verbal and written communication sk...
• Strong interpersonal and communication ski...
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...