ETL Architect Resume Samples

4.5 (111 votes) for ETL Architect Resume Samples

The Guide To Resume Tailoring

Guide the recruiter to the conclusion that you are the best candidate for the etl architect job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.

Craft your perfect resume by picking job responsibilities written by professional recruiters

Pick from the thousands of curated job responsibilities used by the leading companies

Tailor your resume & cover letter with wording that best fits for each job you apply

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

Resume Builder
CHOOSE THE BEST TEMPLATE - Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS - Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES - Instantly download in PDF format or share a custom link.

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

Create a Resume in Minutes
CK
C Koch
Celia
Koch
719 April Haven
Boston
MA
+1 (555) 467 1185
719 April Haven
Boston
MA
Phone
p +1 (555) 467 1185
Experience Experience
Houston, TX
ETL Architect
Houston, TX
Metz, Fisher and Herman
Houston, TX
ETL Architect
  • Responsible for designing, modifying, testing & implementing data warehouse and all related ETL functions
  • Efficiently handled the Granularity, Indexing and Partitioning of underlying data storage platform
  • Develop procedures for data management. Creates procedures for developing and maintaining metadata and data mapping documents
  • Assist in maintaining all data sources and data storage options Record time accurately in the time keeping system
  • Determines the optimal approach for obtaining data from diverse source system platforms and moving it to the data analytics environment
  • Mentoring and training IT personnel on the Informatica platform
  • Perform problem assessment, resolution and documentation in existing ETL, mapping and workflows as assigned
Phoenix, AZ
Big Data & ETL Architect
Phoenix, AZ
Kub Inc
Phoenix, AZ
Big Data & ETL Architect
  • Build and foster a high performance engineering culture, mentor team members and provide your team with the tools and motivation to make things happen
  • Work with the business stakeholders and other programmers and analysts to develop a solution or enhance existing solution
  • Be an “Order Shaper”, partnering with our Enterprise Architects & recommend Platform improvements & work proactively to remove technical debt
  • Assess new tools and software, perform POCs, and offer recommendations to improve our enterprise landscape
  • Effectively deliver presentations to key customers and senior management
  • Own and manage technical debt and security vulnerabilities
  • Build collaborative partnerships with software architects, technical leads and key individuals within other functional organizations
present
Detroit, MI
Data Stage ETL Architect Principal
Detroit, MI
Hegmann, Hegmann and Von
present
Detroit, MI
Data Stage ETL Architect Principal
present
  • Work closely with development lead to finalize on estimated/actual project completion dates for process design, development, testing and implementation
  • Work with support team to handover ETL to perform UAT and production role
  • Develop process jobs as per design, prepare unit test cases, prepare test data and Perform unit testing
  • Work with BIS project manager to finalize on estimated/actual project completion dates
  • Perform final code review before moving to SIT environment and fix issue in warranty Phase
  • Perform technical analysis and prepare recommended data acquisition design approach
  • Participate in a team environment for the design, development and implementation of data warehousing projects
Education Education
Bachelor’s Degree in Related Field
Bachelor’s Degree in Related Field
University of Tennessee
Bachelor’s Degree in Related Field
Skills Skills
  • Good knowledge of Oracle (10g and later)
  • Gains support for change by providing context and responding with sensitivity to concerns; takes initiative to recommend/ develop innovative approaches to getting things done
  • Demonstrates excellent communication and interpersonal skills; able to communicate clearly and concisely in a variety of settings and styles; is effective in a variety of formal presentation and meeting settings
  • Looks toward the broadest possible view of an issue/ challenge; can easily pose future scenarios; can think globally about all aspects of the Bank; can discuss multiple considerations of an issue and forecast them into the future; understands how the Bank works, competes, serves clients, and generates shareholder value
  • Focus on development/ improvement of framework to support repeatable and scalable solutions
  • Understanding of traditional and alternative asset class investment data, including but not limited to equity, fixed income, private equity, real estate, derivatives, mutual funds, ETFs, global assets, foreign exchange, etc
  • Capital Markets/Investment Management knowledge and experience is highly desired
  • Experience and knowledge of optimizing database performance and capacity utilization to provide high availability and redundancy
  • Adapts style to contribute and enhance overall team performance and works effectively with people across a wide range of disciplines and levels (both internal and external/3rd party suppliers)
  • Ability to independently problem solve - Ability to be flexible and play multiple roles
Create a Resume in Minutes

8 ETL Architect resume templates

1

ETL Architect Resume Examples & Samples

  • Good knowledge of Oracle (10g and later)
  • Strong background in PL/SQL
  • Strong background in Data Warehouse architectures
  • Experience with Hyperion
  • Other reporting technologies would be an advantage
2

ETL Architect Resume Examples & Samples

  • Analyze reporting requirements to determine development methods, development templates, and to determine job scheduling
  • Build the enterprise data warehouse using complex transformations that come from many of Georgia Tech systems
  • Develop ETL jobs that satisfy identified data model
  • Provide guidance in the administration of the DataStage ETL tool including developing best practices of development, administering security, developing job scheduling and monitoring techniques, and all other system responsibility including creating, configuring and applying patch, creating projects, credential mapping, creating users, changing passwords, start stop applications activities, etc
  • Work with other development units in developing best practices in ETL development for Georgia Tech. Support ETL developers in development and troubleshooting data issues
  • Monitor nightly loads and troubleshoot any issues that arise
  • Maintain technical support documentation
  • Perform other related duties as assigned
  • Education:Bachelor’s degree in related field, or equivalent combination of experience and education
  • Work Experience:Six to eight years job related experience. At least six years in ETL development on any tool and at least four years in IBM DataStage ETL tool. These may overlap for a total of six years’ work experience
  • Certifications: N/A
  • Technical Skills: Full life-cycle experience on large/complex enterprise projects; hands on experience in IBM DataStage ETL Design, Development & Build, and in administering the ETL tool; experience in project life cycle activities on DW/BI (Data warehouse and Business Intelligence) development and maintenance projects; experience in developing best practices and reviewing work of other ETL developers; understanding of Unix/Linux system, files systems, shell scripting; understanding of databases/ data marts/data warehouses and complex SQL and Oracle PL/SQL; experience with databases including Oracle (11gR2), Microsoft SQL Server, MySQL; proficiency with automated data modeling tools (ex. Erwin), Hyperion, Business Objects, Cognos, MS Excel, expertise in SQL, PL/SQL, Linux
  • Preferred Work Experience:Experience in a Higher Education environment
  • Preferred Skills:Skills preferred for this job include experience with PeopleSoft HCM and/or PeopleSoft Financials; experience with Banner
3

ETL Architect Resume Examples & Samples

  • Leverage thorough understanding of business and system processes to make recommendations and propose technical/non-technical solutions to meet business requirements
  • Performs an active and lead role in shaping and enhancing the overall ETL architecture and related technologies. Partner with leadership teams on the increasing scalability and robustness of the ETL platforms and solutions
  • Establish & enforce standards and design patterns within data integration tools & technologies, recommend opportunities for reuse of data where appropriate
  • Lead design and work efforts for ensuring security, administration, capacity planning and performance tuning of the ETL platforms. Ensure the ETL solution and platforms meet service level requirements
  • Perform design and development activities such as source to target mapping, job flows, code reviews, deliverables reviews, test planning etc
  • Conduct impact assessment and provide effort estimates based on business & technical requirements
  • Guide, coach and mentor development teams & specialists on ETL best practices, design patterns and decision rules
  • Collaborates with other IT staff to ensure the information management environment is operating at a high level of efficiency and provides a reliable resource for the user community
  • Research, evaluate, and recommend software packages for purchase and deployment
  • Develop and sustain multiple relationships across the organization, including external vendors to ensure successful project outcomes
  • Bachelor’s degree in appropriate field (Finance, MIS, Business Administration, Computer Science) or two year degree with equivalent experience
  • 10+ years of experience with leading and designing integration services for data warehouse, data marts and operational data store platforms which includes the following
  • 5+ years of architectural leadership experience delivering ETL solutions within a large enterprise environment
  • 5+ years of Informatica PowerCenter platforms and various components
  • 5+ years of experience working Oracle or SQL based RDBMS
  • 5+ years of experience using PL/SQL and query development tools like Toad, SQL Developer etc
  • Experience in code migration, database change management and data management through various stages of the development life cycle
  • Prior working knowledge of data stewardship, data quality and metadata management
  • Thrives in a dynamic work environment; delivers successfully, exhibits flexibility, and is recognized as being a strong team player
4

ETL Architect Resume Examples & Samples

  • 5+ years of experience in data transfer and Extract-Translate-Load (ETL)
  • 3+ years working with Informatica
  • Should have worked in a Regulated/Compliance industry; prefer Financial Services
  • Excellent skills in business and information modeling and development methodologies
  • Understands data & database technologies; structured and unstructured data sources
  • Development of scripts in Linux operating system
  • Requires knowledge with aspects of Databases; Data Warehousing; metadata concepts, master data technology and implementations; relational models, etc.; and business intelligence/OLAP concepts
  • Good organization, communication, and interpersonal skills
  • Informatica platform
  • Sybase
  • Oracle DBMS
5

ETL Architect Resume Examples & Samples

  • Broad experience in DW, Data Management, ETL and BI technical and leadership roles, including Cognos and Informatica technical architecture Specifically
  • Informatica tools and capabilities including: Powercenter, Metadata Management, Data Quality
  • Design and document business requirements in respect to Informatica data quality and Collaborate with team members
  • Document what metrics will be used to classify quality dimension of completeness, conformance, consistency, validity, uniqueness, and content
  • Efficiently handled the Granularity, Indexing and Partitioning of underlying data storage platform
  • Mapping experiences with SCD TYPES, Master, Transactional Subject areas and other dimensional models with respect to RDBMS based large Data Warehouses
  • Performed Data Profiling, Standardization, Identifying Anomalies, creating/applying rules and mappings/mapplets, Performed End-to-end Data Lineage using Metadata Manager
  • Great understanding of Informatica Power Center [ Should able to develop mapping and workflow
  • Identify Data Gaps and Quality issues plus recommending potential solutions
6

ETL Architect Resume Examples & Samples

  • 1-3 years Ab Initio experience
  • 1-3 years Control-M experience
  • 1-3 years Unix, SQL experience
7

ETL Architect Resume Examples & Samples

  • Education:Bachelors degree in related field, or equivalent combination of experience and education
  • Work Experience:Six to eight years job related experience. At least six years in ETL development on any tool and at least four years in IBM DataStage ETL tool. These may overlap for a total of six years work experience
  • Skills:TECHNICAL SKILLS: Full life-cycle experience on large/complex enterprise projects; hands on experience in IBM DataStage ETL Design, Development & Build, and in administering the ETL tool; experience in project life cycle activities on DW/BI (Data warehouse and Business Intelligence) development and maintenance projects; experience in developing best practices and reviewing work of other ETL developers; understanding of Unix/Linux system, files systems, shell scripting; understanding of databases/ data marts/data warehouses and complex SQL and Oracle PL/SQL; experience with databases including Oracle (11gR2), Microsoft SQL Server, MySQL; proficiency with automated data modeling tools (ex. Erwin), Hyperion, Business Objects, Cognos, MS Excel, expertise in SQL, PL/SQL, Linux. ADDITIONAL REQUIRED SKILLS: Strong written and verbal communication skills including the ability to express ideas concisely and clearly to both technical and non-technical audiences; good problem solving and analytical skills used to resolve technical problems; must possess a good understanding of business requirements and IT strategies; ability to work independently, but is also a team player; ability to lead a team of ETL developers
  • Preferred Education: N/A
  • Preferred Work Experience:Experience in a Higher Education environment; experience with PeopleSoft HCM and/or PeopleSoft Financials; experience with Banner
8

Big Data & ETL Architect Resume Examples & Samples

  • You understand what it takes to build and support highly scalable and reliable Big Data platform
  • You know how to empower platform teams and use of platform teams to drive standards
  • Build and foster a high performance engineering culture, mentor team members and provide your team with the tools and motivation to make things happen
  • Be an “Order Shaper”, partnering with our Enterprise Architects & recommend Platform improvements & work proactively to remove technical debt
  • Leads the analysis and design of quality technical solutions
  • Actively participate in code reviews of own code and that of peers. Test solutions and ensure it meets specifications. Present and validate solution
  • Assess new tools and software, perform POCs, and offer recommendations to improve our enterprise landscape
9

Big Data ETL Architect Resume Examples & Samples

  • At least 8 years of experience in Data Management projects, operational data stores and large scale implementations
  • At least 10-15 years of experience within a total information technology (IT) environment
  • Ability to translate complex functional and technical requirements into detailed design
  • Ability to communicate to both highly technical and non-technical stakeholders effectively
  • Great attention to detail and design with strong work prioritization, planning, and organizational skills
  • In-depth knowledge of the software development lifecycle (design, build, test, deploy, support)
  • System Design & development
  • At least 2+ Years on Big Data implementation project with strong understanding of underlying Hadoop concepts and distributed computing
  • Good aptitude in multi-threading and concurrency concepts
  • Hands on experience with major components like MapReduce, HBase, Hive, Pig
  • Data warehousing
  • Application design and architecture
  • Strong experience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMS and/or knowledge of NoSQL platforms
  • Leading performance tuning activities of the system
10

ETL Architect Resume Examples & Samples

  • Determines the optimal approach for obtaining data from diverse source system platforms and moving it to the data analytics environment
  • Assists and coaches ETL specialists during the course of their individual projects
  • Works closely with the Architecture team, Data Warehouse development team and Business representatives to analyze needs and develop architectural requirements to ensure client satisfaction with product
  • Assess current technical architecture
  • Estimate system capacity to meet near- and long-term processing requirements
  • Develop ETL technical architecture, including Data Quality, Metadata Management and Data Migration solutions using DataStage
  • Define and implement ETL development standards and procedures
  • Conduct impact assessment and determine size of effort based on requirements
  • 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
  • Ensure effective ETL functional decomposition into deliverable objects
  • Ensure ETL quality through inspections and knowledge sharing
  • Resolve difficult developments issues. Identify bugs and implement/recommend solutions when developers are not able to do so
  • Interface with DBA staff
  • Develop and manage the BI dependency plan, job scheduling and cycle management
  • Develop disaster recovery strategy
  • Determine and ensure execution of backup and recovery strategy
11

SAP ETL Architect Resume Examples & Samples

  • Minimum 7 years of experience of SAP Business Objects Data Services (version 4.2 and before) design, delivery and support with at least 2 full life cycle implementations
  • Excellent oral and written communication skills with business and technical audiences
  • Thorough knowledge of online and/or printed SAP reference sources such as the SAP Service Marketplace and SAP Developers Network
  • Bachelor’s degree in an IT or related field, with 4+ years of experience with SAP BODS Data service solution delivery required; familiarity with BW/BusinessObjects preferred
  • Awareness of the health care and consumer products industries is beneficial
  • Knowledge of agile delivery methodology a plus
  • Cross-functional data knowledge of SAP components such as: Finance and Controlling (FI/CO), Sales and Distribution (SD), Materials Management (MM), Production Planning (PP), Supply Chain Management (SCM, including APO, SNC) a plus
  • Knowledge of commercial data ETL solution delivery a plus
  • Experience with BODS performance tuning, real-time services, and BOBJ/BODS system administration, preferred
12

ETL Architect Resume Examples & Samples

  • 4Sight is looking for developers/architects with Pentaho experience. Property & Casualty Insurance experience is not required, but a big plus
  • Required to read, analyze and digest business requirements and design best ETL process(es) around those requirements
  • Responsible for designing, modifying, testing & implementing data warehouse and all related ETL functions
  • Required to document all designs (high level and detail) and ETL processes, including mapping documentation
  • Perform problem assessment, resolution and documentation in existing ETL, mapping and workflows as assigned
  • Assist in maintaining all data sources and data storage options Record time accurately in the time keeping system
  • Communicate with clients responsively and proactively when required
  • Communicate status and issues to management
  • Staying current on Pentaho and other ETL/Data Warehousing technologies Perform other duties/responsibilities as assigned
  • Required knowledge of Pentaho
  • Knowledge of any/all of these technologies preferred
  • SQL (MSSQL preferred) - Windows, Linux - Tomcat, HTML/JavaScript, XML
  • SOAP and REST based web services, SOA
  • AWS, Redshift
  • Sybase PowerDesigner
  • Ability to independently problem solve - Ability to be flexible and play multiple roles
  • Capable of multi-tasking and working multiple clients/projects/tasks
  • Knowledge of Insurance Industry is a huge plus!
  • Pentaho: 2 years
13

ETL Architect Resume Examples & Samples

  • Develop testing routines or procedures. Plans and conducts data warehouse and data repository system tests, monitor test results and takes required corrective action
  • Develop procedures for data management. Creates procedures for developing and maintaining metadata and data mapping documents
  • Develop performance metrics or standards related to information technology. Communicates effectively with business lines and various technology groups. Leads reviews of functional and non-functional requirements with development teams and business lines. Leads other data analysts
  • Test software performance. Plans and conducts data warehouse and data repository system tests, monitor test results and takes required corrective action
  • Design software applications. Collaborates with data architect to define relationships in the data within the system of record and within the data warehouse. Models the data conceptually and logically
  • Develop models of information or communications systems. Defines complex business rules concerning the process of the data warehouse. Designs methods for data validation to ensure data quality
  • Document operational procedures. Creation and maintenance of operational procedures including but not limited to; code migrations, troubleshooting and configurations, IT Service Management procedures and upgrade procedures of Data Warehouses and ETL platforms
  • Develop diagrams or flow charts of system operation. Responsible for developing and maintaining architectural and conceptual flow diagrams of current and proposed Data Warehouse and ETL environments
  • Minimum 3+ years’ experience in implementation, configuration, administration and support of the Informatica Big Data Edition software package
  • Minimum 3+ years’ experience in administering Informatica products in a complex Enterprise Data Management ecosystem
  • Background in deployment and implementation of ETL packages
  • Bachelor’s degree or equivalent work experience in an Information Technology field
  • Working knowledge of Windows and Linux operating systems
  • Familiarity with the use of version control tools
  • Experience in the Financial and banking industry
  • At least 6 years of experience with design, development, automation, and support of applications to extract, transform, and load data
  • At least 9 years of experience within a total information technology (IT) environment
  • PROBLEM SOLVING
  • EXECUTIONAL EXCELLENCE Extensive r5
  • BUSINESS ASSESSMENT
  • REQUIREMENTS ANALYSIS
  • LOGICAL DATA MODELING
  • SYSTEM DEVELOPMENT LIFE CYCLE
  • DATA MANAGEMENT (5+ Years)
14

Data Stage ETL Architect Principal Resume Examples & Samples

  • Perform technical analysis and prepare recommended data acquisition design approach
  • Participate in a team environment for the design, development and implementation of data warehousing projects
  • Lead and drive a small team including onsite/offshore responsible for data acquisition jobs development, debugging and testing of project to meet project time lines
  • Prepare and Present system designs to all DW architects (Internal design review) and BIS design panel
  • Work closely with development lead to finalize on estimated/actual project completion dates for process design, development, testing and implementation
  • Work with BIS project manager to finalize on estimated/actual project completion dates
  • Prepare and validate end to end business logic and mappings
  • Develop process jobs as per design, prepare unit test cases, prepare test data and Perform unit testing
  • Perform final code review before moving to SIT environment and fix issue in warranty Phase
  • Prepare detailed design, architecture, mapping sheet and other ETL documents
  • Work with support team to handover ETL to perform UAT and production role
  • Resolve all technical issues raised during SIT/UAT/ Warranty phases
  • Prepare root cause corrective action document for the ETL issues
15

Enterprise Data / ETL Architect Resume Examples & Samples

  • Technical Architect with strong understanding of Data Models, Data Processing and Analytics
  • Experience working on I &D (Insights and Data) projects with architecture knowledge
  • Overall experience of 8+ years, all in Enterprise Data Warehouse and Analytics projects
  • Experience working in Technical Architect role for 4+ years
  • Good understanding of data models, data processing techniques & analytics
  • Good communication & interpersonal skills
  • Strong knowledge of various ETL/Reporting/Database/Analytics tools
  • Should be able to grasp current customer landscape & suggest architectural improvements
  • Must be local to Chicago, IL or willing to relocate (work location is Oak Brook, suburb of Chicago)
16

System ETL Architect / Analyst Resume Examples & Samples

  • 1/ creation of documentation for existing data base
  • Physical model of the database
  • Describe ETL processes (Schemes of all ETL processes (Visual scheme); Processes input parameters; Data souses descriptions (purpose, communication protocols, the name of external objects); Algorithms of data transformation; Timetable and steps to launch (sequence, load, re-load, dependences, auto\manual); User guide for monitoring, if any)
  • Describe data base objects (tables, views, procedure, functions etc)
  • 2/ creation documentation of internal reporting system
  • Reports description
  • Description of input/output parameters
  • Description of data source
  • 3/ creation documentation of web application (optional)
  • Experience on working with MS SQL and Oracle RDBMS
  • SQL skills, C# (preferable)
  • Understanding of DWH architecture
  • Understanding of ETL processes
  • Experience in technical documentation
  • General understanding of banking data
17

ETL Architect Resume Examples & Samples

  • At least 6 years experience with design, development, automation, and support of applications to extract, transform, and load data
  • At least 9 years experience within a total information technology (IT) environment
  • Hadoop (Hortonworks)
  • Data movement tools: Informatica, SSIS, DataStage
18

Data Warehousing Lead ETL Architect Resume Examples & Samples

  • Re-architect existing marts and define ETL architecture for new marts, by resolving architectural conflicts and ensuring consistency and alignment with industry best practices
  • Demonstrate expertise in network architecture, ETL architecture, and data modeling
  • Provide thought and technical leadership, guidance, and cross-training on highly complex applications to a team of ETL developers and data modelers
  • Work with Data Science, Research, IT, and business units to assess and incorporate demographic, firmographic, geographic, weather, traffic, model, and other data sources for analytic benefit
  • Potentially introduce and manage unstructured, “Big Data” such as telematic, internet-of-things (IOT), drone, wearables, sensor, and social media, in a distributed ecosystem like Hadoop
  • Act independently under general supervision using established automated software tools
  • Design, supervise, plan, and coordinate highly complex projects
  • Consider equipment capacity, limitations, and operating time while completing assignments
  • Interpret requirements (written or oral) into technical specifications for projects across a broad knowledge base
  • Have full technical knowledge of all phases of applications systems analysis and programming, including but not limited to designing, coding, testing, debugging, documenting, installing, etc
  • Have quality assurance responsibilities and very limited after hours on-call support
  • Monitor, plan, document, conduct, and evaluate assignment status with project teams and management
  • Evaluate progress and results to recommend changes in procedures
  • May assist with the review and evaluation of personnel performance
  • Interact and communicate effectively with all business contacts, including group presentations and meeting facilitation
  • Responsible for project completion and user satisfaction on highly complex projects
  • Update the project management software weekly to reflect assigned task status and effort
  • Update the problem management and tracking system to reflect problem status
  • Update the Performance Objectives/Evaluation document
  • Make suggestions and track internal and external EODB
  • 6+ years of related work experience in similar or directly related functions, preferably in insurance or financial services
  • Expert, demonstrated knowledge of relational database models such as Oracle, DB2, SQL Server, Teradata, and Netezza; ETL architecture; and data modeling. SSIS programming experience a plus
  • Experience managing unstructured data in distributed ecosystems like Hadoop
  • Ability to work independently under general supervision with considerable latitude for un-reviewed actions or decisions
  • Must have an in-depth knowledge of a group’s applications programming system / platform and a general knowledge of all groups’ applications programming systems. Competent to work at the highest technical level of all phases of applications systems analysis and programming activities. SSIS expertise preferred
  • Must possess excellent interpersonal and communications skills, excellent problem solving skills, and the self-motivation to improve skills and abilities as generally acquired through six years of experience
  • Must demonstrate leadership, professionalism, and preferably an understanding of the insurance business
19

ETL Architect Resume Examples & Samples

  • To provide end to end ETL Design solutions and support Architecture in defining strategies
  • Leading team of designers and tech leads
  • To understand the overall purpose of the projects and contribute to requirements & data analysis, and provide solutions from an ETL perspective
  • Delivery of high level design documents with ETL & ODS strategy, standards and adhering to best practices and guidelines
  • Provide approval and oversight to requirement documents as entry criteria to design and development
  • Hands-on support to build and development team for issue resolution and completion
  • Accountable for closure of any design and build related queries/issues
  • Participate in various ETL, ODS and designs forum for the Senior Architects
  • Leading a team of designers/tech leads working on one or multiple projects of varying complexity, undertaking the following activities, maintaining overall accountability for the work of the team in terms of quality and timeliness of delivery
  • Strong understanding of ETL, ODS and API with functional and non-functional assessment for enterprise level implementations
  • Abinitio
  • MOngoDB & Hadoop
  • Data Modelling basics
  • BigData – Toolset (preferred)
  • Strong skills on ETL design patterns and ODS architecture
  • Hands on ODS design & architectural skills with design and build of large enterprise projects
20

ETL Architect Resume Examples & Samples

  • 10+ Years of experience in a data architect role with deep knowledge of Enterprise Data Architecture concepts
  • Expertise in implementing Data Warehouse, operational data stores and real time data integration
  • Experience with Development Methodologies, Databases Platforms and Data Modeling tools (ERwin/Model Manager)
  • Expert level skill in modelling, managing, scaling and performance tuning high volume transactional database
  • Bachelor's Degree in computer science or equivalent experience
  • Experience with Data Modeling tools such as Erwin/ER Studio
  • Experience and knowledge of optimizing database performance and capacity utilization to provide high availability and redundancy
  • Understanding of Agile and its implementation for Data Warehouse Development
  • Strong experience with SQL Server Management Studio, Advanced T-SQL and SQL Server Databases
  • Experience working with ETL tools like Informatica and SSIS
  • Capital Markets/Investment Management knowledge and experience is highly desired
  • Understanding of traditional and alternative asset class investment data, including but not limited to equity, fixed income, private equity, real estate, derivatives, mutual funds, ETFs, global assets, foreign exchange, etc
  • Focus on development/ improvement of framework to support repeatable and scalable solutions
  • Looks toward the broadest possible view of an issue/ challenge; can easily pose future scenarios; can think globally about all aspects of the Bank; can discuss multiple considerations of an issue and forecast them into the future; understands how the Bank works, competes, serves clients, and generates shareholder value
  • Demonstrates excellent communication and interpersonal skills; able to communicate clearly and concisely in a variety of settings and styles; is effective in a variety of formal presentation and meeting settings
  • Gains support for change by providing context and responding with sensitivity to concerns; takes initiative to recommend/ develop innovative approaches to getting things done
  • Can quickly find common ground and solve problems for the good of all; is a team player and encourages collaboration