Senior ETL Developer Resume Sample
Bryce Bruen
97757 Donnelly Extensions,
Houston,
TX
+1 (555) 984 4417
Work Experience
Senior ETL Developer
07/2016
-
PRESENT
New York, NY
- Provide cost and time estimates for assigned work packages to support the development of time tables and project plans
- Coordinate coding, testing , implementation, integration and documentation of solution
- Provide solutions that potentially impact other dependent projects and applications
- Ensure that errors are detected to avoid production outages
- Establishes and leads ETL work at the client site to meet client requirements and business needs
- Determines ETL strategy; selects tools and techniques, including data cleansing tools, and/or data management systems to provide the solution to data and client issues and other matters of significance and to meet business needs
- Evaluates existing subject areas and determines what ETL work needs to be accomplished and developed
Senior ETL Developer / Admin
03/2009
-
01/2016
Los Angeles, CA
- Demonstrated competency in all phases of business intelligence and data warehousing projects, from inception to production deployment
- Expert knowledge of Netezza and/or Teradata platform and associated tools such as NZload, FastLoad, MultiLoad, TPT, BTEQ , Data export, temp table usage, and distribution keys
- Expert design/coding skills, unit testing methodologies and techniques, including tuning and performance considerations in high-volume MPP environments
- Solid understanding of data warehousing principles, concepts and best practices (e.g. ODS, Data Marts, Staging)
- Strong understanding of Release Management process and required applications
- Familiar with business intelligence tools such as MicroStrategy, Tableau or similar
- Understanding of data modeling principles for data warehousing (Normalization and Star Schema)
- Experience in developing and supporting ETL/ELTapplications
Applications Development Senior ETL Developer
06/2002
-
02/2009
Dallas, TX
- Provides leadership during the development and enhancement of the enterprise’s production applications including; working with applications, technical support and operations during the design, development and implementation of applications
- Performs tasks required to conform to the company’s configuration management and software release processes
- Follow Charter’s standard software development best practices relative to design, development, testing, and implementation
- Demonstrated proficiency in OLTP/OLAP, Analysis and E-R modeling, developing database structures – Star schemas and Snowflake schemas used in relational, dimensional and multidimensional modeling
- Strong knowledge of network, PC and platform operating systems
- Knowledge and experience working with Teradata platform solutions
- Experience with scripting languages including Perl, Python, VBScript, UNIX
- Strong analytical and conceptual skill in database design and implementation of RDBMS concepts
- Hands on experience in tuning mappings/queries, identifying and resolving performance bottlenecks in various levels such as sources, targets, mappings, and sessions
Education
University of North Carolina at Asheville
1996 - 2001
Bachelor's Degree in Computer Science
Professional Skills
- ETL Development experience with strong ETL and SQL programming skills (required); MySQL experience (desired)
- Excellent ETL design skills, and hands-on experience developing ETL mappings
- Excellent scripting and programming skills using python or shell or any other programming language
- Excellent SQL skills, including writing efficient PL SQL/SQL tuning
- Strong performance tuning skills (especially with Oracle)
- Strong scripting skills(shell or perl)
- Strong Linux Scripting skills
How to write Senior ETL Developer Resume
Senior ETL Developer role is responsible for etl, analytical, sql, design, modeling, development, technical, java, analysis, programming.
To write great resume for senior etl developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Senior ETL Developer Resume
The section contact information is important in your senior 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 Senior ETL Developer Resume
The section work experience is an essential part of your senior 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 senior 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 senior etl developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Senior ETL Developer resume experience can include:
- Advanced problem-solving skills. Able to learn effectively and meet deadlines
- Strong skills developing queries, scripts, and stored procedures in mysql and/or other databases
- Proven modeling and information design skills
- Dedicated to excellence in one’s work; strong organizational skills; detail-oriented and thorough
- Team Player with excellent collaborative skills
- Strong data analysis skills and the ability to track a data element from source to transformation to target
Education on a Senior ETL Developer Resume
Make sure to make education a priority on your senior 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 senior 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 Senior ETL Developer Resume
When listing skills on your senior 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 senior etl developer skills:
- Effective decision-making and critical thinking skills for problem identification and solution recommendation
- Expertise in banking domain with good analytical skills across wealth management, credit cards with ETL Datastage/Teradata
- Excellent communication skills and an outstanding team player
- Advanced ETL programming skills and experience in SAS in order to create, import, transform, format, export, and analyze data files
- Experience with Informatica tool set with good working experience in Informatica latest market version
- Experience with Oracle tool set with good working experience in latest versions
List of Typical Experience For a Senior ETL Developer Resume
1
Experience For Senior ETL Developer / Admin Resume
- Strong Logical & Physical Data Modeling experience. Proven skills in 3 rd Normal and Star Schema
- A good understanding of SQL Server 2016 (at least 2008 or later) and advanced skills in T-SQL
- Strong interpersonal, communication, and writing skills; able to work independently or in a team environment
- Strong SQL and PL/SQL development skills in a multi-tier environment
- Strong oral, written and presentation communications skills
- Experience in software development experience demonstrating depth of technical understanding within Business Intelligence
- Demonstrated working experience in large and complex data and Cloud environments (AWS)
2
Experience For IT Senior ETL Developer Resume
- Proficient technical skills to include (SQL DDL and DML, ETL methodologies, TOAD, git, RDBMS, Scheduler, shell scripting)
- Intermediate Excel skills and working knowledge of data analysis and BI tools such as Microstrategy, Hyperion, MS Access
- Handle all aspects of systems life cycle for ETL processes related to DB2, Teradata and extract files using Mainframe skills and Teradata utilities
- Strong Unix shell scripting experience required
- Demonstrate strong proficiency with Microsoft Office Suite
- Experience defining and managing ETL using tools and industry standard practices
- Extensive experience with databases (MS SQL Server, Oracle, and Teradata), Performance tuning using profiler and execution plan
- Excellent understanding of DW design and dimensional data modeling
3
Experience For Applications Development Senior ETL Developer Resume
- Experience with DB2 as an application developer; using stored procedures, user defined functions and embedded SQL in other Programming Languages
- Experience in developing systems using Java, C#, .NET, Perl or C++
- Experience in or working knowledge of investments accounting systems PAM/PFI
- Experience in implementing and supporting several different ETL solutions
- Experience with normalizing and de-normalizing data
- Experienced working with AGILE methodologies, utilizing JIRA
- Provide mentoring and guidance to less-experienced developers in order to improve productivity
- Experience in designing ETL workflows
- Experience with Microsoft SQL development including SSRS, SSIS and SSAS
4
Experience For Senior ETL Developer / Analyst Resume
- Excellent data analysis and debugging
- Experience developing web services-based applications or applications that interact with SOA
- Strong knowledge of data warehousing concepts
- Perform Data Validations using SQL across multiple databases
- Be flexible, set priorities and meet deadlines in a changing environment for self and team
- Experience developing with both SSDT and SSDT-BI (SSIS)
5
Experience For Mid-senior ETL Developer Resume
- Hands on experience for complex query writing and query optimization in different databases
- Experience in documenting work flow and processes, from both a technical and a business perspective
- Experience in DataStage ETL; Expert knowledge of ETL processing, with extensive knowledge of DataStage as the data integration tool
- Experience with Data Modeling - Dimensional and Normalized Relational
- Experience developing process diagrams, data flow diagrams, and spreadsheets with "data elements" mappings
- Experience with data modeling and documentation for OLTP and OLAP
- Experience building ETL pipelines with different technology stacks
- Experience with PeopleSoft data models including Campus Solutions, Finance and/or HCM version 9.0 or higher
- Experience in working with securities & reference data feeds, such as Bloomberg, Thomson Reuters, S&P, Moody’s, IDC, Markit, or similar
6
Experience For Core Banking Senior ETL Developer Resume
- Four years of experience in data warehouse design and data modeling
- Experience to include any of the following
- ETL and Database tuning experience
- TWS Scheduling S/W : 2 to 3 years relevant work experience
- Unix scripting : 3 to 4 years relevant work experience
- Experience using Informatica Power Center 9.x/10.x tools
- Experience with data warehousing
7
Experience For Senior ETL Developer Optima Resume
- Experience building flexible, reusable Informatica mappings and workflows
- Experience in working with many different data sets, large and small
- Good understanding of logical and physical data models
- Strong background in a customer interfacing role
- Experience/exposure to facilitating business process design & development as it relates to Analytics, dashboards and KPI’s reports
- Work experience in delivering IT/BI solutions
- Experience sourcing data from JDE
- Experience with database design, modelling and data analysis on large amounts of data
8
Experience For Senior ETL Developer / Architect Resume
- Experience with Linux operating system or other Unix systems
- Pluses if experience in
- Perform data analysis, data mapping, data loading, and data validation; reusability, parameterization, workflow design, etc
- Leads and provides technical direction to less experienced programmer/analysts
- Experience with job automation, key communication setup (on SLA failures and job failures)
- Experience in Informatica development
- More than 6 to 8 years of progressively responsible directly-related experience
- More than 5 years of experience in data warehouse/data mart environments
9
Experience For Senior ETL Developer, Finance Practice Resume
- More than 5 years of experience in the Informatica suite of products
- Experience on multiple data warehouse projects
- Good understanding of SDLC and Agile Methodologies
- Good understanding of model driven development
- Good understanding of ETL best practices
- Seven or more years’ experience in software engineering
- Demonstrates success working in a team-based environment
- Actively participates in requirements, design and analysis sessions to ensure sound team decision-making and effective ETL strategy
- Strong DB expertise (preferably any MPP database (Oracle)
10
Experience For Senior ETL Developer for Statements Application Resume
- Strong knowledge of flat file formats, XML within PL/SQL, and file format conversion
- Create and validate XML files based on XSD specificationsSearch Jobs US
- Demonstrates knowledge of ETL techniques and fluency
- Experience with TFS for source control and project management
- Past work experience as an ETL or Database developer
- Advanced SSIS experience including ETL
- Strong in SQL programming
- Develop cross validation rules to ensure data accuracy
- Experience with data center migration. Someone who can debug and be able to put things in the right place. Needs to know how SSIS is run
List of Typical Skills For a Senior ETL Developer Resume
1
Skills For Senior ETL Developer / Admin Resume
- Prior Experience: 5+ years ETL development experience preferably using Microsoft SQL Server Data Tools/BIDS, with deep and thorough hands-on use of T-SQL
- Strong problem solving, analytical skills, and team player
- Prior Experience: 8+ years of previous experience supporting data warehouse implementations
- 3) Very strong SQL skills
- Strong experience with Informatica Big Data Edition development experience
2
Skills For IT Senior ETL Developer Resume
- Excellent written and oral communication skills, ability to articulate and document processes and workflows
- Effectively communicating with and developing excellent working relationships with internal and external stakeholders
- Strong experience working in a Cloudera/Hadoop environment using Informatica (including Hive and Blaze engines)
- Proven experience in investigating and resolving issues in development, testing and the production environment
- Demonstrated experience with Data Warehousing and Business Intelligence Architecture concepts (including database design, data modelling, data flow diagrams)
3
Skills For Applications Development Senior ETL Developer Resume
- Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings
- Proven ETL/Data Integration experience using all of the following
- Experience with Data Warehousing principles with hands on experience with slowly changing dimensions and fact tables
- Demonstrate expert level experience in developing ETL solutions using Pentaho or relevant ETL tools
- Strong ETL Development experience using ETL tools, such as Informatica PowerCenter
- Experience as a technical developer, including 2 years of extensive application development experience
- Experience: Five or more years experience in data warehousing, business intelligence, and ETL development
- Good experience in Unix Scripting
- Strong experience in developing Informatica mappings and reusable components
4
Skills For Senior ETL Developer / Analyst Resume
- Proven record of being a strong team player - a whatever-it-takes attitude to complete a project successfully for the team
- Prior experience in working in offshore/onshore model
- Prior experience working with Tidal or other enterprise schedulers
- Demonstrated experience of project estimation and planning
- More than 10 years total experience and 8 years’ experience on software development
- 4) Database Development skills
- Effectively communicates relevant IT-related information to superiors and peers across the organization
- Effectively communicate with UM administration, faculty, and staff on a daily basis as needed
- Manage and develop team skills
5
Skills For Mid-senior ETL Developer Resume
- Data querying and modeling skills. So many candidates can write ETL but have no idea what the data they're moving is for or how it's supposed to work
- Critical thinking skills. Can figure out any new challenges we throw at them
- Understanding of BI development in the IT industry with recent development, system administration, application tuning and debugging experience
- Engineering leadership experience with small agile groups
- Working knowledge and experience with Cognos and / or Tableau developer
6
Skills For Core Banking Senior ETL Developer Resume
- Have good understanding for developing solution using existing EDW architectural standards and audit tables
- Experience with designing, developing, testing, and supporting applications
- Experience developing or supporting applications using IBM Infosphere Datastage
- Experience creating test plans and leading testers in the execution of test plans. Able to develop mitigation strategies for managing data integrity issues
- Strong knowledge of ETL Maintenance, ETL Auditing and Reporting, Data Mapping, Exception
- ETL development experience with designing data structures, building functions, indexes, triggers, large volume extracts, and performance tuning
- Three years of practical experience developing data warehouses, utilizing SAS & SQL programming languages related to area of assignment
7
Skills For Senior ETL Developer Optima Resume
- Experience in and working knowledge of financial reporting and investments accounting principles
- Experience with SQL Agent –creating, configuring, and monitoring jobs
- Experience building scalable and robust ETL data flows using a range of technologies
- Experience designing & developing analytics and reports
- Experience working with a scheduling tool
- Experience developing and loading data warehouse (DW) systems
8
Skills For Senior ETL Developer / Architect Resume
- Proven understanding of SQL optimization (indexing and ability to interpret and act on execution plans)
- Strong problem solving abilities and capable of articulating specific technical topics
- Excellent Understanding of Oracle, Microsoft Sqlserver. Need to be able to write complex queries with ease & Performance tuning
- Data mapping experience - mapping data sources to and from multiple applications
- Experience loading data to SAS LASR Server and administering security within SAS Visual Analytics
- Strong knowledge of data warehousing concepts and dimensional data modeling
- Relevant work experience in business intelligence, data engineering, data warehousing or related field
- Skilled in writing SQL queries, functions, and stored procedures; leveraging transnational databases, relational data marts and data warehouses
9
Skills For Senior ETL Developer, Finance Practice Resume
- Skilled in writing SQL queries, functions, and stored procedures; leveragingtransnational databases, relational data marts and data warehouses
- Experienced in writing complex T-SQL statements, scripts, stored procedures, triggers and views implement business intelligence and data warehousing solutions
- Solid foundation in, and application of, data warehousing and reporting platform concepts with ability to recommend solutions and drive best practices
- Several years of experience building/implementing scalable, reliable, and high-performance ETL architectures
- Able to prioritize work by dividing time, attention and effort between current project workload and on-going support tasks
- Demonstrated ability in developing project deliverables using Agile/Scrum methodology
- Work independently and as part of a team while demonstrating initiative and using good business judgment
10
Skills For Senior ETL Developer for Statements Application Resume
- Experience with manipulating data with Pig, Hive, Java and/or Python
- Experience working with data in multiple ERP and data movement technologies
- Experience with SQL Server 2008R2 – SQL 2017, SQL Server Reporting Services
- Experience with Informatica Power Center workflow, mapping and session development
- Demonstrated expertise in providing the technical knowledge of Extract/Transform/Load (ETL) solutions for data integration projects
- Strong ETL (IBM DataStage / QualityStage) development expertise for data movement, data quality, data cleansing and other ETL-related activities
- Knowledge and experience using Statistical tools
- Experience with self-service reporting tools
- Strong understanding of Informatica Powercenter 9.x
List of Typical Responsibilities For a Senior ETL Developer Resume
1
Responsibilities For Senior ETL Developer / Admin Resume
- Plan self-training and education in order to ensure that technical knowledge is developed so that appropriate new technology and techniques can be suggested in order to effectively meet customers’ needs
- Prior Experience: 10+ years equivalent work experience in Information Technology
- Excellent communications and collaboration skills
- Good understanding in Relational Database Management System, Data Mart and Data Warehouse design
- Experience in writing complex SQL statements, JAVA or VBA scripts, batch files
2
Responsibilities For IT Senior ETL Developer Resume
- Experience translating functional business requirements to technical specifications
- Hands on experience with ETL tools like Informatica
- Expert level SQL experience
- Demonstrated ability to understand data architectures and systems
- Experience with Oracle versions including 9, 10 and ODI or MS SQL Server and SSIS or Informatica
- Experience with database engines including Oracle and Teradata
- Strong Unix, Python/Shell,SQL scripting knowledge
- Experience with interpreted (Perl or Python) or Unix scripting languages
3
Responsibilities For Applications Development Senior ETL Developer Resume
- Hands-on experience with unix shell scripting, ETL tool [either of PENTAHO or INFORMATICA], Oracle, Version Control [CVS/SVN/Git], Cognos
- Experience with mainframes, VB scripting and access databases, SAS programs
- Experience in development using ETL tools, preferably Data Stage and Talend required
- Experience with the LINK for Informatica application
- Experience with SQL Server, Oracle, MySQL and/or PostgreSQL
4
Responsibilities For Senior ETL Developer / Analyst Resume
- Experience to include
- Experience as an administrator of an ETL or middleware tool (DataStage, ODI, Informatica, OSB, etc.)
- Experience on one or more projects to implement an ETL or information management tool
- Hands-on experience in the Hadoop Ecosystem
- Experience with Spark
5
Responsibilities For Mid-senior ETL Developer Resume
- Experience with noSQL
- Hands on experiences on Yarn architecture, HDFS and Hadoop ECO system tech stack(Spark/Hive/etc.)
- 8+ yrs IT experience
- 6 + yrs ETL experience
- PLSQL development experience
- Four years of experience with ETL tools, such as Pentaho, SSIS, Business Objects, or Informatica
6
Responsibilities For Core Banking Senior ETL Developer Resume
- Five years of experience in Oracle 10g/11g,/12c PL/SQL
- Five years of experience in SQL
- One year of experience of development and maintenance in the Cloud
- Experience in relational and data warehouse database design, optimization and performance; preferably with MS SQL Server
- Experience with API (Application Program Interface) development
7
Responsibilities For Senior ETL Developer Optima Resume
- In a structured IT organization with a variety of methodologies, and strong technical environment management
- Experience with multiple SDLC methodologies – Waterfall and Agile
- Extensive experience with data dictionaries, data analysis and relational databases
- Relevant work experience for a college or university
- PL/SQL or T-SQL experience
- Informatica PowerExchange CDC experience on Oracle, DB2, and Mainframe
- Experience with Informatica Intelligent Cloud Services (IICS)
- Experience in higher education data
- Development experience with web-services
8
Responsibilities For Senior ETL Developer / Architect Resume
- Coding, testing, modifying, debugging, documenting and implementation of Informatica maps
- Creating SQL queries to profile and understand data, and documenting and developing ETL
- Building, maintaining and enhancing ETL workflows
- Understanding of Network/Server/Application security/encryption as related to protecting data monitoring tools such as Splunk
- Designing, implementing or managing a Big Data Platform
- Reviewing and restructuring existing code
- Understanding of modern software engineering principles, practices, and systems development methodologies, preferably Rational Unified Process (RUP)
- Allocating programmers to pieces of work, taking account of individuals’ abilities and the requirements of the work. Task Allocation
9
Responsibilities For Senior ETL Developer, Finance Practice Resume
- Fixing performance issues (PL/SQL, PL/pgSQL and SQL tuning)
- Mapping web applications through the UI back to the database and documenting logic applied in each step
- Automating ETL processes through C# or .net languages and implementing encryption for data
- Working knowledge of scheduling software, XML files
- Designing and creating the data warehouse and all related extraction, transformation and load of data functions
- Inserting and extracting data from a Big Data platform
10
Responsibilities For Senior ETL Developer for Statements Application Resume
- Developing plans to ensure delivery of their team’s work
- Working closely with Architects and Product Owners to capture system level requirements
- Working with BI warehouse data and Big Data in the Cloud
- Understanding complex ETL, data conversion and extract strategies
- Taking ownership of data being generated from several of our key games
- Providing production support on a rotating basis
- Understanding of OBIEE / RPD development a benefit
Related to Senior ETL Developer Resume Samples
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...
ETL Developer Resume Sample
Work Experience
• 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 depart...
Professional Skills
• Excellent functional, analytical, interper...
• Strong written communication skills; outst...
• Exceptional verbal and written communicati...
Lotus Notes Developer Resume Sample
Work Experience
• Convert existing Lotus notes client applications
• Researches and evaluates alternative solutions and recommends system design solutions
• Evaluates the application systems/programming requirements and processes (e.g. new enhancements or maintenance), in the preparation of ap...
Professional Skills
• Strong verbal and written communication sk...
• Strong skills in Forms, Agents, Performanc...
• Excellent analytical and organizational sk...
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...