ETL Lead Resume Sample
Fannie Quigley
6950 Auer Pine,
Dallas,
TX
+1 (555) 913 8928
Work Experience
ETL Lead
10/2017
-
PRESENT
Dallas, TX
- 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
- Participate in client calls and prepare the clarification list to seek clarifications
- Prepare the list of requirements and seek review inputs from the key stakeholders
- Update requirements traceability matrix
- Create impact analysis document (for simple change) to understand the impact on the existing functionality, as required
- Provide inputs to testing strategy, configuration, deployment, hardware/software requirement etc
ETL Lead Developer
02/2013
-
05/2017
Phoenix, AZ
- Review plan and provide feedback on gaps, timeline and execution feasibility etc as required in the project
- Participate in KT sessions conducted by customer/ other business teams and provide feedback on requirements
- Work with architects and business on early project vision, and architecture blueprint. Review design roadmap for impacted systems, and look for opportunities to move systems toward long-term vision as part of project
- Serve as an expert resource on matters of data design to business and IT staff in all phases of project development, implementation and support
- Develop solid understanding of the various source data sets and assist in laying out the overall high level and detail Data Design solutions
- Responsible for successful Design, Development and Delivery of projects involving ETL, Database and Business Intelligence
- Understand potential impacts of proposed solutions on other systems, processes or projects. Articulate and document designs, considering tradeoffs, costs, and benefits
- Create appropriate standards, processes and tools to promote and facilitate mapping of data sources, documenting interfaces and designing the movement of the data
- Collaborate with architecture group on design decisions, standards, methodologies, and execution
ETL Lead / Developer
06/2008
-
11/2012
Dallas, TX
- Work with Data Management to establish governance processes around metadata to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of metadata
- Work across multiple projects and systems to develop, communicate, and mentor others on information design/implementation standards, guidelines and best practices
- Engage in and build strong working relationships with IT, Business and Sourcing partners
- Understand the client’s business goals, information needs, application requirements, IT plans, and architecture and articulate linkage to the proposed architecture and application designs
- Participate in client discussions to gather business requirements
- Design Technical Documents from functional specification or Business Requirements
- Design and develop ETL jobs in DataStage from Technical Design Documents
Education
Virginia International University
2003 - 2008
Bachelor's Degree in Computer Science
Professional Skills
- Strong technical leadership and communication skills. Ability to lead and direct work of other developers
- Strong verbal and written communication skills. Ability to present technical details to senior management or less technical audience
- Strong interpersonal and communication skills and ability to interact positively with peer groups within IT and outside IT and management
- Hands on experience in SQL and UNIX skills (basic UNIX commands)
- Good analytical and problem solving skills for selecting data tools and resolve data warehousing issues
- Independent problems solving skills
- Prior insurance work related experience preferably in the P&C sector
How to write ETL Lead Resume
ETL Lead role is responsible for reporting, architecture, mainframe, training, integration, database, java, design, telecom, modeling.
To write great resume for etl lead job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For ETL Lead Resume
The section contact information is important in your etl lead 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 Lead Resume
The section work experience is an essential part of your etl lead 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 lead 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 lead position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative ETL Lead resume experience can include:
- Experience with Data warehousing concepts and BI Components
- Experience with working in complex source system and data acquisition environments
- Strong understanding of ETL Tools – Ab>Initio, Informatica, Hadoop
- Work experience within Data Warehousing or Business Intelligence
- Data Warehousing experience, 5-7 years with Informatica Power Center
- Proven track record of being able to solve complex problems independently and to seek out and generate innovative solutions
Education on an ETL Lead Resume
Make sure to make education a priority on your etl lead resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your etl lead 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 Lead Resume
When listing skills on your etl lead 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 lead skills:
- Solid experience designing, developing and deploying ETL solutions in multi-terabyte Data Warehouses
- Solid Oracle Database Architecture/Design / Performance Tuning Experience
- Experience leading data warehousing efforts with focus on Oracle, SQL Server, Mainframe & SAP sources using Informatica Power Center
- Experience with correlating different modules for data ware house solution components – ETL, DW modeling, Reporting and Analytics
- Good understanding of Reporting Tools – Ab>Initio, Informatica, Hadoop, Hyperion
- Experience ETL process design/development, data modeling, data integration and data migration process design and performance tuning
List of Typical Experience For an ETL Lead Resume
1
Experience For ETL Lead Developer Resume
- Fix ETL process failures or warnings and provide technical support for all
- Provide guidance to technical team and train new team members
- Perform Effort Estimation & Resource Estimation for all the new projects
- Review all the deliverables like Tech Design, DataStage Jobs & Test Logs for all
- Prepare Project Schedule & Implementation Plan for all the ETL Projects
- Support Production & QA promotion activities for all ETL deliverables
- Coordinate with global teams to make sure delivery timelines are met for new projects
2
Experience For ETL Lead Developer Developer Resume
- Provide support to end users of BI Applications from system analysis to BI/ ETL (Informatica) development and support
- Use appropriate software development methodologies prescribed by ResMed,
- Interact with users to gather requirements from various departments and document business requirements; and to prepare functional specifications and mockup designs as necessary
- Troubleshoot data warehouse and BI issues using SQL development and querying tools (e.g. Toad), Provide production support and help resolve nightly ETL (Informatica) data & Cube refresh issues
- Perform troubleshooting on ETL components as needed
3
Experience For ETL Lead / Developer Resume
- Respond to assigned defect tickets working with QA and users to resolve data load defects
- Interact with local. remote development teams and other regional BI teams for production support
- Troubleshoot, debug and diagnose BI / ETL (Informatica) issues
- Working with Data architects and data modelers, perform source data profiling to identify business rule gaps, capture metadata, refine transformation mappings, develop technical design documents and process flow diagrams
- Review model schema for stage, warehouse and marts
4
Experience For Senior Data Integration ETL Lead Resume
- Make database changes to support model design
- Design and build an end-to-end orchestration process (Talend TAC Execution plan) to schedule/trigger and run the ETL process
- Complete code reviews for ETL components and design documentation
- Prepare documentation and production migration scripts
List of Typical Skills For an ETL Lead Resume
1
Skills For ETL Lead Developer Resume
- Experience in relational, OLTP, SQL, SQL performance tuning, dimensional and OLAP databases and technologies
- Experience in Data analysis and mapping, creation and usage of metadata
- Experience in vendor teamwork and working with onshore and offshore partners
- Good Understanding of data model
- Relevant work experience needed is between 6-7 years
2
Skills For ETL Lead Developer Developer Resume
- Work experience as team lead
- Relevant work experience needed is between 7-10 years
- OLAP experience with MDX/DMX query development
- Experience with MPP data warehouse technology, IBM Netezza is helpful
- Experience with ETL tools, IBM InfoSphere DataStage is helpful
- Experience in Agile methodologies and implementation is helpful
- Progressive experience in the design and development of relational database systems and more recently data warehouses
- Experience in DataStage and QualityStage design
- Experience in Development of Data warehouse Architecture with BI best practices and reusability
3
Skills For ETL Lead / Developer Resume
- Experience BI performance optimization techniques
- Experience in IBM DataStage or equivalent ETL tools ( Informatica etc.)
- Experience with MS-SQL Sever and Windows/UNIX OS
- Experience with Developer-Cloud Dev and Migration-AWS-App Services
- Support all testing, including Development, Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance Testing
- Provide performance tuning and enhancement of ETL (Informatica) processes, including supporting technical documentation
- Build ETL jobs in compliance with established standards and patterns. Including error processing and integrated scheduling
- Conduct training or knowledge sharing sessions (in case of niche technology)
4
Skills For Senior Data Integration ETL Lead Resume
- Expertise in data modeling & data mining
- Proficient in performance improvement & fine-tuning ETL implementations
- Conduct code reviews across projects. Takes responsibility for ensuring that build and code adhere to architectural and quality standards and policies
- MS SQL Server or Oracle environment – creating tables/views/store procedures
- Data Warehouse/Data Mart data loading
- BI Reporting-Microsoft SSRS
- A challenging, team-oriented work environment
5
Skills For Informatica / ETL Lead Resume
- Proficient with data modeling tools
- Well versed with database administration tasks and working with DBAs to monitor and resolve ETL (Informatica) issues
- Knowledge and alignment to enterprise data modeling and data architecture standard methodologies established for Guitar Center, Inc
- Perform ongoing daily production support tasks, review daily exception email, ad-hoc requests and provide on-call support
- Performance tuning of ETL jobs to keep data loads within SLA
6
Skills For Fortent ETL Lead Resume
- Suggest and implement enhancements to existing processes in production
- Develop and/or enhance ETL (Informatica) solutions - expert knowledge of Informatica and Oracle PL/ SQL programming required
- Provide BI training to various business users and on new BI projects
- Create/ contribute to document development (case study, lessons learnt etc) as required
- Conduct technical, face to face interviews (as part of organization contribution activities)
- Provide feedback for performance appraisals for the development team
- Search the knowledge repository for information to resolve problems
- Post release participate in project review call and discuss points on what went well and what didn't
- Create and update knowledge articles (case studies, lessons learnt) in the knowledge management repository
7
Skills For ETL Lead Infrastructure Operations Engineer Resume
- Publish white papers/ blogs/ articles (if required)
- Provide feedback on Developers form technical /domain standpoint to the module lead
- Technical Design and development of ETL services /components
- Functional knowledge of AML
- Talend ETL open studio
- Informatic or Datastage
- Review the technical work of less senior ETL developers, provide direction and resolve problems of high complexity
- Current knowledge of insurance industry technology trends such as ACORD and / or IBM’s IAA data models nice to have
- Background in statistics and/or quantitative analysis
8
Skills For DB / ETL Lead Developer Resume
- Data Analyst-SQL
- Data Integrator-ETL-Microsoft SSIS
- Experienced in concepts around Master Data Management, ETL, Data Quality, metadata management, data profiling, micro-batches, streaming data loads, and Change Data Capture (CDC) is also critical for this role
- Good understanding of Java, J2EE, Hibernate and Spring Framework
- Exposure and experience on Talend ETL and Jasper BI would be an added advantage
- Competitive remuneration and benefits
- Resource management and offshore resource management
- Expertise in Enterprise Data Warehouse SDLC, standards, and methodology
9
Skills For ETL Lead Engineer Resume
- Code/update/tune very complex SQL queries
- Provide both innovative and improvement solutions to current and anticipated business challenges
- Expert knowledge of data warehouse architecture
- Well versed with SQL and MDX concepts
- The role requires someone with strong passion for technology architecture/design, have good execution skills and enabling BI reporting solution through technology. He/She needs to be a self-starter and comfortable working in an agile fast paced environment
- Accountable for mentoring, guiding the BI and reporting technology staff at Zafin
- Responsible for all aspects of ETL Development, improvements and operations, data model and architectural design, and implementation
10
Skills For Business Intelligence ETL Lead Resume
- Lead or participate in business meetings to capture requirements, provide status updates and document the requirements
- Collaborate, lead, and manage the productivity of the project tasks and work of the offshore team
- Perform code review of offshore to ensure the quality and efficiency of the code is in alignment with project requirement
- Ensure all aspects of software development are in compliance to SOX and PCI policies for all phases of SDLC and Change Management
- Lead or assist with application/hardware upgrade and system maintenance support
- Monitor the Daily & Monthly Production flows which load key data in Data Ware House
- Troubleshoot ETL Production Issues / Incidents for Data Ware House, Fact & Dimension Loads
Related to ETL Lead Resume Samples
ETL Resume Sample
Work Experience
• 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 proj...
Professional Skills
• Analyze the feature requirements as presen...
• Strong analytical skills; Solid interperso...
• Software Engineering experience in a clien...
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...
SAP Lead Resume Sample
Work Experience
• Manages the proposal and implementation of system solutions
• Provides technical support and guidance in all aspects of design and development
• Serve as level 2 technical support for all ranges of incidents and problem resolution. Provide technical expertise for resolving es...
Professional Skills
• Team building and leadership skills, prefe...
• Strong communication skills and a fluent k...
• Strong business acumen with significant bu...
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...