- Featured in:
-
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Data Warehouse Engineer Resume Samples
Filter:
No results found
Candidate Info
27
years in workforce
1
year at this job
BA
Mis Equivalent
It To Material Management
Sr. Data Warehouse Engineer in Consulting Role
- Converted and redesigned 45 packages for project deployment. New ETL control flows; modular and audited data flows and transforms. Rewrote T-SQL in lookups to end transaction blocking and reduce memory use. Wrote T-SQL for incremental data extraction. Optimized run time by 89%.
- Reduce size of database by factor of 4 to reduce SSAS bottlenecks from DW loads and MDX queries.
- Rewrote Revenue by Employee packages to balance employee counts; measure group and hierarchies merged with GL database. Used windows functions for product, sales and customer packages.
- CAO proposal; to produce Cash statement by direct means; subtract COGS from Receivables.
- Resolved 1.5% variance between Sale and General Ledger reporting through forensic analysis of SSIS packages. Tabular T-SQL data model with PowerPivot DAX functions to filter and Calculate.
Candidate Info
11
years in workforce
2
years at this job
BS
Business
Data Warehouse Engineer
Provided production support and new development for existing SQL Server 2008 R2 data warehouse.
- Designed tables, complex ETL mappings and workflows in Informatica and SSIS to integrate new billing system into existing data warehouse.
- Developed Reports in Business Objects XI 3.1, SSRS and Microsoft Excel.
- Provided production support, product enhancements and bug fixes to SSAS multidimensional cube.
- Created processes, procedures and tools to validate data post ETL.
- Lead project to create reusable transformations, mapplets and mappings in Informatica to create consistency in the application of business rules.
- Worked on project to reduce the number of staging and transformation layers between source data and reporting.
Candidate Info
5
years in workforce
5
years at this job
BS
Applied Sciences
MA
Computer Applications
Data Warehouse Engineer
- Designed and implemented Data warehouse business Intelligence system for Visa corporate, which helps to forecast the complete business.
- Physical and Logical Database designing and modeling experience.
- Backup/Restore databases, Monitor, and optimize databases.
- Data Modeling, ETL and data mapping across projects.
Candidate Info
9
years in workforce
9
months at this job
AA
Information Services And Science
BA
Information Science
MA
Information Management Systems
Data Warehouse Engineer / Systems Engineer III
- Constructing, deploying, maintaining operational data stores through data engineering functions including data extract, transformation, loading, integration in support of enterprise data infrastructures, data warehouse, operational data stores and master data management
- Enabling BI and advanced analytics solutions utilizing the Microsoft stack (SSMS 2012, SSIS, SSRS, SSAS, MDS, Visual Studio and Excel Services)
- Implementing concepts of programming and database concepts such as data structures, error handing, data manipulation and I/O processing
- Developing OLAP solutions by creating cubes using data from data marts/data warehouse for deeper and faster data analysis
- Programming views, stored procedures, and functions, and reviewing query performance, optimizing code and monitoring overall data warehouse performance
- Enforcing data quality, integrity and reliability and creating solutions throughout the data warehouse by designing, maintaining and promoting proper data governance and database efficiency
- Fluency in file processing concepts (flat file, archive file, XML, etc.) and data integration• Investigating and troubleshoot coding errors and data flow failures
- Creating enhancements to existing data model and related platforms
- Ensuring security of data warehouse containing PHI
- Documenting and governing the life cycle of data, including source-to-target mappings, data dictionaries, transformations, and data quality and business rules