Data Warehouse Developer Resume Samples

A Data Warehouse Developer is hired for analyzing, organizing, retrieving, and extracting data for staging, accessing, and integrating information. A professional Data Warehouse Developer Resume highlight certain responsibilities such as – working on internal projects; gathering inputs from various sources; preparing study materials for training batches; developing analysis reports; designing and implementing data models for database applications; determining source data of different types and designing programs for extraction.

Summary of skills that can highlight a resume includes – strong understanding of Data Warehouse and business intelligence concepts; profound knowledge of reporting OLAP tools; in-depth knowledge of data modeling and database design; and a solid understanding of transactional, and multi-dimensional databases. While there are no standard education specifications, employers prefer those having a degree or masters in IT of the related areas.

 

Data Warehouse Developer Resume example

Data Warehouse Developer Resume

Objective : Over 11 years of IT experience in Data Analysis, Design, coding and Informatica/MDM/Data Quality (IDQ) and Development of Data Warehousing implementations across Retail, Financial, Pharmaceutical, Health care, Insurance and Mortgage Industries. Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star- Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.

Skills : PL/SQL, SQL, ETL, Data Modeling, Java, Python, Reporting.

Description :

    1. Experienced of CVS in implementing major Retail Projects, The existing Enterprise Pharmacy Management System needs to be developed and maintained, The scope of the project is to understand current application, design, develop, test, rollout, support and document.
    2. Designed and developed Informatica mappings for data loads Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
    3. Designed OLAP data mart for worker's compensation reporting Created Data Stage (ETL) jobs to denormalize and load OLTP data Developed DB2 SQL and .
    4. Analyzed data source to designed simple and efficient query transforms Loaded data from flat files Designed work flows and data flows Cleaned data in .
    5. Reviewed documentation, peer programming, code reviews, and conducted code walkthroughs.
    6. Resolved issues and provided on-call support for production database.
    7. Demonstrated ability to utilize cognos report studio for testing and report writing.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors Of Engineering


Sr. Data Warehouse Developer Resume

Objective : Around 9 years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica. Worked on various domains including Hospital & Health Care, Energy (Oil & Gas), Manufacturing, Telecom, Retail, Finance. Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.

Skills : Informatica, OBIEE, Teradata.

Description :

    1. Conducted JAD sessions with business users and SME's for better understanding the requirements and to define business and functional specifications.
    2. Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
    3. Transformed business requirements into technical specifications, source-to-target mappings.
    4. Extracted data from DB2 VSAM files, XML Files, Flat Files and populated into Teradata Warehouse.
    5. Developed Complex transformations, mapplets using Informatica to Extract, Transform and load data into Datamarts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
    6. Analyzed data source to designed simple and efficient query transforms Loaded data from flat files Designed work flows and data flows Cleaned data in .
    7. Demonstrated skill utilizing sql server management studio r2 (ssms) and sql server integration services r2 (ssis).
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
BA In MIS


Jr. Data Warehouse Developer Resume

Summary : Datawarehouse Developer role in the development, deployment and support of data warehousing solutions that support Open Systems architecture including internet, intranet, reporting and business intelligence applications using prescribed technologies and methodologies.

Skills : Product Management, Data Warehousing, Business Intelligence, Business Analysis, SQL.

Description :

    1. Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
    2. Conducted Joint Application Development (JAD) sessions with IT groups.
    3. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
    4. Unified Modeling Language (UML), Object Oriented Analysis and Design (OOAD) using use case, activity and state chart diagrams.
    5. Worked on Master Data Management (MDM) processes that involved collection, aggregation, consolidation, distributions and quality assurance of the data as per the project need.
    6. Experienced in Master Data Management (MDM), Data Mining, Data Mapping, Data Profiling & Data Warehousing.
    7. Responsible for implementing Scrum Methodology as well as on SDLC procedures in the implementation of Tableau/Spotfire.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Arts In Spanish

Data Warehouse Developer III Resume

Objective : Over 15 years of experience in database design, administration and data analysis Extensive experience with Structured Query Language MS Reporting Services and Crystal Reports experience including implementations and administration Excellent communication skills with emphasis on supporting the customer.

Skills : Oracle, Unix Administration, Toad, SQL, UML, Powerpoint, Excel, Visio, Word.

Description :

    1. Centralized data warehouse was responsible for maintaining Nextel's customer information, their account and payment history, billing information, statements history, etc.
    2. Membered of the warehouse design team, which interacted with the business community and database administrators to identify the business requirements.
    3. Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational, XML and flat file sources into the data mart.
    4. Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
    5. Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
    6. Implemented complex mapping such as Slowly Changing Dimensions Type1, Type 2, Type3.
    7. Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for other mappings.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Arts In Spanish

Data Warehouse Developer II Resume

Objective : 6+ years of ETL and data integration experience in developing ETL mappings using ETL tool - Informatica Power Center 9.x./8.x./7.x. (Designer Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), experience in using Informatica Client tools: Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager.

Skills : Data Warehouse Architect, Teradata DBA, Data Architect, Data Modeler.

Description :

    1. Analyzed business requirements and worked closely with the various application teams and business teams to understand business requirements and the source data.
    2. Involved in designing logical models for staging, production warehouses using ERWIN 3.0.
    3. Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
    4. Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
    5. Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
    6. Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
    7. Partitioned sources to improve session performance.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
M.A. In Biomedical Informatics

Data Warehouse Developer I Resume

Objective : Overall 7+ years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications. Extensive experience with Informatica Power Center 9.x, 8.x, 7.x. Expertise in working with Informatica, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities.

Skills : Microsoft Office, Visio, Sap, Business Objects, Sql Server.

Description :

    1. Worked closely with business analysts and data analysts to understand and analyze the requirement to come up with robust design and solutions.
    2. Involved in standardization of Data like of changing a reference data set to a new standard.
    3. Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
    4. Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
    5. Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
    6. Involved in Exception Handling Mappings for IDQ.
    7. Involved in IDQ process the team considered to create the Column Profiling.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
MBA In Business Administration

Assistant Data Warehouse Developer Resume

Objective : Overall 8+ years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications. Extensive experience with Informatica Power Center 10.x, 9.x, 8.x, 7.x. Expertise in working with Informatica Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities.

Skills : Program/Project/Operations/Contract Management, Business Development, Scrum, Agile, Data Architecture, Data Warehousing, Business Intelligence.

Description :

    1. Created indexes, materialized views, partition tables as well as recommend oracles best practices to the data analysts and other developers in the .
    2. Reviewed requirements for Web-based applications and developed the databases needed to support the front-end applications Worked on table .
    3. Automated batch processes with Perl scripts to perform data loads to Oracle Database from external financial vendors (State Street, Bloomberg, etc.) .
    4. Worked with Variables and Parameters in the mappings to pass the values between sessions.
    5. Performed development and testing duties for ROI, UCB/POR, Proof of Revenue, PAL Lighting and Audit projects.
    6. Developed, tested and deployed data replication solution based on IBM's Enterprise Data Propagator (EDP) for multiple projects.
    7. Created Detailed Designs for slowly changing dimensions for core dimensions in the database (Bill Account, Premise, etc ).
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Post Graduate Diploma

Associate Data Warehouse Developer I Resume

Objective : Functions include designing, developing, testing, debugging, supporting and documenting ETL processes for enterprise-wide Data Warehouse implementations.

Skills : Software Development, Database Development, Web Development,.

Description :

  • Designed, and developmented of data warehousing and business intelligence components
  • Maintained existing data warehousing and business intelligence applications and processes using a standardized suite of software development products.
  • Implemented new application components and processes for data warehousing and business intelligence environments
  • Developed software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.
  • Provided technical and functional troubleshooting of software bugs
  • Met with customers to gather and/or clarify requirements associated with a data warehousing or business intelligence deliverables.
  • Performed detaile analysis and documentation and assist in determining the best solution for meeting the needs of the customer.
     
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Data Warehouse Developer/Manager Resume

Objective : 10 years of IT experience in Data Analysis, Design, coding and Informatica,MDM, Data Quality (IDQ) and Development of Data Warehousing implementations across Retail, Financial, Pharmaceutical, Health care, Insurance and Mortgage Industries. Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star- Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.

Skills : BODS BODI Oracle SQL, 

Description :

    1. Ability to work as a team player to achieve results. Must be able to build positive working relationships with database administrators, ETL developers, and BI developers.
    2. Responsible for the development of complex ETL processes for all projects assigned.
    3. Design data infrastructure across all technical environments
    4. Participate in the design, completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
    5. Designed and planed for the integration for all data warehouse technical components.
    6. Provided input and recommended on technical issues to the project manager.
    7. Participated in testing of the data design, tool design, and data extracts/transforms.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Data Warehouse Developer Resume

Objective : Over 9 years of IT Experience as MS SQL Server Developer, and involved in Design, Development and Support of MSSQL Server for various business domains like Pharmaceuticals, Constructions, financial services and Health Care. Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.

Skills : BODS BODI Oracle SQL.

Description :

    1. Partnered Healthcare is a health care system that is committed to patient care, research, teaching and service to the community locally and globally.
    2. Gathered business requirements, created specification documents, data mapping, data quality analysis, working in conjunction with the data warehouse team on the development of logical data models.
    3. Worked as a developer in creating complex stored procedures, triggers, and user defined functions.
    4. Managed index statistics, tables, views, cursors and optimizing queries by using execution plan for tuning the database.
    5. Implemented different types of constraints on tables.
    6. Responsible for MySQL installation, configuration setup, DB systems administration, provisioning, troubleshooting database performance problems.
    7. Performanced tuning to optimize SQL queries to improve data retrieval using query analyzer and DMV.
    8. Worked on array of .NET Services built to read incoming EDI 834 files, process the data into individual XML transactions and prepare them for sending them to the Facets database via the FXI web services.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Technology In Technology