A Data Warehouse Analyst undertakes the most crucial job of collecting, analyzing, mining, and helping the business leverage the information stored in data warehouses. A well-drafted Data Warehouse Analyst Resume mentions the following core duties – researching and recommending technology solutions relating to data storage, reporting, importing, and other business concerns; and defining the user interfaces for managing the interactions between data marts and data warehouses.
Below are the most sought-after skills and qualifications needed for the job role – excellent research, analysis, and problem-solving skills, extensive knowledge of relational database theory; experience with data modeling and architecture, strong verbal and written communication skills, and strong listening skills for communicating to technical and non-technical team members. A bachelor’s degree in computer science or a related field is necessary.
Objective : Responsible for Working and coordinating with other team members from the Data Warehouse team and also with the Data Exchange team to make sure we meet client deliverable deadlines.
Skills : Database Management, Project Management, BI Reporting, Analytics, Data Standards, Excel, Powerpivot, SQL, Text Analysis, Google Apps, Bitcoin.
Description :
Designed and developed store procedures, tables, views and functions; implemented best practices to maintain optimal performance.
Analyzed and integrated data from various legacy systems.
Developed complex reports using SSRS.
Integrated and replicated data to build data marts and data models.
Involved in creating nightly batch process using Informatica to transfer data from legacy system to SQL Server data warehouse.
Worked on various business reports using Microsoft business intelligent reporting.
Used different functionality of SSRS like sub reporting, drill trough reporting, links, interactive sorting, etc.
Experience
2-5 Years
Level
Executive
Education
MS In Computing
Data Warehouse Analyst Resume
Headline : Currently under contract with a global media company specializing in on demand video streaming to African audiences. I provide BI reports that drive business decisions.
Gathered, analyzed business requirements and converted them into technical specifications.
Developed Oracle Warehouse Builder (OWB) maps and process flows to load multiple Dimensions and Facts.
Created external table objects based on the FSD to read incoming eligibility and claims data from various clients.
Developed ODI components like interfaces, packages and load plans from scratch.
Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into the data warehouse tables.
Developed PL/SQL packages to load data into various marts, dimensions and facts tables.
Coordinated with clients and vendors to setup and test SFTP connections between their servers and HealthFitness.
Experience
5-7 Years
Level
Executive
Education
BS
Data Warehouse Analyst Resume
Objective : Talented and skilled IT Professional with around 5.5+ years of IT experience in working on multiple projects based on data warehousing portfolio as an ETL developer Using Netezza/Oracle and Datastage and Business Object Data Services Ability to understand business problems and apply technology to formulate workable solution.
Reviewed and validated data loaded into the data warehouse for accuracy.
Reviewed documentation, peer code and conducted code walkthroughs Responsible for gathering requirements and designing data warehouse Documented and tested all queries used to pull data for reporting purposes.
Interacted effectively with user community to produce analysis results and analytics requirements.
Ensured data integrity and timely output of daily, weekly, and monthly scheduled jobs.
Performed data replication, extraction, loading, cleansing, and data modeling for data warehouses.
Worked on performance tuning on Netezza by using effective bright light optimization techniques to avoid overhead on source, target and intermediate components.
Experience
2-5 Years
Level
Executive
Education
Computer Application
Data Warehouse Analyst Resume
Headline : More than 9+ years of experience in Business/Data Analysis, Design, and Development of complex software systems. Extensively worked on Oracle 9i, 10g, and 11g using SQL/PLSQL. Experienced in gathering business requirement, analyzing and translating it into technical specifications. Experienced in identifying and implementing Business Intelligence strategies.
Skills : Data Analysis, Software Development, Oracle PLSQL/SQL.
Description :
Always focused on Data Analysis and Data Profile.
Extensively used SQL and Excel to identify, analyze and interpret trends or patterns in complex data sets.
Designed and implemented software solutions to meet complex business requirements.
Independently and concurrently worked on Multiple Projects.
Worked closely with Project Team for gathering requirements.
Interacted with business users and business analysts to translate business requirements into technical specifications.
Involved in defining the source to target data mappings, business rules, and data definitions.
Experience
5-7 Years
Level
Executive
Education
MS In Computer Science
Data Warehouse Analyst Resume
Objective : Responsible for Designing various Access Layers and Data Marts (Physical as well as virtual) by extracting data from the centralized warehouse for complex reporting and analysis, and also Tunning batch queries, views, and reports to run with minimal resource utilization.
Skills : SQL Server, Communication SKills, Accounting Skills.
Description :
Identified and sought personal and professional growth opportunities and proactively contribute to the success of the team and company.
Courageously adapted, celebrated the achievements of others, and take pride in doing quality work.
Developed and leveraged self-awareness and self-management to establish and maintain genuine relationships with colleagues, leadership, and external stakeholders.
Proactively learned about and consciously leverage your unique and powerful Strengths in a manner that supports cohesion and company-wide success.
Acted as liaison with Trading Partners to establish secure data exchange method and troubleshoot issues with file ingestion or validation.
Analyzed EDI X12 and flat file formats containing healthcare data to assure necessary data points are included, data is in an acceptable format, and perform preliminary mapping to assure files can be ingested without issue into the Data Warehouse.
Crafted and distributed analytics of the tracking against established KPIs utilizing Power BI.
Experience
2-5 Years
Level
Executive
Education
M.S. In Database Systems
Data Warehouse Analyst Resume
Objective : Responsible for Performing pre-and post-data load QC to assure data completeness and appropriateness, and also Assisting ETL Specialist regarding any data pipeline issues.
Skills : Managing Skills, Data Warehouse, Multitasking.
Description :
Summited ICMA Reporting initiative has been developed to improve, automate, and introduce more controls around reporting.
Decentralized Accounting unit (DAU) s will be using the tools to conduct their validation and to produce analytics on the portfolio.
Created Detailed Design documents to implement ETL strategy to load ICMA Datamart.
Extracted data from CDW feeds for different instrument types.
Designed DataStage jobs to validate and to produce analytics on the portfolio adhering to EUC needs.
Implemented insert/update strategy using repetitive logic.
Various Lookup build hash files and Load ready files are created in the process Created Batch jobs to load various static dimensions, dimensions, and facts Implemented Roll-forward mechanism for generating Adhoc Reports.
Experience
2-5 Years
Level
Executive
Education
M.S. In Database Systems
Data Warehouse Analyst Resume
Summary : Over 8+ years of total IT experience in the Planning, Analysis, Design, Implementation, and Maintenance in different domains of Financial, Manufacturing, Pharmaceutical, Health, and Retail Oriented companies, 7+ years of Data Warehousing experience in designing and implementing Data Warehouse applications using Informatica Power Center.
Skills : Training Skills, MS Office, Team Work.
Description :
Responsible for designing mappings, sessions, workflows, Mapplets, re-usable transformations, Shortcuts, Performance Tuning, and Error Handling.
Worked closely with the data modeler and with the business intelligence team for data loads into the staging area, ODS, WH, and data marts.
Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
Implemented Informatica Power Exchange CDC Option to capture the changes for up-to-the-minute data and increasing business agility.
Developed divisional sales performance analysis datamart Developed exception analysis process.
Experience
7-10 Years
Level
Management
Education
Bachelors In Computer Science
Data Warehouse Analyst Resume
Headline : With 8+ years of Data Warehouse Analyst professional experience in Data Modeling, designing, and Data analysis with Conceptual, Logical, and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP) systems. Extensive experience in designing robust data models using Erwin, Sybase Power Designer, and VISIO.
Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
Involved in extensive DATA validation using SQL queries and back-end testing.
Used SQL for Querying the database in the UNIX environment.
Developed separate test cases for the ETL process (Inbound & Outbound) and reporting.
Involved with Design and Development team to implement the requirements.
Developed and Performed execution of Test Scripts manually to verify the expected results.
Designed and developed ETL process using Informatica ETL tool for dimension and fact file creation.
Experience
5-7 Years
Level
Junior
Education
GED
Data Warehouse Analyst Resume
Objective : Expertise in designing logical data models and physical structures associated with transactional, data warehouse, and dimensional databases with conformed dimensions. Proven proficiency in translating complex business processes into defined data transformations integrating multiple data sources. Data design documented using ERwin primarily for Oracle.
Skills : Developing Skills, Testing Skills, Test Casing Skills.
Description :
Impacted analysis of existing applications.
Created Source to target mapping document.
Prepared of High level, Low-level design documents.
Developed data cleansing jobs.
Developed UNIX wrapper scripts, Shell scripts for validating the data.
Developed sample test data according to Test cases.
Developed Unit Test cases, System Testing documents with respective Test cases/Scenarios with expected results.
Experience
2-5 Years
Level
Executive
Education
GED
Data Warehouse Analyst Resume
Headline : A results-oriented professional with over ten years of healthcare software development experience including product, program, and project management in addition to over ten years of clinical experience. Well-versed in the software development lifecycle, optimizing cross-functional teams, enterprise solutions, content development, and requirements management with a passion for designing and delivering products that customers love.
Skills : Developing Skills, Planning Skills, Communication Skills.
Description :
Maintained the Teradata database environment over 10 terabytes of data.
Designed and developed 3M's Account Receivable Reporting System on Teradata Platform.
Worked on backup and recovery strategies on mainframe environment using ARCMAIN.
Supported business users in their reports and query performance.
Developed various DBA tools and macros within Teradata to gather various matrices for data warehouse growth analysis, capacity planning and warehouse usage cost analysis.
Developed ELT (Extract, Load, Transformation) processes using Teradata utilities such as MultiLoad, FastLoad, FastExport and BTEQ.
Identified load strategies, physical design and backup/restore strategies.
Creating an account is free and takes five seconds.
You'll get access to the PDF version of this resume template.
Choose an option.
Sign up with Google
Sign up with Facebook
Sign up with Linkedin
This helps us make sure you're human and prevents spammers from abusing our services.
By continuing, you agree to our Privacy Policy and Terms.
Unlock the Power of Over 10,000 Resume Samples.
Take your job search to the next level with our extensive collection of 10,000+ resume samples. Find inspiration for your own resume and gain a competitive edge in your job search.
Get Hired Faster with Resume Assistant.
Make your resume shine with our Resume Assistant. You'll receive a real-time score as you edit, helping you to optimize your skills, experience, and achievements for the role you want.
Get Noticed with Resume Templates that Beat the ATS.
Get past the resume screeners with ease using our optimized templates. Our professional designs are tailored to beat the ATS and help you land your dream job.
