ETL Architect Resume Samples

An ETL Architect is hired to head and direct the pattern and transport of ETL and information and guide the development team. A well-drafted ETL Architect Resume mentions the following core roles and responsibilities – assisting the plan of actions, holding design classes with information proprietors; helping other members of the business intelligence team; coordinating with the end-users; making a credential method for reports; making the basic ETL architectural rules and regulations; owning the architectural production actions pertaining to ETL projects; and helping in enhancements of ETL requests forms.

Apart from having a bachelor’s degree in the field of computer science or related field, the person should have work experience in modeling and business systems designs. Software skills should be excellent, having a post-graduate education will be an asset for this post. In addition, the applicant should have observation skills and possess strong multitasking skills.

 

ETL Architect Resume example

ETL Architect Resume

Summary : 10+ years in the information technology field spanning multiple platforms and areas of focus Leadership experience in both waterfall and agile SDLC environments Understanding of both Kimball and Inmon data warehouse methodologies Possess excellent interpersonal, analytical, and organizational skills.

Skills : Information Technology, Information Architecture.

Description :

    1. Driven application T2 (Traction) for incident management and tracking actions raised against incidents.
    2. Captured in T2 application will be analyzed by S&OR analysts by retrieving data in reports.
    3. Responsible for data is presented to users in terms of the dashboard, standard reports, and Search & Save and Ad hoc reports.
    4. Built to feed data to the dashboard.
    5. Understood and analyzed the ETL requirements from the business.
    6. Developed the Datamart dimension model.
    7. Created ETL TDD (Technical design doc).
    8. Planned to configure, and deploy code in various environments.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor's


Sr. ETL Architect Resume

Summary : 7.5 years of IT experience including Data Warehouse Design, Analysis, Architecture, Dimension Modeling, Business Intelligence strategy, Development, Testing, Implementation, Training and Documentation. Strong Focus on Software Development Life Cycle (SDLC) with design, concept, architecture, planning, modeling, coding, development, testing , implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI.

Skills : Informatica, Oracle 10G, Sql Server, TIDAL, JIRA, ERWIN.

Description :

    1. Integrated Procurement Environment (IPE) Kroger is a retail giant in the USA.
    2. Responsible for various departments inside the organization for procuring various goods that would be sold.
    3. Used different formats for storing procurement related data.
    4. Dealt with this and integrated data cross all formats for a unified data format.
    5. Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
    6. Worked on data analysis to find the data duplication and existed data pattern using a data profiling tool, IDE.
    7. Generated few complex business-reports/graphs using IDQ, which was being used for understanding, acting and reporting.
    8. Extensively worked on column profiling, scorecard and address validators.
    9. Responsible for Business Analysis and Requirements Collection.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
B. Tech.


Jr. ETL Architect Resume

Objective : 8 Years and 11 months Experience of development & maintenance in the IT industry including Banking and Health Care Industry. Having experience in offshore coordination, requirement gathering, analysis, design, development, and implementation with strong skills in latest technologies, application servers, and databases. Possess excellent communication skills and a performance oriented team player with Good analytical, design skills, and problem solving abilities.

Skills : ETL, Oracle, Linux, Informatica.

Description :

    1. Completed one major development related to RBS within 4 months.
    2. Created and altered metadata, creating the Database design for new enhancement, creating and altering mappings, testing and deployment.
    3. Created and testing deployment scripts.
    4. Worked on RBS development, worked regularly on support calls to debug, change, test and implement complex pl/sql code.
    5. Automated the whole reconciliation process.
    6. Identified major issues in existing MIS system, like too many measures/metrics in a fact, wrong hierarchy in levels of Dimensions, too many unwanted layers of L's and T's in ETL, mismanaged and inconsistent surrogate keys in those layers of L's and T's.
    7. Created the business case for the new MIS2 project.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Certification

ETL Architect I Resume

Objective : Accomplished ETL Architect Professional with over 15 plus years' experience in leading large complex programs, matrix manage cross-functional resources, driving process efficiency, implementing systems and key initiatives. Defining and implementing strategy for enterprise level data integration architecture, business intelligence, enterprise reference data, and data quality solutions across all divisions.

Skills : Management, Organizing.

Description :

    1. Worked with Enterprise Architecture Team to find the gaps in Actimize system from approach that meet overall enterprise architecture requirements.
    2. Led and mentored the efforts of data quality completeness initiative for Informatica based ETL architecture.
    3. Performed deep assessment of the Actimize system in order to find whether ETL best practices were followed or not and submitted the recommendations of improvement.
    4. Designed architecture solutions for Hornet Data warehouse requirements to develop ETL solution.
    5. Initiated Design of ETL architecture solution from already existing ETL processes which are required to be analyzed as a part of the quality assessments.
    6. Evaluated current data warehouse/ETL environment for usage in spend analytics solution deployment and provide gap assessment.
    7. Responsible for ETL Database into Physical Data Models using ER/ Studio Tool.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Master's

ETL Architect II Resume

Objective : Having 15+ years of experience in IT industry in which 13 years of experience in Data warehousing environment. Strong knowledge in Data Warehouse concepts, ETL, OLAP,MOLAP, Business Process Analysis,Dimensional Data Modelling. Experience in ETL development using Informatica Power Centre [] and developed Informatica mappings.

Skills : Oracle Forms, Business Objects, Oracle PL/SQL, Informatica,.

Description :

    1. Helped Avago business users in multiple ways to analyze the business critical scenarios.
    2. Enabled out of box OBIA Finance and SCOM (supply chain and Order Management) reports To accommodate the growing number of business users and their analytics requirements, Wipro has decided to send a key profile with Techno-Business background from India.
    3. Experienced in Informatica-OBIEE and required business function knowledge, an employee can help to accelerate the project requirement gathering and analysis and to deliver the project on time.
    4. Implemented OPLA(Project Life Cycle Analytics) package for Product life cycle management user.
    5. Developed customized report based on OPLA package Responsibility.
    6. Worked as ETL architect and Data warehousing architect in this project 2.
    7. Worked with business user to define requirements.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor's

ETL Architect III Resume

Summary : Over 14 years of IT experience with emphasis on Data Warehousing, Business Intelligence, Migration, Data Integration and Big Data Solutions. 3 years of experience in Hadoop Ecosystem providing and implementing solutions for Big Data Applications with excellent knowledge of Hadoop architecture, various components and MapReduce programming paradigm.

Skills : Management, Organizing.

Description :

    1. Helps financial services firms mitigate reputational, internal and regulatory risks.
    2. Responsible for the data to this application is fed from clearing firms like NFS, DTCC and Pershing after transforming the data using ETL.
    3. Consolidates the different clearing firms and build a Broker-Dealer Warehouse (BDW) and data marts.
    4. Sanitizes the data in non-prod environments using prod data for all the application testing in non-prod environments.
    5. Responsible for architectural design of ETLs, different ETL load patterns and complex mappings to load the data.
    6. Develops solution in highly demanding environment and provide hands-on guidance to other team members.
    7. Designs, develops, and implements interactive visualizations by processing and analyzing large datasets.
    8. Designs and builds new data aggregations for ongoing data analysis and statistical modeling.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Asst. ETL Architect Resume

Objective : Nine years of experience in analysis, design, development and implementation of database and ETL solutions. Expertise in enterprise data warehousing, data integration tools such as Informatica, relational databases such as Oracle, Sybase, SQL server and MPP systems such as Greenplum. Proficient in performance tuning using Informatica session partitions, cache management, DB indexes, SQL query optimization using hints.

Skills : Associate, Management.

Description :

    1. Worked with the business analysts to understand the functional requirements and transformed them into high level technical requirements and performed feasibility analysis.
    2. Provided solutions to the architectural problems with the data integration into the system and provided guidance on the data model adjustments and enhancements.
    3. Involved in analysis, design and development of the database and ETL solutions.
    4. Developed technical specifications that included Flow Diagrams and Process flows.
    5. Documented the requirement changes and technical design changes as required and discussed with management on the proposed changes.
    6. Worked on performance optimization to reduce the time taken for loading.
    7. Handled 5 member team for sap-Edw integration project and 3 member team for price catalog project.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Masters

Associate ETL Architect Resume

Headline : ETL Architect provide subject matter expertise on data architecture, that includes designing, creating, deploying and managing analytics data architecture that aligns with direction, best practices, and standards defined.

Skills : Management, Organizing.

Description :

  • Analyzes, assesses, documents and designs scalable and sustainable data architecture and data transformation processes within a large analytics pipeline

  • Works with stakeholders to understand the limitations and constraints of current data architecture (models, transformations, pipelines).

  • Designs, develops and maintains analytics data model

  • Develops subject matter expertise in both the data and the process/analytic domains

  • Oversees or reviews the implementation of improvements to the data architecture, providing feedback and guidance to product developers, data scientists, and product owners.

  • Facilitates design discussions and assist with decision making & guidance during development.

  • Responsible for overall etl design and implementation - define and maintain environments, coding standards and migrations, data movement strategies from source through the data warehouse.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Lead ETL Architect Resume

Objective : 10 years of IT experience in Data Warehousing implementing Enterprise Data Warehouse (EDW), Data mart and other end to end Business Intelligence Solutions using Informatica Power Center 8.x/9.x, Informatica Cloud and SAP Business Objects 3.x 5.5 years of experience as an ETL and Data Modeling expert working at multiple client sites in the United States.

Skills : Management, Organizing.

Description :

    1. Created Dts packages to load large cubes and create incremental laod jobs.
    2. Automation of error reporting and building of validation systems.
    3. sp Optimization and code review AAAE (American Association of Airport Executives), Washington, DC ETL Architect AAAE: AAAE is the Association for all airports of US and IAEE is the association of all Airports of the world.
    4. The AMIS application takes care of the reporting needs of AAAE.
    5. AMIS takes data from transactional systems and reports on membership data across different dimensions like Airports, regions, Managers, time and also membership type.
    6. Developed the DTS jobs which took data from the different systems like the Solomon transactional system, the billing system and the membership system and created the staging dimension and fact tables.
    7. Besides the development responsibilities I also handled the responsibilities for providing production support to the AMIS application, maintaining security for the AMIS production server and also configuring and maintaining database maintenance plans.
    8. Re-indexing databases and running DBCC checks.
    9. Defined and developed a database backup and restore plan, a disaster recovery plan.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Engineering

ETL Architect Resume

Objective : Extensive experience in Business Intelligence - Data Warehousing Technology (Mostly in Healthcare, Finance and Industrial services). Key areas of expertise include Solution design, Data Architect, ETL Architect, Data Integration, Data Modeling, and Master Data Management. EDW Architect with extensive experience in designing and developing data warehouse, ETL applications strategy and technology solution to support cross-boundary data integration in the Enterprise Data Warehouse (EDW) environment.

Skills : Management, Organizing.

Description :

  • Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing and analyzing large sets of data across different domains for analysis.
  • Uses different Data warehousing concepts to build a Data warehouse for internal departments of the organization.
  • Designs and develops data pipelines, data ingestion and ETL processes that are scalable, repeatable and secure for stakeholder needs.
  • Builds Data architecture to support data management strategies to support business intelligence efforts for various stakeholders.
  • Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
  • Supports deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution Data Pipeline Management.
  • Develops real-time and batch ETL data processes aligned with business needs, manages and augments data pipeline from raw OLTP databases to data solution structures.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Engineering