Data Warehouse Developer Resume Sample
Immanuel McKenzie
3936 Dorothy Hills,
Detroit,
MI
+1 (555) 254 9881
Work Experience
Senior Data Warehouse Developer
08/2017
-
PRESENT
Houston, TX
- Leads or acts as chief technical contributor to translation of business requirements to technical specifications
- Leads or acts as the chief technical contributor in the design of new applications or enhancements including integration of purchased solutions in accordance with Enterprise wide strategy
- Oversees/Coordinates the completion of unit testing, integration and system testing, according to detailed test plans to ensure high-quality systems. Assists business partners with User Acceptance Testing
- Leads or acts as a key subject matter expert for all or portions of the set of applications aligned with a sub-domain or domain
- Serves as team leader to direct technical activities (including analysis, planning, architecture, design, development, testing, installation, and maintenance of support systems for business areas)
- Interacts and receives general direction from the Business, Project Managers or Application architects
- Apply industry wide understanding of technology, tools and methodologies to assist in developing solutions on projects of strategic significance. Evaluate and identify issues and constraints pertaining to technology approach; coordinate evaluation of solutions to insure adherence to Aetna technology standards (such as security, database, etc.)
- Be part of the ‘Run the Engine’/L2 application support activities and incident resolutions in Production
- Collaborate with BA’s, data architects, application leads, QA analyst and production support, through SDLC
Data Warehouse Developer
04/2013
-
02/2017
Los Angeles, CA
- Assist your Team Manager and the Software Architect with systems design and development governance, as well as the production of system and integration test plans
- Understand the technical interfaces with other departments such that a mentoring role can be played to other developers
- Be a point of reference for technical issues
- Advanced/expert level knowledge of database processing concepts and techniques
- Advanced/expert level knowledge of MSSQL scripting and coding
- Advanced/expert level knowledge of the ETL process
- Working knowledge of the Windows Server O/S platform
- Working knowledge of Qualys vulnerability scanning product
Junior Data Warehouse Developer
06/2007
-
03/2013
Los Angeles, CA
- To deliver quality code to defined standards in order to satisfy business demand for system maintenance and application development
- To produce quality technical and functional specifications in line with demand
- To produce plans for, and carry out, thorough unit testing and to contribute successfully to system testing where appropriate
- To provide accurate estimates where required and to contribute to successful project planning and progress monitoring
- To provide clear and accurate progress reporting on any given tasks
- To adopt a delivery and quality focussed approach
- To provide technical and process advice and guidance to juniors and analyst programmers where necessary
- To be pro-active in seeking out solutions to issues being experienced by team members
- Gain an in-depth knowledge of Admiral technology such that a mentoring role can be played on most projects
Education
York University
2002 - 2006
Bachelor's Degree in Computer Science
Professional Skills
- Strong systems/process orientation with demonstrated analytical and conceptual thinking, organization skills and problem solving skills
- A positive self-starter with a solid work ethic, ability to meet deadlines, strong organizational skills and excellent interpersonal skills
- Excellent written and verbal communications skills along with exceptional customer service skills
- Strong ETL experience, SQL SSIS experience, SQL Server experience, T- SQL experience, Visual Studio, and SQL & Query Tuning
- Demonstrated excellent communication skills with business and technical teams
- Strong data manipulation skills and experience with data warehosue ETL tools and processes
- Use fine motor skills to operate office equipment and/or machinery Ability to properly drive and operate a company vehicle
How to write Data Warehouse Developer Resume
Data Warehouse Developer role is responsible for sql, development, server, technical, database, analytical, programming, customer, business, integration.
To write great resume for data warehouse developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Data Warehouse Developer Resume
The section contact information is important in your data warehouse developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Data Warehouse Developer Resume
The section work experience is an essential part of your data warehouse developer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous data warehouse developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular data warehouse developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Data Warehouse Developer resume experience can include:
- Proven strong SQL skills
- Display strong data analyzing skill and troubleshooting skill
- Strong self-learning ability and multitasking ability to manage time effectively
- Proven skills in developing robust, extensible, scalable Data Warehousing relational and dimensional data models
- Experience SQL coding/querying skills in SQL Server and/or MySQL
- Strong SQL development skills -- knowledge of writing complex queries, stored procedures, and query tuning
Education on a Data Warehouse Developer Resume
Make sure to make education a priority on your data warehouse developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your data warehouse developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Data Warehouse Developer Resume
When listing skills on your data warehouse developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical data warehouse developer skills:
- Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team
- Effective communicator with excellent analytical and problem solving skills
- Understanding of design patterns, best practices, analytical thinking and good troubleshooting skills
- Strong skills in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite
- Strong skills working with slowly changing dimensions
- Solid analytical skills and ability to examine requirements, re-engineer existing processes, envision new concepts and deliver complete reporting solutions
List of Typical Experience For a Data Warehouse Developer Resume
1
Experience For Senior Data Warehouse Developer Resume
- Excellent SQL and T-SQL development skills
- Strong analytical skills desired to solve problems required
- Experience: Typically entry level; less than 2 years IT Software Developer experience (in addition to any experience identified above)
- Advanced SQL skills and proficiency with Stored Procedures
- Strong Data Warehouse design / development experience
- Relational data modelling skills
- Strong Test Data Management (TDM) experience required
- Experience with Azure Services and other cloud experience
2
Experience For Lead Data Warehouse Developer Resume
- Experience with Azure Services and other cloud experience required
- Proven experience developing and deploying data warehouses
- Understanding and experience with dealing with star schema models in use of a data warehouse
- Scripting experience with Windows and/or Python
- Working experience in at least one of the BI tools such as Power BI, Tableau, Spotfire, Microstrategy
- Experience designing, developing, testing, and supporting of ETL, and OLAP cubes
- Experience designing, building, developing and supporting end-to-end ETL strategies
- Experience with: data staging through Informatica or PL/SQL; Physical Data Modeling; Query optimization and tuning; Unix and Unix Shell scripting
3
Experience For SQL / ETL / Data Warehouse Developer Resume
- Experience developing Cubes in SSAS in SQL Server using a Kimball approach including cube security, user defined hierarchies, and MDX
- Strong understanding of common database technologies including performance, tuning, and optimization
- Experience developing applications, preferably in Java using the Spring Framework
- Experience developing database solutions - developing SQL stored procedures, complex functions, and processing large datasets
4
Experience For Enterprise Data Warehouse Developer Resume
- Excellent understanding of VLDB performance (partitioning, sharding, table distribution and extreme optimization)
- Experience with logical and physical data modeling, data warehousing, data querying languages and data strategy
- Strong T-SQL coding, creating & editing
- Experience mentoring developers/development teams/technologists charged with providing data access to internal customers in a safe, reliable, secure manner
- Experience collaborating with customers in multiple geographic locations and from various engineering disciplines
- Experience modeling and analyzing complex software systems
- Experience with database modeling, design, and ETL programming
- Experience with Database development, administration, debugging, and tuning
- Experience using SQL Server in a Data Warehouse using Kimball methodology star schema design
5
Experience For Senior Data Warehouse Developer ETL Resume
- Experience creating and updating perspectives and drill through on SSAS Cubes
- Experience in developing reports using tools like Tableau, Business Objects, Cognos, and etc
- Excellent working knowledge of data warehousing
- Experience with Linux/UNIX operating system and shell scripting
- Experience generating reports using Crystal Reports
6
Experience For DB \ Data Warehouse Developer Resume
- In-depth understanding and demonstrated proficiency in data warehousing concepts, best practices, and dimensional database design
- Contribute to the AI/Machine Learning vision for our products maximizing efficiency and effectiveness for our customers with best in class analytics
- ETL Lead with hands-on experience in designing and implementing data warehouses and data marts for large financial institutions
- Strong understanding of data normalization rules, denormalization and other techniques to support reporting and analytics
- Design, direct and implement ETL\ELT processes, including data capture, data quality, testing and validation methods
- Experience working with code versioning framework like Git or SVN
- Experience including data analysis, data integration, dimensional modeling, database design and development
- Experience understanding complex data warehousing performance management
- Experience with database programming and design, including mastery of complex report queries and SQL optimization
7
Experience For ETL / Data Warehouse Developer Resume
- Strong grasp of advanced SQL writing and query tuning/optimization
- Experience in developing ETL using Oracle/PL SQL
- Support the testing and validation of all solutions, ensuring accuracy
- Experience developing large data warehouse and data mart applications; preferably using Teradata DBMS
- Experience developing large data warehouse and data mart applications; using Teradata DBMS
- Experience with financial budgeting and forecasting processes, allocations and driver-based calculations
- Experience with Database development, administration, debugging, and tuning in SQL Server required
- Good understanding of data warehousing
- Strong knowledge of Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools e.g. Qlikview, Power BI, Crystal Reports
8
Experience For Junior Data Warehouse Developer Resume
- Experience with server side scripting and programming in a linux environment (primarily bash shell)
- Experience evaluating existing data warehouse implementation, architectures and processes
- Experience working directly with business analysts or business sponsors clarifying business details
- Experience working on data warehousing systems
- Experience reading and creating dimensional data models (Star Schemas)
- Experience reading and creating traditional Codd 3rd Normal Form data models
- Practical experience extracting data from multiple sources (Oracle or IBM iSeries desirable) using data integration tools such as SSIS or Informatica
9
Experience For Data Warehouse Developer / Analyst Resume
- Experience with preparing and publishing Meta Data and Data Dictionaries in support of Corporate Data Governance
- Experience with data warehousing, including work on ETL
- Experience in OBIEE repository, including physical, business model, and mapping and presentation layers
- Experience with Oracle Public Sector Planning and Budgeting (PSPB) implementation with employee and position configuration
- Development experience including design patterns and building modular/clean code
- Experience Monitoring jobs, Logging, Incident definition and notification
- Experience with SQL Server, including writing T-SQL, SSIS, SSRS and SSAS required
10
Experience For Data Warehouse Developer Oracle SQL, PL / SQL Resume
- Good knowledge developing and deploying applications in Azure environment required
- Strong understanding of physical database design and modeling
- Experience working with ETL (extraction, transformation and loading) technologies
- Years of experience developing and supporting moderate to complex data warehouses or data marts
- Experience working with Informatica Power Center, developing mappings and workflows
- Strong grasp of Kimball data warehouse methodology (ETL processing and dimensional data modelling)
- Proficient in all phases of data warehousing concepts and experience in dimensional modeling
- Data warehouse experience in Data Extraction, Data Integration and Data Mining for decision support system using ETL and OLAP tools
- Experience working with or leading offshore resources
List of Typical Skills For a Data Warehouse Developer Resume
1
Skills For Senior Data Warehouse Developer Resume
- Strong knowledge of data warehousing and demonstrated experience in designing dimensions
- Proficient computer skills, including experience with Microsoft Development Suite or other applicable technology suites
- Strong communication and interpersonal skills, including the ability to work with all levels within the organization, are required
- Strong MS SQL Server skills (ability to write complex queries and implement performance tuning)
- Strong skills working with relational and dimensional data models
- Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff
- Demonstrated knowledge and skills in requirements gathering
2
Skills For Lead Data Warehouse Developer Resume
- Strong troubleshooting and problem resolution skills and Ability to work with cross-functional teams
- Strong MS SQL Server skills, working with dynamic SQL, stored procedures and T-SQL
- Strong communication, time management, organization, decision making and customer service skills
- Creative and analytical thinker with demonstrated problem solving skills
- Proficient technical programming skills and experience with Base SAS, SAS/SQL, SAS/STAT and SAS/Macros
- Demonstrated skills in establishing data warehouse best practice standards
3
Skills For SQL / ETL / Data Warehouse Developer Resume
- Strong Informatica Power Center development skills
- Position requires excellent communication skills, to interface with several different projects/teams as workload demands naturally shift
- Excellent skills in the architecture of data warehouse and data integration strategies and solutions
- DLC with strong skills in MS SQL Server (2008 or higher)
- Strong SQL Server 2008/2012/2016 skills
- Good languages skills in English and German
- Strong communications skills suitable for customer communications by phone, email, and in-person
- Strong research skills and familiarity with complex data sources such as Census and educational information systems
- Strong positive, interpersonal communication skills; and
4
Skills For Enterprise Data Warehouse Developer Resume
- Using robust analytic thinking skills with the ability to identify, debug, and resolve technical issues
- Communicating effectively both verbally and written with project team members; and,
- Developing skills in the architecture of data warehouse and data integration strategies and solutions
- Prioritizing data clarity, accuracy and validity
- Programming skills in C# and/or PowerShell
- Knowledge of query performance tuning and basic DBA skills including database file system understanding and table partitioning in SQL Server
- Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support)
5
Skills For Senior Data Warehouse Developer ETL Resume
- Moderate skills working with slowly changing dimensions
- Demonstrated working experience with data warehousing development
- Strong Experience in Installing and/or Upgrading Informatica
- Python scripting experience and experience writing custom libraries
- Track record of working effectively within a team
- Skills in navigating a large organization in order to accomplish results
6
Skills For DB \ Data Warehouse Developer Resume
- Moderate skills working with relational and dimensional data models
- Logical and physical data modelling skills
- Demonstrated experience working on data warehouse systems
- Data Warehouse ETL Development experience using commercial ETL tools, and SSIS experience
- Expert level SQL Scripting and Stored Procedure development skills
7
Skills For ETL / Data Warehouse Developer Resume
- Demonstrate hands-on experience leading the architecture, construction, and deployment of an end-to-end ETL platform
- Strong experience developing ETL for a Data Warehouse
- Strong knowledge & Experience of Analysis, Reporting, Integration Services
- Strong SQL tuning experience and query optimization
- Prior experience with architecting complex ETL processes
- Strong development experience using the Microsoft BI stack (SQL Server 2014 / 2016)
- Strong experience with SSIS developing end to end ETL processes
- Experience with Cognos including 1+ years experience with Cognos 10
- Pro-actively seeks out on the job training from other resources to increase both technical and professional skills
8
Skills For Junior Data Warehouse Developer Resume
- Expert level PL/SQL programming skills
- Solid UNIX command level experience; Shell Scripting and build automation knowledge; Knowledge of Linux
- Communicate technical information effectively to business users and to communicate business needs to technical teams
- Advanced T-SQL development skills
- Has analytical skills and is accountable for his/her actions
- Be able to build/Create reports in SSRS (a good skill to have but not required)
- Experience with query performance tuning techniques required. Hands on experience in performance tuning of SQL scripts required
- Experience integrating DW data with other data sources via ESB. (i.e. MuleSoft)Informatica Cloud experience
9
Skills For Data Warehouse Developer / Analyst Resume
- ) Extensive experience developing complex SQL scripts - Additional SSIS experience for ETL processes is a nice-to-have
- Solid Agile / Scrum experience required
- Prior DBA experience in Microsoft SQL Server
- Big data development skills desirable such as Hadoop, Spark, Hive, Python
- Effectively communicate with other team members to exchange information, ideas and answer inquiries
- Work effectively across internal functional areas in ambiguous situations
- Solid development experience with erwin EA, MS SQL Server 2012/2014/2016, SQL Server Agent, T-SQL, SSIS, SSAS
10
Skills For Data Warehouse Developer Oracle SQL, PL / SQL Resume
- Participate in company development of strategy, processes, skills and operational practices for the support database integration and development
- Interpersonal and communication skills with the ability to rapidly communicate technical concepts to technical team members
- Excellent SQL Developer experience with Microsoft SQL Server 2008R2 and SQL Server 2012 R2
- Expert Azure SQL skills
- Possess good experience with C#, .NET, and JSON required
List of Typical Responsibilities For a Data Warehouse Developer Resume
1
Responsibilities For Senior Data Warehouse Developer Resume
- Think strategically with supporting analytical and problem-solving skills, including the ability to deal with ambiguity
- Reading and creating traditional Codd 3rd Normal Form data models; Experience with Informatica PowerCenter
- Experience designing, developing and implementing large scale data warehousing initiatives
- Experience in Business Objects, Tableau, Qlikview, interest in building UI and reporting suites
- More than 5 years of experience on designing and developing Data Warehouse solutions on
- Experience in developing applications in a high volume ETL DataStage environment
2
Responsibilities For Lead Data Warehouse Developer Resume
- Experience developing ETL processes in SSIS in a Kimball based star schema design
- Experience developing SSRS reports based on Analysis Services cubes
- Experience in writing complex SQL queries, stored procedures, triggers, and functions
- Experience using tables and views in SQL Server
- Experience in developing applications in a high volume ETL DataStage environment
- Experience creating column store indexes
- Hands-on experience in data warehousing development and design
- Five years of experience in SQL programming (PL/SQL or T-SQL); at least three of which are in SQL Server 2005/2008
- Experience in converting stored procedures from Informix or Oracle to SQL Server
3
Responsibilities For SQL / ETL / Data Warehouse Developer Resume
- Experience working within Agile framework and related lifecycle methodologies
- Experience working with automation tools like TIDAL or related technologies
- Experience working with Informatica desired
- Experience working with Netezza and/or Oracle desired
- Experience in Java or other programing languages desired
- Motivated, good at communicating with technical and non-technical business associates, and superb work ethic
- Experience in Business Intelligence and Data Warehousing
- Knowledge of and hands-on experience in Meditech: data extracts, data structures, reporting
- Previous experience of mentoring others within a development team
4
Responsibilities For Enterprise Data Warehouse Developer Resume
- Exposure or experience to the following technologies is highly recommended
- Experience in analytics, data correlations, and large data processing and data volume optimizations
- Strong interest in data warehousing and business intelligence
- Deal with large data sets; Query tuning and optimization experience
- Experience working with data stored in SAP environments
- Experience in developing ETL processes with data from various sources: NoSQL, SQL Server, Oracle, Online contents
5
Responsibilities For Senior Data Warehouse Developer ETL Resume
- Excellent understanding of Application Architecture and relational data models
- Excellent opportunity to immerse in and learn within the Market Sales Analytics and gain exposure to Equities and Fixed income products/asset classes
- Experience with SQL, Teradata, Oracle in Unix environment
- Work as an advanced contributor to the Data Warehouse team, with supervision but leeway to operate independently
- Ensure newly designed systems run as needed, perform validity check on production output
- Strong knowledge of current relational database and big data software and query concepts
- Cross-functional experience with sales, human resources, finance, or operations
6
Responsibilities For DB \ Data Warehouse Developer Resume
- Technical team leader experience
- Strong background in data and business intelligence project work
- Expert with SQL and PL/SQL, Experienced with Oracle databases
- Experience with Banking data (product, accounts, customers, payments), data reconciliation, ability to trace data from source systems to target systems
- Experience with database as a service in Azure
- Experience with SQL Server 2016
- Expert knowledge of interface engines and protocols. Experience with HL7, X12 and/or XML and OPENLink
- Experience in business intelligence tools, especially SAP Business Objects Web Intelligence
7
Responsibilities For ETL / Data Warehouse Developer Resume
- Understanding of star schemas, dimensional modeling, and data warehousing concepts (including keys & transactional statements)
- Designing and creating Microsoft SQL Server Analysis Services tabular data model, as well as developing maintenance plans
- Interpreting, testing, and challenging business-supplied rules and calculations into data warehouse transformation logic
- Working knowledge of content management systems and information delivery and reporting tools
- Troubleshooting errors and debugging code
8
Responsibilities For Junior Data Warehouse Developer Resume
- Supporting and extending the corporate Data Warehouse
- Responding to and engaging with data analysts to research and clarify information or patterns in data
- Suggesting customer-facing and infrastructure related improvements for the product backlog
- Managing and Maintaining the enterprise-class Data Warehouse
- Translating operational and business needs into technical solutions
9
Responsibilities For Data Warehouse Developer / Analyst Resume
- Working knowledge of Microsoft SQL Server administration, stored procedures, query plans, etc
- Identifying dimensions and subject areas
- Working with non-standardized data from external sources
- Understanding of education and/or terminology
- Understanding of Kimball mothodology
10
Responsibilities For Data Warehouse Developer Oracle SQL, PL / SQL Resume
- Converting analyst prototypes/proof of concepts into robust enterprise data sources
- Creating and maintaining Linux shell scripts
- Designing and developing ETL in conjunction with the design governance of the data warehouse architecture
- Contributing to the data warehouse design and following through to a successful implementation
- Supporting live systems ensuring availability for business users in a timely fashion
- Developing solutions on the Kognitio database platform
- Working alongside other team members on multi developer projects
- Developing an intimate and detailed knowledge of the business data structures
- Working knowledge of Database/Data Warehouse design – Kimball methodology
Related to Data Warehouse Developer Resume Samples
Data Warehouse Resume Sample
Work Experience
• Experience in diagnosing and resolving root cause of performance problems
• Monitors performance of major elements on an on-going and historical basis
• Proven experience in maintaining and supporting multiple major or critical applications
• Experience...
Professional Skills
• Excellent communication skills, experience...
• SQL Server ETL Development experience usin...
• Strong analytical skills and experience wi...
Data Warehouse Analyst Resume Sample
Work Experience
• Consistently exhibits behavior and communication skills that demonstrate HealthCare Partners’ (HCP) commitment to superior customer service, including quality, care and concern with each and every internal and external customer
• Uses, protects, and discloses HCP patients’ protected health informat...
Professional Skills
• Excellent communication skills, organizati...
• Strong data analysis skills. Hands on expe...
• Strong analytical and problem-solving abil...
Data Warehouse Consultant Resume Sample
Work Experience
• Demonstrates excellent customer service to users and partners
• Develop user communications for analytic platforms data warehouses, applications and systems
• Provides business knowledge regarding the appropriate use of data elements and cooperates with existing business proc...
Professional Skills
• Excellent analytical, problem-solving and ...
• Strong Communication, analytical and inter...
• Demonstrated experience developing measure...
Inventory / Material Resume Sample
Work Experience
• Receives, stores and issues materials, supplies and merchandise. Compiles and verifies stock records against source documents. Ships end products. Loads, unloads and moves materials within and outside the plant. Performs tasks with minimal supervision
• Unloading/handling, opening/sorting packages,...
Professional Skills
• To support, execute and assist in the deve...
• To implement and execute Standardized Proc...
• Experience in Inventory analysis, systems ...
Inventory Logistics Resume Sample
Work Experience
• Using Bard’s ERP system(s) and other service management systems, manages the S&R repair parts, component, and accessories inventory for U.S. service operation
• Maintain awareness and comply with Bard’s Quality Management System, specific Quality policies, and any applicable laws and regulation...
Professional Skills
• Responsible, hardworking and motivated wit...
• Work independently and with strong initiat...
• Able to work in a fast paced environment a...
Sales / Warehouse Resume Sample
Work Experience
• Assist in TWW’s banking including deposits, reconcile to EOD report, confirm check and cash balances, process of credit cards and other
• Sells industrial, medical and specialty gases, welding supplies and related equipment to customers
• Advises customer on equipment and mat...
Professional Skills
• Strong interpersonal skills including sale...
• Proven success in sales and providing exce...
• Capable of working in a fast paced environ...