Data Warehouse Developer Resume Samples

The Guide To Resume Tailoring

Guide the recruiter to the conclusion that you are the best candidate for the data warehouse developer 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.

Create a Resume in Minutes

J Douglas

Jessie

Douglas

21620 Auer Union

Boston

+1 (555) 207 7473

21620 Auer Union

Boston

Phone

p +1 (555) 207 7473

Experience Experience

San Francisco, CA

Data Warehouse Developer

San Francisco, CA

Weissnat and Sons

San Francisco, CA

Data Warehouse Developer

Assist ETL developers with specifications, documentation, and development of data migration mappings and transformations for Data Warehouse loading
Evaluates performance and conducts performance management planning
Assists in the development of standards and procedures affecting database management, design and maintenance
Provide support and participate with development team during the analysis, design, coding, development and testing processes
Design and develop ETL processes. Establish coding standards, perform code review and automate the health of the platform
Perform data analysis, develop database design, share and get consensus on design, and then develop the stored procedures to fulfill the database design
Manages end-user accounts and accessibility; provides technical expertise to end-users who create complex queries and reports

New York, NY

Data Warehouse Developer / Analyst

New York, NY

Okuneva, Herzog and Mertz

New York, NY

Data Warehouse Developer / Analyst

Assisting the team with performance tuning for ETL and database processes
Design, develop, implement and assist in validating processes
Self-manage time and task priorities and of other developers on the project
Work with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data
Develop mapping / sessions / workflows
Conduct ETL performance tuning, troubleshooting, support, and capacity estimation
Map sources to targets using a variety of tools, including BusinessObjects Data Services/BODI. Design and develop ETL code to load and transform the source data from various formats into a SQL database

present

Detroit, MI

Senior Data Warehouse Developer

Detroit, MI

Smith-Hoeger

present

Detroit, MI

Senior Data Warehouse Developer

present

Provide “level 3 support” which includes development of minor/major enhancements, defect fixes and provide work around to business problems
Develop new ETL applications, maintain, support and improve the performance of existing applications in production
Analyze performance issues, perform RCA and provide resolutions for immediate fix and also recommend/build long term solutions to resolve the root cause
Complete projects and development activities timely and accurately while following the System Development Life Cycle (SDLC)
The role will provide an opportunity to work best in class data warehouse team with downstream integration systems
Work with users on SAS issues and provide training and mentoring to consumers of the SAS services
Establish best practices, processes and focus on continous improvement

Education Education

Bachelor’s Degree in Computer Science

California State University, Fullerton

Bachelor’s Degree in Computer Science

Skills Skills

Strong knowledge of SQL Server 2008 R2 (or higher), excellent knowledge of SQL queries, stored procedures and triggers
Basic understanding of creating business reports using Tableau, ability to troubleshoot issues in report generation
Strong desire to develop business knowledge
Will work closely with business users and able to support month end, quarter end and year end reporting production cycles with ownership and accountability
Excellent analytical and problem-solving ability
Strong communication skills; particularly with business partners with less technical knowledge
Very strong SQL knowledge and performance tuning of SQL. Master of relational database concepts and implementation
Strong written and oral communication skills; excellent organization skills
Strong organizational skills with attention to detail
Demonstrates knowledge and proven application of knowledge within a specific discipline(s)

Create a Resume in Minutes

15 Data Warehouse Developer resume templates

Read our complete resume writing guides

ETL Informatica Data Warehouse Developer Resume Examples & Samples

Document the detailed application specifications, translate technical requirements into programmed application modules and develop/Enhance software application modules
Design Informatica workflows and mappings for optimal performance in a large scale Unix/RDBMS environment. Tune Informatica workflows; knowledge of optimal mapping techniques
Development in a data warehousing environment, with expertise in: CDC, type-2 processing, dimensional surrogate key handling, exception data processing, etc
Create and manage PL/SQL packages, triggers, and stored procedures, views, SQL transactions. Proven ability writing SQL statements
Bachelor's/Master's Degree in Computer Science or related field
8+ years of professional experience in the field of information and technology
3+ years of experience in Data Management
Experience with all Informatica Power Center transformation types and reusable components
Experience in PL/SQL, SQL*Loader, PERL, scheduling tool and UNIX Shell scripting required
Demonstrate understanding of the criticality in adhering to architecture standards, risk management and security policies
Knowledge of version and revision control practices and procedures
Strong analytical and communication skills and an eagerness to learn new technologies
Demonstrated experience working with a project team to develop a design, technical solution, and ultimately to implement high quality technical solutions
Demonstrated ability prioritizing and managing development and implementation of enhancements/changes to multiple applications

Am-etl Data Warehouse Developer Resume Examples & Samples

Data Warehouse ETL design, development and support
Participate in the analysis and design of system solutions to meet business needs
Performance tuning, code promotion and testing of application changes
Creation of batch scheduling workflows to automate processing of feeds
Development of data-marts, extracts and reporting
Create technical and detailed data mapping documents for ETL development
B.S. (Computer Science preferred)
1 to 3 years of software development experience
Experience with ETL development (experience with Informatica PowerCenter 8.x a plus)
Experience with Databases (SQL, design, indexing, tuning, etc.)
Experience with Business Intelligence tools (Business Objects XI)
Experience with Batch Scheduling tools (Control-M is a plus)
Knowledge of UNIX scripting, commands and systems
Knowledge of Data Warehousing concepts
Proven ability as a member of a team to communicate technical and production related concepts to a broad range of technical and non-technical staff
Demonstrate experience in effective decision making within a high pressured environment

Data Warehouse Developer Resume Examples & Samples

Design and implementation of Data Warehouses, planning applications and reporting solutions
Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts
Gather requirements and create system and user documentation
Develop solutions to leverage ETL tools and identify opportunities for process improvements
Conduct root cause analysis and resolve production problems and data issues
Provide technical expertise and recommendations in analyzing customer needs, document requirements, and design technical solutions
Create test plans, test cases, test scripts and perform data testing and validation
Work with existing systems to track and manage requests and issues
5+ years experience including data analysis, data integration, dimensional modeling, database design and development
Advanced SQL skills are a must
Strong relational database knowledge
Experience in Unix Scripting
Proficiency in ETL/ELT Tools like Informatica (preferred), IBM Infosphere DataStage 8.x or higher and Data Integrator
Development experience in cubes preferably with SQL Server Analysis Services (SSAS)
Data Virtualization experience in CISCO Composite or CISCO Information Server
Experience with MDX
Perl Scripting

Senior Data Warehouse Developer Resume Examples & Samples

Partner with Business Analysts and internal customers to improve our data coverage and analytic capabilities
Design and develop new datasets, data feeds, reports, and analysis features ensuring high performance and future scalability; champion the adoption of data warehousing best practices to improve the performance, reliability, and scalability of our data warehouse
Lead in design reviews, code reviews, and test case reviews
ELT/ETL Experience in Large Scale Data warehouse would be desirable
Hands-on systems development experience
Well versed with multithreading, data structures and collections in Java

Senior Data Warehouse Developer Resume Examples & Samples

Providing technical development and production support for applications owned by Global Treasury
Support of strategic change projects, enhancements for continuous improvements
Providing application development for the delivery of technical solutions required by business users from Global Treasury
Analyze, design, develop, implement and support a variety of scripting languages and ETL tools
Develop technical and functional specifications for data acquisition, transformation and load processes from a variety of data sources
Performing functional and regression testing on new and enhanced application functionality
Design, develop, test and maintain solid solutions and architecture for handling incoming and outgoing data flows
Providing technical development and production support for applications owned by Global Treasury Providing technical development and production support for applications owned by Global Treasury
Support of strategic change projects, enhancements for continuous improvements Support of strategic change projects, enhancements for continuous improvements
Providing application development for the delivery of technical solutions required by business users from Global Treasury Providing application development for the delivery of technical solutions required by business users from Global Treasury
Analyze, design, develop, implement and support a variety of scripting languages and ETL tools Analyze, design, develop, implement and support a variety of scripting languages and ETL tools
Develop technical and functional specifications for data acquisition, transformation and load processes from a variety of data sources Develop technical and functional specifications for data acquisition, transformation and load processes from a variety of data sources
Performing functional and regression testing on new and enhanced application functionality Performing functional and regression testing on new and enhanced application functionality
Design, develop, test and maintain solid solutions and architecture for handling incoming and outgoing data flows. Design, develop, test and maintain solid solutions and architecture for handling incoming and outgoing data flows
LI-MK1* *LI-MK1*Requirements
4+ years’ experience as a technical developer, including 2 years of extensive application development experience
Strong programming skills including application development abilities using Oracle/SQL
Familiarity with Informatica ETL tools desired
Demonstrated abilities for drafting detailed technical designs and test cases from functional specifications
Conduct performance analysis and optimize data processes. Make recommendations for continuous improvement of the data processing environment
Experience working in Unix environment
Exposure to batch scheduling packages such as Control-M
Understanding of Agile software development methodologies, specially scrum is desirable
Experience working with source control tools (Subversion, Source Safe, etc.)
Proven ability to work in team environment and act as a mentor and coach to junior team members
Degree from an accredited university, preferably in Computer Science or related discipline, or comparable industry experience
4+ years’ experience as a technical developer, including 2 years of extensive application development experience 4+ years’ experience as a technical developer, including 2 years of extensive application development experience
Strong programming skills including application development abilities using Oracle/SQL Strong programming skills including application development abilities using Oracle/SQL
Familiarity with Informatica ETL tools desired Familiarity with Informatica ETL tools desired
Demonstrated abilities for drafting detailed technical designs and test cases from functional specifications Demonstrated abilities for drafting detailed technical designs and test cases from functional specifications
Conduct performance analysis and optimize data processes. Make recommendations for continuous improvement of the data processing environment Conduct performance analysis and optimize data processes. Make recommendations for continuous improvement of the data processing environment
Experience working in Unix environment Experience working in Unix environment
Exposure to batch scheduling packages such as Control-M Exposure to batch scheduling packages such as Control-M
Strong problem solving skills Strong problem solving skills
Understanding of Agile software development methodologies, specially scrum is desirable Understanding of Agile software development methodologies, specially scrum is desirable
Experience working with source control tools (Subversion, Source Safe, etc.) Experience working with source control tools (Subversion, Source Safe, etc.)
Effective communication and interpersonal skills Effective communication and interpersonal skills
Proven ability to work in team environment and act as a mentor and coach to junior team members Proven ability to work in team environment and act as a mentor and coach to junior team members
Degree from an accredited university, preferably in Computer Science or related discipline, or comparable industry experience Degree from an accredited university, preferably in Computer Science or related discipline, or comparable industry experience

IB R&A Build CCM Data Warehouse Developer Resume Examples & Samples

Excellent understanding of common data warehouse concepts. e.g. Star vs. Snowflake Schema. Slowly changing dimension types
Intermediate/Strong experience of writing windows services and processes using C#
Excellent TSQL programming skills, using SQL Server 2008 or later versions
Strong experience of SSIS (Integration Services)
Strong experience of SSAS (Analysis Services)
Proven experience of proactively improving existing development process and take part in strategic design discussions
Experience of Big data technologies e.g. Hadoop, Hive, PIG scripts etc strongly preferred
Understanding the concepts behind derivatives pricing and calculation of risk strongly preferred
Experience of other ETL packages, e.g. Informatica
Experience of QlikView or other reporting technologies (Spotfire, SSRS, Power Pivot etc.)
Hands on experience of agile development methodologies
Experience of delivering product releases through Dev/UAT testing cycles
Experience of source control and release management using Team Foundation Server

Senior Data Warehouse Developer Resume Examples & Samples

Maintain, support and understand the enterprise Data warehouse system
Comply with project life cycle methodology and adhere to IT control policies and guidelines
Identify applicable system platform, components, and dependencies
Provide uniform integration into legacy systems
5-7 years of overall IT Experience
Core Skills
BFSI (Banking Finance Service and Insurance) experience is preferred
Should be able to relate business requirements, high level design, detail technical design and implement the changes
Readiness to work in flexible hours to provide for overlap with US teams
Process & Management
Awareness of industry standard SDLC processes for quality management

Data Warehouse Developer Resume Examples & Samples

Own and manage batch processing of mission critical processes feeding into multiple systems like Trading, Risk, Account management and operations
Provide “level 3 support” which includes development of minor/major enhancements, defect fixes and provide work around to business problems
Analyze performance issues, perform RCA and provide resolutions for immediate fix and also recommend/build long term solutions to resolve the root cause
3-6 years of overall IT Experience
Ab Initio components like GDE, EME, Coop, MFS and good concepts and experience in parallel processing
Strong knowledge of Control-M or other scheduling batch tools
Good knowledge of Unix/Perl scripting
Oracle PL/SQL skills
Ability to debug and trouble shoot Ab-Initio graphs
Prefer ability to build complex jobs/graphs from loading data into data-warehouse schema
Exposure on large DW databases is advantages
Experience with data integration, batch processing, delta processing and change data capture
Knowledge of Crystal Reports would be preferred
Domain
Soft Skills
Proactively identify and communicate issues leveraging standard monitoring and alerting tools, and work to resolve issues liaising with 3rd party resolver teams as necessary
A good listener and should articulate ideas in writing and verbally to any audience in a way where these are understood and achieve the goals intended with that communication
Have ability to work effectively with teams/people having different skill sets, personalities, work styles, or motivation level
Maintain documentation in-line with group best practices to ensure knowledge accessibility and continuous learning within team

Senior Data Warehouse Developer Resume Examples & Samples

Lead creation of design documentation of Data Integration Solutions across multiple teammates
Lead development of ETL using Informatica Power Center
Unit Test
Participate in requirements and design sessions
Lead the design, build, and test efforts on multiple parallel projects
Provide Technical oversight to consulting partners
Proven ability to work effectively in a fast-paced environment as part of a high-performing development team
8+ years experience developing large data warehouse and data mart applications; preferably using Teradata DBMS
Demonstrated knowledge of data warehousing concepts
8+ years experience with Informatica Power Center, or a similar ETL tool or language

Data Warehouse Developer Spec-di Resume Examples & Samples

Demonstrated problem solving and decision making skills and strong written and verbal communication skills
3-5 years experience developing large data warehouse and data mart applications; preferably using Teradata DBMS
Proven experience and exceptionally strong understanding of SQL
Proven experience and strong understanding of various relational database technologies
Proven experience and exceptionally strong understanding of Teradata Utilities (BTEQ, Fastload, FastExport, Tpumps, MLoad)
Demonstrated knowledge of the Sales Composite Application at Walt Disney Parks & Resorts

Senior Data Warehouse Developer Resume Examples & Samples

Strong experience working with Enterprise Data Warehouse Frameworks and direct experience with BI or DW projects over the full development lifecycle
Strong Skills in Relational Database (preferably DB2) including database design & SQL writing
Experience with Unix and Autoys is a plus
Write and maintain ETL mapping specifications for development team
Responsible for design, development and maintenance throughout the lifecycle of the DWH and Business Intelligence systems
Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
Troubleshoot data issues and work with data providers for resolution
Coordinate and conduct impact analysis because of upstream data changes
Strong SQL writing
DB2 (or any other RDBMS)
Unix
Informatica Powercenter /Informatica Data quality (IDQ)
BI/data visualization tools ? Qlikview, Tableau or other
Knowledge of financial services data

Am Data Warehouse Developer Associate Resume Examples & Samples

Lead the development and enhancement of software application modules but also be able to code when necessary
Translate technical requirements into programmed application modules
Communicate with as well as direct an Offshore team
Participate in design reviews and provide input to the design recommendations
Participate in all Development Lifecycle processes
Incorporate Corporate Architectural Standards into application design specifications
Incorporate security requirements into design
Understand the structures, usage and sources of data
Knowledge and understanding of Data Warehouse concepts and tools
Understanding of data and batch processing from the context of an ETL or a BI development tool like Informatica or Qlikview
Should have strong written and verbal communication skills, problem solving ability, and leadership qualities
Proficient in SQL, and experience with Stored procedures (Sybase/SQL Server/Greenplum a big plus but any RDBMS ok)
Experience with Dimensional Data Modeling
Experience working with offshore teams (giving directions, doing code reviews, etc)
Involvement in all parts of the project lifecycle
Experience with Linux and Linux Shell scripting a plus
Finance industry experience a plus

Data Warehouse Developer Resume Examples & Samples

Strong SQL
Scripting (Python/Perl)
Linux
Excellent communication and interpersonal skills, proven ability to build working relationships with business users
Strong desire to develop business knowledge
DB2/Oracle
Knowledge of Repo, Securities Lending or Collateral management
OO Programming (Java)
Experience of Data Visualisation

Data Warehouse Developer, Bristol Resume Examples & Samples

Ensuring the implemented processes are coherent, efficient and support the strategy for data architecture
Act as the technical design expert for new projects and developments
Proactively indentify improvements required from existing warehouse solutions
Maintain a high technical knowledge of the Data Warehousing tools and techniques
Mentor the development team, providing technical support
Undertake database and application development as required
Educated to degree level
Oracle and/or DB2 experience data warehouse experience
Working knowledge of Informatica Power Centre (to Level II Developer standards)
Understanding of Informatica Velocity Methodology
Experienced in Informatica components including; Power Centre, Power Exchange, (IMS & Flatfile), Data Validation Option (DVO) and Metadata Manager and Data Integration Certification
Understanding of Data Warehouse methodologies and design
Experience of leading and mentoring development teams
Ability to design Logical/Physical Data Models
Experience working to Agile & Waterfall methodologies

Data Warehouse Developer Resume Examples & Samples

7+ years of experience with information technology
5+ years of experience with Oracle SQL
5+ years of experience with data analysis and troubleshooting data processing issues
3+ years of experience with UNIX shell scripting
Ability to learn the ETL tool IBM Infosphere DataStage
Ability to think and work independently
HS diploma or GED
Experience with ETL tool sets
Knowledge of development methodologies, including SDLC and Agile
Ability to use explain plan, indexes, partitioning, and other Oracle features to optimize queries and improve application performance
Ability to construct, refine, and maintain logical and physical data models to meet business requirements
Ability to deliver finished products
Possession of excellent collaboration, teamwork, and client service skills
BA or BS degree in CS or a related field

Senior Data Warehouse Developer Resume Examples & Samples

Perform administration of the SAS Platform; including incident management and resolution and 24x7 on-call rotation
Perform platform upgrades and implement new features of the toolsets
Perform build, deploy and project implementation activities
Contribute to the SAS platform roadmap development and execution
Establish best practices, processes and focus on continuous improvement
Work with users on SAS issues and provide training and mentoring to consumers of the SAS services
Minimum 7+ years of experience of SAS Administration activities
Experience coding in SAS and utilizing SAS tools
Experience with SAS Management Console for environment management configuration
Experience with installation and configuration of SAS components
Knowledge of SAS web services
Knowledge of authentication through Active Directory and Enterprise LDAP Directory
Troubleshooting SAS issues from business users
Knowledge of Build Management concepts and best practices and experience with GIT and Stash toolset
Experience with Tableau Administration including installation, configuring ODBC drivers, configuring user and groups security, and monitoring system resources in a Windows environment
Willingness to learn new software applications, methodologies, and processes related to SAS Administration and Data Warehousing
Comfortable working in UNIX/LINUX server environments and issuing commands from the server command line
Familiarity with Maestro and UC4 scheduling
Demonstrated knowledge of ITIL, Build and Change Management concepts and best practices

Data Warehouse Developer Resume Examples & Samples

A lead role in designing, developing and maintaining ETL processes using SQL Server 2012 Integration Services (SSIS) and T-SQL
Design and implement solutions that meet key requirements for audit, data quality, performance, scalability and security
Strong development experience using the Microsoft BI stack (SQL Server 2012), particularly SSIS
Excellent knowledge and experience of data warehousing principals
Working knowledge of SSRS and SSAS
Experience in Business Objects, Cognos or MicroStrategy a plus

Senior Data Warehouse Developer Resume Examples & Samples

Produce high quality Technical & Release documents and work in collaboration with other teams
Create business rules using SQL stored procedures, functions, triggers to meet project requirements
Tune data model and relational implementation to ensure excellent response times
Be able to model schema for complex data fetch and data input scenarios
Design and develop database infrastructure based upon the business requirements provided by the business stakeholders; this will require investigating and learning various internal data models
Extend the data model to support new data sources required by the project requirements
Create processes to load data from internal sources and outside vendors into environment by using Microsoft SSIS and relational technology
Quality assure stored proc output and response times meet business requirements
Very strong working experience in SSAS, SSIS, T-SQL
Hands-on experience on any one of the BI tool
8-10 years working experience in developing SSIS packages, SSAS cubes and stored procs on SQL platform
Exposure of reporting tools -- Micro strategy, Microsoft Reporting Services, Oracle OBIEE,Cognos
Bachelor’s degree in Engineering/Computers a must

Data Warehouse Developer Resume Examples & Samples

Design/development of enhancements for the existing flows
Support customer System Integration testing (SIT)
Ability to translate architecture documents in functional specification documents
Development experience in DataStage 7.5 / DataStage 8.X
PL/SQL scripting
BO XI
Oracle Exadata
Oracle GoldenGate
Shell scripting
C/C++ language
HP-UX / Linux (RedHat 5.x) environment

Data-warehouse Developer Resume Examples & Samples

Strong Understanding of Foundational Concepts of Data-warehouses
Develop end to End Data Mart models based on Client requirements
In depth knowledge of MDS
Managing and monitoring application access to ensure security policies are adhered to
Degree qualified - IT / Business / Commerce / Finance degree
Strong Property experience required
Ability to prioritize tasks and adhere to priorities despite conflicting requests
Should have 4 - 7 years of work experience in Data-warehouse Development

Senior Data Warehouse Developer Resume Examples & Samples

Perform administration of the Informatica Platform; including incident management and resolution and 24x7 on-call rotation
Perform Informatica platform upgrades and implement new features of the toolsets
Perform Informatica platform monitoring activities
Contribute to Informatica platform roadmap development and execution
Establish best practices, processes and focus on continous improvement
Provide training and mentoring for consumers of the Informatica Service on standards, best practices, and procedures
Minimum 7+ years of proven experience and exceptionally deep experience with Informatica Power Center platform, Informatica MDM platform and layered toolset including Data Analysis Services and IDQ
Proven experience and exceptionally strong understanding of SQL, relational database technologies, preferably Oracle and Teradata
Demonstrated analytical, data management, and data quality skills
Demonstrated knowledge of Data Warehousing concepts
Willingness to learn new software applications, methodologies, and processes related to Informatica Administration and Data Warehousing
Demonstrated knowledge with Linux, unix commands, bash scripting, and GIT

Banking Data Warehouse Developer Associate Glasgow Resume Examples & Samples

Experience and hands on proficiency in the following tools/skill sets are a must: Informatica, Oracle and UNIX scripting, delivering high quality solutions
Demonstrated ability to understand and work effectively within complex IT environment containing onshore/offshore model, multiple development and testing environments, sharing of environment with multiple teams, load balancing and disaster recovery setup
Understanding of development using SCRUM and Agile practices

Data Warehouse Developer Resume Examples & Samples

Communicate with stakeholders to comprehend and integrate new data sources
Design physical database structures for new data
Develop, test, deploy, document and maintain new and existing ETL processes
Ensure timely completion of scheduled ETL tasks
Develop views and queries for application use
Conduct ad-hoc analysis to evaluate data integrity and to support executive requests
Must have very strong SQL skills
Experience with Unix/Linux
Scripting in the Unix environment (shell, sed, awk, etc.)
Manipulation of data in diverse formats (relational, text, spreadsheets, xml)
Database and data warehouse design
Data modeling (ER and dimensional)
Experience with DB2 is preferred
Knowledge of Java is a plus
Excellent analytical ability
At least 8 years experience in developer
Chinese simplified: Fluent

Securitized Product Data Warehouse Developer Resume Examples & Samples

Strong database skills, SQL and one or more of Oracle, Sybase, Sybase-IQ, DB2 on Linux and Windows
Strong object-oriented programming skills in Java or other high level programming language
Scripting skills in Perl / Python or Scala script
Comfortable working on distributed platforms and multi-platform and multi-technology systems
Bachelor�s degree in computer science or engineering with total of 5-10 years of experience
Ability to cope with rapid front-office development and to respond to and address production situations promptly
Has worked and thrived in a dynamic front office development environment under tight deadlines and with demanding clients
Ability to work in a team-oriented setting with strong interpersonal skills
Proficient in agency and non-agency mortgage loans data (eMBS, Loan Performance), Intex CMO data
Experience in some or all of the following sectors: Agency MBS, Agency CMOs, CMBS, Consumer ABS, Non-Agency RMBS
Advanced degree in Computer Science, Engineering or Finance

Data Warehouse Developer Specialist Resume Examples & Samples

Demonstrated strong analytical, data management, and data quality skills
3-5 years experience with Informatica Power Center, or a similar ETL tool or language
Proven experience with Python
Experience with Walt Disney Parks & Resorts policies and procedures
Bachelor’s degree in Computer Science, Management Information Systems or related field or equivalent experience

Data Warehouse Developer Resume Examples & Samples

Minimum 5 years experience with data warehouse technical architectures, infrastructure components, ETL, and BI/analytical tools
Advanced proficiency in SQL Server full stack
Ability to work independently with minimal supervision and as a part of a team
Demonstrated strong problem solving skills
Excellent follow-through skills
Proficiency with MicroStrategy, ETL tools (e.g., Informatica, SQL Server SSIS, etc.) preferred
Basic knowledge of big data technology (e.g., Hadoop, HDFS, NoSQL databases, graph databases)
Knowledge of cloud technology, specifically Amazon Web Services

Data Warehouse Developer Resume Examples & Samples

DB2/Oracle Experience
Experience of using ETL Pattern
Data warehousing
Columnar Databases

Data Warehouse Developer Resume Examples & Samples

Create test plans for new datasets, reports, and analytic capabilities
Strong Data Modelling and Data Query Writing Skills
Data warehousing / BI design skills (platform independent)
Solace Messaging
Experiences in Hadoop/HDFS/Hive/Impala/SOLR/MapReduce/Sqoop/Flume/HBASE/Spark

Senior Data Warehouse Developer Resume Examples & Samples

Bachelor Degree or equivalent and 4 years of experience in data warehouse design and development in a formal software environment
At least 2 years of experience working with Pentaho (Kettle, BI, Mondrian)
Thorough understanding of enterprise data warehousing principles and standard practices
Proven expertise in ETL & data warehouse design and development
Excellent skills at database optimization
Able to mentor others and lead design efforts
Experience with the complete software development lifecycle and Agile development practices
Familiarity with emerging technologies and software development best practices
Great interpersonal relations, team cooperation and the ability to communicate with technical and business stakeholders
Experienced in Oracle development
Experienced with healthcare EDI formats

Data Warehouse Developer Resume Examples & Samples

Open, create, and modify SQL queries used in QA and ETL
Open and modify ETL packages in SSIS for diagnoses and support
Develop ETL packages in SSIS to implement business requirements
Validate data quality and integrity using SQL tools
Work with BI co-workers in understanding data sources and uses
Advise and inform BI co-workers on DW data and data models
Complete assigned projects with minor assistance from the senior SQL developer(s)
Participate in on-call support rotations
Knowledge of and experience with data warehousing concepts, practices, and procedures including star-schema table design
Ability to document data validation and discovery information about DW data, schema, and processes
Ability to commit oneself to learning data warehouse concepts, practices, and procedures
Ability to identify and correct bottlenecks in data transformation
Ability to work and communicate technically with database administrators, IT system engineers, and programmers
Ability to work closely and communicate effectively with business analyst(s) to define data cleaning and business integration rules
Ability to process requests, determine appropriate solutions and complete requests in a timely fashion
Desire to understand requested goals and ability to develop processes, objects, and data to meet requirements
Bachelor’s degree in computer programming, business, or equivalent experience
Minimum one year experience working in business intelligence, application and/or database programming
Experience with Windows and Microsoft T-SQL server environments
Experience with SQL Server Development Tools (SSMS, SSIS, SSAS, and BIDS)
Experience with logical and physical data models and Entity-Relationship Diagrams (ERD)
Experience with DW concepts for data acquisition, movement, and persistence

Senior Data Warehouse Developer Lead Resume Examples & Samples

10+ years of database technology experience with concentration in Very Large Databases
4+ years design/architect for large scale data warehouses and BI solutions, encompassing industry standard methodologies
Strong data modeling skills
In-depth knowledge of multiple RDBMS, warehouse systems
Expert SQL skills for DB2, Oracle, SQL Server (t-SQL, PL/SQL, in a data warehouse setting)
Strong experience with advanced design strategies and optimization techniques, using ETL tools such as Informatica, DataStage, ab Initio and Oracle Warehouse Builder
Java experience a plus
Develop and communicate best practices and coding standards ensuring adherence to sound data warehouse principles
Ability to influence and drive proper architecture decisions to meet strategic vision
Contribute to the design of Master Data Management and Meta Data Repository solutions
Possess strong communication and client management skills
Ability to effectively manage multiple projects simultaneously
BS in Computer Science or equivalent experience in a relevant field

SQL Database / Data Warehouse Developer Resume Examples & Samples

Responsible for applications systems analysis and programming activities. ( strong SQL, database programming, data modelling and any ETL tool)
Requirement understanding, technical design
Involvement in Software Development Lifecycle
Test case reviews and ensure code developed meets the requirements
Coding/ Unit Testing/ Debugging
Undergraduate degree in MIS, Computer Science, Computer Engineering
Ability to work as part of global team
Interpersonal skills to interact with team members and clients
Excellent verbal and written communications skills
Knowledge of Equities and Fixed Income markets is a plus
4-6 Years of project experience as database/Data warehouse developer
ERwin Data Modeller tools/Power Designer, SQL, DDL, DML
Demonstrated experience creating conceptual, logical and physical models
Must have experience created ERD, normalized and dimensional models
Previous experience w/Metadata management strategies and implementation
Understanding of indexing, partitioning and data design performance considerations for industry standard DBMS (Sybase ASE, Sybase IQ, SQL Server 2005 preferred)
Understanding of data warehousing design and development best practices. Understanding of ETL design and development best practices

Data Warehouse Developer Resume Examples & Samples

Develops PL/SQL code in Oracle to create tables, views, functions, triggers and stored procedures
Troubleshoots and resolves production tickets related to the forecasting applications in a timely manner
Attends weekly status meetings with the development, functional and project management teams to discuss status, project timelines and testing strategies
Puts in bug fixes, co-ordinate with operations, functional, business, testing, infrastructure and change management teams
Co-ordinates testing with business analysts and users
Collects and document requirements for new forecasting applications
Conducts status calls with offshore and onsite development teams
Bachelors Degree in Computer Science, Information Systems, Mathematics, Engineering or a related field
5+ years experience in developing stored procedures, functions, packages using PL/SQL on Oracle 10g or higher. Relevant experience in any other major RDBMS may be considered in lieu of Oracle
Strong problem solving skills, ability to learn new technologies/concepts quickly
Good communication skills, should be able to communicate and gather business requirements effectively with both the technical and business audiences

Lead Data Warehouse Developer Resume Examples & Samples

Work with different Line of Business partners to creatively solve complex business problems
Leverage development frameworks such as continuous integration and test driven development to enable the rapid delivery of working code
Perform unit tests and conduct reviews with other team members to make sure code is rigorously designed, elegantly coded, and effectively tuned for performance
Writes code according to accepted standards based on user requirements, which are included in the delivery of the application solution, to meet the business need
Leads in the planning, estimating, development, testing and implementation of initiatives of any size and any level of complexity to meet the functional and non-functional requirements of the application. The resulting artifacts will be used to better understand, communicate, and provide specifications during the coding and Quality Assurance activities
Leads/participates in project and team meetings interacting and collaborating with team members and other departments, when appropriate, to provide a developer’s perspective in the meetings and to contribute to the timely delivery and design
Possesses a university degree/college diploma in applied technologies and/or 5+ years systems analysis and programming experience with extensive business knowledge
5+ years of experience in Software Development with previous experience as team lead
Possesses solid knowledge of design and analysis methodology and application development processes from both an industry and BMO perspective
Demonstrates solid understanding of the Software Development Life Cycle (SDLC) and Quality Assurance requirements and software development control and release procedures
Applicant should be proficient in the following languages & tools: SSIS, C#, Java, J2EE, SQL, PLSQL, UNIX (shell scripting), Oracle, MQ, ClearCase, Eclipse, Toad
Experience in Enterprise Data Warehouse (EDW) or Data Mart (DM) implementation
Experience creating and reviewing ETL design and mapping specifications documents
Possesses solid analytical skills for complex problem solving
Is able to manage multiple priorities
Is able adapt and quickly develop in-depth technical understanding of new/different applications
Is detail oriented with strong organizational skills
Demonstrates solid communication skills, both written and verbal
Demonstrates good leadership skills and independence

Data Warehouse Developer Resume Examples & Samples

Solid Oracle Development skills with 11g or later
Solid SQL Server Development skills with version 2008 R2 or later
Experience in writing ETL Packages using SSIS
Data Warehousing Design experience and Kimball Methodologies
Understating of the data governance life cycle
Experience working on scheduling software, such as Control-M/Autosys
Exposure to Analysis Services and query writing using MDX
C# Development experience
Experience working with Collibra

Data Warehouse Developer Resume Examples & Samples

Assists in the gathering of business requirements by analyzing source systems and reporting
Provides analytical support and consultation on projects to ensure appropriate design, implementation, testing, and documentation
Develops and maintains relationships with clients by building personal credibility and trust
Demonstrates a high level of personal integrity and strong work ethic
Willingness to travel to client sites as needed
Desire to work with a dynamic team of seasoned professionals who implement complex, high-value projects for mid-size and large manufacturing companies world wide
Enjoys challenge. Desire to grow both technically and as a professional consultant
Ability to analyze complex data structures with minimal direction
Strong team player with willingness to collaborate
High comfort level working on multiple simultaneous assignments and dealing with assignment prioritization changes
Bachelor’s degree, preferably in Computer Science, Informatics, or a similar field

Data Warehouse Developer Resume Examples & Samples

5+ years of full development life cycle experience in large scale Data Warehouse environments
Excellent interpersonal skills necessary to work effectively with colleagues at various levels of the organization and across multiple locations
Knowledge of big data technologies like Hadoop/HDFS/Hive/Hbase/Impala & ETL tool integration experience with Hadoop file system desired

Data Warehouse Developer / SQL Analyst Resume Examples & Samples

Designs, develops, and supports new and current ETL processes, employing industry standards and best practices to enhance loading of data from the ERP system
Develops reports and visualizations using SQL Server Reporting Services, Power BI, and Excel
Troubleshoots and adjusts existing data warehouse applications
Has a passion for data, reporting & analytics, and data warehousing
Experience with SQL (Microsoft, Oracle, PostgreSQL, MySQL, etc.), including the creation of complex views, stored procedures, and/or packages
Understanding of star schema models and data warehouse theory

IT Data Warehouse Developer Resume Examples & Samples

12+ years' experience designing, implementing, and maintaining large enterprise business intelligence and data warehousing solutions, with an emphasis on Cognos
In-depth experience with Cognos 10 Framework Manager, Report Studio, Query Studio, Cognos Viewer and Business Insights
Understands the Cognos 10 product suite and recommends the best use of the functionality
Experience in using the mobility suite would be a big plus
Experience with Analysis Studio, Cognos Insights, Metrics Designer and Transformer desirable
Experience with all aspects of data warehousing, including data modeling, integration, and OLAP
Leverages knowledge of industry, solutions, and best practices to design and implement solutions
Experience providing technical leadership on complex projects following recognized software development methodologies, including Agile
Ability to communicate with and influence others within IT and business groups
Experience with IBM Infosphere suite is a plus

Senior Data Warehouse Developer Resume Examples & Samples

Informatica Power Center will be utilized for ETL processes where appropriate
Data Marts will be built and maintained to support BI reporting and strategic analyses
Contribute to the success of the Healthcare Informatics Data Management team
Design, develop, maintain, monitor and execute production ETL processes
Investigate production ETL issues / problems
Map database sources to specified data formats
Verify and validate ETL deliverables incoming / outgoing
Provide direction and mentorship to junior colleagues on topics related to datamart design and ETL deliverables
Lead troubleshooting episodes and communicate solutions/resolutions to the team
Translate concepts to requirements, then design, and develop into an automated production process
Act as a subject matter expert for other team members on assigned processes
Complete projects and development activities timely and accurately while following the System Development Life Cycle (SDLC)
Suggest changes and enhancements for processes
Maintain ongoing self-study program to enhance knowledge of PL / SQL development, Oracle RDBMS Best Practices and Informatica PowerCenter
Document hours of development activities by following SDLC and IS Change Management
3+ years of professional experience in Datamart design with Oracle 10g / 11g databases
3+ years of professional experience in SQL development
3+ years of professional experience with an ETL tool
Professional experience in Data Warehousing schema design
Professional experience with production ETL operations and monitoring
Undergraduate Degree
Informatica PowerCenter
Experience with PL / SQL
Experience with T-SQL

Data Warehouse Developer Resume Examples & Samples

Design, implement, and support the processes to automate the processing of data from multiple data sources
Write SQL to run in Sybase IQ data warehouse
Unix Shell scripting to run processes
Design reporting in Crystal Reports
Support testing, code reviews
Provide documentation
Sybase database development
Support system maintenance
5+ years of experience related to the responsibilities listed
Bachelor's Degree in a related field preferred
Experience with SybaseIQ is required in support of general DBA functions. Do not apply if you do not have SybaseIQ experience
Experience in UNIX Shell Scripting is required
Experience in use of T-SQL for SQL code, stored procedures, and related is required
Experience with multiple of the following technologies and toolsets: Sybase Replication Server, SAP Crystal Reports, SQL Anywhere, SAP/Sybase Power Designer, PL/SQL, T-SQL, Oracle 11g, Perl, TOAD, UNIX shell scripting, HTML, DHTML, XHTML, Java Script, AJAX, Sun Solaris

Senior Data Warehouse Developer Resume Examples & Samples

8 years minimum experience in software development with a majority of this experience building ETL process
Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design
Technologies currently used and supported in Medica IT are: PL/SQL, Oracle, Informatica and SAS
Ability to evaluate, analyze, design and implement solutions based on technical requirements
Ability to identify solutions to complex problems and business processes using tools and technologies to improve efficiency through automation, re-use, design patterns, and best practices

Data Warehouse Developer Resume Examples & Samples

Expertise in Data Modeling, Master Data Management, ETL and database concepts in a transactional and data warehousing environment
Must have expertise and hands on in various SQL Server technologies including hands on with SQL Server, SSIS, SSRS, SSAS, Replication and XML
Developed logical data architectures that enable robust and extensible solutions that meet both short and long term business requirements
Must have hands-on experience with relational and dimensional data modeling and metadata management
Documented existing data usage and patterns in support of logical/physical data modeling. · Strong analytical and problem solving skills with ability to clearly articulate solution alternatives
Ability to document business processes and data flows as they relate to technology system use - applications, COTS, etc. upstream/downstream
Communicate, analyze, and collaborate with IT PMO, corporate systems development, data modeling, systems users and key business stakeholders
Strong attention to detail, seasoned senior judgment and experience to anticipate business needs
Motivational leadership with a high level of energy, sense of urgency, creativity and decisiveness with the ability to balance all of the above under pressure
Exceptional interpersonal skills including written and verbal communication skills, high level of business savvy and ability to operate at and with all levels in the organization. · Subject matter expert in financial systems, business processes, and a strong familiarity with industry best practices, solutions, and trends. · Experience with Informatica a plus
Experience with Agile methodologies a plus · Enterprise Architecture experience a plus · Experience with Sales Force a plus Education · BA/BS in Computer Science or related experience

Data Warehouse Developer Resume Examples & Samples

All applicants must be currently authorized to work in the United States without employer sponsorship now or in the future
Ability to lead the design and development of a large-scale data warehouse in Teradata & Informatica
Must have experience with an ETL tool Informatica
Must have experience with Teradata & Teradata utilities
Must have experience in Unix / Oracle
Experience in enterprise data modeling standards and tools such as Erwin
Strong written and oral communication skills; excellent organization skills
5+ years working in Data Warehouse

SQL Database / Data Warehouse Developer Resume Examples & Samples

The majority of time will be spent on lead reporting projects and initiatives
Quantifiable experience with MS SQL server programming
Quantifiable experience with any scripting or programming in object-oriented language (e.g. PHP, C++
Experience working with data analytics methods and techniques (e.g. R programming) and with data visualization tools (MS Excel, Tableau, Business Objects, etc.)
Experience with Unix shell scripting

Agile Data Warehouse Developer Resume Examples & Samples

Work alongside the Development and Infrastructure teams; gaining an understanding of the Sky Network Services data domain. You will then be required to apply this knowledge to develop the SNS departmental data warehouse
Develop high quality ETL routines to improve and maintain the data warehouse
Develop ad-hoc SQL reports when business requirements demand immediate data investigation work
Work as a part of the team on support and maintenance of the data warehouse and assist end users with downstream data feeds
Experience in big data solutions
Excellent SQL skills
Excellent ETL Knowledge with Informatica or similar
Excellent database skills with Oracle and or Netezza
Excellent dimensional data modelling skills
Experience using Unix/Linux operating systems
Experience with BI tools and methodologies
Ability to work in a highly pressurised environment

Data Warehouse Developer / Analyst Resume Examples & Samples

Profile and understand the large amounts of source data available, including structured and semi-structured/web activity data
Gather reporting and analysis requirements and translate into reporting structures data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) marts
Use data mining techniques to analyze the source data and determine the best reporting structures to build
Map sources to the target design using a variety of tools, including BusinessObjects Data Services/BODI. Design and develop ETL code to load and transform the source data from various formats (including key-value pair and variable-structure data) into a SQL database
Conduct ETL performance tuning, troubleshooting, support, and capacity estimation
Conduct thorough testing of ETL code changes to ensure quality of data produced
Provide day-to-day support and mentoring to end users who are interacting with the data
Expertise with data warehouse
A bachelor's degree and 3 years of professional work experience (or a master's degree) is required
Expert-level ETL development using tools such as Informatica PowerCenter or SAP Data Services
Experience with Business Intelligence tools such as Crystal, Business Objects, Microsoft SSRS, or Oracle OBIEE
Exposure to Amazon RDS and RedShift, and/or Google BigQuery
Must be comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools quickly

Data Warehouse Developer / Analyst Resume Examples & Samples

Profile and understand the large amounts of source data
Work with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data
Primary point of contact working with stakeholders to understand their systems, processes, and business needs. Work as a trusted advisor to identify opportunities for new insights, analytics, and reporting solutions
Demonstrated experience in/with data warehouse
Expert-level ETL development using tools such as SAP Data Services or Informatica PowerCenter
Experience with Business Intelligence tools such as Business Objects, Crystal, Microsoft SSRS, or Oracle OBIEE

Lead Data Warehouse Developer Resume Examples & Samples

Providing technical leadership and best practices in the design, development, and deployment of complex ETL
Developing and maintaining data warehouse packages of turnkey standard models and ETL definitions for deployment at our clients across the globe
Developing, upgrading, and maintaining ETL packages under full configuration management using carefully controlled deployment
Performing system, unit, and performance testing of new and existing developments to ensure accurate and efficient operations that meet the business needs of the users
Master's degree in engineering, computer science, or other relevant background
Solid understanding of data warehousing design and architecture
Experienced in dimensional data modelling
Data Warehouse ETL development experience working with modern data warehouse ETL tools
Expert level skills in problem decomposition and ability to navigate through ambiguity
Excellent problem-solving abilities and capable of articulating specific technical topics
Oracle certifications
Oracle administration knowledge
MS SQL server experience

Senior Data Warehouse Developer Resume Examples & Samples

) Must have SSIS & SSRS experience (8 yrs with designing and developing data packages)
) ETL - SQL Server Integration experience
) SQL Server 2008 R2

ETL / Data Warehouse Developer Resume Examples & Samples

Build data integration design and technical specifications, in alignment with DI technical architecture and framework, based on business functional and non-functional requirements
Design, build and unit test the DI application modules with Abinitio, DB2/scripting, K Shell scripting & Control M scheduling
Perform development activities such as Source to target mapping validations, identify, document and execute unit test cases/scripts, peer and lead code reviews per code review checklist and document test and review results
Support QA on functional test case review, functional/system testing and UAT testing
Perform DI application/module deployment employing change management policies and procedures and support through the deployment in higher environments
Be part of the ‘Run the Engine’/L2 application support activities and incident resolutions in Production
Achieve deliverables according to agreed to terms for scope, cost, quality and schedule
Collaborate with BA’s, data architects, application leads, QA analyst and production support, through SDLC
Through application development process, Identify and document gaps as process and code enhancement opportunities
Report/Share weekly status of application development, SDLC phase risks and opportunities with work stream leads and project managers
Bachelors or Master degree from an accredited college in a related discipline
A minimum of 8 years of IT based software development experience
A minimum of 6 years of data integration experience developing DI Applications using Abinitio or Informatica
A minimum of 1-2 years of working experience with DB2
A minimum of 1-2 years of experience developing Abinitio continuous flow components in support of mission critical applications is preferred
A minimum of 1-2 years experience using Control M is preferred
Excellent verbal and written communications with the ability to influence others
DI architecture and data modeling experience

Data Warehouse Developer / Analyst Resume Examples & Samples

Works closely with the data warehouse team to translate business requirements and logical data models into working databases, including relational and dimensional (star-schema) designs
ETL programming: Understand the source data available and map sources to the target design using a variety of tools, but primarily using the ETL tool of choice (SAP Data Services, formerly BusinessObjects Data Integrator)
Conducts thorough testing of ETL code changes to ensure quality of data produced
Makes changes to BusinessObjects universes to reflect changes made to marts
Monitoring the DW platform metrics, while recommending and implementing improvements
Assisting the team with performance tuning for ETL and database processes
Owning and maintaining the data refresh processes in our test environments
2+ years’ experience with Database development, administration, debugging, and tuning in SQL Server required
Great interpersonal and communications skills, while establishing and maintaining effective work relationships with team members

IT Data Warehouse Developer Resume Examples & Samples

Understand the business requirements and design & build dimensional Models
Design and develop ETL batch processes using AEP and industry best practices
Unit Testing & System Testing developed ETL code to make suite it meets the business and reporting needs
Work in an Agile Scrum Framework environment
Informatica 9 Series: Minimum 8-10 Years of experience
Oracle, PL/SQL: Minimum 6-8 Years of experience (SQL Development, Performance Tuning)
Dimensional Modeling: Minimum 4-5 Years of experience
Agile Scrum framework: Must to have experience
Cognos, Business Objects: Preferred
Big Data, Hadoop: Preferred
Good Team player. Should be well suited to work on an Agile Team
Strong communication and should be able to differentiate between Business Audience vs.Technical Audience
Strong Business Acumen
Should have a strong sense of Business value addition

Senior Data Warehouse Developer Resume Examples & Samples

Contribute to the success of the OptumCare Data Management team
Verify and validate ETL deliverables incoming/outgoing
Provide direction and mentorship to junior colleagues on topics related to Data Mart design and ETL Deliverables
Lead troubleshooting episodes and communicate solutions / resolutions to the team
3+ years of professional experience in Data Mart design with Oracle 10g / 11g databases
3+ years of professional experience in SQL development (PL / SQL, T-SQL)
3+ years of professional experience with the ETL tool Informatica PowerCenter

Data Warehouse Developer Resume Examples & Samples

Provide query writing support and tuning expertise to analysts and end users
Work in a 24x7 environment which requires on-call rotation
3-5 years of experience in database development including analyzing, designing, documenting, coding, testing and implementing SQL, PL/SQL code
Exceptional Oracle SQL skills and PL/SQL skills
Hands on experience with set based operations, analytic functions and query hints
Command of data warehouse modeling concepts is required
Proficiency with Linux and shell scripting
Experience with Perl, system administration, database administration, storage architectures, backup & recovery and networking
Technophile with command of the command line
Cognos 10.3 reporting experience

Senior Data Warehouse Developer Resume Examples & Samples

Experience designing information data models and data structures using Oracle
Strong knowledge of SQL for database structures and reporting, with Oracle, including developing complex SQL queries and stored procedures
Experience developing ETL processes for data extraction and transformation
Experience performing SQL tuning and optimization
6+ years of related experience required
Review, analyze, and resolve user or data-related issues in collaboration with other team members
Developing functional requirements specifications, documenting detailed system requirements and definitions for databases in collaboration with business, development and operations teams
Identify process improvements and provide strategic direction for the Enterprise Data Warehouse
Lead the resolution of issues and the development of solutions
Lead the development of solutions for design and development of Data Warehouse capabilities in collaboration with business, development and operations teams
Strong problem solving and analytic skills
Ability to translate business needs into technical specifications
Good communication skills and team player

Experienced Data Warehouse Developer Resume Examples & Samples

Support customer System Integration Testing (SIT)
Support production deployment
Identify and address technical issues in due time
Ability to understand business requirements and create design to meet those business requirements
Strong experience with PL/SQL programming
Oracle DB 10g, 11g
Good communication and documentation skills in English

Senior Data Warehouse Developer Resume Examples & Samples

Reviews and analyzes on-going customer requests (for new data elements to be brought into the existing model, for customizations or cross-walking of existing data elements, for computation of new fields based on customer-provided business logic, combinations of existing data elements, etc.)
Functions as a primary contributor in designing, coding, testing, debugging, documenting and supporting all types of applications consistent with established specifications and business requirements to deliver business value. Participates in multiple concurrent projects
Solves unique and complex problems with broad impact on the business
Translates highly complex concepts in ways that can be understood by a variety of audiences
Develops complete descriptions of all specifications and solutions required
Develops common operations, which can be reused
Devises data verification and quality methods and standard systems procedures that will be used to support Enterprise Data Warehouse and Business Intelligence platforms
Participates in certain aspects of user consulting, systems analysis, general systems design, vendor contracts and detail systems design
Learns user functions, organization and role in the enterprise to the extent required
Performs all other related duties as assigned
Bachelor’s degree in computer science, business administration or related field (4 additional years of comparable work experience beyond the required years of experience may be substituted in lieu of a bachelor’s degree)
3+ years of strong Informatics / ETL experience, SQL Server experience (Version 2005 or higher), T- SQL experience, Visual Studio (Version 2005 or higher), SQL SSIS experience, and SQL & Querying Tuning
Excellent communication skills both written and verbal
Background in the healthcare industry
Experience with SAP Business Objects
Knowledge of healthcare revenue cycle management
Experience gathering business requirements
Experience developing OLAP cubes for business intelligence applications and reporting
Develop analysis and design of transactional systems and / or programs
Assist subordinates with debugging whenever necessary
Expertise in working closely with business and IT stakeholders to define problems and design large-scale, enterprise class solutions in a leadership role

Data Warehouse Developer Lead Resume Examples & Samples

10+ years of Enterprise IT based solutions experience required
7+ years experience architecting, designing and developing data warehouse solutions
Very strong understanding of Data warehousing concepts
Experience with business domain modeling, logical modeling and physical modeling
Experience with data analysis and facilitation, i.e., able to produce data designs using a variety of inputs such as requirements analysis, SME interviews, business process and data flow analysis, data profiling, etc
Significant relational database design and development experience, especially using Oracle
Experience with performance tuning relational databases
Understanding of variety of information architecture components such as MDM, data warehousing, data quality, business intelligence, metadata management, content management, SOA, etc.,
Experience participating in data governance initiatives is desirable
Integration experience including with 3rd party applications
Self-motivated and capable of working autonomously with minimal management supervision and driving forward delivery
Excellent analytical and problems solving skills for business and technical problems
Excellent communications skills, both written and oral
Background in Information Technology and IT Risk and Security
Experience with ETL tools like Informatica or similar
Experience developing complex sqls and plsql programs
Experience working in a Data Warehouse environment
Experience with ERWIN or similar data modeling tools/repositories
Reporting/Business Intelligence solutions delivery experience
Data Analysis and functional Specification and testing experience
RDBMS (Oracle) experience
Leading delivery of solutions
Master's degree or equivalent in Computer Science, Mathematics, Engineering (any), or relevant work experience of over 5 years in a related field
Strong communication skills and ability to work with partners and stakeholders at all levels of an organization
Highly organized and detail oriented with a structured/analytical approach to problem solving
Self-directed: be an independent contributor who is comfortable working in a self-directed environment
Analytical and detailed - strong analytical skills with complementary communications and presentation skills with attention to detail and accuracy
Documentation - ability to produce clear, concise, relevant and accurate documentation based on captured requirements and information gathered from stakeholders and subject matter experts
Motivated - displays drive, energy and enthusiasm
Must be highly reliable, trustworthy, honest and commitment oriented
Team player – able to create effective partnerships with colleagues

Data Warehouse Developer / Analyst Resume Examples & Samples

Build, review and analyze the ETL requirements
Design, develop, implement and assist in validating processes
Create and execute unit test plans based on system and validation requirements
Troubleshoot ETL processes
Document all related work per company's methodology
Maintain existing code and fix bugs when needed
Ensure all timeline of loading/validating data are met
Develop mapping / sessions / workflows
Determine the structure of data; experience in data analysis
Self-manage time and task priorities to meet project timelines and identify potential project risks
Handle multiple work related tasks
Write and optimize SQL code and stored procedures
Self-manage time and task priorities and of other developers on the project
24x7 On-Call Support Rotation

ETL Data Warehouse Developer Resume Examples & Samples

Architect and design ETL Data Warehouse infrastructure and solutions
Develop, enhance, and integrate ETL Data Warehouses / Data Marts and Business Intelligence Solutions
Test ETL Data Warehouses / Data Marts
Deploy and maintain ETL Data Warehouses / Data Marts
Creating documentation
5+ years ETL experience
2+ years Teradata experience
SSIS experience
SQL programming experience
Demonstrated experience writing and executing UNIX shell scripts
Proven advance database skills
Demonstrated solid understanding of Data Warehouse design theory
Solutioning / Architecture experience
Data modeling experience
Dimensional Data Modeling experience
Health Care data experience
Proven individual contributor and team player with high communication skills
Proven ability to thrive in change by having a fast, flexible, cooperative work style and ability to reprioritize at a moment's notice

Data Warehouse Developer Resume Examples & Samples

Full systems lifecycle development experience
Significant data warehouse experience, including both ETL and report development
SAP Business Objects
Traditional and dimensional data modeling
Data and solution architecture
SQL Server
Bachelor’s Degree required from an accredited college or university in a related field
Ability to work overtime required on occasion
Ability to sit in an office environment for long periods of time

Data Warehouse Developer Resume Examples & Samples

Bachelor's degree in Computer Science, Engineering or
5 plus years ETL/Data warehousing technology (Ab Initio), EME, Co-Op, BRE, or Continuous flow
5 plus years with Unix, PERL, Teradata

Data Warehouse Developer Resume Examples & Samples

Determines database structural requirements by analysing operations, data need of downstream applications and evaluating current systems
Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications, storage need and storage growth
Design and develop ETL processes. Establish coding standards, perform code review and automate the health of the platform
Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases
Engineer solutions to facilitate strategic goals such as Database as a Service and Data as a Managed Service
Work with vendor on critical problems, designs and get the solutions/fixes
Develop and maintain shell scripts, Perl code to automate data ware house tasks
4+ years of working experience as data warehouse SME and Sybase experience is MUST
Working knowledge on Sybase IQ is good to have
Strong scripting and programming knowledge is desired
Prior experience with capital market and financial data
Data warehousing experience is required
The candidate should have very strong technical experience in the areas of data analysis, database design and ETL
Experience working on parallel development tracks at the same time is required
Experience in leading smaller development teams is necessary
Adhere to the SDLC process, & also ensure others follow process too
Should have root cause analysis skills, able to quickly analyze and interpret code and ensure that issues are resolved or escalated appropriately
The sometimes ambiguous environment means that the candidate should also be experienced with multi-tasking and balancing tasks with priorities
Expertise in Sybase and data ware house architecture, design and implementation
Working knowledge of at least two ETL tools
Working knowledge of Linux/Unix shell, Perl Scripting
Very strong SQL knowledge and performance tuning of SQL. Master of relational database concepts and implementation
Experience of scheduling tools such as Autosys
The candidate should have strong analytical skills
The candidate must possess excellent communication skills as they will be interacting with people with diverse skills and seniority across different locations and time zones
Exposure to other RDBMS, for example, Oracle, Netezza
Exposure to the database related tools
Understanding of Capital market data is huge plus
Educational requirements: BA/BS
Language requirements (including proficiency levels for speaking, reading, and writing): English

Data Warehouse Developer Resume Examples & Samples

Over 2 years of experience in PL/SQL
Database knowhow, Star-scheme, snowflake, DWH specifics
ETL experience
Advanced English
Technical degree would be a plus
Knowledge about banking process would be a plus

Data Warehouse Developer Resume Examples & Samples

Coding and testing program modules that meet design specifications; assisting in design
Assisting in the integration of technical and application components to meet business requirements
Maintaining, tuning and repairing applications to keep them performing according to technical and functional specifications; providing user support
Master degree - technical profile (IT, telecommunication, electronics, economy)
Good knowledge of SQL, and one of database: Oracle, SQL Server or MySQL
Good knowledge of English and very good knowledge of Polish
Knowledge of high-availability protocol authentication concepts will be an advantage
Good communicative skills and ability to work as a team member

B.i. / Data Warehouse Developer Resume Examples & Samples

Develop data warehouse solutions based on function specifications received from the Business Analyst
Develop end to end solutions on BI platforms with emphasis on Birst and Tableau technology
Expected Experience

Lead Enterprise Data Warehouse Developer Resume Examples & Samples

Hands-on experience with end-end solution delivery of Data & Analytics applications involving structured and un-structured data on the Teradata platform (ELT & ETL) is essential
Strong working knowledge of tools like Informatica, Advanced Teradata SQL, Teradata Analyst Package, Viewpoint, etc. along with interaction with Cloudera Data Lake and Reporting layer
Knowledge of best practices in using Consumption tools like Tableau, Qlik, R, etc on Teradata preferred. Integration with Cloudera Hadoop would be strongly considered
Working knowledge of using tools like Bteq, Mload, Fload, Tpump
Working knowledge of using tools like Sqoop, Hive, would be a bonus
Experience documenting best practices and enforcing strong governance in a team
A commitment and passion for continuous integration, unit tests, and using automation to ensure stable deliverables
Excellent verbal and written communications
Desire to work in a fast paced, growing, deadline driven, startup-up environment
Experience with Scrum and an Agile Development environment is required
8+ years professional software development experience

SQL Database / Data Warehouse Developer Resume Examples & Samples

Understanding client reporting goals and developing metrics that address their requirements
Working with data owners to identify data sources that will meet client reporting needs
Extracting data from various sources into our data warehouse using SQL Server Integration Services
Implementing data transformation procedures using SQL or automated scripts
Ensuring data quality management of newly acquired data by developing reports that communicate invalid elements to data owners
Using the data warehouse in developing impactful client reports using various visualization tools
Delivering client training sessions aimed at explaining how customers can utilize data visualization tools to perform ad-hoc analyses based on data stored in the data warehouse
Monitoring and timely fixing ETL jobs in order to prevent data loss
Assisting clients with ad-hoc data analytics requests

Entry Level Data Warehouse Developer Resume Examples & Samples

NOT ABLE TO PROVIDE SPONSORSHIP
SQL Server Analysis Services (SSAS) 2012
Team Foundation Server (TFS) 2012
SQL Server Reporting Services (SSRS)
Master Data Services (MDS) 2012
Melissa Data deduplication components
Multi-dimensional tabular modeling
Knowledge of HIPAA regulations and best practices pertaining to PHI or PII
Construct, deploy, maintain operational data stores
Monitor data warehouse performance
Create solutions for maintaining data integrity and database efficiency
Investigate and troubleshoot coding errors and data flow failures
Create enhancements to existing data model and related platforms
Ensure security of data warehouse containing PHI

Data Warehouse Developer Resume Examples & Samples

Work with stakeholders to understand their systems, processes, and business needs. Work as a trusted advisor to identify opportunities for new insights, analytics, and reporting solutions
Gather reporting and analysis requirements and translate into solutions, develop data models, and design relational and dimensional data marts
Map sources to targets using a variety of tools, including BusinessObjects Data Services/BODI. Design and develop ETL code to load and transform the source data from various formats into a SQL database
Profile and understand the large amounts of source data.Work to fill data gaps and adjust source-system data structures to facilitate analysis and integration with other company data
Conduct ETL testing, performance tuning, troubleshooting, support, and capacity estimation
Experience with Business Intelligence tools such as Business Objects, Crystal, Tableau, Microsoft Power BI, or Oracle OBIEE

Data Warehouse Developer Resume Examples & Samples

Eight or more years in database/data warehouse development experience. Involvement in all phases of the systems development life cycle
6-8+ years systems analysis and program development experience with some task or team leadership, or an equivalent combination of education and experience
Experience with MS SQL Server 2008 and higher, SSIS, NoSQL, MarkLogic a plus
Healthcare or Medical industry experience a plus

Data Warehouse Developer Resume Examples & Samples

Proven experience in implementing complex solutions in a professional development environment
Strong design and development skills in the Microsoft SQL Server platform, including SSIS and SSRS
Strong skills in the T-SQL Language and developing for performance
Strong experience in developing ETL solutions from complex backend systems
Strong knowledge in Data Warehouse solutions and Data Architecture
Strong ability to build relationships with the business to provide fit for purpose solutions
A proven aptitude for developing high quality solutions
Strong problem solving skills and ability to adapt to new situations
Excellent listening, verbal and written communication skills

Data Warehouse Developer Oracle SQL, PL / SQL Resume Examples & Samples

Responsible for implementing code based solutions as determined by the team’s project manager and business analysts
The developer is responsible for unit testing their code, checking in code on a daily basis and maintaining their code as needed
Work with a team of programmers who share key concepts and knowledge in order to create a unique and exciting work environment
Collaborate closely with the project team and business in order to determine best practices and solutions for current data quality issues and to plan for future strategic goals implementation
Responsible for providing documentation as needed, based on client standards
Required to work with standard tools including JIRA
Understand and translate business requirements into Data Warehouse solutions
Create data models and designs to meet specific business needs that require sourcing data from multiple source systems
Code Oracle ETL scripts that will extract data from an operational database and populate the staging and target data warehouse schemas
Document code and processes for distribution to all interested parties
Document design using industry standard artifacts for documenting data warehouse designs
Develop shell scripts for production job automation
3-5 years of experience in database development including analyzing, designing, documenting, coding, testing and implementing sql/pl code
Thorough knowledge of data warehouse principles and techniques, specifically dimensional data modeling
Experience working with a large, multi-terabyte data warehouse
BS in Computer Science or related degree, or equivalent experience
Medicaid or other healthcare or claims processing experience
Informatica ETL experience
Cognos 10.3 and/or 11 reporting experience

Data Warehouse Developer Resume Examples & Samples

Experience of full software development life cycle
Ability to coordinate with various teams to deliver projects successfully- Working knowledge of agile development practices including Test Driven Development, continuous integration and SCRUM
Teradata
Perl
Greenplum
Good understanding of Service Oriented Architecture (SOA)

Data Warehouse Developer Resume Examples & Samples

Bachelor's degree or equivalent in Computer Science or related discipline, or knowledge acquired through equivalent experience
A minimum of five (5) years experience in systems and software development
3+ years strong native SQL skills
3+ years strong experience in database and data warehousing concepts and techniques. Must understand: relational and dimensional modeling, star/snowflake schema design, BI, Data Warehouse operating environments and related technologies, and ETL, MDM, and data governance practices
Ability to work in a fast-paced, team oriented environment
Must be able to interface with various solution/business areas to understand the requirements and prepare documentation to support development
Design and develop ETL and master data management processes
Work with data architects on the logical data models and physical database designs optimized for performance, availability and reliability
Scripting and automation to support development, QA and production database environments and deployments to production
Provide technical knowledge to teams during project discovery and architecture phases
Document new development, procedures or test plans as needed
Partner with the business units to develop effective solutions that solve business challenges
Keep management informed of work activities and schedules
Proactively helps to resolve difficult technical issues
Participate in projects through various phases
May have responsibilities for process and/or people management

Senior Data Warehouse Developer Resume Examples & Samples

Minimum 7 years of experience in systems development and programming with IBM DataStage ETL Tool including DataStage Sequencers, Routines. Also experienced in stages like ABAP extract, Complex Flat file, IDOC stages, XML parsers and Java stages, required
3 years of experience with extracting data from SAP Systems and basic transactions in SAP, preferred
Experience with IBM Tivoli scheduling tool, preferred
Extensive knowledge in Unix Shell scripting
Required Database experience in Teradata, Oracle and SQL server

Data Warehouse Developer Resume Examples & Samples

1) RDLC - Dynamic Reporting. More complicated than SSRS as it uses C# programming skills so C# and SQL both are preferred
2) SSAS Cubing/MDX experience using Power Pivot
3) Tableau
4) Sharepoint

Data Warehouse Developer Resume Examples & Samples

Coordinates with IT database administrators, systems administrators, and development team
Support development, migration of data through manual or ETL processes, revision and update of DataMart and cubes, procedure development, troubleshooting, system configuration, security administration, and account setup
Manages the lifecycle of physical data models and data maps for data warehouse system
Provides assistance to end users and programmers regarding data warehouse related problems and issues
Manages end-user accounts and accessibility; provides technical expertise to end-users who create complex queries and reports
Coordinates, schedules, and tests upgrades to the data warehouse system
A minimum of a Bachelor's degree coupled with 7+ years' experience in the information technology arena
5+ years' experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data
5+ years' experience with Oracle and/or SQL Server RDBMS, PL/SQL & SQL
3+ years' experience in ETL tools such as Informatica
Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills
Good understanding of Data warehouse and Operational Data Store concepts
Good understanding of Informatica/ODI/SSIS or related ETL tools
Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk
Experience with reporting tools such as Cognos, OBIEE, Oracle EPM Client is a PLUS
Familiarity with development methodology such as Agile, Waterfall and Systems Engineering
Must have a 4 year degree an in applicable STEM or related field
Java Certification or any related industry certification is desirable

Data Warehouse Developer Resume Examples & Samples

Respond promptly and effectively to resolve incidents
Demonstrate the knowledge, skills and abilities described above
Fulfill customer requirements using Oracle Data Integrator and PL/SQL
Practical knowledge of lifecycle database design, 3NF and dimensional design concepts
Positive : Maintain a positive attitude by focusing on solutions and promoting a collaborative and enjoyable environment
Respectful : Value teamwork, share successes, appreciates others and communicates in a way that promotes trust
Insightful : Make timely well-considered decisions, create innovative solutions and continuously learn
Earnest : Be honest, sincere and consistent. Work hard and pursue our goals together relentlessly

Data Warehouse Developer Resume Examples & Samples

This role will be responsible for the development of code to satisfy technical requirements
Develop, test, implement and debug database code and complex queries to extract, calculate or manipulate information
Generate ideas for improvements based on business and technical design challenges
Ensure technical work is in alignment with Lands’ End’s architecture and security principles, patterns, standards, and controls
Participate in an on-call rotation which is responsible for support of EDW production systems
Associate or Bachelor’s degree in a computer-related field or equivalent experience and 1+ years of experience in an EDW environment
Demonstrated ability to deliver unique, innovative, and efficient solutions to business and technical problems
Proven ability to deliver effective, on-time results from an established set of tasks
Ability to communicate complex system information to individuals and groups of wide backgrounds and experiences
Demonstrates excellent written and oral presentation skills
Experience in Datastage or other ETL tool, SQL and COBOL desirable but not required
Experience in Unix and Mainframe systems desirable but not required
Experience in DB2, Netezza, Oracle or other relational databases desirable but not required
Understanding of data warehouse principles
Retail industry experience desired but not required

Senior Data Warehouse Developer Resume Examples & Samples

Review and approve the modification of existing applications
Participate in full SDLC including Agile methodology
Review project requests describing user needs to estimate time and cost required to accomplish project
Bachelor’s degree in computer science, software engineering or relevant field required
5+ years software engineering experience required
Experience developing web applications with Oracle 11g as the back end, preferably as products for external clients
Strong Oracle PL/SQL development experience
Experience working in Agile/Scrum methodologies
Strong experience working with Linux (Redhat, Ubuntu)
Big data/HPCC/ECL (Enterprise Control Language) experience is a plus
Software development in Java is a plus
Exercises independent judgement with minimal direction from supervisor
Verbal and written communication skills, problem solving skills, customer service and interpersonal skills (Required)
Strong ability to work independently and manage one’s time (Required)
Strong mentoring skills necessary to provide support and constructive performance feedback (Required)
Strong knowledge of the full software development lifecycle: from business/systems analysis, through requirements gathering and functional specification authoring, to development, testing and delivery (Required)
Strong ability to troubleshoot issues and make system changes as needed to resolve issue

Senior Data Warehouse Developer ETL Resume Examples & Samples

Engage with business users to gather, define and document requirements
Translate business requirements into technical solutions
Develop and document detailed functional specifications
Lead, design, develop and implement data collection processes in conjunction with the data warehouse. Source data from ERP and legacy application systems supporting a centralized data warehouse and reporting platform
Design and develop Extract Transform and Load (ETL) processes using Informatica to support various business unit specific and enterprise data marts, staging areas and data warehouse structures
Perform data modeling, data profiling, database design and metadata management
Design technical solutions to meet the requirements for Business Intelligence and Data Warehouse solutions
Produce detailed technical specifications and other necessary supporting documentation
Lead and perform tuning activities throughout all aspects of the data warehouse function. Produce efficient solutions
Build, support and maintain data warehouse processes to ensure reliable and efficient application performance of reporting and end user ad hoc solutions
Collaborate and engage with the project team to design, develop and implement Data Warehouse solutions across all functional business areas
Manage complex projects and coordinate the efforts of both internal and external resources. Plan and manage project schedules. Communicate project issues and assumptions as appropriate
Thorough understanding of Business Intelligence and Data Warehousing concepts
Excellent interpersonal and communication skills (verbal/written) and ability to interface effectively throughout the organization
Strong technical knowledge coupled with solid follow through and problem solving skills
Detail oriented with a capacity and passion for learning business data
Ability to multi-task across multiple projects, prioritize, meet deadlines and maintain flexibility in a fast-paced, service oriented environment
Manage complex projects with minimal supervision and assist less experienced peers
Ability to exercise a wide span of independent judgment
Strong understanding and a successful track record of delivering data warehouse solutions
Ability to work with and meet deadlines
Results oriented with an ability to think creatively and be able to implement creative ideas
Bachelor’s degree in Computer Science, or related discipline required
7-10 years’ experience building Business Intelligence and Data Warehousing solutions
5-7 years’ experience in Project Management
5-7 years’ experience using Informatica, Oracle and SQL
3-5 years’ experience using MS SQL Server Analysis Services, a plus

SQL Data Warehouse Developer / Designer Resume Examples & Samples

Develop technical specifications and design documents
Test Data Warehouses/Data Marts
Deploy and Maintain Data Warehouses/Data Marts
Ability to communicate analysis including trends and opportunities to clients and the business in writing and verbally
Working knowledge of claims or equivalent healthcare claims system is highly preferred
Behavioral Healthcare and Medicaid systems experience strongly preferred
Occasional business analysis responsibilities to include gathering and documenting business requirements for new or changing business functions
Excellent communication, time/project management, organizational, and analytical skills required
Self-driven, proactive problem solver/solution oriented
4+ years of experience performing significant data analysis and report development
3+ years of data and programming experience (SQL, Hyperion, SAS, Tableau, SQL Server and Crystal Reports)
Proficient with PC based software programs (Advanced Excel, Access, and PowerPoint)
Experience communicating analysis including trends and opportunities to clients and the business in writing and verbally
Working knowledge of claims or equivalent healthcare claims system
Behavioral Healthcare and Medicaid systems experience
Experience documenting business requirements and/or workflows
Ability to work on own with little or no direction
Ability to work in disparate systems
Ability to compose complex SQL queries

SQL / ETL / Data Warehouse Developer Resume Examples & Samples

Build and maintain the data model that supports the application
Build ETL packages to ingest data from source systems (multiple formats)
Design and build objects for data access (stored procedures)
Implement row level data security for sensitive data
Design and implement user authentication and security features
Extensive SQL development skills (T-SQL, Stored Procedures, UDF)
Extensive experience with ETL processing tools (SSIS)
Extensive experience with Data Warehousing and data modeling
Experienced with data visualization tools (SSRS, COGNOS, QlikView)
Experienced with OLAP Data Modelling (SSAS)
Experience with Agile project methodology, continuous build, and integration tools
Ability to work independently and collaboratively
Creativity, innovation, and resourcefulness
SQL Server 2012, advanced level of experience
SQL Server Integration Services, advanced to expert level
SQL Server Reporting Services, advanced to expert level
Experience in Data Modelling and Data Warehoused design methodologies
Through understanding of Agile or Scrum methodologies
Exposure to Cognos, QlikView or other data visualization tools is a plus
Understanding of Cubes and Cube Design is a plus
Exposure to Big Data is a plus
Experience with ServiceNow data is a plus
SQL Server Business Intelligence (SQL, SSIS, SSRS, SSAS)
Data Warehousing design methodologies
Team Foundation Server (TFS)
Agile / Scrum project methodologies
ITIL Certified preferred
ITIL Certification
Microsoft Business Intelligence certification is a plus
ServiceNow data model knowledge is a plus

Senior Data Warehouse Developer Resume Examples & Samples

Develop and support world class end to end Data Warehouse and Business Intelligence solutions for analytics and management teams
Create and maintain complex SSIS ETL packages
Create complex queries, data transformation, aggregation, stored procedures, and triggers
Consult with business partners such as marketing analysts, management, and other developers to clarify program objectives, determine scope, identify problems and recommend solutions
Develop of ad-hoc SQL to research data questions
Performance tune ETL, stored procedures, and reports to keep databases and applications optimized; identify root causes in case of ETL failures
Perform code reviews, data validation, and system testing for data warehouse changes
Interact closely with members of both IT and the business
Thrive in a dynamic, technology savvy, high performance culture with minimal supervision

Data Warehouse Developer Resume Examples & Samples

Comply with standards and guidelines related to the design, construction, testing and deployment activities within the Delivery Management environments
Demonstrate collaborative skills working within a project team of diverse skills and will bring communication skills including oral, written and presentation skills, creativity, and problem solving skills to a challenging environment
Identify opportunities in business processes, system capabilities and delivery methodologies for continuous improvement
Bachelor's degree in a technical area of study; OR equivalent professional experience
4+ years of TSQL experience (developing procedures, functions, SQL queries, etc.)
4+ years of experience with ETL or ELT tools (SSIS, Datastage, Informatica, Talend, etc.)
Ability to work non-standard hours occasionally as necessary for deployment/load support
Experience working with a virtual team environment over multiple locations, including off-shore
An understanding of a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models
Strong analytical and technical aptitude
Microsoft Technology Stack (SQL, SSIS, SSRS, PDW)
Experience with multiple programming languages (shell scripts, C#, VB, TSQL or other)
Healthcare industry knowledge
Experience dealing with large warehouse queries (Performance optimization)

Data Warehouse Developer Resume Examples & Samples

Collaborates with business unit liaisons to understand and develop business and functional requirements
Change management of existing database tables/views and data models
ETLs job creation, maintenance and supervision
Database programming (procedures) and administration of BI/DWH back office
Attends team meetings and daily scrums with in-house as well as remote colleagues
Ad-hoc analysis and data extractions
Performs technical analyses for development of new features
Maintains the knowledge base and follows documentation process rules
Ability to write software code in database environments
SQL and PL/SQL knowledge is essential
Understanding of RDBMS architecture
Data warehousing and ETL principles
Experience with RDBMS performance tuning, partitioning and indexing strategies, materialized views management
Experience with Oracle
Experience with Data Science (Predictive Analytics, Machine learning, R)
Degree in Computer Science, Software Engineering, Statistics, Mathematics or similar
At least 5 years of experience in IT
At least 3 years of experience in database development

Data Warehouse Developer Resume Examples & Samples

Bachelor’s degree in a technical area of study or equivalent professional experience
4+ years of experience developing procedures, functions, packages and SQL queries
4+ years of experience with ETL or ELT tools (SSIS, Datastage or other)
4+ years of experience troubleshooting
Experience dealing with large warehouse queries (performance optimization)

Data Warehouse Developer Resume Examples & Samples

Collaborate with technical teams to develop solutions that are reusable
Understand modeling and/or diagramming techniques, with the ability to create process flow diagrams and understand the entity relationship models
Document technical designs to ensure clients’ needs are captured
Research, evaluate, identify alternative design and test approaches, and lead code reviews
Develop ETL code that meets technical specifications and business requirements according to the established designs and framework
Proactive and diligent in identifying and communicating development issues and recommending potential solutions
Troubleshoot development and operational problems and provide timely solutions
2+ years’ experience in developing applications in a high volume ETL DataStage environment
2+ years’ experience with SQL, Teradata, Oracle in Unix environment
2+ years’ experience in a technical leadership role
Strong written and verbal communications skills required; ability to lead project meetings, communicate with business stakeholders, and report to management
Understanding of data warehousing architecture is a plus
Attention to detail and maintaining high data quality standards
Tivoli Work Load Scheduler and Shell Scripting (UNIX/Linux) is a plus
Bachelor’s Degree required, preferably in Engineering or Computer Science

Senior Data Warehouse Developer Resume Examples & Samples

Position functions as a leader inside the Data Management Team to create scalable ETL and reporting solutions which meet the business needs of the organization
Partner with Business Analysts, Subject Matter Experts from TCB’s Business Units, and counterparts in IT to complete system requirements, technical specifications and process documentation for assigned projects
Review, analyze, and evaluate the scope of the business problems presented and help identify viable technical solutions
Develop ETL and data warehousing solutions with the SQL Server product and services
Drive data warehouse architectural decisions and development standards
Create detailed technical specifications and release documentation for assigned ETL projects
Ensure data integrity, performance quality, and resolution of data load failures
Multi-task across several ongoing projects and daily duties of varying priorities as required
Provide input into each phase of the system development lifecycle as required
Ensure adherence to published development standards and database best practices, resulting in consistent and efficient implementation of project components
Ability to make good judgments, decisions, negotiate and problem solve
6+ years of experience as ETL/BI developer working directly with large scale data warehouses required
Advanced experience with SQL Server 2008R2/2012/2014/2016, including T-SQL, SSIS, SSAS, and SQL Agent required
Proven knowledge and ability developing against both relational (OLTP) and dimensional (OLAP) data models required
Bachelor’s degree in Computer Science or MIS related area required
Strong discipline in full life cycle development required
Experience with Master Data Management and related services (MDS) and tools highly desired
Experience with Azure SQL products and services highly desired
Experience with Salesforce and other SaaS data integrations desired
Experience with reporting tools (Power BI, Tableau, etc.) desired
Experience with TFS desired
Banking and/or financial services experience desired
Experience with agile development methodologies desired
Advanced knowledge of data warehousing best practices and practical applications
Strong project team leadership experience including maintaining system backlogs, and leading team members
Detailed-oriented with a proven history as a self-starter who can work independently with minimal supervision
Strong oral presentation and written communication skills
Outstanding organizational and effective time management skills
Ability to obtain, analyze and synthesize information from multiple sources
Excellent problem-solving, analytical and critical thinking skill

Senior Data Warehouse Developer Analyst Resume Examples & Samples

Works with our project team members and business contacts to understand business needs and drivers, develop domain expertise, and identify MathWorks' analysis and reporting requirements. Develops strong working relationships across MathWorks. Must be solution-oriented and comfortable working on complex problems in a fast paced environment. Proposes viable solutions and ensures that business needs are met with a high degree of satisfaction
Expertise working with data to solve operational and analytical use cases
Develops and makes changes to our reporting environment using tools like Business Objects Universe Designer and Tableau
Participates in the design review processes, while providing technical advice, support, and mentorship to other team members
Extensive hands-on expereience with leading reporting and visualization tools, such as BusinessObjects, Tableau, and Power BI
Participating in on-call 2nd-tier rotation supporting the nightly DW loading process
A bachelor's degree and 7 years of professional work experience (or a master's degree and 5 years of professional work experience, or a PhD degree) is required
Demonstrated experience in/with ETL
BS degree in a technical field
5+ years of experience in IT software development (such as Systems Analysis, Data Warehousing, ETL, and QA areas)
3+ years’ experience with ETL tools, such as Informatica, SAP Data Services, or MS SSIS
Expert-level SQL coding/querying skills in SQL Server and/or MySQL
Great interpersonal and communications skills, while establishing and maintaining effective work relationships with technical and business team members
Must be comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools and concepts quickly

Data Warehouse Developer Resume Examples & Samples

Participate in design, development and support of Data Warehouse solutions
Work with stakeholders to understand business needs and develop highly scalable solutions and make recommendations to help solve problems or improve processes
Understanding and working with multiple data sources to meet business rules and supports analytical needs
Create stored procedures, SSIS packages, and using other methods to import/translate/manipulate data
Analyze potential data quality issues to determine the root cause, and creating effective solutions
Deliver high quality projects on time and budget in fast paced environments
Extrapolate database schema to meet the business needs of the application
3+ years of experience working directly with data warehouses
3+ years’ experience on SQL Server Integration Services
3+ years’ experience designing, developing, testing, and supporting of ETL, and OLAP cubes
Advanced knowledge of OLAP technologies, and dimensional modeling
Net or Java programming skills

Data Warehouse Developer Resume Examples & Samples

1) SSIS / Integration
2) Data Models / Data Modeling
3) Analytical experience within DW
A healing focus
Responsible for creating software code that will extract data from source systems, transform it as necessary and load it into data warehouses and/or into data marts required during the development, quality assurance and transition to production phases
Help data analysts run data profiling scripts and documenting the results
Create detail design specifications based on architecture and design specifications
Document satisfaction of requirements in design specifications to help with requirements trace-ability
Participate in design specification quality assurance reviews involving a data integration architect and data integration designer
Create unit test data to ensure that the code performs under all expected conditions
Develop data integration software using SSIS (SQL Server Integration Services)
Conduct unit tests in a personal schema to ensure that the code meets specification
Document test results and store test data and results in a project documentation repository
Participate in code reviews with data architects, lead developers and other developers
Be accountable to the data integration architect for the quality of data warehouse developer deliverables
5-10 years of experience working in a data warehouse environment using SSIS and Microsoft SQL Server
7+ years of experience in advanced SQL and be able to write complex logic using SQL as part of ETL, and use SQL effectively to perform complex data analysis and discovery
Must be detail-oriented and have a critical eye for data quality
Demonstrated ability to troubleshoot, optimize and performance-tune existing SQL code
Demonstrated ability to perform data analysis/discovery and communicate results in business friendly terms
Extensive related experience in lieu of education will be considered
Experience in healthcare a plus
This job requires access to confidential and sensitive information, requiring ongoing discretion and secure Information Management

Data Warehouse Developer Resume Examples & Samples

Develop ETL processing across multiple applications including BI, POS, & Inventory
Custom development and maintenance of MicroStrategy and data warehouse
Participate in data model design and data build for the enterprise Data Warehouse
Perform UAT on software to ensure changes function for affected business processes and reporting
Supply knowledge and training as applicable to changes
Document designs, specifications and flow diagrams to assist in efficient development, support and problem analysis
Produce test plans and load test conditions that for all sites affected by software alterations
Assist with IT controls documentation
Communicate clearly and effectively with business users and technical teams through all phases of the development life cycle
Research and troubleshoot reported problems and conduct ongoing maintenance and development
Provide on-call support of production applications as part of a rotation within the development team
3 years of experience with ETL development
Experience with development with the following toolset

Senior Enterprise Data Warehouse Developer Resume Examples & Samples

Translate strategic requirements into usable enterprise architecture, including enterprise models, associated meta-models, common business and technology vocabulary, and taxonomies, which will then be used to guide enterprise solution development and achieve consistency of information assets across the application portfolio
Determine the strategic and tactical enterprise goals that provide traceability through the organization and are mapped to key success metrics to provide ongoing governance oversight
Ensure existing IT assets are identified, stewarded and leveraged across the enterprise
Evangelize the enterprise architecture process, its outcome and ongoing results
Develop a business architecture strategy based on situational awareness of various business scenarios and motivations
Collaborate across multiple teams to research, architect, engineer and configure complex database solutions to specified requirements in support of global, business critical systems
Document database designs, solutions, configurations, and teach/mentor other support tiers, team members and vendors including onboarding and knowledge transfer
Coordinate and oversee the assignments, delivery, and quality of other database administrators
Continuously improve system and database performance, automation, operations and processes
12+ Years of architecture and hands-on development of Enterprise Data Warehouse environment with focus on Data Integration (ETL)
10+ Years of focused experience in developing Data Warehouse and ETL in SQL Server and Talend ETL environment
Expert level demonstrated experience in full data warehouse implementation and knowledge of both Kimball and Inmon approaches
Hands on experience with data modeling, development of staging, EDW, and presentation layer (Star/Snow-Flake)
Proficient with SQL, Complex SQL Tuning, Stored Procedures, SQL Server Data Warehousing best practices etc
Hands on experience architecting and developing ETL in a Talend environment. Expert level understanding of ETL framework – Developing Audit, Balance, Control; Validation architecture etc
Required experience with Azure or AWS-Redshift
Ability to work with Senior Enterprise Architects and Data Architects to develop EDW logical and physical roadmap
Ability to advice senior IT management on Data Warehouse and ETL trends
Bachelor’s degree with 12+ years of architecture and hands-on development of Enterprise Data Warehouse environment with focus on Data Integration (ETL)

Senior Data Warehouse Developer Resume Examples & Samples

Develop the overall data warehouse design i.e. conceptual, logical, and physical models for different domains i.e. Finance, Sales, Support & Marketing subject areas
Work directly with internal business analysts and functional users to understand the requirement and perform detailed data analysis to develop the model for the data warehouse and data marts
Ensure that new data warehouse solutions meet defined technical, functional, and service level ‎requirements and standards
Manage the end-to-end lifecycle for new data integration, data migration and data services oriented solutions
Develop new ETL applications, maintain, support and improve the performance of existing applications in production
Minimum 4-6 yrs. experience in requirement, analysis, design , development , testing and implementation of data warehouse applications using dimensional data modelling techniques
Exceptional background in design, development, testing and implementation of ETL applications
Minimum 3+ yrs. experience in designing and developing ETL jobs using Oracle Data Integrator ETL tool or any other ETL tool i.e. Informatica will be preferred
Minimum 4+ experience in designing and developing database applications using SQL,PLSQL and procedures/functions using Oracle database 11g
Experience in creating in Unix Shell scripts for creating data extracts and automating ETL jobs
Knowledge of pre-built Oracle BI Apps ETL jobs for Oracle business analytics warehouse (OBAW) and in depth knowledge of Oracle BI APPS 11.1.1.9 is a plus
Strong functional knowledge of Oracle EBS and CRM source system is a plus

Data Warehouse Developer Resume Examples & Samples

Bachelor's degree in Computer Science, Business, or Engineering or equivalent work experience is required
Oracle and/or Informatica certifications would be a plus
Three to five years of experience maintaining and administering a multi terabyte sized Oracle data warehouse in a UNIX (AIX) environment. Hands-on experience using Informatica Power Center for loading and maintaining a data warehouse is required. Demonstrated analytical, problem-solving and conceptual skills. Excellent oral and written communication skills and the ability to communicate effectively with non-technical people
Thorough understanding of the relational database model and experience in designing, modeling, developing and supporting data warehouses. Experience working with diverse data sources. Knowledge of SQL query optimization and performance tuning. Experience in entity relationship data modeling and data modeling tools. Knowledge of star and snow-flake schemas

Data Warehouse Developer Resume Examples & Samples

Works with team to create data sets and data interfaces for reporting
Manage and support the reporting environment
Establish and document reporting standards and best practices, Enforces standard development protocols, and analyzes requirements to ensure technical and standard operating procedure impacts are considered. Develops and coordinates test plans
Translate business requirements into specifications that will be used to implement reports and dashboards
Work with data services team members to integrate and leverage data infrastructure in the application layer
Collaborates with the Data Services team and business stake holders to learn the aspects of the business and develop analytic insight

100

DB \ Data Warehouse Developer Resume Examples & Samples

To develop stored procedures, triggers, MQTs and views on our DB2-based Data Warehouse
To assist the Informatica ETL developers with their development of complex ETLs
To perform data profiling and analysis on source system data to ensure that source system data can be integrated and represented properly in our models
To monitor the performance of queries and data loads and perform tuning as necessary
To develop and tune views within our Cisco Virtual Data Platform
To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues
Bachelor?s degree in Computer Science, Software Engineering, Information Technology, or related field required
At least 7+ years of experience in data development and solutions
At least 7+ years for SQL experience with the ability to write ad-hoc and complex queries to perform data analysis
At least 5+ years of experience developing complex stored procedures, triggers, MQTs and views on IBM DB2 (experience with v10.5 a plus)
At least 3+ years of experience with Informatica
An understanding of E-R data models (conceptual, logical and physical)
Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal \ BI-Temporal models, etc.)
Experience with BI applications like Cognos a plus
Experience with Cisco Virtual Data Platform (previously known as Composite) a plus
Experience with NoSQL databases such as MarkLogic a plus
Experience with Autosys a plus
Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions
Experience with both Waterfall and Agile development methodologies
Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels
Self starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to competing priorities
Strong problem solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements and priorities
Overall technical understanding of data warehousing, business intelligence, web and other multi-tiered, distributed applications/systems

101

Data Warehouse Developer Resume Examples & Samples

Support the current AR datawarehouse and BI environment
Will work closely with business users and able to support month end, quarter end and year end reporting production cycles with ownership and accountability
Load and validate ETL data into the regulatory reporting DW
Comply with the standard release cycle and deployment controls
Perform all application unit and system testing, as appropriate
Support users with adhoc queries relating to regulatory reporting
Support the loading and integrity of the data warehouse
Create data dictionary’s and proper documentation on the DW_ warehouse (Oracle DB)
Gather Business Requirements
Support requirements and design of future reporting needs (regulatory and internal)
Will be responsible for production support
Must adhere to all internal IT policies and controls while handling sensitive financial production data
Solid Oracle OBIEE skills with 11g or later
Solid SQL Server Development skills
Experience of writing ETL Packages
Data Warehousing Design Experience
Experience of working within a large database development project team)
Prior Experience in Regulatory and Compliance Reporting will be an added advantage
Prior experience of supporting internal management reporting will also be considered as an advantage
Data Architecture
DB2 Warehouse
DBA Oracle 10g

102

Data Warehouse Developer Resume Examples & Samples

Minimum 5 years of data analysis, architecture, transformation, governance, and management
Minimum 2 – 3 years of database development and operation experience
Minimum 2 – 3 years of reporting and dashboard experience with preference to Tableau
Experience in project management
Experience communicating and presenting to executives and directors
Excellent core consulting skills in interviewing, writing and communicating orally
SQL Server experience
Must be able to work independently and leverage and support the greater Grant Thornton team to accomplish tasks
Must understand how data can be architected to provide high-performance analytics
Must be able to develop low-cost alternatives for databases and infrastructure; including, cloud options
Must remain agile to changing client priorities
Must be to schedule work to completion on schedule
Must be able to interact with client personnel at employee, management and leadership levels

103

Data Warehouse Developer Resume Examples & Samples

Develop data models and ETL process that address data quality best practices and promote data integrity
Create data layers for the business to consume
Assist with identifying required data in various source environments as well as identifying data quality gaps
Develop required extract programs or methods
Ensure integration testing of data from various sources
Map data to the B/W environment as well as fine tune to improve performance
7+ years of experience designing, implementing and deploying into production an enterprise data warehouse including defining data standards and creating data models
5+ years of experience working with SQL Server databases
5+ years of experience designing security at both the schema level and the accessibility level in conjunction with the DBAs
5+ years of experience tuning ELT and reposting processes
5+ years of experience developing SAP BEx queries and developing Business Objects Universes for use by the business
1+ years of experience ABAP programming
1+ years of experience working with Business object front-end tools (Webi, Lumira, Business Analysis for Office)

104

Senior Data Warehouse Developer Resume Examples & Samples

Oracle 11g or newer - Function and Performance Analysis and Tuning (SQL & PL/SQL)
ETL Design and Development using Informatica PowerCenter
Batch Scheduling using Control-M
Unix including shell scripting
Java
Automation / Continuous Integration
Excellent Personal and Team Organizational Skills
Mentoring of Junior Team Members
Agile Application Development Techniques
Standard Database and DWH Modelling Techniques
Data Lineage tools
Fluent English language skills required

105

Data Warehouse Developer Resume Examples & Samples

Solid and effective written, interpersonal, oral and presentation skills
Excellent analytical and problem-solving ability
Understanding of relational and dimensional data models
Proven ability to produce logical flows to support the design of data solutions
Proven ability to describe technical solutions to non-technical audiences
Ability to produce data flow diagrams that can easily show data lineage
Skilled in requirements gathering and data analysis
Data sourcing, data mapping and managing metadata
Documenting and analyzing workflow and clinical processes
Experience and knowledge in developing complex SQL scripts in various RDBMS environments
Thorough understanding of Data Modeling, including ER and Dimensional models
Healthcare/Research industry experience required
Knowledge of analytical tools, business intelligence tools, and statistical packages a plus
Experience with data management preferred
Ability to plan and facilitate meetings with diverse participants
Ability to effectively work on a team

106

Senior Data Warehouse Developer Resume Examples & Samples

Design, develop, test and implement logic to extract, transform & load data from transactional applications into the DW using Oracle Data Integrator (ODI) and PL/SQL
Help End Users Understand and query data to accomplish their business purposes
Partner with Database and Middleware Administrators to achieve great application performance
Demonstrate advanced skills while coaching and mentoring less senior team members
Design, code, test and deliver insightful and architecturally sound business solutions
Document code and projects so others can easily understand
Fulfill customer requirements as measured in customer survey scores
Show insight; know your application design & data; offer simple, working solutions
Apply team coding, documenting and testing standards and recommend process improvements
Recognize upstream and downstream impacts; communicate effectively (verbally & in writing)
Learn the Business Process Your Application Supports so your code will better support the business
Improve your application and team processes
Decrease incidents and increase uptime of your application
Attendance as required by department
Minimum of 5 years DW design and development experience
Minimum of 5 years Information Systems experience
Knowledge of ETL tools -Oracle Data Integrator Enterprise Edition
Proficiency in PL/SQL coding, troubleshooting, and performance tuning
Experience with Oracle Database (version 11 or 12 preferred)
Willingness to participate in an On-call rotation
Remain compliant with our policies, processes and legal guidelines

107

Data Warehouse Developer Resume Examples & Samples

Develop ETL database scripts / stored procedures based on technical requirements
Perform data analysis, develop database design, share and get consensus on design, and then develop the stored procedures to fulfill the database design
Resolve data validation and performance concerns identified by the developers and/or the DBA
Provide technical support to the testing and production implementation team as needed
Collaborate with customers to develop functional requirements, identify options for meeting those requirements, recommend a course of action and follow through implementing or overseeing all technical aspects
Bachelors or Masters in Information technology with Math/Statistics or equivalent 10 years’ experience
5 years of working experience with MS SQL Server including but not limited to database design, developing SQL scripts and stored procedures
5 years of experience with systems analysis and data warehousing
Experience working with MS SQL Server 2008, 2012, and/or higher
Experience creating source to target data mapping design specifications using SSIS
Experience developing data validation and data reconciliation SQL queries to confirm appropriate transformation of data and identify issues in source data for data cleanup
Performance tuning experience to ensure optimal use of DB resources
Demonstrated experience scaling to profile / assess rules against large enterprise systems
Ability to review, understand and validate logical and physical data models
Experience working with data encryption and understanding of compliance policies regarding data
Solid troubleshooting and defect tracking skills
Deep understanding of source data, its strengths, weaknesses, semantics, and formats
Strong critical thinking, operations and systems analysis, and problem solving skills
Consultative approach and work ethic should be described by the following

108

Data Warehouse Developer Resume Examples & Samples

Bachelor degree in relevant field
6-8 years IT experience including the following
Self-starter with the ability to work independently through the development process from request, design, implementation, to testing and maintenance
Strong analytical, quantitative, problem solving and critical thinking skills to assess reporting needs and determine the appropriate actions needed
Good verbal and written communication
Comfort working in a large, dynamic and complex technical and operational environment
Data Warehouse development in a hospital or healthcare environment extracting data from Epic’s EMR system
Experience developing MDX queries
3-5 years exposure to Reporting Tools such as Crystal Reports and Business Objects
Development of Enterprise Dashboards and KPI

109

Data Warehouse Developer Resume Examples & Samples

Design, test, implement, and maintain DML, data structures and schemas contained in the segment data warehouse to support logical database design and development
Develop complex ETL queries to extract, calculate, and/or manipulate data from various disparate sources into the data warehouse
Using Oracle Data Integrator (ODI), develop and implement packages, scenarios, and mappings based on extract, transform, and load methodologies
Provide environment performance assessment using tuning and optimization, query optimization, index tuning, caching and buffer tuning, database health monitoring and diagnostics
Attend data mapping sessions, provide inputs to ensure mappings are accurate from a technical standpoint. Understand business requirements and translate them into robust technical specifications
Facilitate responses to database issues, outages and recoveries in critical situations, serving as a resource to remedy difficult technical issues
Basic understanding of creating business reports using Tableau, ability to troubleshoot issues in report generation
Bachelor's degree in Computer Science or Engineering or related field required
6+ years of continuous database experience in solution architecture, data migration and integration
Oracle 12c, Oracle SOA, ODI 12c, Java, Microsoft SQL Server, DB2, *nix, Tableau
Expert in database architecture, scalability and bandwidth for complex environments; Thorough understanding of end-to-end Enterprise Data Warehousing architecture, source-to-target mappings, and reporting methods
Experience in data projects working with ETL, ODI, Cognos, Informatica, and related data modeling tools
Expert at problem solving with high degree of data analytical skills
Experience designing, modeling, documenting, and guiding the logical and conceptual relationship of data and database changes in an Oracle environment
Experience in using OEM to perform basic database and ODI administration activities that include but are not limited to query tuning, tablespace management
Proven experience in implementing data warehouse systems with emphasis on large scale data transformation and conversion, and star schema designs
Experience in developing session partitioning, parallel processing, mapping variables, mapping parameters, workflow variables and session parameters, functions, stored procedures, and views
Ralph Kimball Data Warehouse methodology
Informatica Power Center experience
Finance and ERP exposure
O&G industry background
Oracle Managed Cloud Services

110

Data Warehouse Developer Lead Resume Examples & Samples

5+ years of Data Warehouse ETL Development using commercial ETL tools (preferably SSIS 2012/2014) and BI (preferably SSAS 2012/2014)
Experience with SSIS, SSAS, and SSRS
Experience in SQL programming (stored procedures, functions, triggers, query plan analysis, etc.)
Experience conducting DBA activities on MS SQL Server. Windows Server 2008 & 2012
Hands-on experience leading the architecture, construction, and deployment of an end-to-end ETL platform

111

Junior Data Warehouse Developer Resume Examples & Samples

Major duties include designing/developing/administering ETL production processes, performing data verification/validation activities and serving as an active member of the HCE Data Management team
Solves moderately complex problems and/or conducts moderately complex analyses
Works with minimal guidance; seeks guidance on only the most complex tasks
Translates concepts and developments into an automated production process
Provides explanations and information to others on difficult issues
Acts as a resource for others on assigned production flows/processes
Under minimum supervision, completes projects and development activities timely and accurately while following the System Development Life Cycle (SDLC)
Responsible for maintaining and supporting several extracts and reporting deliverables for all customers of the Mountain West Region (NV,UT,AZ) market
Develop and maintain data-mart ETL processes
Suggest changes and enhancements for ETL processes
Maintain ongoing self-study program (with mentored guidance) to enhance knowledge of: Oracle RDBMS, MSSQL, TOAD, Oracle PLSQL, Microstrategy, ArcGIS and Informatica PowerCenter
Document development activities by following SDLC and IS change management guidelines
Bachelor's Degree in Management Information Systems or Computer Science
Classes in Database Design
Classes in SQL
Classes in Software/DB Development
Experience with relational databases and data marts (MSSQL, Oracle RDBMS 10g/11G/12c)
Experience with Oracle PLSQL Development
Experience with MS SQL Server T-SQL, SSIS, Job Scheduling/Monitoring
Experience with Extract, Transform, and Load (ETL) tools
Experience with Informatica PowerCenter and/or Microstrategy a Plus

112

Senior Data Warehouse Developer Resume Examples & Samples

Strong Oracle database knowledge (SQL, PL/SQL, basic administration …) - 5 years of experience minimum
Strong Unix scripting knowledge (best practices, limitations, error handling …) - 5 years of experience minimum
Experience with Computer Associates Autosys scheduler or other scheduling/monitoring tools
Must have banking industry experience
Worked in Agile environment and familiar with Waterfall & Agile development methods
Atlas2 Infocenter BNP Paribas application knowledge is a huge plus
Knowledge on development methodologies: Waterfall
Knowledge of CMMI (Capability Maturity Model Integration)
Good communication skills both oral and written to be able to work with a varied user base
Previous experience in large corporate environments (Finance preferred)

113

Senior Data Warehouse Developer Resume Examples & Samples

Must be skilled with all Datastage modules, development strategies to create efficient loads, tune projects, manage resources for a Netezza data appliance environment
In collaboration with Data Architect, architect Datastage (v. 11.5) jobs to migrate and transform data to a IBM Industry Model Healthcare Enterprise Data Warehouse utilizing knowledge of dimensional data warehouse
Enforce object reusability, provide administrative and technical expertise in the Datastage platform, and lead development team in creating efficient data flow solutions
Designs, develops and implements complex Extract, Transform, and Load (ETL) procedures
Develops data warehouse process models, including sourcing, extraction, transformation and loading
Creates execution plans, test files and scripts for data warehouse testing
Produces supporting documentation, such as metadata and diagrams of entity relationships, business processes and process flow
Develops and maintains standards, including organization, structure and nomenclature, for the design of data warehouse elements (data architectures, models, tools and databases)
Implements business rules via stored procedures, middleware or other technologies
Maps data between source systems, data warehouse and data marts
Performs system analysis, data analysis or programming
Selects methods, techniques or criteria for data warehousing evaluation procedures. Verifies structure, accuracy and quality of warehouse data
Writes new programs or modifies existing to meet project requirements
Investigates and tests new software solutions or products, as necessary
Provides mentoring and coaching to team members and affiliated teams, as needed
Reviews and provides guidance to the development team and recommendations to optimize the data extraction and loading using ETL jobs
Develops and implements corrections and improvements according to change requests
Collaborates and works with multiple technical and business units to resolve support issues
Bachelor’s Degree in Computer Science, Information Technology or related technical field, required
Minimum ten (10) years of experience in the design, development and implementation of databases/data warehouses
Must have 3+ Datastage experience in a leadership role + 2 years in development
Strong understanding of ETL design and development such as direct-path loading and parallel SQL
Strong understanding of data warehouse concepts and architecture. Understanding of star/snowflake schema design; dimension and fact tables
Strong understanding of Oracle and SQL Server database architecture
Understanding of data modeling and design including partitioning, indexing, constraints and optimizer statistics
Experience with development methodologies such as Agile
Full life cycle experience (requirements gathering through production deployment) in all aspects of Business Intelligence and Data Warehousing
Analytic, process flow, problem solving, communication, customer service, organization skills, required
Knowledge of Health Industry and Healthcare Data Exchange Standards (HL7, CCD), preferred
Knowledge of web services (SOAP, REST), preferred

114

Data Warehouse Developer Resume Examples & Samples

Expert in data services over Oracle
Expert in data modeling for relational and OLAP environments
Expert in ETL design and implementation
Expert in database change management and development lifecycle
Strong understanding of Data Warehouse model type benefits and drawbacks
Experience implementing database row and column level security
Experience with PL/SQL packages, functions and stored procedures, a plus
Strong Linux shell or similar scripting skills
Experience with Oracle 11g or 12c
Experience designing, implementing, maintaining a data warehouse of similar size
Experience in Oracle database modeling/architecting including partitions
Experience with database query monitoring, tuning, and optimization
Experience in Oracle backup and recovery process
Experience with SAP Business Intelligence platform, preferably Business Objects 4.x
Experience archiving historic source data after warehouse loads
Expert knowledge of database tools: e.g. TOAD, SQL Developer, SQL*Plus
Experience supporting and/or migrating data from other sources
Excellent communications and teamwork skills
Previous work with Government or DoD programs
Experience with CMMI, ITIL, or similar standards
Strong analytical and problem solving abilities
Additional work hours including weekends, holidays, and on-call as required
Must obtain prior to employment

115

Data Warehouse Developer Resume Examples & Samples

Demonstrates ability to align presentation tools with audience to ensure and enhance effective communication
Designs, coordinates and conducts the testing of custom software development updates/fixes and routine maintenance
Validates that custom developed systems operate and perform properly through the implementation of controlled unit, system, integration, and volume testing
Recommends alignment of resources and plans to meet development needs
Designs, manages and/or leads the implementation of improvements, enhancements, and updates to custom applications
Responsible for executing project tasks including development of project work plans, resource plans, schedules, costs, administrative reports, and acceptance criteria
Manages/leads the requirements analysis, functional specification definition and design processes, and implementation and testing of enhancements
Evaluates and provides technical direction to Information Systems associates and user departments
Develops and executes test plans to validate applications prior to requesting a move to production so that no significant problems are found in production
Develops application requirements and appropriate documentation, including analyzing needs, developing functional requirements, and determining the best approach to the application
Participates in and/or leads meetings, committees, task forces, and/or multi-disciplinary quality and service improvement teams as a subject matter expert
Provides customer support for assigned applications including coaching customers on how to use the application and resolve customer problems
Serves as a subject matter expert in current technology, trends and developments in the healthcare industry
Serves as an expert in problem analysis in support of decisions and planning within the enterprise application service area
Analyzes the impact of application modules on departments
Serves as project leader in small to medium scale projects including developing project administration documents, developing tasks, providing periodic updates and coordinating project related activities
Follows established procedures for project startup, system and database design, project completion and move-to- production
Supervises the day-to-day operations of the Application Development and Support group
Assures timely and professional customer service relative to the development and support of applications
Trains, orients, and assigns department staff
Evaluates performance and conducts performance management planning
Maintains ongoing communication with staff to review programs, provide feedback, discuss new developments, and exchange information
Coaches, guides and mentors application support staff members
Provides leadership by example
Strong SQL experience, especially with database design, modeling data, creating data marts
Strong customer service and communication skills
BizTalk experience is highly preferred
Strong SSIS experience is a must
Experience with both OLTP and OLAP – data modeling, DB design, loading data, pushing data into an operational system, familiar with dimension tables
Familiarity with SSRS and Tableau
Must have a background in healthcare insurance/payer industry, Medicaid payer knowledge is a plus
Full SDLC experience, specifically in an Agile/SCRUM environment
Start-up/entrepreneur background/mentality

116

Senior ETL / Data Warehouse Developer Resume Examples & Samples

10+ years in IT experience, especially in data warehouse and SDLC
Strong experience in large-scale data warehouse development life cycle
Strong experience in data architecture and data modeling
Strong experience in Informatica
Strong data analysis and problem solving skills
Very strong SQL skills
Experience on PostgreSQL database and is a plus
*Please note that as a member of the Apex Systems team, you’d be eligible for Health, Dental, Vision and Life Insurance; Short Term Disability; Hospitalization Coverage; Direct Deposit; Weekly Pay Periods; Training and Development Programs; and our Referral Program.***

117

Data Warehouse Developer Resume Examples & Samples

Relevant Experience or Degree in: Information Technology, Mathematics, or related field
Typically Minimum 6 Years Relevant Exp
Development and data warehouse design experience
None Identified
Skills / Knowledge - Having wide-ranging experience, uses professional concepts and company objectives to resolve complex issues in creative and effective ways. Some barriers to entry exist at this level (e.g., dept./peer review)
Job Complexity - Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results. Networks with key contacts outside own area of expertise
Supervision - Determines methods and procedures on new assignments and may coordinate activities of other personnel (Team Lead)
Development Skills - Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
Design Abilities - Data warehouse design
Computer Knowledge - Advanced Microsoft Excel

118

Data Warehouse Developer Resume Examples & Samples

Create logical and physical data model designs (including 3NF and dimensional models) supporting the business needs
Work hands on with the new OLAP solution
Design and implement data solutions including data partitioning, data normalizing/de-normalizing, data aggregations, and ETL to support the data warehouse environment
Maintain and guide the technical architecture, standards and infrastructure of the technologies and tools used in the Data Warehouse program
Provide an EDW foundation that will allow for a forward thinking analytical layer
Provide thought leadership with regards to creative data profiling and integration recommendations
Oversee data warehouse testing and participate in regression testing as it relates to the data warehouse environments or data marts
Provide strategic and tactical guidance with respect to data warehousing / data mart best practices
Support the Business Intelligence Solutions Architect with overall information strategy and roadmap including data governance, master data management, and identification of enterprise-level data
Work with business users to review and provide input into functional and non-functional requirements
Provide consulting and conduct reviews through the development lifecycle
Drive increased data warehouse maturity with continuous improvement towards an enterprise data model
Other IT projects and duties as assigned
Database development including stored procedures, stored functions, triggers, and views
Knowledge of different data models (3NF, star schema, and snowflake schema) and when to use them
Work across multiple teams in an open and collaborative way to design holistic solutions, solving business problems
Knowledge of SQL Server 2016 functionality
Knowledge of the Microsoft Business Intelligence stack (SSIS, SSRS, SSAS)
Strong analytical, evaluative, and problem-solving abilities
Experience with BI reporting tools, such as Tableau or Microsoft Power BI preferred
Demonstrate proficient use of data analysis, data integration, and data visualization techniques that inform and accelerate decision-making
Excellent communications skills at both the IT and business levels
Formalized audit and/or financial training desirable
Azure experience a plus
Business Intelligence experience desirable
Data analysis, design, & testing
Data stewardship & governance
Solution architecture & planning
Critical thinking & problem solving
Excellent oral & written communications
Technical & business analysis
Implementation of solutions applying development life cycles. Agile experience desired
Languages: SQL, HTML, XML, C#, .NET
Microsoft: Word, Excel, Access, PowerPoint, Visio, SQL Server

119

Data Warehouse Developer Resume Examples & Samples

Assist in construction of enterprise data warehouse (EDW)
Translate user requirements for reporting and analysis into data warehouse deliverables
Develop and implement data auditing strategies and processes to ensure data accuracy and integrity
Support operation and expansion of data warehouse and reporting environment
Manage multiple projects in a fast-paced environment
Extract and load enterprise data into the data warehouse using cutting edge technology
Monitor performance and reliability of load processes
Bachelor’s Degree in Computer Science (masters preferred), Information Systems or related field required
Minimum of 2+ years of SQL experience
Minimum of 2+ year ETL experience with SSIS or equivalent
Must have one year of experience with AWS Redshift
Sound understanding of Kimball design principles for Data Warehouse
C#/Java experience a plus
C#/Java
Familiarity with streaming technologies (Spark, Kafka, EMR)
Familiarity with Tableau a plus

120

Senior Data Warehouse Developer Resume Examples & Samples

Expert knowledge of Transact-SQL
Minimum seven (7) years’ experience of the following technologies is required: SQL Server 2008/12, SQL Server Integration Services
Experience modeling and designing Relational Databases, Star Schemas, and cubes (Kimball)
Proven ability to work with end users to translate high level requirements into a solution approach including both high level and detailed estimates
Highly organized team player with the ability to innovate, multi-task and set priorities effectively
Experience in logical and physical data modeling
Ability to quickly understand both business and technical concepts
Self-starter with strong verbal and written communication skills
SQL Server Analysis Services (a plus, not required)
Experience with using MDX to query Analysis Services cubes (a plus, not required)

121

Data Warehouse Developer Resume Examples & Samples

Analyze business requirements and legacy reports to drive new development utilizing 3rd party development tools, SSIS, and SQL Server
Interface and communicate with business customers and team leads for scope, estimates, requirements and project deliverables
Interface with the various information technology groups, as needed, for source-to-target mappings and reporting interfaces
Work with DBA's, as needed, to manage schema changes
Create and maintain production support documentation
Use project management and systems development life cycle methodologies to achieve on time results

122

Data Warehouse Developer Resume Examples & Samples

Excellent knowledge in developing SSAS cubes in SQL Server 2008 R2 (or higher)
Excellent knowledge in SSIS, SSRS and Data warehousing using the Kimball Methodology
Strong knowledge of SQL Server 2008 R2 (or higher), excellent knowledge of SQL queries, stored procedures and triggers
Proven experiences of large data sets
OLAP / Cube Development
Proven knowledge of MDX (preferable)
Microsoft Certification beneficial
Ability to learn and apply new skills and concepts quickly
Perform design reviews of solutions to ensure the design aligns and supports the specified architecture (current and future state)
Required strong analytical, conceptual and problem-solving abilities
Solution driven
Ability to prioritise and manage time effectively
Ability to find the root causes of problems and quickly determine efficient solutions
Ability to anticipate risks and mitigate them
Comfortable under high-stress
A Relevant IT Degree/Diploma
5 years of experience
SSIS, SSRS, SSAS

123

Enterprise Data Warehouse Developer Resume Examples & Samples

Hands-on experience in delivery of Data & Analytics applications involving structured and un-structured data on the Teradata platform (ETL, ELT) is essential
Working knowledge of tools like Informatica, Teradata Utilities, Bteq, Mload, Fload, Tpump, Advanced SQL, Viewpoint, etc is required
Knowledge of best practices in using Consumption tools like Tableau, Qlik, R, etc that interact with Teradata required
Proven ability to work with project managers and stakeholders to help refine and capture software requirements in an iterative fashion. Accurately forecast engineering effort
Experience with Scrum and an Agile Development strongly preferred
Experience with tools like Jira, git, Confluence, etc is preferred
BS or MS degree in Computer science or equivalent
5+ years professional software development experience

124

Data Warehouse Developer Resume Examples & Samples

The successful candidate should have relevant data warehouse development and data warehouse architecture experience
Extensive experience in working with Enterprise Data Warehouse Frameworks, and direct experience with BI or DW projects over complete software development lifecycle
Understanding of methodologies and techniques for designing data integration, conversion, aggregation, standardization and validation in Enterprise Data Warehouse solutions
Strong data analysis and data profiling skills, as well as knowledge of principles, techniques, and best practices of enterprise data modelling and dimensional data modelling
Experience in Relational Databases (preferably with Teradata) including database design and SQL coding skills
Experience in ETL tools (preferably with Informatica) with an ability to develop ETL design specifications and troubleshoot ETL issues
Strong hands-on experience in UNIX shell-scripting
Experience in defining, introducing and enforcing design and development standards
Ability to provide production support on as-needed basis, e.g. during code deployments, in case of production issue escalations from ASG (Application Support Group) to Application development team
Strong written and verbal communication skills for productive and impactful interactions with the business partners or IT counterparts
Strong organizational, collaboration and relationship-building skills
Ability to multi-task and function efficiently in a fast-paced environment
Ability to function as a self-starter

125

Senior Data Warehouse Developer Resume Examples & Samples

Design/development of enhancements for the existing business processes
Design/development of new functionalities/business processes
Support and maintain the existing development, resolve any issues that may arise
Provide project documentation as per the software development process
Ability to understand and develop business requirements and create design to meet those business requirements
Understands telecom operators applications landscape
Experience with Data Warehouse architecture, design and development - Oracle DB 10g, 11g
Experience with SQL and PL/SQL programming

126

Enterprise Data Warehouse Developer Resume Examples & Samples

8+ years experience must include the following
8+ years of focused development experience with Microsoft product/tools (C#, SQL Server, ASP.Net, Visual Studio, etc.)
8+ years of SQL development experience

127

Enterprise Data Warehouse Developer Resume Examples & Samples

Support the ongoing development and maintenance of our data warehousing systems, including a migration to elastic Cloud Data Warehouse
Work with project teams and business contacts to understand their needs and requirements and ensures the design and delivered solution meets those needs
Work closely with the enterprise data warehouse team to translate business requirements and logical data models into working data artifacts
Understand the source data available and map sources to the target design using a variety of tools: Informatica, Python scripts, plsql
Makes changes to data artifacts to reflect changes required by new subject areas
Monitoring the EDW platform metrics, while recommending and implementing improvements
Bachelor's degree in a technical field -or- equivalent experience
3+ years of experience in IT software development (such as systems analysis, data warehousing, ETL, etc)
3+ years’ experience with ETL tools, such as Informatica, Talend, SAP Data Services, SSIS, etc
2+ years’ experience with Database development, administration, debugging, and tuning
Experience with relational database design/modeling using tools such as ERstudio or ERwin
Expert-level SQL coding/querying skills
Great interpersonal and communications skills
Solid understanding of systems architecture
Experience dealing with large relational data sets, including load performance, query performance, archiving, etc
Project experience with unstructured or semi-structured data
Snowflake cloud data warehouse experience is a bonus
2 years: Database design/modeling
3 years: SQL coding/querying
2 years: Database development
3 years: ETL Tools
3 years: IT software development

128

Data Warehouse Developer Resume Examples & Samples

Experience of DWH Design, development and implementation
Definition of a development roadmap
Operational knowledge and experience of working in a multi-site, cross function operation, Call centre and Back office
Experience of working with CRM or similar systems
Knowledge of Kimball and/or Inmon methodologies
Previous experience of working through and delivering large scale transformation programmes
Excellent planning and organisational skills
Outstanding communication skills at all levels internal / external
Able to work under significant pressure and to tight deadlines
A highly motivated and driven individual
Previous experience in generating growth
Commercially aware and experienced in understanding complex contracts

129

Data Warehouse Developer Resume Examples & Samples

Assist Data Architects and ETL Developers to build and modify data movement and storage solutions in support of new and existing data-oriented systems
Analyze data quality, metadata and data lineage issues and best practices
Act as subject matter experts in the topics of data warehousing, data management, data quality and ETL architecture
Utilize alternate data-oriented technologies and leverage these tools across multiple database technologies
Act as advocate for proper data management principles, understand relevant technologies and utilize the best methods for constructing and supporting a mature data factory
Collaborate with peers to advance data management principles across the enterprise
Support 24/7 production support activities
Combination of 2 years' experience (5 preferred) which includes: Undergraduate degree in CS/CE/CIS/MIS/Engineering/Technology or equivalent experience/ training
IT experience
Experience in working with Oracle ETL solutions (PL/SQL) preferred
Experience in using Datastage or Informatica ETL tools, Datastage preferred
Experience in working with other ETL tools preferred
2 years' experience supporting large database solutions preferred
2 years' experience in UNIX, Solaris 2x and LINUX Red Hat Advance Server preferred
2 years' experience in working with data management solutions including: Data Marts, Data Warehouses and Operational Data Stores preferred
Knowledge data management principles and ETL development within a large data environment preferred
Proficient with Microsoft Office software (e.g. Word, Excel, Outlook, PowerPoint)
Excellent verbal and written communication skills, with the ability to effectively interact with employees at all levels within the organization
Airline experience preferred

130

Senior Data Warehouse Developer Resume Examples & Samples

Contribute to improvement of the structure, design and development of the DHW architecture
Evaluate the current DWH architecture and - where necessary - design and implement adjustments
Design and model parts of the DWH and develop required ETL
Develop and implement new solutions within our to-be "state-of-the-art business intelligence
Supply the technical design and conduct a review on them for accuracy, completeness and consistency
Provide reports and dashboards
Support system management and Business with regards to functional requests or technical problems

131

Senior Data Warehouse Developer Resume Examples & Samples

Partner with Business Analysts, Business Subject Matter Experts , and counterparts in IT to complete system requirements, technical specifications and process documentation for assigned projects
Drive data warehouse architectural decisions and development standard
Ensure adherence to published development standards and database best practices, resulting in consistent and efficient implementation of solution components
Strong data profiling and analysis skills required
Deep understanding of data integration methods required
Willingness and ability to learn new tools and technologies required
Cloud data services and integration tools experience highly desired, such as Microsoft Azure
Experience with reporting and analytics tools desired, such as Power BI, Tableau, and Allteryx
Experience with TFS or similar source control and work tracking systems desired
AML/Financial Crimes Compliance experience desired
Knowledge of different software development methodologies desired (e.g. Agile, Waterfall)
Ability to present ideas in user-friendly language
Excellent problem-solving, analytical and critical thinking skills

132

Data Warehouse Developer Resume Examples & Samples

Highly motivated, organized, and detail oriented individual who can quickly come up to speed, understand, and enhance existing the deployed Data Warehouse
Creates and enhances existing processes based on changing business needs
Assists in the design of processes to meet business needs
Demonstrated ability of bringing complex tasks to a successful completion
Responds to user issues in a timely manner
Must have excellent oral and written communication skills
Experience with SQL Server 2008 R2 or greater
Visual Studio 2013 or higher
Experience with Excel Pivot spreadsheets and Power BI would be most helpful
Dashboard design and SSRS subscription maintenance would be most helpful

133

Data Warehouse Developer Resume Examples & Samples

Designs, tests, implements, maintains and controls Sinai’s research-oriented databases (e.g., physical, relational and objective oriented) for major national and regional projects and data sharing initiatives such as the Data Submission and Repository portal of the NIEHS-funded national Children’s Health Exposure Analysis Resource (CHEAR), and the data submissions and study support for the NYC-Clinical Data Research Network (CDRN)
Works closely with technical management and researcher-clients to design and implement databases and database support tools in support of complex business application development requirements and processes (e.g., diverse development platforms, technological environments, software, hardware, tools, etc.)
Supports, designs and manages upgrades to Sinai-developed software that interacts with these databases, such as the Cohort Query Tool
Monitors transaction activities and assists in the utilization of databases. ETL maintenance and job monitoring is required. On-call support on a rotation basis is required
Responsible for the integrity and security of data in master files
Assists in the development of standards and procedures affecting database management, design and maintenance
Establishes and maintains databases for user tests and production purposes
Trains user groups on procedures and standards
May act as a project leader
Performs related duties as assigned or requested

134

Senior Data Warehouse Developer Resume Examples & Samples

Understand modeling and/or diagramming techniques with the ability to create process flow diagrams and understand the entity relationship models
Research, evaluate, identify alternative design and test approaches and lead code reviews
Teach, mentor and lead junior developers including best practices
Develop ETL code meeting technical specifications and business requirements according to the established designs and framework
Participate in system and integration test; identifies and remedies solution defects
Create other technical deliverable artifacts such as source-to-target mappings, implementation runbooks etc. needed for project implementation
Help in knowledge transfer to the business/client and other technical teams
5+ years’ experience with SQL, Teradata, Oracle in Unix environment
3+ years’ experience in developing applications in a high volume ETL DataStage environment
Strong communications skills required; ability to lead project meetings, communicate with business stakeholders and report to management
Solid understanding of data warehousing architecture
Tivoli Work Load Scheduler and Shell Scripting (UNIX/Linux) is strongly desired
Airline/Travel industry experience is a plus
Experience in Agile software development is a big plus

135

Data Warehouse Developer Resume Examples & Samples

Five years' minimum experience in the design and administration of logical and relational databases in diverse technological environments
Strong SQL analysis skills required (Oracle RDBMS is a plus)
Strong ETL development experience required (SAP Business Objects Data Services is a strong plus)
Healthcare data knowledge is a strong plus
HL7 Interface knowledge is a plus
Microsoft SQL Server Reporting Services (SSRS) is a plus
Must understand the systems development process and have a solid understanding of business processes. Requires excellent analytical ability, consultative and communication skills, strong judgment and the ability to work effectively with clients and other IT management and staff

136

Data Warehouse Developer Resume Examples & Samples

Analyze data quality, metadata, and data lineage issues and best practices
Act as subject matter experts in the topics of data warehousing, data management, data quality, and ETL architecture
Act as advocate for proper data management principles, understand relevant technologies, and utilize the best methods for constructing and supporting a mature data factory
Experience working with Oracle ETL solutions (PL/SQL) preferred
Experience using Datastage or Informatica ETL tools, Datastage preferred
Experience working with other ETL tools preferred
2 years' experience in UNIX, Solaris 2x, and LINUX Red Hat Advance Server preferred
2 years' experience working with data management solutions including: Data Marts, Data Warehouses, and Operational Data Stores preferred

137

Data Warehouse Developer Resume Examples & Samples

BA/BS or equivalent technical school
7+ years of related experience
Experience must include the following: Reports development utilizing Information Builders' WebFocus version 8.1, AppStudio InfoAssit+ User Interface Design Experience with GUI / User Interface driving dynamic/parameter driven reporting selection criteria
US Citizenship required

138

Data Warehouse Developer Resume Examples & Samples

Typically 5-10 years of IT experience
Strong design and problem solving skills
Proficiency in abstract logic and complex design challenges
Experience with table driven solutions and parameterized processes
Strong communication skills; particularly with business partners with less technical knowledge
Collaborative work practices
Ability to guide and lead junior resources
Transact SQL proficient in SQL Server 2012-2016; SSIS (SQL Server Integration Services); SSAS (SQL Server Analysis services); proficient writing complex stored procedures, functions, views
Familiarity with the Kimball Methodology of Data Warehousing
Experience with the Hadoop Ecosystem and the available development/admin tools (HDFS, Impala, Hive, Hue, Sqoop, Spark, etc)
Experience with migration of an RDBMS platform to a Hadoop environment is a big plus

139

Data Warehouse Developer Resume Examples & Samples

Contribute to the improvement of the structure, design and development of the DHW
Implement changes to the existing DWH
Design and model parts of the DWH and required ETL
Automate and optimize various processes within the DWH
Implement new solutions within our to-be "state-of-the-art business intelligence
Develop reports and dashboards
Support system management and Business if there are functional requests or technical problems
Maintenance of the DWH environment

140

Data Warehouse Developer Iii Enterprise Resume Examples & Samples

Highly proficient in SQL with the ability to understand
Business Intelligence (Business Objects preferred)
Knowledge of basic statistics
Experience with database tools such as TOAD, SQL Explorer
Working knowledge of healthcare / clinical environment

141

Lead Data Warehouse Developer / Modeler Resume Examples & Samples

Understand the healthcare business needs and translate it into data model
Provide and propose appropriate data analysis solutions for EDW development
Create logical and physical data models for new and existing projects
Document ETL specs
ETL implementation

142

Data Warehouse Developer Resume Examples & Samples

Gather user requirements and perform basic business analysis to ensure proper design
Design and develop data extracts and integration processes using SSIS, T-SQL and C#
Architect and develop Data Warehouse models
Develop detailed test conditions and test cases to ensure quality of queries and data
Research and troubleshoot data questions
Collaborate on problem resolution, team decisions and project planning
Experienced with typical office technologies such as MS Word, Excel and Outlook
Experienced with Windows
Skilled SQL server environments
Skilled with Sequel Query Language (SQL)
Skilled with DW principles and Kimball, star-schema, Methodology
Skilled with logical and physical data models and Entity-Relationship Diagrams (ERD)
Able to work and communicate technically with Database Administrators, IT System Engineers and programmers
Able to work and communicate effectively with Business Analysts to define data cleaning and business integration rules
Skilled with DW physical platform and Star-Schema architecture
Skilled with concepts for data acquisition, movement and persistence
Skilled with SQL Development Tools (SSMS, SSIS, SSAS and BIDS)

143

Data Warehouse Developer Resume Examples & Samples

Utilize skills in development areas including data warehousing, business intelligence, and databases (SQL Server, T-SQL)
Support programming/software development using Extract, Transform, and Load (ETL) tools, especially SSIS
Design, develop, enhance and support business intelligence systems primarily using Microsoft BI tools
Collect, analyze and document user requirements
Participate in software validation process through development, review, and/or execution of test plan/cases/scripts
Create software applications by following software development lifecycle process, which includes requirements gathering, design, development, testing, release, and maintenance
Communicate with team members regarding projects, development, tools, and procedures; and
Provide end-user support including setup, installation, and maintenance for applications released
3+ years of SQL Server database development experience
Bachelor's Degree in Computer Science or a related field
Experience developing Business Intelligence initiatives using SQL Server stack (SSRS, SSAS, and SSIS), TFS
Experience developing multi-dimensional data models and awareness of the advantages and limitations of Star Schema and Snowflake schema designs
Solid ETL development, SSAS development, SSRS reporting experience all based off intricate understanding of business process and measures
Knowledge of MDX is preferred
Knowledge of PowerPivot, and SharePoint integration around Microsoft BI tools
Experience with C#/ASP.NET is preferred; and
Excellent analytical, written and oral communication skills

Download Data Warehouse Developer Resume Sample as Image file

Related Job Titles

Data Warehouse Engineer Resume Sample

Data Warehouse Architect Resume Sample

Data Warehouse Resume Sample

Data Warehouse Consultant Resume Sample

Data Warehouse Manager Resume Sample

Warehouse Operations Manager Resume Sample

Warehouse Support Resume Sample

Data Warehouse Analyst Resume Sample

Associate, Warehouse Operations Resume Sample

Warehouse Receiving Resume Sample

Warehouse Laborer Resume Sample

Shipping / Warehouse Resume Sample

Browse More

Data Warehouse Developer Resume Samples

The Guide To Resume Tailoring

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

Resume Builder

15 Data Warehouse Developer resume templates

Read our complete resume writing guides

How to Tailor Your Resume

How to Make a Resume

How to Mention Achievements

Work Experience in Resume

50+ Skills to Put on a Resume

How and Why Put Hobbies

Top 22 Fonts for Your Resume

50 Best Resume Tips

200+ Action Words to Use

Internship Resume

Killer Resume Summary

Write a Resume Objective

What to Put on a Resume

How Long Should a Resume Be

The Best Resume Format

How to List Education

CV vs. Resume: The Difference

Include Contact Information

Resume Format PDF vs Word

How to Write a Student Resume

ETL Informatica Data Warehouse Developer Resume Examples & Samples

Am-etl Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

IB R&A Build CCM Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Spec-di Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Am Data Warehouse Developer Associate Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer, Bristol Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data-warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Banking Data Warehouse Developer Associate Glasgow Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Securitized Product Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Specialist Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Lead Resume Examples & Samples

SQL Database / Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Lead Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer / SQL Analyst Resume Examples & Samples

IT Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer Resume Examples & Samples

SQL Database / Data Warehouse Developer Resume Examples & Samples

Agile Data Warehouse Developer Resume Examples & Samples

Data Warehouse Developer / Analyst Resume Examples & Samples

Data Warehouse Developer / Analyst Resume Examples & Samples

Lead Data Warehouse Developer Resume Examples & Samples

Senior Data Warehouse Developer Resume Examples & Samples

ETL / Data Warehouse Developer Resume Examples & Samples

How to Make
a Resume

50 Best
Resume Tips

200+ Action
Words to Use

Internship
Resume