Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Become An ETL Architect

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.

Working As An ETL Architect

  • Interacting With Computers
  • Thinking Creatively
  • Making Decisions and Solving Problems
  • Getting Information
  • Analyzing Data or Information
  • Mostly Sitting

  • $120,425

    Average Salary

What Does An ETL Architect Do At PSAV

* Lay a pattern and sets standards for Dimensional Data warehouse and SSIS ETL design and development.
* Define and execute business intelligence projects.
* Build quality "back-end" solutions that prepare for growth in both data volume and concurrent usage.
* Design & develop the Data Integration framework.
* Ensure code-reuse and maintainability.
* Ensure dimensions are conformed across all data marts when appropriate.
* Perform exploratory source data analysis, including ad-hoc SQL queries, to proactively find and expose data quality problems or data that violate assumptions and business rules, and may cause unexpected output in the developed solution.
* Effectively leverage automated data profiling tools when available.
* Create documented designs and unit test plans.
* Develop dashboards, scorecards, and reports using Microsoft Tech Stack, BI Visualization tools, services, and Excel.
* Recommend tools, and keeps current on capabilities of new product releases.
* Serve as expert on analysis tools capabilities, trains power-users in the organization on capabilities of the analysis tools and dimensional data warehouse.
* Work closely with the PSAV Data Warehouse Customers, Business Analysts, and Application Architects/Developers to gather and document requirements to support the data analysis needs of the organization.
* Scrutinize functional requirements, specifications and source to target mapping documents, identifying underspecified requirements and other design challenges.
* Effectively communicates the dimension models, process/data flow, KPI driven dimensional model design, and data warehouse concepts to the customers.
* Use any available resources to understand PSAVs business processes and application capabilities.
* Recommend operational systems enhancements to improve data quality and provide additional analytic capabilities.
* Troubleshoot and resolve performance, security, and data quality issues affecting analysis solutions.
* Plan and size infrastructure needs for new projects.
* Send resume to: Sherry Schaetzlein, PSAV, 5100 N.
* River Road, Suite 300, Schiller Park, IL 60176.
* Required Experience

What Does An ETL Architect Do At Nuvasive, Inc.

* Gather requirements, Analyze, Design, Develop and enhance ETL solutions – may involve BI reports, models and Cubes as needed for development / troubleshooting
* Provide production support related to ETL schedules, tasks and work with other BI/ IT team members and service desk to resolve data refresh issues –
* Work with onshore/ offshore resources for development/ support efforts
* Have the ability to work with users, BI and ERP teams to get ETL solutions developed and implemented
* Performance tuning and enhancement of data loads, SQL and ETL processes and prepare related technical documentation
* Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data
* Provide data governance practices in data administration, data integration, and data modeling
* Communicate very clearly and professionally with users, peers, and all levels of management.
* The communication forms include written and verbal methods
* Adhere to the processes and work policies defined by management
* Participate in ad-hoc BI/ DW projects as required
* Basic Qualifications

What Does An ETL Architect Do At Hire It People, LLC

At least 8+ years of experience in BI technologies and BI project development life cycle

Show More

Show Less

How To Become An ETL Architect

Software developers usually have a bachelor’s degree in computer science and strong computer programming skills.

Education

Software developers usually have a bachelor’s degree, typically in computer science, software engineering, or a related field. A degree in mathematics is also acceptable. Computer science degree programs are the most common, because they tend to cover a broad range of topics. Students should focus on classes related to building software in order to better prepare themselves for work in the occupation. For some positions, employers may prefer a master’s degree.

Although writing code is not their first priority, developers must have a strong background in computer programming. They usually gain this experience in school. Throughout their career, developers must keep up to date on new tools and computer languages.

Software developers also need skills related to the industry in which they work. Developers working in a bank, for example, should have knowledge of finance so that they can understand a bank’s computing needs.

Other Experience

Many students gain experience in software development by completing an internship at a software company while in college.

Some software developers first work as computer programmers and then are given more responsibility as they gain experience. Eventually, they become developers.

Advancement

Software developers can advance to become information technology (IT) project managers, also called computer and information systems managers, a position in which they oversee the software development process.

Important Qualities

Analytical skills. Developers must analyze users’ needs and then design software to meet those needs.

Communication skills. Developers must be able to give clear instructions to others working on a project. They must also explain to their customers how the software works and answer any questions that arise.

Computer skills. Developers must understand computer capabilities and programming languages in order to design effective software.

Creativity. Developers are the creative minds behind new computer software.

Detail oriented. Developers often work on many parts of an application or system at the same time and must therefore be able to concentrate and pay attention to detail.

Interpersonal skills. Software developers must be able to work well with others who contribute to designing, developing, and programming successful software.

Problem-solving skills. Because developers are in charge of software from beginning to end, they must be able to solve problems that arise throughout the design process.

Show More

Show Less

ETL Architect jobs

Add To My Jobs

ETL Architect Career Paths

ETL Architect
Data Warehouse Architect Solutions Architect Program Manager
Chief Information Officer
11 Yearsyrs
Data Warehouse Architect Business Intelligence Architect Solutions Architect
Chief Technology Officer
11 Yearsyrs
Integration Architect Senior Consultant Solutions Architect
Customer Relationship Management Manager
8 Yearsyrs
BI Architect Data Architect Enterprise Architect
Director Of Enterprise Architecture
14 Yearsyrs
Solutions Architect Program Manager Senior Manager
Director Of Information
10 Yearsyrs
Project Manager Information Technology Project Manager Director Of Information
Director, Applications
13 Yearsyrs
Architect Project Manager Information Technology Project Manager
Information Technology Director
10 Yearsyrs
Solutions Architect Senior Project Manager Program Management Consultant
Program Manager
8 Yearsyrs
Technology Architect Architect Senior Project Manager
Senior Delivery Manager
11 Yearsyrs
Data Engineer Senior Network Engineer Director Of Information
Senior Director Of Information & Technology
13 Yearsyrs
Project Manager Consultant Senior Software Engineer
Senior ETL Developer
5 Yearsyrs
BI Architect Lead Architect Technical Manager
Senior Information Technology Manager
10 Yearsyrs
Data Engineer Senior Software Engineer
Senior Java Developer
6 Yearsyrs
Data Architect Architect Project Manager
Senior Project Manager
12 Yearsyrs
Architect Senior Project Manager Contractor/Consultant
Senior Software Engineer
6 Yearsyrs
Data Architect Solutions Architect Senior Project Manager
Senior Technical Program Manager
12 Yearsyrs
Senior Data Architect Senior Database Administrator Information Technology Manager
Vice President Of Information Technology
12 Yearsyrs
Technology Architect Project Manager Senior Project Manager
Vice President, Technology
11 Yearsyrs
Show More

ETL Architect Demographics

Gender

  • Male

    77.8%
  • Female

    17.3%
  • Unknown

    4.9%

Ethnicity

  • White

    44.7%
  • Asian

    38.9%
  • Unknown

    7.6%
  • Hispanic or Latino

    7.2%
  • Black or African American

    1.6%
Show More

Languages Spoken

  • Swedish

    10.0%
  • Danish

    10.0%
  • German

    10.0%
  • Cantonese

    10.0%
  • French

    10.0%
  • Norwegian

    10.0%
  • Hindi

    10.0%
  • Spanish

    10.0%
  • Mandarin

    10.0%
  • Tamil

    10.0%
Show More

ETL Architect

Unfortunately we don’t have enough data for this section.

ETL Architect Education

ETL Architect

Unfortunately we don’t have enough data for this section.

Job type you want
Full Time
Part Time
Internship
Temporary

Real ETL Architect Salaries

Job Title Company Location Start Date Salary
Ab-Initio ETL Architect Lead Jpmorgan Chase &Amp; Co. Columbus, OH Sep 20, 2014 $160,000
ETL Architect Xtime Inc. Redwood City, CA Apr 09, 2016 $159,120
ETL Clarity Architect Stanford Hospital & Clinics Palo Alto, CA Jun 20, 2016 $149,365 -
$176,072
ETL Clarity Architect Stanford Hospital & Clinics Palo Alto, CA Sep 22, 2015 $149,365 -
$176,072
SR. ETL Informatica Architect (Multiple Positions) Partners Information Technology, Inc. Laguna Hills, CA Aug 17, 2016 $148,735
SR ETL Informatica Architect Partners Information Technology Inc. Torrance, CA Nov 14, 2016 $148,000
SR ETL Informatica Architect Partners Information Technology Inc. Torrance, CA Aug 21, 2016 $148,000
Informatica ETL Architect Diversant LLC Jersey City, NJ Sep 14, 2015 $135,000 -
$145,000
ETL Architect Companion Professional Services, LLC Washington, DC Aug 02, 2016 $129,394
ETL Architect Uptake Technologies LLC Chicago, IL Mar 15, 2015 $125,000
ETL Architect Evolvescape, Inc. New York, NY May 05, 2014 $122,179
ETL Architect Software Paradigms International Group, LLC Atlanta, GA May 12, 2014 $120,000 -
$140,000
Dw/Etl Architect III, SR. Arrow Electronics Englewood, CO Jul 28, 2016 $120,000
ETL Architect (Multiple Openings) NTT Data, Inc. Plano, TX Nov 01, 2016 $110,406
ETL Architect (Multiple Openings) NTT Data, Inc. Plano, TX Jan 19, 2016 $110,406
ETL Architect NTT Data, Inc. Plano, TX Feb 05, 2016 $110,406
ETL Architect (Multiple Openings) NTT Data, Inc. Plano, TX Apr 28, 2016 $110,406
ETL Architect (Multiple Openings) NTT Data, Inc. Plano, TX Apr 26, 2016 $110,406
ETL Architect (Multiple Openings) NTT Data, Inc. Plano, TX Apr 25, 2016 $110,406
ETL Architect (Multiple Openings) NTT Data, Inc. Plano, TX Dec 20, 2016 $98,883
ETL Architect, IAR NA Stanley Black & Decker, Inc. Westerville, OH Jan 26, 2015 $97,850
ETL Architect Healthnow New York Inc. Buffalo, NY Aug 06, 2014 $96,346 -
$120,000
ETL Architect Xtime Inc. Redwood City, CA Dec 11, 2015 $94,162
SR. ETL Architect Asher Technologies, LLC Austin, TX Oct 15, 2015 $93,000
ETL Architect Mindtree Limited Jersey City, NJ Feb 14, 2013 $92,206 -
$122,206
Bidw-Etl Architect Savin Technologies Irving, TX Mar 06, 2015 $91,200 -
$101,000
ETL Architect Asap Solutions Group Columbus, OH Jan 11, 2013 $90,200

No Results

To get more results, try adjusting your search by changing your filters.

Show More

Top Skills for An ETL Architect

InformaticaPowercenterMicrosoftSQLServerDataWarehouseUnixArchitectureSourceSystemsPhysicalDataModelDataFlowProceduresPl/SqlBusinessRequirementsWindowsServerDatastageETLDesignDocumentsTeradataDB2BIFinancialEDWFactTables

Show More

Top ETL Architect Skills

  1. Informatica Powercenter
  2. Microsoft SQL Server
  3. Data Warehouse
You can check out examples of real life uses of top skills on resumes here:
  • Conducted a presentation demonstrating the best practices of Oracle data warehousing and Informatica PowerCenter.
  • Prepared some reusable components for Data Validation and Referential Integrity checks for each module using Microsoft SQL Server Database Stored Procedures.
  • Identified and documented data sources and transformation rules required to populate and maintain data warehouse.
  • Designed and developed several SQL/Unix scripts to support the Day0, Daily and Monthly and Yearly processes.
  • Designed the whole ETL Architecture for Client, which has been accepted and used in other project for client.

Top ETL Architect Employers