ETL Architect Job Description
ETL architect
provides technical leadership in data management: data modeling and db design, DWE Solution Architecture, Big data Architecture, data integration, data movement and replication, business intelligence, data quality, reference and master data management, data governance etc.
ETL Architect Duties & Responsibilities
To write an effective ETL architect job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL architect job description templates that you can modify and use.
Sample responsibilities for this position include:
Perform analysis of business requirements and develop logical and physical data models for data warehouse to support them
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
Analyze business/functional requirements, review the solution architecture, and develop the technical architecture and detailed design
Analyze data issues, identify and articulate the business impact of data problems
Perform code reviews and ensure that all solutions are aligned to pre-defined architectural standards, guidelines, best practices, and meet quality standards
Deploy the solution on a high-availability shared service production environment
Understand and comply with the established software development life cycle methodology
Establish and enhance technical guidelines and best practices for the integration development team
Utilize subject matter expertise in area of enterprise applications, solutions to evaluate complex, sensitive business problems and architect technical solutions
Keep current with industry technologies and tools in the integration domain
ETL Architect Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for ETL Architect
List any licenses or certifications required by the position: BI, MCSA, PMP
Education for ETL Architect
Typically a job would require a certain level of education.
Employers hiring for the ETL architect job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Business, Technical, Information Systems, Information Technology, Computer Engineering, Design, Information Science
Skills for ETL Architect
Desired skills for ETL architect include:
Microsoft's Master Data Services
Aspects of enterprise architecture
Code management concepts and platforms
Database platforms
SDLC
Data Integration
Data Mapping and parent/child relationships
Data Quality
Data mining
Data stores & processing engines like HBase
Desired experience for ETL architect includes:
Work with business to understand user requirements and translate into code
Build a standard distribution framework for downstream extracts
Architect Database to meet strategic data architecture standards
Participate in strategic development of future state of Post trade processing
Experience in message processing/realtime data sources � MQ/JMS
Strong experience in Informatica Toolset
ETL Architect Examples
1
ETL Architect Job Description
Job Description Example
Our company is looking to fill the role of ETL architect. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for ETL architect
- Analyze data-related systems integration opportunities and challenges, validating data models from a data integration perspective for current projects other impacted projects and drive quality improvements
- Keep current with the above tools/technologies
- Actively participate in code reviews of own code and that of peers
- Design ETL processes
- Populate BI tool metadata
- May develops performance plans and evaluations of employees, including subordinate supervisors reviews evaluations to assure equity of individual employee performance objectives, standards and ratings among lower level staff/groups
- Work with and provide technical guidance in the data realm to cross functional Scrum teams
- Work directly with Treasury Services Business Partners in Operations and Product Management to design and architect robust and redundant data services
- Learn the Treasury Services Business and propose ideas to reduce cost and/or generate more revenue
- Stay current with general industry trends and possible “disruptive” technologies that could have an impact on our Business
Qualifications for ETL architect
- 5+ yrs of experience in datawarehouse development
- Lead design/development of ETL/DB processes to build consolidated stock record
- Database design/modelling skills recommended
- Experience in Oracle Databases required, preferably 11g
- Experience in Agile Development such as SCRUM
- Experience in Collateral Management and Settlements Preferred
2
ETL Architect Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of ETL architect. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for ETL architect
- Directs the construction of architecture components (e.g., data architecture, application architecture, technical architecture)
- Works with business units to translate business strategy into discrete requirements compatible with current technical architectures
- Explains how the roadmap maintains and delivers cost effectiveness, business value, and competitiveness
- Manage the Life Cycle Management of development technologies
- Translates basic business functions into conceptual, logical and physical data models
- Creates and implements a design for the storage and maintenance of data (otherwise known as data modeling)
- Develops approaches for warehouse implementation, data acquisition and archive recovery
- Evaluates new data sources for adherence to quality standards and ease of integration
- Eliminates data redundancies
- Interfaces with stakeholders to understand an organization's data needs
Qualifications for ETL architect
- Performance tuning experience with Reporting tools like Cognos, ETL tools like DataStage
- 7+ years leadership of design and development in BI environments scaling to hundreds of users and multiple terabytes of content
- Proficient in designing and developing of mappings, transformations, sessions and workflows, and deploying integration solutions on Informatica PowerCenter 8.x/9.x
- Five to Seven years of hands-on technical experience in ETL design and development using Informatica PowerCenter 8.x/9.x in a high-availability RAC environment on Linux
- Strong experience in performance tuning of Informatica processes
- Experience in developing ETL for Teradata 12 and Oracle DB are preferred
3
ETL Architect Job Description
Job Description Example
Our innovative and growing company is looking for an ETL architect. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for ETL architect
- Designs, develops and enforces standards and architecture for all data needs within the organization
- Works collaboratively with a team of senior software architects and developers to implement solutions
- Significant ingenuity and flexibility is expected
- Designs, develops and enforces standards, and architecture for installing, configuring and using business intelligence applications
- Designs specifications and standards for semantic layers and multidimensional models for complete Business Intelligence projects across all environments
- Translate business and user requirements into specific systems, applications and/or process designs for custom technical solutions
- Act as the key interface between business and technology teams in defining and influencing business requirements and assists in developing the appropriate data-feeds /batch integration solutions between Internal applications, & with third parties
- Understanding the business implications of technical solutions, assist in defining the technology solutions to support future business requirements
- Have technical understanding of data models, data standards, and business glossary
- Have technical breadth in data profiling to profile data from different sources and determine whether and how data can support business and its intended use
Qualifications for ETL architect
- Experienced in incorporating Tidal enterprise Scheduler or comparable job scheduling system is preferred
- Knowledge of modern data science approaches (forecast modelling, decision support systems, multivariate regression/non-linear modelling, generic algorithms, neural networks)
- Strong understanding of RDBMS concepts, data modeling techniques (3NF, Dimensional)
- 5+ years experience Oracle RDBMS required
- Demonstrated expertise in implementing technology for large-scale BI architectures
- Experience with Oracle Business Intelligence (OBIEE) or Hyperion Essbase or any OLAP tool
4
ETL Architect Job Description
Job Description Example
Our growing company is hiring for an ETL architect. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for ETL architect
- Partner with ESB integration engineers to help define the company Common Data Model
- Hands-on with tools such as Informatica’s PowerCenter
- Design ETL integration solutions and produce all design phase deliverables including technical design documents, flowcharts, data transformations, mappings, routing evaluating impacts to performance and scale to support policies and SLAs as required
- Perform an active, leading role in shaping and enhancing overall Informatica architecture, including standards, patterns and best practices
- Evaluate New Tools and features
- Research and recommend future improvements in the Informatica operational environments
- Deliver Best practice document (Pre-Install Checklist, Architecture, Job Scheduling, Multi-tenancy setup, Fit for Use, Comparative Evaluation, Strength/ Weakness, Upgrade Strategy, Code Deployment Strategy) for each tool
- Develop in-house knowledge repository for best practices, solution documentations, manuals, and procedures
- Prepare cheat sheet on tool's features for user education
- On-boarding project team for Proof of Concept(POC ) on different Informatica products
Qualifications for ETL architect
- Self motivated personality and able to work independently in a team
- Strong experience on Oracle (11g, 12c) SQL/PLSQL and database design, programming, and performance tuning skills
- Deep SQL skills are required
- Thorough understanding of source code management, solution design documentation tools and processes, and environment management
- Experience with testing and defect management tools such as DevTest, TestLink, JIRA
- Exadata, Teradata, Veritca appliance solutions experience helpful
5
ETL Architect Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of ETL architect. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for ETL architect
- Conceptualizes creative ETL solutions, develops specifications and presents solutions to senior
- Perform an active, leading role in shaping and enhancing overall Informatica ETL architecture
- Establish ETL standards and best practices in conjunction with Enterprise Architect
- Communicate and promote adoption of practices and standards within ETL development teams
- Evaluate emerging trends and practices with the overall ETL community for application within the Enterprise
- Collaborate with vendor product development teams and senior designers to develop requirements to influence new features within the ETL toolsets
- Technical Leadership role for data management on development team
- Providing subject matter expertise for data management and modeling challenges
- Evaluation and implementation of tools/strategies for databases and data stores, ETL, MDM, reporting/analytics, and similar
- Some travel may be required (<25%) (currently domestic travel)
Qualifications for ETL architect
- Experience on ER-Studio or similar modeling tools is preferred
- Knowledge and experience in building Data Warehouse/Data Mart data models for a dynamic work environment that is complex
- Outstanding verbal, written and presentation skills required
- Bachelor Degree required – CS or equivalent experience preferred
- Understands data & database technologies
- Requires knowledge with aspects of Databases