Etl Architect Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

ETL Architects, or Data Architects, develop, analyze, and administer data for businesses, schools, and other organizations. Example resumes for this position showcase such skills as understanding requirements and coordinating with clients to get their projects approved, and coordinating with the testing team for driving system testing, regression testing, and parallel testing. ETL Architects typically hold a bachelor's degree in Information Technology and can show years of experience in the IT field on their resumes, along with optional certifications.

Find out what is the best resume for you in our Ultimate Resume Format Guide.

1

Senior ETL Architect

Restatement Project: Undertaken to restate company's earnings, this $1 Billion project employed over 2000 workers.

  • Spearheaded the automation of restatement operations which was instrumental in completing restatement within a short period of 7 months against projections of 3 years.
  • Managed a team of 18 AbInitio developers, Autosys schedulers and Business Analysts. Created BOXI/WEBI reports for senior management.
  • Played a leading role in the setup of the Restatement Operations Center.
Candidate Info
16
years in
workforce
7
months
at this job
BA
Economics
BS
Electrical Engineering
MS
Engineering And Policy
2

ETL Architect/etl Lead

Deployed a robust business intelligence solution that increased the ability to monitor Meter to Bill process on a daily basis and provided the ability to reconcile source system Meter Determinants

  • Designed and implemented generic Visio Mapping template that facilitated automatic generation of Informatica ETL mappings which reduced significant time and effort.
  • Lead development initiative to adhere Informatica best practices and standards outlined in Informatica's Velocity Methodology.
  • Worked extensively on Informatica partitioning when dealing with large volumes of Meter Reads data and also partitioned the tables in Oracle for optimal performance.
  • Led a group of technical on-shore and off-shore developers and support team.
  • Managed software design and technical architecture of large complex system, using project management and planning skills to minimize development time and maximize client acceptance.
Candidate Info
17
years in
workforce
10
months
at this job
MS
Computer Science
Be
3

ETL Architect - Risk Management/compliance

The scope of this project is the remediation of the pre-Helix OFAC/OSFI (Office of Foreign Asset Control/Office of the Superintendent of Financial Institutions) system process. This process resides in the CSA as of January of 2006. This system is designed to source personal data about customers to a downstream process that is designed to compare our entire customer base to a list provided by an external source.

  • Led a team of Onsite and Offshore Designers, as of the new Data Movement architecture.
  • Designed and mentored multiple custom and generic processes, which were used by many other applications outside the platform.
  • Led a team in Developing new and modifying existing UNIX shell scripts to automate routine tasks as of the new ETL architecture directions.
  • Ensured data is clean, consistent and synchronized across source platforms.
Candidate Info
4
years in
workforce
1
year
at this job
BA
Computer Applications
MA
Enterprise Business Management
4

ETL Architect

  • Designed and developed Informatica objects to support the company's needs, this includes Unit testing and QA
  • Upgraded from Informatica 7.x to 8.1, then to 8.5
  • Analyzed and implemented different projects for different clients. Started by gathering the requirements, writing the design documents and conducting all required development, including the UNIT testing and QA
  • Supported development, production and business groups by providing technical tips
  • Identified some bottlenecks with the mapping and improve the performance by using Pushdown optimization.
Candidate Info
11
years in
workforce
9
months
at this job
BS
Computer Engineering
MS
Computer Science
5

ETL Architect

Application developed to forecast the demand for various products. The system captures data along the way. It looks at 20 different parameters and estimates the demand for the product, calculates projected and targeted days of supply and host of other numbers that helps the company to schedule manufacturing, stocking and release of products at various locations around the country.

  • Analyzed and documented the requirements.
  • Participated in Data Model design.
  • Wrote detailed technical design
  • Planned and managed the tool development
  • Participated in the User Acceptance Testing and tool release
Candidate Info
34
years in
workforce
3
months
at this job
6

ETL Architect/ ETL Lead

Architected new ETL solution for [company name] EDW using Windows, Sql Server and IBM Information Server(Datastage 8.1)

  • Developed, Tested, Implemented and Supported SSIS/DataStage jobs as part of Data Warehouse Migration Project.
  • Designed and developed star schema solution for [company name] Financial reporting.
  • Documented ETL Designs, ETL Standards and Source to Target mapping.
  • Supported Database migration project.
  • Supported Admin tasks like DataStage Installation, Configuration and ETL Tuning on Windows
  • Supported day to day DataStage admin tasks like lock management, User Management, Database configurations and User defined Parameters.
Candidate Info
20
years in
workforce
6
months
at this job
BS
Electronics And Communications Engineering
MS
Electrical And Computer Engineering
MS
Computer Engineering
7

Sr.sql Server/etl Architect

Actively involved as part of a team for gathering and analyzing needs of end user requirements to build BI architecture.

  • Actively responsible for leading warehouse development team.
  • Working with SSIS to load data files to SQL Server and the other way. Maintaining data, database backups, backup strategies, scheduling backups.
  • Designed database models including creation of tables, referential integrity, keys and constraints.
  • Scheduled jobs weekly/monthly basis to import data from various data sources like Netezza, Oracle, excel & delimited files.
  • Managed multiple projects to ensure data load dependencies used by different business users.
  • SDLC cycle was completed on time for almost all projects to meet deadlines with team effort.
Candidate Info
10
years in
workforce
3
years
at this job
MA
Computer Science
8

Ab Initio Systems Administrator/technical Lead/etl Architect

Responsible for the design, and administration of the Ab Initio infrastructure within Marketing Services

  • Assisted in the creation of enterprise ETL development standards and best practices
  • Designed and created several common utilities used to integrate ETL services with external systems
  • Architected and delivered several ETL batch applications centered on application modernization
  • Mentored client team members in the design and development of several batch applications
Candidate Info
7
years in
workforce
2
years
at this job
BS
Computer Engineering
9

Microstrategy Architect and ETL Architect

Defined the process between [company name] IMD and Cognizant in terms of roles & responsibilities, deliverables and SLA.

  • Analyzed the [company name] business, BA team requirements and communicating offshore team effectively.
  • Designed and developed ETL mappings, high level design document, Source to Target Mapping document and test cases.
  • Designed and developed MicroStrategy projects by creating attributes, facts, hierarchies, metrics, prompts, filters, transformations, logical tables and canned reports.
  • Managed and reviewed offshore deliverables, prepared test cases, and logs and assisted the [company name] IMD business team for User Acceptance Testing and getting sign off for production.
Candidate Info
6
years in
workforce
10
months
at this job
BA
Computer Science
10

ETL Architect/manager (consultant)

Managed and oversaw the entire ETL solution for [company name]'s new Operational Data Store(ODS). This is about a three terabyte database and supports the on-line customer service application. There are over four hundred incoming source feeds. The load schedule is automated through Autosys.

  • Managed and oversaw the group of ETL Developers consisting of up to 25 on-shore developers.
  • Data Warehouse Architect responsible for overseeing the entire new Data Warehouse Model and ETL architecture which supports it. Implemented a dimensional model for the membership subject area.
  • Responsible for managing 15 DataStage ETL resources across multiple concurrent projects.
Candidate Info
20
years in
workforce
2
years
at this job
BS
Computer Science

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!