Data Warehouse Engineer Resume Samples
4.5
(95 votes) for
Data Warehouse Engineer Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the data warehouse engineer 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
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.
VL
V Ledner
Valentine
Ledner
208 Kamren Forge
Los Angeles
CA
+1 (555) 185 9380
208 Kamren Forge
Los Angeles
CA
Phone
p
+1 (555) 185 9380
Experience
Experience
Los Angeles, CA
Data Warehouse Engineer
Los Angeles, CA
Hudson Group
Los Angeles, CA
Data Warehouse Engineer
- Work closely with application developers and administrators to create and improve data flows between internal/external systems and the data warehouse
- Establish and maintain working relationships with technical and architectural team members across the technology organization
- Review and manage work assignments (includes support cases) for team in an Agile environment
- Exposure to dealing with the challenges of large relational data sets, including load performance, query performance, archiving, etc
- Engage with partners in testing, release management, and operations to ensure quality of code development, deployment and post-production support
- Work closely with report development team
- Work in a team environment to support goals and to improve reporting practices
Phoenix, AZ
Data Warehouse Engineer, Informatica
Phoenix, AZ
Monahan-Gerlach
Phoenix, AZ
Data Warehouse Engineer, Informatica
- Design and develop ETL Data Loading packages
- Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects
- Assist in the design and development of Data Warehouse/Data Mart
- Perform duties and responsibilities specific to department functions and activities
- Provide Production Support of the Data Warehouse as well as the ETL jobs used to support the Data Warehouse and FRB. This includes being an active member of the Point rotation as well as providing support to other team members that are covering point
- Adhere to ETL/Data Warehouse development Best Practices
- Assist in the design and development of Informatica for Data Warehouse/Data Mart
present
Chicago, IL
Senior Data Warehouse Engineer
Chicago, IL
Koelpin-Huel
present
Chicago, IL
Senior Data Warehouse Engineer
present
- Evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration
- Work with e-commerce and systems that support supply chain management and APIs
- Evaluate and select data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration
- Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design
- Perform various QA tasks if necessary
- Perform source data analysis
- Design, develop, and test in ETL tool environment (GUI driven tools and hands-on SQL)
Education
Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Harvard University
Bachelor’s Degree in Computer Science
Skills
Skills
- Knowledgeable about data quality tools and practical uses
- Knowledge and direct experience using business intelligence reporting tools. (OBIEE, Business Objects, Cognos, Tableau, MicroStrategy, SSAS Cubes, etc.)
- Strong bias for action; ability to juggle multiple priorities and create a sense of urgency in a fast-paced, dynamic environment
- Ability to build strong relationships with business partners and team members
- Respond quickly and effectively to production issues and take responsibility for seeing those issues through to resolution
- Ability to communicate and work with both technical and non-technical team members
- Deep knowledge of dimensional modeling and experience with it on at least 2 large projects
- Excellent collaboration and communication skills
- Strong data analytics skills – from both a research and testing angle
- Ability to help influence technical direction
15 Data Warehouse Engineer resume templates
Read our complete resume writing guides
1
Data Warehouse Engineer Resume Examples & Samples
- Develop customer relationships with internal customers to determine reporting requirements stemming from possible upgrades, integration, and general support and how this impacts the data warehouse
- Analyze and provide requirements to transform data into a variety of contexts
- Demonstrate a full understanding of the Fact/Dimension data warehouse design model, including star and snowflake design methods
- Responsible for ETL (Extract, Transform, Load) processes to bring data from multiple sources into a single warehouse environment. ETL will consist of a combination of Microsoft SSIS and TSQL stored procedures
- Analyze data from multiple data sources and develop a process to integrate the data into a single but consistent view
- Quickly analyze complex data patterns in order to establish technical solutions to resolve data issues
- Coordinate the efforts of many technical resources to ensure the solution is implemented timely and precisely
- Develop standards and processes to ensure the successful operational support required to ensure daily reporting information is timely and accurate, so that day-day-business decisions can be made by the executive staff
- Responsible for fully documenting the data warehouse environment and operational components
- Bachelor’s degree in computer science or related field is preferred, minimum of 4 years related IT experience, minimum of 2 years reports development experience; or equivalent combination of education and experience
- Microsoft SQL Server 2008 or later experience required. Oracle experience a plus
- Familiarity with creating and maintaining SSIS packages required
- Knowledgeable of BI/data visualization tools such as Cognos BI, Tableau, or Pentaho
- Strong TSQL skills required
- Knowledgeable in all Microsoft Office applications, including Word, Excel, Access, PowerPoint and Project software applications
2
Data Warehouse Engineer Resume Examples & Samples
- Experience with UNIX System Administration and Database Administration
- Experience with shell, Perl, Python or any other Unix scripting / programming language
- Proficiency in automating tasks
- Experience with product evaluations and Proof-Of-Concepts
- Good written and verbal communication skills in English
- Experience with BI and Data Analytics (would be a plus)
- Experience with working on any of the following Data Warehouse appliances: Teradata, Netezza, Greenplum, Exadata, Vertica or Microsoft Fast Track (would be a plus)
3
Database & Data Warehouse Engineer Resume Examples & Samples
- Contribute to the technical design of next generation databases, which may span across multiple products. Use experience to help translate requirements into technical designs
- Actively participate in all phases of system development including planning and analysis, design, development, and testing
- Maintains application performance and scalability with a focus on performance tuning SQL queries, table design, indexing, query plan analysis and SQL refactoring
- Provide guidance in database migration and managing SQL Server Replication including log shipping, database mirroring and clustering
- Provide support for architectural designs to enhance complex subsystems like analytics engines
- Design and implement data warehouse solutions
- Design and implement Continuity of Business solutions for SQL Server databases including replication strategy and active-active clustering
- Analyze Load Test results before deploying major database versions to Production
- BS/MS Degree in Computer Science or related field
- 7 years of database engineering experience working with Microsoft SQL Server 2008, 2012, 2014
- Hands on experience with replication, disaster recovery, and Microsoft clustering
- Hands on experience with SQL Server indexes and execution plans
- Proficient in database modeling & design with a focus on performance and scalability
- Ability to understand large and complex data models quickly
- Experience performance tuning SQL Server databases and troubleshooting/resolving complex database issues
- Experience with SQL Server tools and services
- Experience with SSIS, SSAS and SSRS
- Strong problem solving skills and a detail-oriented mindset
4
Gtis-avp-data Warehouse Engineer Resume Examples & Samples
- Knowledge of other Data Warehouse products such as Teradata
- Experience in formulating and maintaining technology roadmaps
- Experience delivering major Enterprise Infrastructure Projects
- Experience in developing programs in languages such as Java, Scala, Python, Perl, or the similar application and shell scripting languages
- Experience in requirements gathering and scope definition
- Knowledge of Security Implementations and authentication protocols
5
Data Warehouse Engineer Resume Examples & Samples
- Work in a fast-paced team environment to complete projects according to business and technical requirements
- Design and create mappings and workflows from data models and design sessions with the data architect and other team members
- Optimize and troubleshoot SQL queries, Informatica mappings and workflows
- Create and perform unit tests
- Conduct deep data analysis on source data as needed to understand and meet business requirements
- Evaluate and prototype new data integration tools and technologies
- Resolve technical issues with minimal help from other team members
- Provide second- and third-level support for production ETL issues
- Respond quickly and effectively to production issues and take responsibility for seeing those issues through to resolution
- Use other ETL, database and Big Data tools as required
- At least 2 years of experience in Data Warehousing
- At least 2 years of experience with Informatica and SSIS
- At least 2 years of experience in one or more of the following databases: Oracle, SQL Server, Teradata, or Netezza
- At least 4 years of experience writing and tuning SQL queries and stored procedures
- At least 2 years of experience with AWS platform and preferably Redshift
- Experience using UNIX/LINUX and UNIX scripting in Korn shell
- Experience with relational and dimensional data modeling
- Experience tuning database/ETL applications and SQL
- Experience with Regular Expressions
- Experience working in an extreme or agile development environment
- Experience with Java and the Hadoop ecosystem, including Hue and Impala
6
Data Warehouse Engineer Resume Examples & Samples
- Application development oriented DBA
- At least 2 years of experience
- Other programming language- Advantage
- Knowledge in reporting technologies - Advantage
- Scrum experience – Advantage
- Good interpersonal skills – Must
- 100% dedication – Must
7
Data Warehouse Engineer Enterprise Performance Management Resume Examples & Samples
- Develop and maintain physical data models for EDW
- Develop guidelines for effective database design
- Converts business requirements into a technical specification
- Support internal departments to ensure compliance with the EDW design
- Identify and manage impact of organization changes on the EDW and processes
- Create and maintain required documentation on system implementation
- Perform data analysis of source systems and develop logical models to support various business intelligence reporting requirements
- Perform monitoring on all processes to ensure consistent performance and data integrity
- Work closely with business units to collect and document all technical requirements
- Develop processes to ensure metadata integrity across the conformed models
- Experience in Data warehousing / Business Intelligence modeling and development
- Strong Understanding of dimensional modeling and data warehousing techniques
- Strong Understanding of ETL Processes
- Expertise in data profiling / source system analysis
- Expertise in SQL Development
- Minimum of 6 years’ experience in Data Warehousing and/or Business Intelligence field
- Expertise in ETL tools (Informatica, SSIS)
- Expertise in Sql Development (T-Sql Coding, Stored Procedures, MDX Query Language, and Data Administration task)
- Strong Performance Tuning Skills
- Ability to diagnose complication issues with the data warehouse environment (ETL Processes, Data Flows, Logic Failures, and/or System Failures)
- Ability to effectively communicate both written and verbal
- Ability to translate Business Requirements into Technical Design
- Experience working within Agile Methodologies
- Dashboard Development experience desired
- Oracle/Hyperion Essbase experience desired
8
Data Warehouse Engineer Resume Examples & Samples
- Meet the expectations of business users by designing, developing and maintaining ETL jobs and related data warehouse models/objects/systems
- Participate in architectural and model decisions during the design and build phases of new projects
- Work closely with application developers and administrators to create and improve data flows between internal/external systems and the data warehouse
- Support business users by analyzing and resolving the root cause of issues
- Cross-train other team members on ETL and data warehousing best practices
- Ensure appropriate documentation is produced for all development projects
- Communicate effectively with end users, Data Warehouse Developers and Business Intelligence Project Managers and Analysts
- BS, BA, or equivalent experience in IT related field
- Minimum five years of experience in data warehouse development strongly preferred
- Very strong experience with Microsoft SQL Server 2012-2014, SQL and T-SQL and Oracle 10/11g, PL/SQL
- Ability to design and implement medium to large projects using Informatica 9.x. Experience with high volume data loads and ability to identify, evaluate and resolve performance issues and bottlenecks
- Experience working in a PeopleSoft environment (on Oracle) strongly preferred
- Clear understanding of data warehousing and data modeling concepts and best practices, combined with Extensive experience with data warehouse concepts and methodologies (Kimball preferred)
- Experience with database design & modeling methodologies and tools, such as CA ERwin or Sybase PowerDesigner strongly preferred
- Experience with Agile methodologies
- Experience with data warehouse lifecycles and a strong understanding of the role of methodology / frameworks
- Understanding of relational and multi-dimensional data design and development techniques
- Experience with Teradata is a plus
- Experience working as, or closely with, a business analyst is a plus
- Experience with process modeling and improvement methodologies a plus
- Experience with reporting and analytic tools and technologies such as MicroStrategy, Business Objects, Tableau, etc., is a plus
- Knowledge of video gaming industry is a plus
9
Data Warehouse Engineer Resume Examples & Samples
- Bachelor’s degree in computer science or related field is preferred
- Minimum of 5 years related IT experience
- Strong SQL skills required
- Experience with Microsoft SQL Server and SSIS required
- Experience with complex enterprise business applications data discovery, dimensional modeling/data warehousing and relational databases utilizing Enterprise Reporting tools such as Business Objects, Cognos or OBIEE required
- Cognos Framework Manager experience a plus
- Cognos Administration experience a plus
- Experience with Data modeling tools like PowerDesigner or ERwin a plus
- Experience with Version Control tools like Git or Subversion a plus
10
Senior Data Warehouse Engineer Resume Examples & Samples
- Define and implement the data warehouse strategy focusing on enabling business users and business analysts
- Maintain and enhance existing multi-terabyte DWH
- Build and promote tools that support the democratization of data movement; empower the teams to access the data independently
11
Data Warehouse Engineer Intern Resume Examples & Samples
- Base knowledge of the W3C’s Web Content Accessibility Guidelines v2.0
- Exposure to current tools used by people with disabilities (screen readers and other assistive technologies)
- Experience with accessibility evaluation and validation software
- Understanding of input and output modes used by people with disabilities
- Familiarity with compliance requirements - state, Federal, international
12
Data Warehouse Engineer Resume Examples & Samples
- Architect, design, build and manage True Fit's data warehouse
- Build custom datasets and reports based on end-user requests
- Continuously optimize performance, storage, and scalability
- Automate everthing
- 3+ years coding in SQL; export SQL skills required
- Significant expose to data warehouse design and implementation
- Postgres or Oracle experience required
- Solid knowledge of Linux systems, including performance measurement and diagnosis
- Experience developing and releasing commercial software products preferred
- Ability to understand business requirements and develop analytic solutions to complex problems
- Undergraduate degree in a quantitative field (Math, Physics, Engineering, and/or Computer Science)
- Strong listening and communications skills
- Excel in an agile development environment
- Highly motivated self-starter and can do attitude
- Thrives in a dynamic and collaborative environment
13
Data Warehouse Engineer Resume Examples & Samples
- Leading the design and implementation of a Data Warehouse at the senior-level
- Working closely with reporting specialists, data analysts, and other data consumers to gather and populate data into a warehouse table structure that is optimized for reporting
- Ensuring best practices that can be adopted in Big Data stack and share across teams
- Playing a key role in technology decisions for the future of our data, analysis, and reporting needs
- Working closely with other teams and disciplines to come up with simple, elegant solutions that balance everyone’s needs
- At least 5-10 years experience with at least 2 of those years being in the Data Warehouse/Business Intelligence space
- Experience with data warehousing; design and implementation experience is preferable
- Ability to write, analyze, and debug SQL queries
- Working knowledge of data management & data warehousing best practices
- Familiarity with ETL (Extraction, Transformation & Load), data warehousing, and BI tools (Tableau, Qlikview, Looker, etc.)
- Proficiency in at least one scripting language (Python, Perl, R, C Sharp, Java, etc.)
- Experience working with a distributed team, particularly across time zones, a big plus
- Exceptional problem solving and analytical skills
- Knowledge of database modeling and design in a data warehousing context
- Experience working with business partners and engineers to gather, understand, and bridge definitions and requirements
- Agile and eCommerce are both a plus, but not required
14
Senior Data Warehouse Engineer Resume Examples & Samples
- Define and implement data warehouse strategy with focus on enabling business users and business analysts
- Design, develop, and test in ETL tool environment (GUI driven tools and hands-on SQL)
- Provide ETL design, development, and testing estimations based business requirements
- Evaluate and select data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration
- Work across organization to ensure optimal data collection and processing to enable data driven decisions
- Support all operational aspects of systems in designated purview
- Perform practical OLAP implementations
- Use SQL and scripting languages (Shell, Perl, and Python)
- Work with columnar databases, (Redshift)
- Use various ETL and reporting tools
- Work with e-commerce and systems that support supply chain management and APIs
- Use cloud providers (Joyent, Amazon, and AWS)
- Provide support for industry best practices
- Build and promote tools for democratization of data movement, and empower teams to access data independently
15
Senior Data Warehouse Engineer Resume Examples & Samples
- Design and develop ETL processes that load and process data for a multitude of business processes such as the Data Warehouse, ODS and datamarts
- Follow the release management process for deployment of code associated with projects or enhancements
- Contribute to the Enterprise Data integration architecture/design & approaches around data movement
- Responsible for design and development of data transformation objects, Technical Specifications, and Transformation rules
- Plays a role in Data quality initiatives
- Provide production support for data warehouse jobs on a rotational basis and respond to incidents within the service level agreements
- 7-10 years of experience developing large data warehouse and data mart applications
- Minimum 5 years of ETL development experience using Informatica PowerCenter
- Minimum 5 years of experience and exceptionally strong understanding of SQL
- Strong RDBMS DB development experience (Stored Procedure Development, Physical DB Object creation etc.) required
- Strong communication skills and the ability to work with internal teams as well as 3rd parties
- Exposure/experience to Agile-Scrum development methodologies (e.g. Kanban) preferred
- MPP database experience preferred (Netezza, Greenplum etc.)
- Big Data and open source experience
- Bachelor’s Degree – Computer Science or equivalent work experience
16
Principal Data Warehouse Engineer Resume Examples & Samples
- Analytics Experience & Data Scientist Tendencies
- Data warehouse Understanding - Star Schema’s and Similar structures & Tools
- Drill-Down Reporting & similar tools
- Machine Learning/Pattern Discovery
- Architecture Design and Documentation
- Java Back End Experience
- Relational Databases
- Continuous Deployment/Integration
- High Availability Architectures
- SOA Concepts and Architectures
- Ability to build and own a BI technology stack
- Online operations support a plus
17
Data Warehouse Engineer Resume Examples & Samples
- Design and develop ETL Data Loading packages
- Ability to identify and resolve any performance and/or data related issues
- Mentorship of junior team members
- Responsibilities include the following: 1) adhering to and complying with all applicable, federal and state laws, regulations and guidance, including those related to Anti-Money Laundering (i.e. Bank Secrecy Act, USA PATRIOT Act, etc.), 2) adhering to Bank policies and procedures, 3) completing required training, 4) identifying and reporting potential suspicious activity to the BSA/AML Officer, and 5) knowing and verifying the identity of any customer(s) that enters into a relationship with the Bank
- Knowledge and prior work experience in Banking, Private Wealth Management or related financial services is a plus
- Strong skills and experience using Informatica PowerCenter, Master - Data Management and Metadata Strategy including implementation, architecture and developing Standards and Methodology required. Experience with Unix Shell and Perl scripting a plus
- Oracle Database knowledge required
- Informatica Test Data Management Development is a plus
- Advance knowledge of performance tuning related to ETL Development
- Strong experience with Source Control (VSS, TFS, Subversion, etc.)
- Strong experience with SQL Server Management Studio & BIDS
- Strong communication (verbal & written) and problem solving skills
- Ability to handle multiple projects and manage time efficiently
- Have an understanding of Microsoft Analysis Services and the Microsoft Business Intelligence Stack
- Furthers the First Republic Bank culture and value
- 5+ Years of Informatica PowerCenter Experience a must
- 3+ Years leading Data Warehouse projects
- Experience with Banking Data is a must
- Data Analysis skills is a must
18
Data Warehouse Engineer, Informatica Resume Examples & Samples
- Translate Business Requirements into a technical solution
- Provide Production Support of the Data Warehouse as well as the ETL jobs used to support the Data Warehouse and FRB. This includes being an active member of the Point rotation as well as providing support to other team members that are covering point
- Adhere to ETL/Data Warehouse development Best Practices
- Assist in the design and development of Data Warehouse/Data Mart
- Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects
- Requires solid knowledge about ETL, data architecture,data modeling and Software Development Lifecycles
- Perform duties and responsibilities specific to department functions and activities
- Performs other duties and responsibilities as required or assigned by supervisor
- Responsibilities also include the following: 1) adhering to and complying with all applicable, federal and state laws, regulations and guidance, including those related to Anti-Money Laundering (i.e. Bank Secrecy Act, USA PATRIOT Act, etc.), 2) adhering to Bank policies and procedures, 3) completing required training, 4) identifying and reporting potential suspicious activity to the BSA/AML Officer, and 5) knowing and verifying the identity of any customer(s) that enters into a relationship with the Bank
- SQL Server database knowledge
- Advanced Microsoft SQL Development (T-SQL)
- Microsoft SSIS Development (2005, 2008, 2012) is a plus
- Advanced Informatica PowerCenter Development and Data Analysis skillset a must
- Implemented Enterprise Level Data Warehouses
- Understanding of Agile Data Warehouse Development
- Proven self starter
- Results/Goal oriented
- 2+ Years of MS SQL Server Database Design/Development
- 5+ Years of Data Warehousing Experience
- 3+ Years writing PL/SQL procedures and functions
- 5+ Years Unix/Linux scripting
- Provides extraordinary service
- Furthers the First Republic Bank culture and values
19
Lead Data Warehouse Engineer, VP Resume Examples & Samples
- Work with Business SMEs to identify available data sources to satisfy a business unit’s needs
- Identify existing data sources or define new sources to be captured for the reporting & analysis data warehouse
- Query and profile data (both source data and data loaded into the reporting & analysis data warehouse) using simple to complex SQL statements
- Understand and translate source code values
- Document data quality issues
- Produce detailed data flow diagrams that demonstrate how data should flow through the system being developed and how it should be transformed
- Design data structures (staging, intermediate staging, Dimension, Fact, Aggregate, views, etc.) well-suited to meet the business requirements
- Apply naming conventions to database objects
- Prepare Source to Target data mapping documentation for developers
- Prepare unit test plans for STG, Dimension and Fact tables and/or views
- Test data in all environments (Dev, Tst, Prd) as required by team and/or project management
- Produce documents (detailed design document, development unit test plan, functional design document, etc.) required by the bank's SDLC
- Bachelor’s degree with 8+ years of experience in conducting requirement analysis, functional & detail design documents along with technical specs for business rules
- Knowledge of Dimensional Data Warehousing (star schema) is a must
- Banking/Financial Services experience is strongly desired
- Advanced SQL knowledge, database knowledge and data modeling knowledge are a must
- Banking product knowledge in either core banking products (loans, deposits, forex and money market) or Capital Markets products (Derivatives, Options & Futures, Securitization and Fixed Income) is strongly desired
- Must be able to perform well in high pressure, time-sensitive environments
- Experience with Oracle a must
- Experience with SQL Server and Greenplum (PostGres) a plus
- Experience with Business Objects a big plus
- Experience with Informatica a big plus
- Experience with AutoSys a big plus
20
SQL Server Data Warehouse Engineer Resume Examples & Samples
- Participate in project planning sessions with business analysts and team members to analyze business requirements and outline the proposed IT solution
- Participate in design reviews and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow
- High level of responsibility and ownership from inception through to implementation
- High level of personal commitment to each task, a can do attitude and a drive to deliver
- The candidate should have a proactive approach to problem solving
- Required: 5+ years of experience in Information Technology in a large corporate environment
- Required: 5+ years of experience in DEVOPS role using SQL Server
- Required: 5+ years of experience supporting Windows applications
- Required: 5+ years of experience troubleshooting through the OSI and Application stacks
- Required: 5+ years of developing in SSDT/BIDS, SSRS, and SSIS
- Required: Experience with Infrastructure components and the integration into an application architecture
- Desirable: Experience supporting Unix applications
- Desirable: Experience in DEVOPS role using QlikView, and Business Objects
- Desirable: Experience in an Agile development environment
- Desirable: Skills in QlikView Desktop, UDT/IDT, and Web Intelligence
- Demonstrates initiative and is a self starter
- Strong interpersonal communication skills written and verbal, able to communicate at all levels in the organization
- Good analysis skills in order to aid in business and technical trouble shooting and problem solving
- Strong issue management and ownership skills
- Must have full life-cycle experience in large, global multi-tiered systems, preferably in the financial industry
- Good testing principles as well as good defect management skills
- Knowledge of release management, version control, and revision control practices and procedures
- Strong knowledge of software development life cycles
- Strong technical documentation skills
21
Senior Data Warehouse Engineer Resume Examples & Samples
- Bachelor’s degree is required, preferably in computer science, information systems, or engineering program.
- Minimum 8 years of experience in systems analysis, quality assurance, and/or engineering support in data-intensive software engineering environments, with at least 5 years of specialized experience in data warehousing
- Work experience in writing complex SQL queries to manipulate and extract data from Microsoft SQL Server, and in building stored procedures and views
- Experience required in designing, modeling, and building Extract Transform and Load (ETL) data flow processes (preferably in SSIS) from data extraction, through source, staging, relational, and dimensional databases
- Demonstrated experience in and commitment to developing under a formal software development process as part of a collaborative team is expected
- Must have an active DoD security clearance
- Must be willing to take a competency test as part of the job application process.**
22
Data Warehouse Engineer Resume Examples & Samples
- Collaborate with Product Leads and BI Analysts to understand business requirements
- Collaborate with data source experts to establish data sources
- Develop logical and physical data models and maintain Entity Relationship Diagrams and related documentation
- Conduct data profiling to ensure data quality and data integrity is maintained at all times
- Develop and support self-monitoring, robust, scalable interfaces, ETL/ELT processes and data pipelines
- Provision data structures such as fact and dimension tables and other objects as needed
- Manage database supporting elements including schemas, tables, views, indexes, stored procedures, scripts and declarative integrity constraints
- Participate and attend development sprints to satisfy Business Intelligence and Data warehousing objectives
- MIS/CIS/CS Degree or 5-8 years relevant experience
- 3+ years Data Engineering
- Experience modeling Star Schemas structures using Ralph Kimball methodology
- Experience developing robust and scalable data integration data pipelines
- Experience in one or more of the following: Python, Java, Javascript
- Experience in one more of the following integration platforms (SSIS,Talend,Pentaho)
- Familiarity with Javascript API, Rest API and Data Extract API
- Experience writing and troubleshooting complex SQL queries
- Working knowledge of Windows/Linux Operating Systems
- Familiarity working with relational and NoSQL
- Familiarity of Amazon Web Services (AWS) such as EC2, SNS,SQS, and Lambda highly desirable
- Must display strong teamwork and interpersonal skills at all levels along with excellent verbal and written communication skills
23
Data Warehouse Engineer Resume Examples & Samples
- Design, implement and support a data warehouse platform for Oracle’s cloud business
- Interface with business customers, gathering requirements and delivering complete BI solutions
- Model data and metadata to support ad-hoc and pre-built reporting
- Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions
- Design and plan for the integration for all data warehouse technical components
- Responsible for data design, data extracts and transforms
- Experience taking a lead role in architecting, designing, and building complex software systems
- Strong bias for action; ability to juggle multiple priorities and create a sense of urgency in a fast-paced, dynamic environment
- Bachelor's Degree in an engineering or technical field
- 5+ years of experience with and detailed knowledge of data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures
- 5+ years of experience with relational data modeling concepts
- Experience in relational database concepts with knowledge of Oracle, SQL and PL/SQL
- Knowledge of data warehousing concepts
- Knowledge and direct experience using business intelligence reporting tools. (OBIEE, Business Objects, Cognos, Tableau, MicroStrategy, SSAS Cubes, etc.)
24
Data Warehouse Engineer, Vacation Rentals Resume Examples & Samples
- Work with internal and external clients to understand business requirements
- Design and implement parts of the data warehouse data model
- Design and implement ETL flows for the data
- Design, implement and deliver reports based on business requirements
- Understand source of our data and how it relates to our business model
- Prototype new ways to mine and display data
- QA any work done by self and other team members
- Troubleshoot and support all BI related production processing
- BS or MS in Computer Science or equivalent
- Solid foundation in data structures, algorithms, and OO Design with rock-solid programming skills
- Experience with SQL and Relational Databases (MS SQL Server, mysql, and/or postgres)
- Excellent interpersonal skills including verbal and written communication, teamwork, and issue resolution
- A problem-solving mindset; the individual should be highly motivated and self-directed
- Experience with Apache Hadoop/Hive integration is also a big plus
- Startup experience is definitely a plus
25
Senior Data Warehouse Engineer Resume Examples & Samples
- Five plus years of experience developing on OLTP databases (MySQL, PostgreSQL, Aurora) with in-depth knowledge of SQL, including writing functions and views
- Five plus years of experience with Java or Scala
- Five plus years of experience with OLAP databases and ETL data processing concepts with full implementation cycle experience in enterprise data marts
- Two plus years of experience and strong interest in developing scalable data services on top of Amazon RDS. Any of these technologies would be a plus: Databases: Redshift, MySQL, Aurora, PostgreSQL; EC2 instances
- Experience with agile engineering practices
- Experience with data integration tools such as Pentaho Data Integration, Oracle Data Integrator, or Talend
- Architecture and design experience for Database systems technologies with a focus on data marts and data warehouses·
- Excellent problem solving and root cause analysis skills
- Experience with performance tuning and scaling production databases
- Experience supporting data marts including monitoring, creating disaster recovery plans, and creating and implementing backup and recovery strategies
26
Data Warehouse Engineer Resume Examples & Samples
- Strong skills and experience using Informatica PowerCenter, Master Data Management and Metadata Strategy including implementation, architecture and developing Standards and Methodology required
- Experience with Unix Shell and Perl scripting a plus
- Requires solid knowledge about Informatica and Database knowledge
- Expert-level ETL development using tools such as Informatica PowerCenter and IDQ
- Experience Data Warehouse and Data Mart modeling and tools
- Experience in Linux and Shell Scripts
- Work with data originators to fill in gaps in the data collected, and/or to adjust source-system data structures to facilitate analysis and integration with other company data
- Assists users with the report design, running, and troubleshooting
- Monitors and maintains system performance and provide statistical reporting
- Establish and maintain working relationships with technical and architectural team members across the technology organization
- Exposure to Informatica Metadata Manager and MDM Concepts
- Exposure to Real-Time Data Replication
- Exposure to dealing with the challenges of large relational data sets, including load performance, query performance, archiving, etc
- 3+ Years Unix/Linux scripting
27
Data Warehouse Engineer, Informatica Resume Examples & Samples
- Design and develop ETL Informatica Power Center and IDQ tools
- Assist in the design and development of Informatica for Data Warehouse/Data Mart
- Expert-level SQL coding/querying skills in SQL Server and/or Oracle databases
- Exposure with Business Intelligence tools such as Tableau, Microsoft SSRS, or Oracle OBIEE
- 7+ Years of Informatica PowerCenter Experience a must
28
Data Warehouse Engineer Resume Examples & Samples
- Design and develop complex ETL data loading work packages in accordance with our Standards
- Be escalation point for design, architecture and process questions/issues
- Provide production support of the Data Warehouse for ETL jobs in an L3 type capacity. This involves being an active member of the production support rotation as well as providing support to other team members for jobs in SSIS and Informatica. Also, work closely with L1 and L2 operations team members in an advisory role for production issues
- Champion for and enhance ETL architectural and development standards
- Provide ongoing documentation (data mapping, ER diagrams, Visio diagrams, technical specifications, production support Runbooks, data dictionaries, test cases, etc.) for all projects
- Responsibilities include the following
- 7+ Years of in MS SQL Server Database Design/Development
- 5+ Years of MS SSIS Experience and SQL Server Management Studio
- 7+ Years of Data Warehousing Experience
- 5+ Years leading Data Warehouse projects
- Experience with Informatica PowerCenter, IDQ and or MDM a plus
- Advanced SQL Server database knowledge
- Expert Microsoft SQL Development (T-SQL) skills
- Expert Microsoft SSIS Development (2008, 2012)
- Experience with .NET technology (VB.net, C#, ADO.net, etc.)
- Experience implementing enterprise level data warehouses
- Experience in Data Modeling
- Solid understanding of MetaData Management and Master Data Management
- Knowledgeable about data quality tools and practical uses
- Strong understanding of agile data warehouse development
- Advanced knowledge about performance tuning related to ETL Development, SQL queries and database indexing
- Strong experience with source control (TFS, VSS, etc.)
- Able to handle multiple projects and manage time efficiently
- Experience with Banking data is a must
- Certifications (Microsoft, TDW, PMP, etc.) a plus
- Team player who provides extraordinary service
- Bachelor's degree in Computer Science, Information Technology or relevant field (or four additional years related work experience in lieu of degree)
- Minimum of 10 years of related work experience with increasing responsibilities
29
Senior Data Warehouse Engineer Resume Examples & Samples
- Collaborate with your Data Warehousing peers, leads and other stakeholders to further expand and develop the Enterprise Data Warehouse platform
- Ensure that new solutions meet defined technical, functional, and service level requirements and standards
- Lead all aspects of software or product vendor implementations as needed to deploy solutions that integrate with SVB systems and / or processes
- Mentor and provide direction to offshore partners on larger scale projects where you will act as technical lead for the organization
30
Senior Data Warehouse Engineer Resume Examples & Samples
- Proactively
- BS/BA
- Microsoft
31
Data Warehouse Engineer Resume Examples & Samples
- Analyze & translate functional specifications & change requests into technical specifications
- Design, Develop, Implement ETL framework for Enterprise DW system
- Executing unit tests and validating expected results; iterating until test conditions have passed Translate business needs into end user applications
- Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution
- Troubleshoot and remediate issues impacting processes in ETL framework
- Modifying existing code to provide defect fixes for existing ETLs
- Coordinate and Collaborate with ETL team and business users to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications
- Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes
- Keep abreast of the tools, techniques and components being used in the industry through research and applies this knowledge to the system(s) being developed
32
ETL Data Warehouse Engineer Resume Examples & Samples
- 3-7 yrs of experience in ETL Development & Support
- Strong programming/scripting background with extensive knowledge of Unix/Linux (e.g., shell,python/perl/ruby and bash/korn etc.)
- Experience with scheduling tools such as opswise & job scheduler
- Exposure in Big Data analytics over warehoused data using Java, Hadoop, Hive and Pig
- Curiously strong written, verbal and interpersonal communication skills
33
Data Warehouse Engineer Resume Examples & Samples
- Work closely with the business and technical teams to understand, document, design and code processes
- Design and develop objects in support of business projects using
- Minimum of a 3rd year student, as well as, 3.0 or better in a Computer related program
- Conceptual understanding of relational databases
- Must have experience in Windows applications including Microsoft Office
- Excellent problem solving skills
- Ability to provide thorough attention to detail
34
Data Warehouse Engineer Resume Examples & Samples
- Run Grab’s Data Warehouse and ensure uninterrupted, error-free up time, while meeting the SLA requirements of Business Intelligence, Analytics and Data Science workloads
- Build and manage scalable ETL pipelines to and from various internal and external data sources that come from a variety of systems (OLTP Databases, streaming data pipelines, text-based data files etc.)
- Manage our Business analytics infrastructure to ensure the timely and accurate delivery of our mission critical business reports
- Spearhead the design and development and deployment of our next generation data warehousing infrastructure to meet our future needs
- Participate in the development and management of a global Data Model for Grab’s entire data ecosystem to streamline data consumption and access across our entire organization
- Strong working knowledge and experience handling complex data workflows spanning across multiple large datasets that will facilitate performance tuning and optimization of big data workloads
- Familiar with databases and engineering standard methodologies - including handling and logging errors, system monitoring, and building human-fault-tolerant data pipelines
- Running modern high performance analytical data warehouse solutions like RedShift, BigQuery, Greenplum, Teradata and others
- Worked with modern business intelligence tools like Tableau,Qlikview etc
- Experience working on cloud systems like Redshift and AWS cloud, workflow schedulers like Azkaban and Oozie will be a strong plus
35
Senior Data Warehouse Engineer Resume Examples & Samples
- End to End Data Warehousing Jack of All Trades
- Experience integrating with Salesforce.com
- Comfortable working with agile methodologies
- LI-DA2
36
Data Warehouse Engineer Resume Examples & Samples
- Responsibilities include creating documentation and standard operating procedures (SOPs) for key data warehouse and ETL operations
- Additionally, this role entails ETL design, development, code maintenance and implementation, leveraging Informatica
- Ability to understand reporting requirements and to ensure business requirements meet expected results
- Review the deliverables for quality, completeness, compliance to standards and adherence to approach
- Proven track record of successfully developing and implementing data warehouse applications
- Possess a strong background with data warehousing and reporting architectures, dimensional modeling, and ETL knowledge
- Provide expertise in data analysis in the areas of reporting, data warehouse, and business intelligence
- Strive to improve data accuracy and organization
- Manage request ticket queue for customer related issues
- Provide day to day support of data warehouse and troubleshooting of existing process and procedures
- Play a pivotal role in all website releases and system migrations
- Support existing Informatica workflows and Unix shell jobs
- Develop and maintain technical specification documentation for all reports and processes
- Perform performance analysis, tuning and measurement of the reporting systems
- Share third-level on-call support responsibilities
- Work in a team environment to support goals and to improve reporting practices
- Strong trouble-shooting, problem-solving skills
- Working experience with Microsoft SQL Server 2008 and its components SSAS 2008, SSIS 2008 and SSRS 2008
- Strong SQL, star schema, data modeling, and database skills
- Experience in supporting MS SQL Server 2000 Analytical and Reporting Services
- Experience in Migration from SQL 2000 to SQL 2008
- Expertise in Oracle, RDBMS systems
- Strong understanding of MOLAP, ROLAP, and HOLAP implementations
- Knowledge of Unix Shell Scripting or Perl
- 3 - 5 years of professional experience implementing business intelligence solutions and associated process improvements
- 3-5 years of professional experience with industry standard OLAP
- 3-5 years of professional experience using a reporting package
- Self-motivated with a passion for business intelligence
- Detail oriented, well-organized, and able to multi-task
- Ability to grasp data and business issues and drive them to successful resolution
- Willingness to collaborate and innovate towards technical excellence
- Bachelor Degree in Computer Science, Engineering or equivalent work experience; 4+ years professional experience in data analysis, reporting, and Business Intelligence
37
Data Warehouse Engineer Resume Examples & Samples
- Associate's or Bachelor's degree in a science, technology, engineering, or math related field or equivalent work experience (6 years of experience equates to an Associate’s degree when defining “equivalent work experience”)
- At least 3+ years of data and database application development experience with a focus on data warehouse, reporting, analytics environments
- Experience with leading technical implementations as well as the desire to mentor/coach others. And you must be willing to roll up your sleeves and contribute to the development activities (this is an Agile world after all!!!)
- Data warehouse development experience in an Agile environment
- ETL experience (e.g. Informatica)
- Experience or exposure to data virtualization (e.g. Denodo)
- Any experience with test driven database development practices (TDD)
- Business Intelligence tooling experience (e.g. Business Objects, SAS, etc.)
- Experience with big data or unstructured data (e.g. NoSQL)
38
Senior Business Intelligence & Data Warehouse Engineer Resume Examples & Samples
- Participate in BI/DW business requirements and user stories review sessions
- Participate in BI /DW functional and technical design sessions
- Work with Business Analysts to create prototypes for BI solutions
- Create technical specifications in accordance with business requirements documentation
- Review technical specifications with remote Developers
- Coordinate the development tasks with remote Developers
- Coordinate the testing tasks with remote Quality Analysts and onsite Business Analysts
- Conduct quality reviews on offshore development deliverables
- Enforce BI/DW design and development standards
- Update BI/DW product documentation
- Provide hands-on technical expertise in ODI program changes, repository changes and report changes
- Travel to business locations to participate in requirement gathering sessions and product deployment sessions
- Travel to remote development centers to build relationships, conduct technical training to remote developers
- Work with International business users to resolve BI/DW-related issues
- Ability to work with functional groups and different level of employees to effectively and professionally achieve results
- Strong follow-up skills; ability to organize applicable department timelines and follow up with internal and external customer needs
- Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast paced environment
- Strong track record of building and maintaining solid relationships with internal and external customers and vendors
- Self-motivated, able to work independently to complete tasks and respond to department requests and to collaborate with others to utilize their resources and knowledge to identify high quality solutions
- Strong technical documentation skills; ability to prepare technical specifications
- Excellent data analysis skills; ability to reconcile the reports with source applications and data warehouse
- Excellent problem solving skills; ability to troubleshoot data related issues and systems related issues
- Ability to communicate effectively with remote Developers and Quality Analysts
- Clear understanding of data warehouse and BI concepts
- Bachelor's degree in Computer Science or related field required
- Between 7-10 years of Information Technology experience required
- Between 5-7 years of BI/DW development experience required
- Experience with ODI required
- Experience with Oracle Business Intelligence Enterprise Edition required
- Experience with Oracle prepackaged BI applications required
- Understanding of Oracle EBS applications required
- Experience with Oracle Essbase cubes preferred
- Experience with Oracle Database programming required
- Experience with other databases, such as SQL Server, preferred
- Experience in collaborating with remote development teams required
39
Senior Enterprise Data Warehouse Engineer Resume Examples & Samples
- Partner with the business system owners and Enterprise Architecture to evaluate, design, develop and implement technology solutions
- Provide technical leadership for the application life cycle in the areas of secure code requirements, system performance measurements, quality metrics, design reviews, agile methodology, unit testing practices, application support, defect troubleshooting, and resolution
- Insure solutions are quality based and incorporate LEAN practices for simplifying business processes
- Design and develop complex systems and their related interfaces incorporating common services as appropriate
- Serve as a mentor and idea leader in developing others by leading code reviews, presenting technology debriefs, and sharing best practices
- Stay actively engaged in the technology industry and understand how the evolving technologies can benefit our organization
- Continually seek to improve applications including system performance, functionality, code efficiency, and code defects
- Develop and maintain appropriate system documentation throughout the system life cycle including design, development, test, support, change release, and implementation documentation
- Provide application support including developing and implementing production application monitors, timely problem identification and resolution
- Embody the Alaska Spirit and conduct oneself with professionalism, integrity, resourcefulness, and caring
- Bachelor?s Degree or equivalent work experience required
- 5+ years of prior professional experience in software engineering required
- 3+ years of experience in the design, implementation, and support of a Kimball method data warehouse on SQL Server or Oracle required
- 3+ years of experience in SQL, writing queries, design and develop stored procedures, writing functions and performance optimization of queries ? required
- 1+ years airline/travel industry experience preferred
- Strong business and/or technical background in the areas of Data Integration (ETL), Data Security, and Enterprise Data Warehouse development required
- Experience in Change Management, Release Management, and Source Code control practices
- Ability to balance multiple projects and work independently and as part of a team
- Experience in Oracle Technologies including Oracle Exadata, Oracle Warehouse Builder (OWB), Oracle Database Integrator (ODI), and Oracle databases
- Experience using C#, .Net, and object oriented techniques ? preferred
- Experience working as a lead on systems with complex data flow and processing, and with large transactional and reporting databases
- Expert understanding of database and transaction processing concepts and knowledge of query analysis tools
- Able to provide 24 x 7 on call support on a rotating basis required
- Minimum age of 18 required
- Authorized to work in the US required
40
Data Warehouse Engineer Resume Examples & Samples
- Deep knowledge and experience designing and maintaining data warehouses including: Redshift, Oracle, Netezza, Greenplum, etc
- Familiarity with Amazon Web Services (EC2, EBS, S3, etc.)
- Systems engineering experience, including Linux performance, memory management, I/O tuning, configuration, security, networking, clusters and troubleshooting
- Experience building and maintaining complex mission-critical production database systems
- Broad awareness of customer workloads and use cases, including performance, availability and scalability
- Experience analyzing issues holistically, from the application tier through the database, down to the storage
- Experience working directly with customers, resolving database, systems and infrastructure-related issues and also providing systems architecture leadership
- Awareness of emerging technologies and approaches in IT
- Working knowledge of relational database internals as well as warehouse internals (locking, consistency, serialization, recovery paths)
- Working knowledge of at least one scripting language (shell, Python, Perl)
- Coding skills in the procedural language for at least one database engine a must
- Proven track record of automating tasks
- Consulting experience is a plus
- 4+ years of experience engineering, administering and managing multiple data warehouse flavors (e.g. Redshift, Oracle, Netezza, Greenplum, etc.)
- 4+ year experience with one or more relational database engines such as Oracle, PostgreSQL, MySQL, SQL Server
- Familiarity with at least one compiled language (Java, C, C++ )
41
Enterprise Data Warehouse Engineer Resume Examples & Samples
- MSBI Stack with min 5yrs experience
- Data modelling
- SSAS, SSIS and MSSQL are key skills required
- Understanding business and translate that into a technical implementation working with our business stakeholders for data validations
42
Data Warehouse Engineer Resume Examples & Samples
- Monitor ETL processes, quickly act upon failures, proactively communicate malfunctions, and coordinate with other teams, whenever necessary
- Provide technical representation and communicate with customers until issue is resolved
- Provide BI development team with the required analysis/data to generate fixes/updates for production issues
- Documents problem status and resolutions to maintain support history
- Become the subject matter expert on toolset and technology - must demonstrate personal drive to achieve expert status
- Design, develop and test deliverables in our enterprise database environments
- Review and manage work assignments (includes support cases) for team in an Agile environment
- Estimate tasks and successfully deliver upon committed dates
- Demonstrate ability to set and manage own priorities effectively in a dynamic organization
- Be an effective listener, who can give timely and constructive feedback. Is willing to state opinions assertively and deals constructively with conflict situations. A problem solver as well as willing to comprise for a common effective and efficient solution
- Work as a team; cross trains as well communicates effectively and efficiently in a virtual team environment
- Support enforcement of security and access control measurements to safeguard database authentication and authorization infrastructure
- Develop and maintain relationships with key business and technology partners
- Participate in production on-call rotation, where required
- Work closely with business analysis and application owners to review and detail project requirements and design
- Identify opportunities for improvement and innovation
- Assist in the preparation of designs and technical and/or functional specifications
- Perform code reviews and work with teammates on according to company coding standards and best practices
- Ensure successful implementation and support of project efforts by working with team on integration activities
- Use ETL standards and practices toward establishing and following a centralized metadata repository
- Work with business areas and IT to ensure integrity and proper integration for all sources of enterprise data
- Bachelor of Science in Computer Science or equivalent years of relevant work experience
- Strong knowledge of relational databases (SQL)
- 2 plus years of ETL development project experience
- 2 plus years of data design/development experience (database development, analysis)
- Prior data integration experience; ETL, EII, etc
- Knowledge of technical concepts, such as: logical and physical data modeling, performance tuning, code reviews process, data normalization processes, data integration methods, Agile SDLC, production support, etc
- 2 plus years of experience developing utilizing the Microsoft BI Stack (SQL Server 2012, SSIS, SSRS) experience
- Understanding of normalization and integration methods/techniques
- Experience using tools such as RedGate, Atlassian (Jira), Wiki, Visual Studio, TFS, PragmaticWorks, Power Designer, Tortoise/SVN
- Travel industry experience is a plus
- Understanding of the Agile and Waterfall methodologies
- Strong analytical and communication skills
43
Data Warehouse Engineer Resume Examples & Samples
- 5 plus years of ETL development project experience
- 5 plus years of data design/development experience (database development, analysis)
- Advanced knowledge and hands on experience of key technical concepts, such as: logical and physical data modeling, performance tuning, code reviews process, data normalization processes, data integration methods, Agile SDLC, production support, etc
- 3 plus years of experience developing utilizing the Microsoft BI Stack (SQL Server 2012, SSIS, SSRS) experience
- Hands on experience with normalization and integration methods/techniques
44
Data Warehouse Engineer Resume Examples & Samples
- Model application layer and metadata Design, develop and implement Business Intelligence (BI) report objects supporting end user business requirements
- Assist in creation of BI development standards and processes
- Design and create automated BI applications and reporting solutions
- Provide technical expertise to business areas in understanding the data architecture and give feedback on a structured approach to transitioning manual reports and applications to the Business Intelligence environment
- Guide business areas in identifying new data needs and delivery mechanisms for reporting information
- Establish documentation of reports and data definitions
- Support daily operations, including job monitoring and troubleshooting of the data warehouse environment
45
Data Warehouse Engineer Resume Examples & Samples
- Design and support the database and table schemas for new and evolving sources of data
- Monitor and troubleshoot data issues on data warehouse servers
- Responsible for dimensional design as we load new areas of business into the data warehouse
- Design and support the analysis services cubes to help with analytics
- Diagnose and resolve data warehouse ETL processes, data flows and business logic failures
- Work with DBA’s to define resource utilization needs
- Provide technical expertise and advice to business areas to help them smoothly transition manual reports and applications to the BI environment
46
Data Warehouse Engineer Resume Examples & Samples
- BS or BA (or equivalent) in computer science or equivalent discipline (EE, Math etc.)
- 4+ years experience in the design, development, and testing of Data Warehouse implementations
- 4+ years of experience with SQL and Relational Databases
- 5+ years of overall software industry experience
- Experience with MS SQL Server 2008
- Deep knowledge of dimensional modeling and experience with it on at least 2 large projects
- Experience with ETL tools (SSIS)
- Experience with Reporting tools (esp. OLAP reporting) (SSAS)
- Ability to communicate and work with both technical and non-technical team members
- Ability to work in a fast-paced and dynamic environment
- Strong Experience with MS BI Stack (SSIS, SSAS, SSRS) is a big plus
47
Data Warehouse Engineer Resume Examples & Samples
- 7-10 yrs of experience in ETL Development & Support
- Very strong in SQL (MySQL, Teradata, Postgres, Oracle) . Demonstrated experience with parallel RDBMS preferred (e.g., Teradata, Netezza, etc.)
- Certifications on RDBMS such as Teradata, Oracle is a plus
- Good understanding of data warehousing concepts
- Be able to work in a challenging, dynamic environment and meet tight deadlines
- Be a good team player
48
Data Warehouse Engineer Resume Examples & Samples
- Develop and maintain SSIS and ETL stored procedures to load data originating from Microsoft SQL Server, Oracle, and flat files into the data warehouse
- Demonstrated understanding of concepts, best practices and functions of a data warehouse in the corporate environment
- Development using .Net, C#, stored procedures, or other development tools
- Ability to troubleshoot and resolve performance issues with overall infrastructure
- Ability to analyze data from multiple data sources and develop a process to integrate the data into a single but consistent view
- Ability to work heads down and independently on projects to meet tight deadlines with accurate results
- Strong communication and team building skills
- Ability to work with highly fluid requirements that may result in re-work of development items, as new data relationships are identified
- Minimum of 7 years related IT experience
- Experience with Microsoft SQL Server 2014 and SSIS required
- Experience with .Net, C#, Python, Powershell, stored procedures or other development tools required
- Strong analysis skills required
- Experience with complex enterprise business applications data discovery, data warehousing/relational database architecture concepts, and ETL Change Data Capture knowledge required
49
Senior Data Warehouse Engineer Resume Examples & Samples
- Design, develop, and implement data-integration jobs to effectively process high-volume disparate data sources and meet processing SLAs
- Ensure ETL requirements are clearly understood and accommodated
- Develop and Document all ETL jobs and processes according to ETL standards and best practices
- Interact closely with business partners and Engineering teams to determine analytics needs and translate those needs into efficient & scalable ETL processing needs
- Implement automated data quality checks, as part of ETL, and iteratively improve upon them as the analytics needs evolve
- Define and develop scalable, maintainable & innovative data-integration solutions
- 4+ years of enterprise ETL toolkit experience (Informatica, Talend, SSIS, SnapLogic, etc.), ETL Design, Development & operations experience in a high-volume Data Integration environment
- 8+ years of Data Warehouse, Data Integration and Business Intelligence experience
- Hands-on experience with columnar database technologies, preferably cloud technologies
- Extensive hands on in-depth experience in scripting: Python, Shell, etc, preferred
- Experience in business requirements gathering, data analysis, data mapping, and dimensional data modeling
- Strong analytical and SQL skills
- Detail oriented and willingness to be a team player
50
Data Warehouse Engineer Resume Examples & Samples
- Provide critical systems support and timely problem resolution
- Heavily involved with the data center migration activities for the BI servers
- Coordinate for other team on special projects
- ETL files
- Transfer files to loadable data warehouse
- Work closely with report development team
- Extra data from Data Warehouse and put it into a defined mart
- ETL (SSIS)
- Previous database experience
- SQL queries
- Data marts
- Pentaho experience is a plus but, not required
- Primary responsibility for problem investigation and resolution during normal work hours
- Participation in after hours support rotation
- On-going platform maintenance
- Coordination with Data Integration, Network, DBA, Server Systems, and Storage Systems for cross-team projects, resource procurement, system maintenance, server migrations or upgrades, database maintenance, and general change management
- Minimum 5, Preferred 7+ years experience in Data warehousing or related position
- 4-year degree in related field
- Extensive knowledge of Microsoft BI Stack (SSIS, SSAS, SSRS)
- Extensive knowledge of Microsoft SQL Server and query performance tuning
- Extensive knowledge of ETL and best practices
- Extensive knowledge of C# and VB as it pertains to Scripting in SSIS
- Knowledge of data warehouse modeling and design
- Knowledge of creating and managing restfull services for accessing data warehouses
- Strong collaboration skills and ability to build strong working relationships across multiple teams to include Data
- Integration, Network, DBA, Server Systems, etc
- This position is eligible for the Employee Referral Bonus Program - Tier 4
51
Senior Data Warehouse Engineer Resume Examples & Samples
- Hadoop - Yarn. Hive. Presto. Tez. Orc. Parquet. Spark
- Linux - Shell scripting is something to be proud. You take pride in your scripts
- SQL and JSON - yes. even window and lambda functions and nested datatypes don't scare you
- Pipeline Management - what can you bring? there's lots here to explore. Let's talk
- AWS - Packer. Terraform. EMR. Cost-Management. Is the cloud *really* worth the expense? What do you think?
- BS in Computer Science or equivalent and 5 years of data warehousing or big data processing experience
52
Data Warehouse Engineer Resume Examples & Samples
- Engage with partners in testing, release management, and operations to ensure quality of code development, deployment and post-production support
- Analyze design specifications, documentation, and requirements surrounding the EDW technology components
- Create high-level designs based on an understanding of the functional needs of projects or internal business clients
- Ensure design of new solutions leverages existing software components where feasible
- Generate SQL DDLs and physical tables for the purpose of loading target data stores
- Develop ETL packages to extract, transform and load source to target stores using SAP BODS tool
- Define and implement scheduling of jobs using Redwood scheduler
- Write and perform unit testing of software components and integration programs
- Execute unit tests to ensure that the software complies to functional requirements
- Tune for performance ETL packages and target data stores based on expected use
- Establish and maintain software and document change management policies and procedures
- Experience in financial and credit card domains preferred
53
Persmod Data Warehouse Engineer Resume Examples & Samples
- Contributes to the overall strategic vision, and integrates a broad range of ideas regarding implementation and support of ADE 2.0
- Lead the design, development and deployment of data warehouse solutions in the cloud
- Design, deploy and maintain enterprise class security, network and systems management applications within an AWS environment
- Supports demos, conference room pilots, and Fit/Gap sessions and propose options to fill gaps through product configuration, BPR, customizations/extensions, or third-party products
- Responsible for supporting and leading project tasks
- Works as member of a dynamic high performance IPT
- Support of technology implementations from a technical perspective including experience with cloud based technologies, data cleansing and conversions, interface design/development, systems development life cycle, etc
- Frequent inter-organizational and outside customer contacts
- Master’s Degree in Engineering, Computer Science, Information Systems, or other related analytical, scientific, or technical disciplines; Relevant Experience: 10+ years. Equivalent experience can be substituted for educational experience.Hands-on experience leading the design, development and deployment of data warehouse solutions in the cloud
- 2+ years experience designing highly scalable ETL processes with complex data transformations, from disparate applications and data formats
- Thorough understanding of cloud computing; virtualization technologies
- Understanding and experience with IAAS, PAAS, SAAS delivery models and the current competitive landscape
- Knowledgeable in designing secure cloud solutions using AWS services like EC2, S3, IAM roles and policies, Auto scaling, Elastic Load Balancing, and VPC. Or similar experience with other leading cloud providers like Azure, Google Cloud etc
- Hands-on experience with cloud data warehouse platforms such as Amazon Redshift
- Highly proficient in coding/programming with strong design and architecture experience
- Experience driving in-person discussions with senior personnel regarding best practices, project management and risk mitigation for cloud services
- Proven experience with software development life cycle (SDLC) and agile/iterative methodologies required
- Must hold an active DoD Secret Security clearance
- Knowledge of best practices for migrating on premise data warehouse onto the cloud
- Knowledge of the primary AWS services (EC2, ELB, RDS, Route53 & S3)
- Strong track record of implementing AWS services in a variety of distributed computing environments
- Proven track record of production deployment: Leading highly-available and fault-tolerant enterprise data warehouse deployments
- AWS Solutions Architect certification
54
Senior Data Warehouse Engineer Resume Examples & Samples
- Participate in building scalable and modern data warehouse environment
- Perform source data analysis
- Build and extend a flexible and scalable reports and dashboard framework
- Interface closely with product, engineering and business divisions
- Participate in building custom frameworks/solutions as well as leverage off-the-shelf data products/tools, as appropriate
- Participate in all aspects of Extract-Transform-Load
- Combine consultative skills with analytical knowledge to critically evaluate objectives and customer requirements and translate these into technical requirements
- Requires direct supervision
- Perform various QA tasks if necessary
