ETL Architect Resume Sample
Vida Hills
8396 Jay Trail,
San Francisco,
CA
+1 (555) 157 0365
Work Experience
Data Warehousing Lead ETL Architect
04/2017
-
PRESENT
Houston, TX
- 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 design skill
- Design and develop complex ETL mappings, sessions, workflows and identify areas of optimizations
- Experience with Oracle RDBMS 10g or 11g
- Define technical strategy and roadmap for PHH’s Informatica platform
- Define best practices and coding standards for ETL
- Review Informatica jobs for compliance with best practices and standards
ETL Architect
12/2013
-
11/2016
Houston, TX
- Project centric development tasks
- Development and maintenance of enterprise reusable framework
- Troubleshooting and resolution management for Informatica related issues and outages
- Estimation of level of effort associated with new ETL jobs
- Engineering Experience with
- ETL / Data Warehouse Management
- Develop data migration solution in highly demanding environment and provide hands on guidance to other team members
- Quickly learn business processes and how the various business units interact with data
- Demonstrate critical thinking, analytical skills, and employ judgment to offer thoughtful, concise solutions to business client data problems
Enterprise Data / ETL Architect
09/2006
-
08/2013
Los Angeles, CA
- Head complex ETL requirements and design
- Collaborate with functional experts and business users to develop architectural requirements to ensure client satisfaction with solution
- Identify performance issues and recommend resolutions
- Experience in data management, data architecture, database analyst, or similar positions
- Broad Knowledge of relational databases, query language and thorough knowledge of referential integrity
- Data modeling (physical and logical), ER diagrams, data dictionary, data map, normalize/denormalize, agile data modeling
- Strong SQL coding experience
- Strong experience in Informatica and ETL approaches
- Provide production support related to ETL schedules, tasks and work with other BI/ IT team members and service desk to resolve data refresh issues –
Education
Georgia State University
2002 - 2006
Bachelor's Degree in Related Field
Professional Skills
- Communication & presentation skills, Analytical Skills | | required
- Strong UNIX scripting and SQL skills required
- Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management
- Strong experience writing / tuning SQL statements
- Strong experience developing software applications as part of a team, employing practical and effective software design concepts
- Strong experience writing Stored procedures , preferably in SQL Server (T-SQL)
- Experience in trouble shooting data warehouse refresh issues and validation of BI reports/ EDW data with source systems
How to write ETL Architect Resume
ETL Architect role is responsible for sql, database, solutions, gis, mainframe, integration, architecture, analysis, design, research.
To write great resume for etl architect job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For ETL Architect Resume
The section contact information is important in your etl architect 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 Architect Resume
The section work experience is an essential part of your etl architect 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 architect 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 architect position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative ETL Architect resume experience can include:
- Experience as Informatica Developer & scripting experience
- Open to learn and acquire new skills
- Lead team of ETL developers of varying experience levels in building and supporting ETL processes for systems
- Manage and prioritize enhancements activity by closely working with business and provide regular status reporting
- Relevant experience in ETL role, including data warehousing and ETL tools, techniques and technology
- Experience in onshore – offshore model
Education on an ETL Architect Resume
Make sure to make education a priority on your etl architect resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your etl architect 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 Architect Resume
When listing skills on your etl architect 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 architect skills:
- Very good communication skills since alot of the analysis work involves interacting with the clients
- Strong Integration experience with CRM applications, Salesforce and Microsoft Dynamics CRM
- Can effectively manage and develop relationships with key decision-makers and stakeholders to achieve successful outcomes
- Prior experience with one of many case tools (ERwin, ERStudio, Power Designer etc.)
- IBM Certified Solution Expert in the above required skills
- Strong grasp on ETL/DataWarehousing concepts with at least 6-8 yrs hands-on experience
List of Typical Experience For an ETL Architect Resume
1
Experience For Data Warehousing Lead ETL Architect Resume
- Preparing integration architecture blueprints, position papers, conducting market research and proof of concepts on emerging technologies
- Participate and provide required architectural suggestions in performance, load, and stress testing, and remediation of issues identified
- Work with onshore/ offshore resources for development/ support efforts
- 1) Maintain formal relationship with Systems Executive Director, . Works with Data Architects and Information Access Analysts to design and implement data integration and transformation programs and processes to enable efficient and effective assess to performance measurement and other analytical information resources
- 3) Strong programming and application development skills that include: SQL programming, Visual Basic, Visual Studio .Net, Exce/VBA, and the experience programming the requirements for loading dimensional and fact tables. Consult with Database Administrators and Data Architects in performance tuning of all the ETL and Database environments
2
Experience For System ETL Architect / Analyst Resume
- 4) Responsible for the design , implementation and maintenance of the metadata repository environment to enable user access to data definitions, processing and business rules regarding performance metrics and analytical information resources
- 5) Serve as the primary liaison with the ETL software vendor in monitoring all ETL solution environment, and recommending and implementing software upgrades as needed. Take a proactive lead in identifying and recommending improvements to the ETL solution environment
- Drive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling
- Establish, maintain and enforce ETL architecture design principles, techniques, standards and best practices
- Installing and configuring Informatica components, including highly available grid environment; managing server activations and de-activations for all environments; ensuring that all systems and procedures adhere to organizational best practices
- Support on-going ETL environment and support during maintenance or failure
3
Experience For Data Stage ETL Architect Principal Resume
- Work closely with Linux admins/ network teams and oracle Sys DBA’s on operational failures and triage issues
- Performances tune the workflows on Informatica 9.6 platform as part of the upgrade and development
- Collaborate with Business, to understand business requirements, data, and optimize ETL performance
- Develop complex ETL mappings on Informatica 9.x platform
- Develop and deploy utilities on Informatica 9.x platform that assist in the daily maintenance of the ETL platform and automation of the jobs
4
Experience For Enterprise Data / ETL Architect Resume
- Peer Review and Participate in activities that ensure the successful use of these systems including: developing analysis and design documentation, test scripts etc
- Develop Oracle SQL/PLSQL’s and Shell scripts
- Support, monitor and perform required data analysis based on the ETL failure or business queries
- Architect and design ETL/ELT integration strategies for enterprise integration solutions to support client business processes and functional requirements as it relates to complex data driven solutions
- Actively participate with cross-functional teams to drive ETL/ELT architecture and solution designs from inception to delivery
- Research, analyze and design to data architecture requirements and recommend optimal ETL/ELT solutions within Information management technology architecture
5
Experience For SAP ETL Architect Resume
- Support the development of Integration roadmaps, associated plans and apply industry and technical knowledge to provide ETL/ELT solutions that increase measureable business results and minimize risk
- Develop architecture standards for code, documentation and designs to ensure best in class integrated solutions. Driving Process and Tool improvements to optimize operations and cost efficiencies
- Identify, recommend, source, negotiate and implement emerging IT Integration trends, developments and improvements solutions (buy/build/reuse)
- Oversee vendor delivery of ETL/ELT solution design and code as per Enterprise standards
- Troubleshoot any Ab Initio related problem/error
- Cloudera, Hadoop, Spark
- IBM Rational Tools
- DBMS and SQL
List of Typical Skills For an ETL Architect Resume
1
Skills For Data Warehousing Lead ETL Architect Resume
- Strong grasp on ETL/DataWarehousing concepts
- Very good understanding of core source systems
- Experience using recent versions of IBM Infosphere DataStage suite of tool
- Experience in working on InfoSphere DataStage
- Experience in the design and development of data warehousing ETL/ELT solutions
- Experience with Microsoft SSIS, Linux, Windows
- Technology specific experience
- Experience in predictive tools such as R, Python, SAS, SPSS, etc. is desirable
2
Skills For System ETL Architect / Analyst Resume
- Pioneering - High level of initiative/innovation
- Understanding of Big data ecosystem and big data technologies such as Hadoop, Spark, Storm, Flume etc
- Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading
- Well versed with database administration tasks and working with DBAs to monitor and resolve SQL / ETL issues and performance tuning
- Develop solution in highly demanding environment and provide hands on guidance to other team members
3
Skills For Data Stage ETL Architect Principal Resume
- Flexible and adaptable working style to work with multiple stakeholders
- Develops and monitors initiatives that integrate learning with practical opportunities
- Data Modeling (ER / Dimensional),
- Data Quality Management Version Control and Scheduling,
- Technical /Functional Analysis, Requirements Gathering Hadoop Technologies, OLAP Technologies
- The ETL architect is required to be part of requirement gathering sessions and create ETL requirements and design
- A>I GDE and other A>I products like MHUB, Express IT, Control Center, Query IT
- Administer and manage Informatica environments
- Strong oral written and interpersonal skills for interacting and throughout all levels of the organization; ability to clearly communicate complex business problems and technical solutions
4
Skills For Enterprise Data / ETL Architect Resume
- Provide expertise and continuity across both the business solution and technical solution involving Ab Initio Builds effective relationships with all stakeholders including federated project teams, BU SPOC, GIS etc
- Develops, administers and recommends billable hours and resource estimates on complex initiatives, projects, and issues
- Explain business purposes of the ETL architecture to executive audiences through presentations
- Contributes to and encourages ideas and builds on the suggestions of others
- Able to communicate a vision and strategy of own role
- CRM (Salesforce, Microsoft Dynamics) Domain Knowledge
5
Skills For SAP ETL Architect Resume
- 401(k) Savings Plan?Matched 150% up to 6%
- Data Acquisition (ETL) technologies
- RDBMS Technologies
- Data Stage (IBM Information Server 8.x)
- Quality Stage, Information Analyzer (IBM Information Server 8.x)
6
Skills For Big Data & ETL Architect Resume
- Data Stage, Quality Stage (IBM Information Server 11.x)
- Erwin Modeler v9.x or above, IGC (IBM Information Server 11.x)
- IBM DB2 v9.x or above
- VN, GitHub, Control M / JCL Information Analyzer (IBM Information Server 11.x)
- Team management (up to 3 members)
7
Skills For Big Data ETL Architect Resume
- Multi team Co-ordination
- Agile Methodologies
- System Support in rotation
- The primary role of the ETL architect would be to lead and guide development of Datastage based ETL architecture
- Using agile techniques, develop full SDLC project plans to implement ETL solution and identify resource requirements. Identify, recommend and implement ETL process and architecture improvements
- Provide assistance to development team in order to resolve difficult design and development issues
8
Skills For ETL Architect Resume
- In ETL development
- Reviews & Sign-Off technical output of developers
- Experience in the role of ETL/Integration architect and knowledge of establishing Big Data ETL/ELT standards on Hadoop (Hortonworks) and platforms such as Exadata, Netezza or Terradata
- Senior ETL architect, admin and developer with good experience in Design and Development of data integration components in Informatica
- Experience with performance tuning and optimization with the Relational Databases and Hadoop stack
9
Skills For Data Warehousing Lead ETL Architect Resume
- Experience with database technologies including Exadata, Oracle, Terradata, Netezza, MySQL, SQL Server, Postgres
- Builds effective relationships with all stakeholders including federated project teams, BU SPOC, GIS etc
- Experience with the Hadoop stack (e.g. MapReduce, Spark, Sqoop, Pig, Hive, HBase, Kafka)
- Related experience in big data architecture with knowledge of Data Lake ingestion tools
- Experience with related/complementary open source software platforms and languages (e.g. Java, Apache, R/Python/Scala)
10
Skills For System ETL Architect / Analyst Resume
- Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and ongoing sustainment
- Provide expertise and continuity across both the business solution and technical solution involving Ab Initio
- Performance tuning and enhancement of data loads, SQL and ETL processes and prepare related technical documentation
- Provide data governance practices in data administration, data integration, and data modeling
- Strong architecture skills in Data and Integration domains which includes deep understanding of partitioning, clustering, indexing and optimization in both Distributed and MPP architectures.I
- Troubleshooting and development in other Ab Initio products like Continuous Flow, Express It, Query It, Metadata Hub, Control Center etc
- Troubleshooting related SQL and NOSQL databases like Teradata, Oracle, MongoDB
- Complex hands-on work on Ab Initio GDE
- Understand concepts of Hadoop and tune A>I product accordingly
Related to ETL Architect Resume Samples
Automation Architect Resume Sample
Work Experience
• Work with line of business and automation PMO to identify and define technical requirements, design, develop, test, and implement new automated solutions
• In cooperation with the existing team of architects; design and build innovative automated solutions that optimize the way we work and deliver ...
Professional Skills
• Effective communication (oral and written)...
• Excellent multi-tasking skill with experie...
• Excellent quality and release management s...
Client Architect Resume Sample
Work Experience
• Responsible for the development and implementation of the standard client hardware architecture roadmap
• Researches, identifies, develops, and manages Client Services application toolsets
• Participates in the design, packaging, and deployment of client images and applicatio...
Professional Skills
• Experience in designing solutions for your...
• Possess strong communications skills
• Exceptional professionalism and customer s...
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...
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...