Data Warehouse Developer Resume Samples

5.0 (64 votes) for 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 by selecting 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 10 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.

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

Create a Resume in Minutes
JD
J Douglas
Jessie
Douglas
21620 Auer Union
Boston
MA
+1 (555) 207 7473
21620 Auer Union
Boston
MA
Phone
p +1 (555) 207 7473
Experience Experience
07/2014 present
Detroit, MI
Senior Data Warehouse Developer
Detroit, MI
Senior Data Warehouse Developer
07/2014 present
Detroit, MI
Senior Data Warehouse Developer
07/2014 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
10/2010 01/2014
New York, NY
Data Warehouse Developer / Analyst
New York, NY
Data Warehouse Developer / Analyst
10/2010 01/2014
New York, NY
Data Warehouse Developer / Analyst
10/2010 01/2014
  • 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
01/2008 06/2010
San Francisco, CA
Data Warehouse Developer
San Francisco, CA
Data Warehouse Developer
01/2008 06/2010
San Francisco, CA
Data Warehouse Developer
01/2008 06/2010
  • 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
Education Education
Bachelor’s Degree in Computer Science
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
1

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
2

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
3

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
4

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
5

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
6

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
7

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
8

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
9

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
10

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
11

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
12

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
13

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
14

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
15

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
16

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
17

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
18

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
19

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
20

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
21

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
22

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
23

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
24

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
25

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
26

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
27

Data Warehouse Developer Resume Examples & Samples

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

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
29

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
30

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
31

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
32

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
33

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
34

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
35

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
36

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
37

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
38

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
39

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
40

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
41

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
42

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
43

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
44

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
45

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
46

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
47

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
48

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
49

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
50

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
51

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
52

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
53

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
54

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
55

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
56

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
57

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
58

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
59

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
60

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
61

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
62

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
63

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
64

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
65

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
66

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
67

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
68

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
69

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
70

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
71

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
72

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
73

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
74

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
75

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)
76

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
77

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
78

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
79

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
80

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
81

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
82

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
83

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
84

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
85

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
86

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
87

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)
88

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
89

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)
90

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
91

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
92

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
93

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
94

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
95

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
96

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)
97

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
98

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
99

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