Data Warehouse Resume Samples

4.5 (97 votes) for Data Warehouse Resume Samples

The Guide To Resume Tailoring

Guide the recruiter to the conclusion that you are the best candidate for the data warehouse job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.

Craft your perfect resume by picking job responsibilities written by professional recruiters

Pick from the thousands of curated job responsibilities used by the leading companies

Tailor your resume & cover letter with wording that best fits for each job you apply

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

Resume Builder
CHOOSE THE BEST TEMPLATE - Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS - Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES - Instantly download in PDF format or share a custom link.

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

Create a Resume in Minutes
HJ
H Johns
Humberto
Johns
5106 Myrtice Springs
Houston
TX
+1 (555) 985 9838
5106 Myrtice Springs
Houston
TX
Phone
p +1 (555) 985 9838
Experience Experience
Phoenix, AZ
Data Warehouse
Phoenix, AZ
Wiegand Inc
Phoenix, AZ
Data Warehouse
  • Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
  • Support other ETL developers; technical assistance, troubleshooting and alternative development solutions
  • Safeguard of your code base, conduct unit and integration testing, as well as provide release management instructions through UAT and production environments
  • Develop working relationships with Business, Information and Technology Architects to facilitate collaboration
  • Responsible to provide status to management as requested
  • Design and develop PL/SQL code to perform ETL processes
  • Establishes and enforces processes to ensure a consistent, well managed, and well-integrated data warehouse infrastructure
Dallas, TX
Data Warehouse ETL Developer
Dallas, TX
Ebert and Sons
Dallas, TX
Data Warehouse ETL Developer
  • Adhere to IT Control Policies throughout design, development and testing and incorporate Corporate Architectural Standards into application design specifications
  • Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation
  • 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
  • Prepare deployment groups for migration of code to QA and Production environments
  • Development using Teradata utilities (fast load, multiload, tpump to load data, BTEQ scripts, DML and DDL, Fast export) and Informatica Teradata optimizations (PDO)
  • Create and Test Control-M jobs in Non Prod environments before migrating to Production
present
Dallas, TX
Ccar-data Warehouse Development Engineer
Dallas, TX
Upton Inc
present
Dallas, TX
Ccar-data Warehouse Development Engineer
present
  • Work closely with project/program management as well as managers of related applications
  • Continually improve the performance of the team in regards to SDLC, QA, and deployment practices
  • Manage the software development team for DB application services
  • Manages one or more software development teams on projects of small to moderate size and complexity
  • Work in an agile development SLDC by focusing on the highest priorities and iterating through delivery in a team oriented manner
  • Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
  • Carry out monitoring, tuning, and database performance analysis Perform the design and extension of data marts, meta data, and data models Ensure all data warehouse architecture codes are maintained in a version control system
Education Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Kent State University
Bachelor’s Degree in Computer Science
Skills Skills
  • Ability to apply detailed knowledge of organizational procedures to make independent decisions and serve as a credible resource for a senior management team
  • Ability to meet deadlines with high attention to detail
  • Strong attention to detail
  • Excellent listening, written, and oral communication skills paired with an excellent sense of humor
  • Proficiency in performance and scalability best practices, data transformation, and data integration strategies using commercial ETL solutions
  • Excellent communication skills; ability to effectively communicate to target audience
  • Detail-orientated; uses sound judgment; and is self-motivated with the ability to handle multiple tasks
  • Excellent problem solving skills with ability to analyze situations, identify existing or potential problems and recommend solutions
  • Functional knowledge of banking products (lending, deposits, investments) will be considered as
  • Strong oral and written communication skills
Create a Resume in Minutes

15 Data Warehouse resume templates

1

Data Warehouse Informatica ETL Developer Resume Examples & Samples

  • Creating, maintaining, and supporting Informatica ETLs
  • Validating results with business representatives
  • Monitoring the data loads
  • Tuning the load processes
  • Relational database management and reporting
  • Star or Snowflake schemas
  • Leading teams
2

Data Warehouse Applications DBA Resume Examples & Samples

  • 5 years of relevant development life cycle experience in systems and applications management including systems/application design; vast majority of experience should bein an Enterprise Data Warehouse environment. Strong relational database experiences in Oracle, or DB2, or Teradata
  • Bachelors degree is mandatory
  • Data Warehousing
  • Hands on experience with relational database
  • Ability to demonstrate in-depth understanding of the ETL process, advantage and disadvantages
  • System Performance tuning
  • Understanding of Business Intelligence (BI) Tools
  • Experience with Data Modeling is a plus
  • Hands on experience with Teradata is a strong plus
  • Prior experience implementing DW presentation layer - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules
  • Proficient knowledge of SQL, SQL scripts, Capacity Planning
  • Unix scripting skills
  • Understanding in at least 1 of the following
  • Informatica products: PowerCenter, PowerConnect, Analyzer
  • InfoSphere (IBM) DataStage, Information Analyzer, Discovery, Business Glossary
  • Good Experience in at leastone of the following
  • Sybase
3

Data Warehouse Applications Developer Lead-firmwide Technology Services Resume Examples & Samples

  • Establish/communicate an architectural vision that will enable group to implement changes into the target EDW in a more timely and efficient manner
  • Plans, architects, designs, analyzes, develops, codes, tests, debugs and documents programming to satisfy business requirements for large, complex projects
  • Establish/communicate a technology vision that will integrate the various source systems into the target EDW infrastructure
  • Establish/communicate goals and objectives for the team and individuals
  • Partner with the infrastructure team to identify and enforce best practices for all aspects of systems development including requirements, design, build, and testing/validation
  • Build / improve client relationships through proactive communication and face-to-face meetings
  • Oversight and prioritize the team's Book of Work which requires strong project management and resource planning
  • 10+ years of relevant development life cycle experience in systems and applications including systems/application design; experience in an Enterprise Data Warehouse environment is preferred
  • 5+ years of Lead experience
  • Demonstrated understanding of the SDLC life cycle
  • Proven ability to work with a project team to implement quality technical solutions
  • Hands on experience with ETL tools--ability to demonstrate in-depth understanding of the ETL process, advantage and disadvantages
  • Familiarity with Metadata, Data Quality, and Data Profiling
  • Data Modeling
  • Understand the concept and value of data modeling
  • Relational Database Management Systems (RDBMS)
  • Proficient knowledge of SQL, SQL scripts, and tuning
  • Business Intelligence (BI) Tools
  • Experience in at least ONE of the following
  • Ab Initio, EME
  • Oracle Warehouse Builder
  • ERwin
  • IDA / RDA
  • BDW / FMDWM
  • FSLDM
  • Netezza
4

Data Warehouse Applications Developer Resume Examples & Samples

  • Analyze business requirement, and define development scope
  • Develop, code, test, debug and document programming to satisfy business requirements
  • Research and evaluate alternative solutions and make recommendations on improving the product to meet business requirements
  • 5 years of relevant development life cycle experience in systems and applications including systems/application design; experience in an Enterprise Data Warehouse environment is preferred
  • Demonstratedunderstanding of the SDLC life cycle
5

Application Developer Lead-data Warehouse Architecture Resume Examples & Samples

  • 10 plus years of solid .NET/C# and Java development experience
  • 10 plus years of experience with data warehousing and data repository expertise
  • Exposure to Software Architectural methodologies and theories
  • Proven expertise and deep experience with Enterprise Multi-tier WEB and Multi-threaded software development, application/database tuning
  • Proven expertise and deep experience with .Net and Web Services, XML parsers, JavaScript development
  • Proven expertise and deep experience with Oracle development (PL/SQL) and relational schema design
  • SQL Server and t-SQL development experience
  • Experience with application and information security is preferred
  • Outstanding documentation experience
  • Experience with system design and architecture
  • Familiarity with web based scripting languages
  • Ability to learn and actively seek new skills and knowledge to keep up with the changing technology field
  • Ability to work with project cycles and manage rapid changes
  • Ability to work efficiently in a fast paced environment, work under pressure and deadline
  • Ability to think outside the box, adapt to circumstances, learn from co-workers, and share information and experiences
  • Independent judgment and decision making is essential
  • Ability to be flexible and adapt to any given situation
  • Ability to perform multiple tasks concurrently
  • Excellent customer service attitude, communication skills (written and verbal), and interpersonal skills, skills in dealing with a diverse population
  • Excellent organizational, time management, analytical and problem-solving skills
  • Ability to make timely and sound decisions
  • Ability to work independently and in a team based environment
  • The desire to make a difference, to grow and learn, and to take responsibility for generating solid products is a must
  • Test scripts definition and testing experience
  • Production support experience
6

Data Warehouse Informatica ETL Lead Resume Examples & Samples

  • Addressing user questions concerning data integrity
  • Communicating functional and technical issues
  • Informatica ETL
  • Analyzing business MIS requirements
  • SQL
  • Full project lifecycle; ability to communicate requirements to clients and developers
7

Data Warehouse Technical Lead-avp Resume Examples & Samples

  • Reviewing complex technical requirements to identify business needs
  • Design and build of a Data Warehouse to match the business needs
  • Design, build and maintain appropriate ETL packages and schedules
  • Management of all technical documentation
  • Managing BAU cycles for the day to day management of the environment
  • Reconciliation to source systems to ensure data integrity
  • Performance tuning and script optimisation
  • Identification and resolution of data quality issues
  • Management of data warehouse incident queue
  • Domain knowledge of Finance / Banking
8

Data Warehouse Technical Analyst Resume Examples & Samples

  • Management of own technical documentation
  • Carry out BAU cycles for the day to day management of the environment as guided by the Technical Lead, whilst taking ownership for own areas of responsibility
  • Ensure all production objects are thoroughly tested before deployment
  • Review and respond to data warehouse incident queue as guided by Technical Lead
  • Management of DB access (server roles) as guided by Technical Lead
  • Provide technical guidance to other team member where required
  • Support Report developers as required
  • Experience of build and maintenance of a date warehouse
  • Specialist knowledge of Database systems (preferably Teradata)
  • SQL Scripting
  • Experience of design, build and maintenance of ETL Packages using appropriate tools – Informatica, SSIS etc
  • Microsoft SQL Server 2008 R2 experience (SSRS/SSAS/SSIS)
9

Data Warehouse QA Engineer Resume Examples & Samples

  • Provide world class test execution to the functional test team through full software development lifecycle projects, including setting timelines, utilizing test resources optimally, and reporting project status
  • Contribute to optimization of test efforts, including test automation, Risk-Based and non-waterfall testing techniques such as Agile or Lean
  • Participate in various planning and retrospective meetings
  • Participate in daily Stand ups and provide daily status to team members and Scrum master
  • Minimum 5 years of technical experience with 3 years in two or more of the following: Data Warehousing, Business Intelligence Systems, SQL Server
  • 3+ years of professional experience working with Unix Shell Scripting, Oracle PL/SQL, SQL, MS Test Manager
  • 2 + years’ experience using Perl, or other equivalent scripting toolsets
  • Experience Testing ETL Processes
  • Experience Testing Stored Procedures
  • Experienced in translating business information into detailed functional requirements using a variety of techniques
  • Must be flexible and effectively function in a fast pace and dynamic environment
  • Demonstrate ability to communicate clearly and concisely in writing and verbally
  • Self-directing
  • BS/BA degree in CIS, Business or equivalent education and experience required
10

Compliance Data Warehouse Resume Examples & Samples

  • Understand logical data modeling and convert logical data model to physical data model
  • Understand the application and provide assistance to ETL designers to build an efficient process
  • Build, maintain, and enhance to all library packages/functions in PL/SQL to support application process
  • Manage Security - User and role management
  • Analyze existing process/application, indentify bottlenecks, and suggest improvements/process tuning and SQL tuning to eliminate performance bottle necks
  • Monitor performance, analyze AWR identify top SQLs and continuously improve the system
  • Manage and maintain all schema objects and promote to various environments
  • Maintain source code for all database objects using SVN
  • Package database deployment scripts based on release document and handle deployment errors if any during release
  • Support implemented BI solutions (MicroStrategy reporting), Actimize Models and ETL (Informatica) batch process.Qualifications
  • Must be proficient in Oracle 11g Database and features
  • Data Warehousing, Star schema data models, Data partitioning and pruning, Oracle Real Application Cluster, ASM, Resource manager, Oracle Enterprise Grid Control , DBFS, Import/Export, SQL Loader, Oracle supplied packages/API, Oracle Scheduler, SQL, PL/SQL, Oracle timed model statistic, AWR, Oracle MAA, UNIX/ Linux operating system, Shell scripting
  • Very large Database archival, backup and recovery methods
  • Must follow Oracle MAA best practices
  • A minimum of ten years of full-time, progressive experience as an application DBA on very large data warehouse database and management
  • Strong interpersonal and management skills to achieve cooperation/coordination of multiple tasks being performed
  • Very strong time management and task prioritization skills
11

Rohq-gfds-data Warehouse Intermediate Analyst Resume Examples & Samples

  • Professional and well spoken
  • With knowledge retention and ability to teach others
  • Should have a minimum of 2 year degree or similar
  • Should possess a general understanding of systems & workflow
  • Working knowledge of Microsoft Applications (MS Excel, MS Outlook, MS PowerPoint)
  • Strong written and communication skills
  • Knowledgeable of Human Resources data (if possible)
12

Data Warehouse Operations Analyst Resume Examples & Samples

  • Execution and maintenance of a standard Playbook, deliver monthly status reporting to senior management
  • Process documentation, reporting and remediation efforts
  • Serve as a liaison between multiple support teams
  • Effectively and professionally represent yourself, as this role rquires creating and presenting materials to multiple levels of management
  • Provide feedback and/or make recommendations on process improvements
  • 3+ years experience with Microsoft Office suite (Excel, Word, PowerPoint)
  • Experience/Knowledge of ITSM preferred
  • Experience/Knowledge of IT Risk preferred
  • Ability to successfully engage in multiple initiatives simultaneously, flexibility to multi-task in order to meet deadlines
  • Possess advanced problem solving skills, the willingness to learn, and the ability to effectively and concisely communicate findings verbally and in written/presentation format
13

Data Warehouse Application Developer Lead Resume Examples & Samples

  • Establish/communicate an architectural vision that will enable group to implement changes in a more timely and efficient manner
  • Establish/communicate a technology vision that will integrate the various source systems into the target state infrastructure
  • Proven experience implementing quality guidelines, standards, and procedures
  • College degree or specialized training
14

Teradata Data Warehouse Appplications Developer Lead Resume Examples & Samples

  • 7+ years of demonstrated hands-on experience on end-to-end data warehouse development life cycle (data integration, logical and physical modeling, and data delivery) supporting enterprise analytics and BI solutions
  • 3+ years of experience using one/more scalable (MPP) relational databases such as Teradata for advanced analytics solutions
  • Demonstrated experience defining and maintaining end-to-end data architectures and designs for advanced analytics solutions
  • A vast majority of foundational experience should be in an Enterprise Data Integration and Warehousing development supporting enterprise-wide analytics and BI
  • Hands on SQL coding experience
  • Proven experience implementing data quality guidelines, standards, and procedures
  • Functional knowledge/experience of the Consumer Banking/Financial Services Industry is highly preferred
  • Bachelor of Science degree or equivalent experience; Computer Science major is preferable
15

Data Warehouse Solutions Architect Resume Examples & Samples

  • Install, configure and upgrade Teradata and Oracle server hardware, software, and related products
  • Establish and maintain sound backup and disaster recovery policies and procedures
  • Implement and maintain database security, create and maintain users/roles, and assign privileges
  • Capacity planning for growth to support current and future needs
  • Identify key thresholds and bottle necks which could impact system performance
  • Optimize and performance tune queries
  • Prepare detailed specifications to design, code and test all database SQL/PLSQL/BTEQ scripts and utilities
  • Database design modeling and implementation to meet business objectives and the needs of BI/application enhancements and other project deliverables
  • Project planning, estimating, approach definition and implementation planning
  • Identify and recommend alternative solutions
  • Maintain awareness of new developments in industry and processes
  • Establish quality processes and standards to deliver stable and reliable solutions
  • Participate in after-hours support rotation and perform duties in the data centers to support system upgrades or hardware problem resolutions
  • Advanced analytical and problem solving skills
  • Strong PC skills
  • Strong organizational, verbal and written communication skills
  • Ability to interface with all levels of staff
  • Must be flexible and able to work in a fast-paced environment
  • Consistent delivery of results
  • Excellent data architect skills
  • Performance tuning of Teradata and Oracle database systems
  • Perform database loads, backups and recoveries using Fastload, Multiload, ARC, RMAN/SQLLoader/Exp/Imp, NetVault, and NetBackup
  • Understanding of data modeling and use of modeling tools a plus, i.e. Erwin, AllFusion Data Modeler
  • Minimum 5-7 years experience as a DBA or similar role working with Teradata and Oracle databases
  • Teradata Certified Master certification a plus
  • Oracle Database Administration certification a plus
  • UNIX scripting, Teradata and Oracle utilities experience required
  • System administration for HP-UX, AIX, SUSE, and NCR MPRAS a plus
  • MS/SQL Server and Windows experience a plus
  • C++, Java, VB, or .NET coding a plus
  • Experience with MicroStrategy a plus
  • CRM experience a plus
  • Experience with retail environment is strongly preferred
  • Bachelor's degree in Information Systems, Computer Science or equivalent course work/job experience
16

Data Warehouse ETL Developer Resume Examples & Samples

  • Strong understanding of ETL tools (5+ years ETL required), including Informatica
  • Very Large Database and DW Implementation experience (20+ TBs)
  • Programming in a Linux/Unix environment, including shell scripting
  • Demonstrated experience and ability to work with business users to gather requirements and manage scope
  • Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects
  • Proven ability to effectively manage their time and a desire to deliver results quickly and correctly
  • Strong trouble-shooting and problem-solving skills with a Logical and pragmatic attitude
  • Team player with strong oral and interpersonal skills
17

Data Warehouse DBA Resume Examples & Samples

  • Performance of incident and problem ticket resolution to SLA for services across the global warehouse estate
  • Performance of BAU change ticket deployments for services across the global estate
  • Aherence to Barclays standards for change control, database security and database patterns
  • Owning, scheduling and implementing maintenance releases to the global estate
  • Participation in disaster recovery and business continuity exercises
  • Identifying incident and problem trends, proposing plans to address and reduce
  • Develop and maintain operational procedures and documentation
  • Provide on-call rota and shift support where required
  • Performing delivery tasks for as a member of Service Improvement Unit initiatives
  • Performing delivery tasks for internal projects as directed by L3 DBA technical leads
  • Proven experience in maintaining and supporting major or critical applications
  • Experience in diagnosing and resolving root cause of performance problems
  • Participates in Post Incident Reviews
  • Resolves incidents and problems and fluently applies escalation and notification procedures for major incidents
  • Can describe specific techniques for isolating a problem and defining resolution approaches
  • Experienced with owning change planning, communication and approvals for BAU change and production maintenance
  • Collaborates and communicates well with partner teams – application run and build, service management, incident management, server and storage
  • Solid knowledge of administration of data warehouses
  • Knowledge of the ITIL framework, vocabulary and best practices
  • Competent in raising Vendor service tickets and working with Vendor technical support staff
  • Expertise in documentation tools and writing / maintaining technical plans and procedures
  • Experience in the Teradata product set
  • Operating knowledge of Teradata tools and utilities
  • Understanding and operational experience of warehouse performance tuning and capacity management
  • Experience of working in a highly regulated environment and the associated processes and tools
  • Have a working knowledge of Barclays infrastructure components and the processes required to maintain the infrastructure
  • Have a general understanding of the business areas and application / service components used and an appreciation of applications from both a technical and business perspective
18

Data Warehouse Quality Assurance Director Resume Examples & Samples

  • Work in conjunction with the Business Analysis and Development teams to ensure that applications meet requirements and are of high quality
  • Leverage deep knowledge of multiple complex applications and provides subject matter expertise to set direction and create test strategies and test plans for one or more releases of an application
  • Lead QA team resources in designing and ensuring integrity of the testing strategy
  • Design test procedures, maintenance procedures and configurations. Creates test strategies for application release. Conducts test strategy and test plan walkthroughs. Creates estimates and allocates resources for individual projects. Works with Development teams to insure test coverage for all functionality. Has significant interaction with internal customers
  • Participates in cross-functional discussions to review the impact of application changes from both internal and external interfaces on the quality of their applications
  • Ensure testing thoroughly and accurately documented following JPMC standards and utilizing prescribed testing application (Quality Center)
  • As the team supports and interfaces with multiple lines of business, candidate must be able to form and facilitate relationships across the enterprise
  • Manage defect tracking and reporting and ensure proper re-testing of all defects
  • Contribute to the development of testing processes and procedures in accordance with JPMC standards
  • Identify opportunities for testing automation and facilitate creation of standardized test suites for processes/projects where appropriate
  • Minimum 7 years of Quality Assurance testing experience as a Director
  • 10 plus Years of Information Technology Experience
  • Extensive years of experience in developing Test Plans, Cases and Script development
  • Data warehouse & data modeling experience
  • Experience executing QA efforts for small to large sized projects from requirements inception to production release, including well rounded testing skills with a firm understanding of Functional, System, User Acceptance and Regression Testing
  • Proficiency in Back-End testing, familiarity with hierarchical and relational databases, and developing SQL/PL*SQL queries to interact with Databases
  • SQA Analysis- Ability to read and comprehend business requirements and high level design deliverables well enough to create detailed test cases
  • Experience creating detailed test cases/scripts, as well as experience utilizing functional and technical documentation to create test plan/scripts
  • Strong experience with manual testing, testing tools (i.e. Load runner), writing test plans, and reviewing test cases
  • Mercury Quality Center, Loadrunner, or other similar tools - Basic understanding including navigation between functional areas within the tool. Ability to input or load and execute test cases and document actual results within the tool. Ability to pull data from testing tools for reporting
  • Basic understanding of application architecture in order to identify quality issues related to design or distribution of application components
  • Can write and execute advanced SQL statements
  • Detailed understanding of development lifecycle and quality assurance phases
  • Strong influence and leadership skills
  • Must be self driven, fast learner and delivery focused
  • Excellent written and oral communication skills and demonstrated strong ability to interact/influence with both business and technology partners
  • Understanding of relevant technologies and various development life cycles
  • Ability to map test cases to business requirements
  • Strong testing methodology background
  • Experience with the development of successful quality control procedures and QA programs
  • Regression, load, benchmarking, White and Black Box testing
  • Validation of third party as well as custom developed applications
  • Testing and validating application implementation efforts similar to those used in the Connectivity Services environment
  • Testing conformance to software quality and usability standards
  • Conducting and managing system and user acceptance testing
  • Solid understanding of systems analysis, programming, and operations
  • Expert in testing documentation and emulation tools appropriate for the QA function. (e.g. Quality Center)
  • Bachelor's degree or equivalent industry experience
19

Head of Oracle & Data Warehouse VP Resume Examples & Samples

  • We build and deploy strategic infrastructure to the business
  • We are transforming our infrastructure, reducing complexity and optimising costs to drive global, sustainable and scalable solutions
  • We are focused on continued 'Go-To' Customer Availability, driving excellence in service resilience, change management and pro-active problem management
  • Service Delivery of a major component of operating platform and database infrastructure services. In this case the Oracle and Data Warehouse estates
  • Delivery of database services to agreed levels, quality and cost through the leadership of a team of 40+ FTE in US, specifically Piscataway and Wilmington
  • Manage key stakeholders and demanding customer base
  • Accountable for the stability of a large proportion of the complex Barclays production and development database environment
  • Accountable to ensure all change, incidents, problems are tracked and resolved as per process
  • Effective delivery of T4 (small) change managing demand/supply
  • Design the infrastructure and process changes needed to support customer requirements
  • Effective management of supplier relationships and contracts
  • Ensuring the database service complies to regulatory and Barclays� security requirements
20

Head of Run Oracle & Data Warehouse Resume Examples & Samples

  • Service Delivery of a major component of operating platform and database infrastructure services. In this case the Oracle estates
  • Delivery of database services to agreed levels, quality and cost through the leadership of a team of 40+ FTE in Asia Pacific, specifically Pune and Singapore
  • Deliver an acceptable risk and compliance profile
  • Influence over the strategic direction to IT database infrastructure
  • Provide data that enables technical components to be aggregated in cost and performance terms into services
  • Delivery of database services to agreed levels, quality and cost through the leadership of a team of 40+ FTE
  • Deliver the infrastructure changes needed to support customer requirements
  • Support service operations in transition and operational acceptance activities
  • Effective delivery of T4 (small) change – managing demand/supply
  • Ensuring the database service complies to regulatory and Barclays’ security requirements
  • Ensure the database service takes advantage of new methods of operation to remain competitive
  • Work with the Heads of Service Delivery, Compliance and Product Management to ensure service is delivered to agreed definitions and roadmaps
  • Manage internal stakeholders including Sourcing, Internal Audit, Group Risk and Group Security
  • Manage key suppliers including Oracle
  • Manage the allocation of resources against the planned levels of demand for own function against time, cost and specification
  • Accountable for the recruitment of resources required to meet future demands for delivering against planned goals and objectives of Service Delivery
  • Ensuring key measures and performance indicators are met to enable progress to be exhibited against performance targets
  • Ensure work items are distributed across the Pune and Singapore teams as part of a follow-the-sun capability and smooth out unpredictable demand
  • Creating and training plans to ensure APAC staff are appropriately skilled
  • Accountable for the compliance delivery of all members of the APAC Database Service Delivery team
  • Ensure that communications and people initiatives are effectively completed for APAC locations
  • Proven Oracle Database Management and Service Delivery
  • In-depth experience of change and service management
  • Experience in leading teams in a complex IT environment
  • Effective cost management and commercial awareness
  • Experience of managing large teams of staff, circa 40+
  • Experience of managing people through change
  • Ability to grasp and understand the IT structure and functions within Barclays and the services and product set of the Group
  • Wide Experience of Data Warehousing Industry – Drivers, Challenges and Opportunities
  • Business Continuity Planning
21

Data Warehouse Resume Examples & Samples

  • Establish/communicate an architectural vision that will enable group to implement changes into the target ICDW and other Analytical systems in a more timely and efficient manner
  • Plan, architect, design, analyze and oversee code development, testing and documentation to satisfy business requirements for large, complex projects
  • Establish/communicate a technology vision that will integrate the various source systems into the target ICDW and Ecosystem infrastructure
  • Partner with the infrastructure team to identify and enforce best practices for all aspects of systems development including requirements, design, build, and test/validation
  • Technical understanding/experience in the following
  • Hands on experience with ETL tools - ability to demonstrate in-depth understanding of the ETL process
  • Knowledge of troubleshooting
  • Familiarity with Metadata, Data Quality and Data Profiling
  • Hands on experience with very large databases
  • Proficient knowledge of SQL, SQL scripts and tuning
  • Experience using and understanding Data Modeling tools; ERwin is a plus
  • Experience with Teradata and Oracle
22

Data Warehouse Inofrmatica Developer Resume Examples & Samples

  • Design technical solutions
  • Review functional specifications for DWH
  • Adhere to standards and guidelines
  • Develop Informatica and unit test code
  • Support the test team during functional testing
  • Contribute to the knowledge library for DWH
  • Contribute to setting standards and guidelines for Informatica
  • Must be able to handle conflicting priorities
  • Intimate knowledge of Informatica
  • Intimate knowledge with complete ETL life cycle Additional Eligibility Qualifications: Desired Characteristics: 1. Experience in Data Modeling and Data Warehousing (to include data mapping)
  • Knowledge of dimensional modeling and other data warehouse design techniques
  • Proven experience in an environment with multiple tasks and changing priorities
  • Experience in working with offshore teams
  • Working knowledge of Microsoft BI suite
23

Business Analyst Financial Management Group Corporate Data Warehouse Resume Examples & Samples

  • Work closely with the business and various project teams to define requirements, conduct data gap analysis and liaise with IT to finalise solution design
  • Use your strong technical skills to interrogate and investigate the Data Warehouse with the objective of delivering an improved reporting and analysis toolkit to support strategic decision-making across the broader organisation
  • Actively manage risks and issues, and drive an appropriate risk management culture in the team
  • Take a strategic view of the book of work to identify opportunities for generic / adaptable solutions which address multiple business objectives at once
24

Data Warehouse Business / Data Analyst Resume Examples & Samples

  • 5+ years of experience with hands-on business and data analysis in data warehousing
  • Experience with full life cycle project development, requirements, design, testing, rollout, and implementation from a BA perspective
  • Experience with performing Level Of Effort (LOE) analysis and with Toad or SQL
  • Ability to foster client and peer relationships by collaborating with technical teams, including internal and external to the data warehouse to review business requirements, documentation, and to resolve issues relating to data, coding, or business logic
  • Ability to perform analysis, research, and manage deadlines across multiple deliverables and provide resolutions to production issues
  • Ability to organize and facilitate information-gathering and validation sessions to gain insight into systems, processes, and data and liaise with the Subject Matter Experts (SME’s) throughout project life cycle
  • Ability to mentor junior staff through day-to-day work tasks in a team environment, lead small to large scale projects through project life cycle, write detailed requirements, and document meeting minutes and data mapping documentation based on business rules provided by clients using internal templates
  • Ability to work in an agile environment and adapt to changing priorities
  • Experience with managing applications that meet Sarbanes Oxley (SOX) process and access controls
  • Knowledge of data modeling techniques
25

Data Warehouse Resume Examples & Samples

  • Participates in analysis, design and new construction of next generation IT applications
  • Responsible for understanding the needs of the customers and the realities of the commercially available IT products
  • Creating requirements that will allow implementation by the development team and COTS products
  • Facilitates change control, problem management, and communication among data architects, programmers, analysts, and engineers
  • Establishes and enforces processes to ensure a consistent, well managed, and well-integrated data warehouse infrastructure
  • Analyzes and identifies data and metadata requirements
  • Defines user requirements and database design specifications
  • Designs, implements, and supports data warehousing requirements. Implements business rules via stored procedures, middleware, or other technologies
  • Provides product support and maintenance of the data warehouse
  • Performs data warehouse design and construction
  • Prepares/implements data verification and testing methods for the data warehouse
  • Provide expert level knowledge of
  • Data Warehouse and Extract, Transform, Load (ETL) processes
  • Informatica PowerCenter 7/9
  • Microsoft SQL Server
  • Orion Rhapsody
  • CA ERWin Data Modeler, Microsoft Visio
  • IDEF or equivalent data modeling notations
  • Must have a Bachelor's degree in Computer Science or related field
  • Must have 10 years’ experience as a mid to senior-level data warehouse/business intelligence system architect/administrator
  • Excellent verbal, interpersonal and written communication skills
  • Strong analytical, problem-solving and decision making capabilities
  • Team player with the ability to work in a fast-paced environment
  • Demonstrated outstanding level of professionalism in providing administrative support, including ability to exercise good judgment, discretion, tact, and diplomacy
  • Sound business ethics, including the protection of proprietary and confidential information
  • Ability to apply detailed knowledge of organizational procedures to make independent decisions and serve as a credible resource for a senior management team
  • Ability to work with all levels of internal staff, as well as outside clients and vendors
  • Excellent problem solving skills with ability to analyze situations, identify existing or potential problems and recommend solutions
  • Superior interpersonal skills including courtesy, professionalism, and a cooperative attitude
  • Ability to be flexible to handle multiple priorities and to work limited overtime as necessary
26

Data Warehouse / Info Business Analyst Resume Examples & Samples

  • Financial and resource allocation management
  • Managing project scope and timelines to support the Demand Management processes
  • Working independently and with other Business Analysts to analyze impacts to INFO1 environment
  • 5+ years of Business Analyst experience
  • 3+ years experience writing SQL queries; Oracle preferred
  • Prior experience with INFO1 Governance required
  • Detailed knowledge of INFO ECO system required
  • Experience/Knowledge of RSAM preferred
  • Work independently with minor oversight
  • Team player attitude a must
  • High degree of self-motivitation
27

Etl Lead Developer Data Warehouse Resume Examples & Samples

  • Analyze business needs and information requirements, define optimum system requirements to meet business needs, and prioritize and manage new requirements. Develop detailed analysis, design, construction and testing specifications ensuring technical compatibility and integration
  • Conduct business analysis, event modeling, logical and physical database design, database optimization, load strategy design and implementation, security and change management
  • Assist the systems development process, including planning and monitoring development efforts, reviewing deliverables, and communications to management. Ensure users effective, accurate and easy access to data; translate user information requirements into data
  • Verify decision support program specifications with users for reliability, accuracy and functionality
  • Lead Data Warehouse projects, plan and monitor development efforts Mentor and provide direction to junior team members on Informatica and ETL best practices Delegate project work to other team members Work closely with business analysts, end users, developers and QA team to ensure technical compatibility
  • 2+ years experience in data warehousing. Informatica experience
  • 2+ years experience in relational data warehousing design
  • Experience in normalized and dimensional logical modeling
  • Experience in analyzing source system, data flows, and delivering data architecture designs
  • Possesses SQL skills
28

Data Warehouse L Support & Developer SAP BW Resume Examples & Samples

  • Strong knowledge of SQL, Data Warehousing and data concepts
  • Experience working as a Database Engineer/Developer
  • Experience building cubes and reports that take advantage of OLAP/Dimensional Modeling capabilities
  • Experience with SAP Business Warehousing, including process chain design and reporting using BEX Queries or other infoproviders
  • Ability to troubleshoot technical problems and research possible solutions in SAP BW
  • SQL and ideally ABAP programming experience
  • Experience with HANA a plus
  • Experience working with SAP FI/CO desirable
  • Some experience in MSTR schema or BOBJ universe design, and report development would be an added advantage
  • Strong problem solving, analytical, communication and troubleshooting skills
  • Ability to work with customers in making system decisions/solutions and to plan and manage technical deliverables within various business areas
  • Ability to translate business requirements into technical solutions and designs, and to work with business customers and technical developers to realize these designs
  • Experience working with geographically dispersed teams
  • Knowledge of Teradata*, AbInitio*, EDW and Intel's reporting systems and processes would be an added advantage
  • Familiarity with Finance operations is a plus
29

Program Analyst Data Warehouse Resume Examples & Samples

  • Provide analytics within a focused area of Data Management, owning the analysis and recommendations for specific Data Management initiatives (reconciliation breaks, data policies & procedures)
  • Evaluate complex situations by working cross-functionally and analyzing multiple sources of data
  • Identify and articulate risks and opportunities relevant to the Data Management initiatives
  • Help implement process improvement and efficiency in order to accurately capture the changing business economics and structure
  • Train and support of new team members
  • Bachelor's Degree. Minimum 2 years of finance, risk, data, IT, or audit experience
  • Experience collaborating on cross-functional projects
  • Proficient use of Microsoft Office (eg. Excel, Word, PowerPoint)
  • Bachelor's Degree in Finance, Accounting, Risk, or Data related field
  • Knowledge of the US Regulatory landscape
  • Financial Services Industry experience
  • Demonstrated ability to manage multiple priorities
  • Prior work experience in enterprise data projects
  • Demonstrated experience analyzing risk/business data with the ability to distill large amounts of information to the critical areas of focus
30

Data Warehouse Extract Resume Examples & Samples

  • At least 2 years experience in ETL tools
  • At least 2 years experience in relational databases, database design and applications; knowledge of performance management and data analysis techniques
  • At least 2 years experience in search results in Structured Query Language (SQL) development and scripting
  • Readiness to travel Up to 5 days a week (home on weekends-based on project requirements)
  • English: Intermediate
31

Senior Data Warehouse / Data Hub Developer Resume Examples & Samples

  • Design/development of new functionalities/flows
  • Support and maintain the existing flows, resolve any issues that may arise
  • University degree in IT, Computer Science or a related discipline
  • Experience with Data Warehouse design and development
  • Development experience in DataStage 7.5 / DataStage 8.X / ETL
  • OBIEE or Business Objects
  • Oracle Streams
  • Linux (RedHat 5.x) environment
32

Big Data / Data Warehouse Administrator Resume Examples & Samples

  • Become our technical expert in Vertica technologies
  • Provide day to day support of our Vertica infrastructure including
  • Cluster monitoring and troubleshooting
  • Provide SQL or Workload Manager query tuning and optimizations
  • Analytical and Big Data Application design
  • Cluster Expansion and Support
  • Install Vertica version updates and patches
  • Work with Analytics teams to develop business initiatives and algorithms as they relate to Vertica
  • Provide day to day support of our Solr infrastructure (willing to train)
  • Monitor and troubleshoot replication, performance, and availability
  • Provide second level On-Call support
  • Performing all other duties as assigned
  • BA or BS degree from a 4-year college or university
  • 2 - 4 years of data warehouse experience
  • Experience working with large-scale analytics environments, such as HDFS and MapReduce, analytic databases like Vertica
  • Data warehouse design knowledge
  • Scripting expertise (Shell, Perl, Python)
  • Experience with SQL Server Analysis Services a strong plus
  • Experience with Netezza, Greenplum, Teradata a plus
  • Experience with the following technologies are a plus: Hive, Git/SVN, Zabbix, MSSQL, MySQL
33

VP of Business Applications & Data Warehouse Resume Examples & Samples

  • Be instrumental in building a data-driven DNA for the organization
  • Leverage the data generated by the company’s products and identify product opportunities
  • Develop and execute a strategy for data and data governance
  • Help build a team to create a culture of data-led decision making
  • Ensure company is using best practices from end-to-end
  • Day to day management of the data engineering function
  • Implement the company’s strategy in a consistent way across all the stakeholders in the business
  • Provide analysis and insight that serves as an engine to drive revenue for the business
  • Ensure data is available to the businesses and stakeholders in an actionable and usable way
  • Establish enterprise data policies, standards, and procedures
  • Manage external third parties where relevant
  • Lead and manage the portfolio of demand from various business functions
  • Build, mentor and support the data community within the company
  • Establish and Chair the Data Advisory Board
  • Oversee various types of datasets including and not limited to healthcare, financial, and sales
  • Foster a culture of collaboration and transparency
  • Work with CIO in delivery of special projects as needed
  • Champion of change and effectively managing the implementation of new ideas/improvements
  • Leadership by example and excellence
  • Support and solicit input from team members at all levels within the business
  • Communicate effectively with stakeholders
  • Continually define ways to improve business satisfaction and deepen stakeholder relationships
  • Bachelor’s Degree in Information Technology, Finance, or other relevant field
  • 15+ years of broad based technology experience that includes large scale analytical studies, modeling, statistical analyses, and forecasting
  • Strong interpersonal skills, as well as excellent written and verbal communication skills
  • Strong organization skills and an ability to multi task to meet multiple deadlines in short time frames
  • Experience in a regulated environment such as HIPAA, ITAR, PCI, FDA
  • Knowledge and familiarity with enterprise applications such as Microsoft Great Plains, Tableau, and SharePoint
  • Ability to make decisions that produce high-quality results by applying technical knowledge
  • Comfortable working in a fast paced environment
  • Must pass background screening
  • Ability to travel 35%
  • Demonstrate interest in and deep understanding of core business problems and challenges unique to the healthcare market
  • Possess a great sense of urgency and accountability to drive results in the team
  • Ability to manage an enterprise data warehouse architecture function
  • Knowledge of current data analytics methods and approaches
  • Ability to communicate complex technical and analytical information in a clear and convincing manner to stakeholders at all levels
  • Strong Customer Centered focus
34

Cib, Data Warehouse & Operations Management Resume Examples & Samples

  • For financial and regulatory reporting of the planned Bank Holding Company (“BHC”), work as a lead member and a business analyst for identification of necessary functions and design of the enterprise data warehouse, and required processes
  • During development of the data warehouse, participate in user acceptance test and rehearsal to ensure workability and efficiency of the identified processes
  • After the establishment of the BHC, maintain, manage and enhance the identified processes. Also identify, establish, maintain, manage and enhance the processes for new requirements
  • Work with stakeholders, which include management, risk management team, finance team, IT team, data governance team, consultants and system vendors
  • Assume other responsibilities related to financial and regulatory reporting in the Project Team
  • Eligible to work in the US
  • Bachelor’s degree in finance or accounting. Master’s degree preferred
  • CPA License
  • 7+ years of relevant work experience
  • Significant knowledge on data management and accounting and/or regulatory reporting in financial institutions
  • Strong analytical and verbal/written communication skills
35

R&D Data Warehouse / ETL Developer Resume Examples & Samples

  • Solid understanding of data warehousing methodologies, various stages of ETL and data modeling
  • Experience working with MPP systems, Hadoop stack
  • Strong analytical and creative problem solving skills
  • Team Player with Excellent communication skills
  • Familiarity with BI tools like Cognos/Tableau/QlikViewThe Company
36

Data Warehouse Resume Examples & Samples

  • Analyzing the business requirements, ensuring that Informatica/Oracle is a right fit to address the challenges and providing estimates of the required work
  • Developing technical specifications
  • Participating in quality assurance peer reviews of their code base
  • Safeguard of your code base, conduct unit and integration testing, as well as provide release management instructions through UAT and production environments
  • Staying on top of technology in Data Warehouse space, and a willingness to share information so that CFT is always positioned to provide optimal solutions
  • 7+ years of Application Development experience
  • 6+ years of Informatica development experience
  • Ability to handle multiple project/tasks efficiently and timely
  • Strong data analysis and troubleshooting skills
  • Strong leadership and communication skills and able to work independently
  • Experience with Large Database and DW Implementation (20+ TBs) Programming in a Linux/Unix environment, including shell scripting
  • Strong experience with Designing and developing ETL mappings, sessions and workflows in Informatica for populating large scale data marts and/or data warehouses
  • Strong working knowledge of Oracle RDBMS
  • Performance tuning
  • Strong foundation in industry standard Data Warehousing design concepts
  • Oracle PL/SQL development and ability to code complex queries against Oracle is strongly desired
  • Financial Services background is a plus
37

Business Intelligence Data Warehouse Administrator Resume Examples & Samples

  • Serves as a project leader for the customization and maintenance of a complex multi-platform system configuration
  • Provides leadership, guidance and direction to lower level staff
  • Designs and administers all ETL processes using SQL Server 2008/2012, SQL Server Integration Services and other Microsoft BI stack applications in a multi-server enterprise configuration. This includes extraction schedules, data mapping into conformed dimensions, and query optimizations
  • Administers the database hardware, software, and table structure supporting both the staging and star schema components of an enterprise BI data warehouse. Tasks include the structuring of data incorporated from multiple sources
  • Resolves any data availability or access issues pertaining to the data warehouse level of the BI software stack
  • Monitors systems, servers and auxiliary devices for performance and security. Determines whether adjustments need to be made and confers with technical support staff and vendors as appropriate. Identifies changes that need to be made in the future
  • Leads troubleshooting; identifies hardware and software problems in a timely manner; resolves routine problems, replaces defective components and researches resources to identify solutions
  • Assigns, modifies, and deletes user accounts and resolves security access problems; maintains integrity of the security system
  • Develops and maintains appropriate system documentation. Formulates standards for system management
  • Stays informed of new developments and technologies by reading journals and other pertinent publications, maintaining contact with vendors, and participating in professional organizations, meetings, and seminars
  • Performs other related duties as assigned or requested. The University reserves the right to add or change duties at any time
38

Data Warehouse / ETL Developer Resume Examples & Samples

  • Build and support large DW platform (20 TB) , aggregation engine, complex calculation and datamart reporting platform
  • Participate in strategic planning, design and delivery of next generation of DW using Big Data technologies
  • Develop Data Modeling and Data Analysis strategy
  • Perform ongoing technical assessment of database environments for operational considerations including performance, capacity, redundancy, stability and security. Partner with operational teams on implementations that address issues and proactively
  • Design, develop and upgrade databases, ETLs, schemas, automation of data quality rules, ER designs, naming conventions, optimized queries and indexing
  • Evaluates various technologies as related to Data Warehousing, Data Modeling, and Data Integration
  • Strong problem solving and troubleshooting skills
  • 8+ year’s hands-on experience with all aspects of the Data Warehouse lifecycle including data analysis, data modeling, design and implementation
  • 8+ years’ experience in data integration tools (ETL)
  • Experience in MPP database design, implementation and tuning (Vertica or Greenplum)
  • Excellent understanding of full life cycle experience in Data Warehousing, Data Modeling, Data Integration, and Master Data Management
  • Experience in Java-based platforms
  • Hands on development experience in NoSQL technology(Spark, Hadoop, Cassandra)
39

Data Warehouse Database Engineer Resume Examples & Samples

  • Bachelor or Master degree
  • 8+ years experience working with DB2 LUW in large DPF/Data Warehouse environments ; Good analytical skills, good performance tuning and scripting skills
  • Knowledge of other RDBMS, especially Oracle, along with Hadoop and Big data technologies is a plus
  • Support multiple projects and applications. Experienced with DB performance monitoring, DB backup and recovery, and DB troubleshooting
40

Business Analyst for Data Warehouse & Business Intelligence Systems Resume Examples & Samples

  • Gathering and analyzing business needs as basis for implementation projects
  • Creating and delivering business concepts and requirement specifications for reporting and business intelligence solutions
  • Supporting IT requirements engineers in the implementation concept design and coordinating and supporting local IT in the development
  • Ensuring on-time implementation and running business acceptance tests for delivered solutions
  • Acquiring business know-how from Swiss part of the team
  • Producing high quality documentation related to solution design, operations, governance and end-users
41

Data Warehouse Resume Examples & Samples

  • Develop long-term partnerships with customers and vendors and contribute to the development of their strategic business plans by understanding the future direction of organization, the industry and the customer’s business
  • Develop working relationships with Business, Information and Technology Architects to facilitate collaboration
  • Develop working relationships with tactical implementation teams and those focused on new functionality to facilitate collaboration on solution definition and development
  • Develop working relationships with staff to facilitate the adoption of standards, methodology and metrics in preparing architecture deliverables
  • 3+ years of experience in a combination of business intelligence / data warehouse development and or architecture roles
  • Experience using Tableau 8.2/9.0 and Alteryx as well as other BI tools
  • Demonstrated ability to understand and apply ETL knowledge using Microsoft BI stack (SSRS, SSIS)
  • Demonstrated ability to do data modeling
  • Ability to obtain a security clearance
  • Ability to obtain a security clearance-strongly preferred
  • Master’s in Geographic Information Systems, Computer Science or related field + 2 years experience with GIS and web development
  • Experience with GIS software packages such as GDAL, Quantum GIS (QGIS) or GRASS
  • Experience with Google Maps, Bing Maps, and OpenLayers
  • Proficient with a database SQL language for user-defined database extract or update statements
  • Knowledge of relational and non-relational databases such as MySQL, MongoDB, LevelDB, and ElasticSearch
  • Experience with ETL tools or data migration or data integration
  • Understand database concepts of referential integrity, indexes and keys and table metadata
  • Experience managing and mentoring junior staff, leading project tasks, and working directly with senior managers and clients a big plus
  • Excellent listening, written, and oral communication skills paired with an excellent sense of humor
  • Highly self-motivated and directed
  • Ability to exercise independent judgment while effectively prioritizing and executing tasks while under pressure
  • Builds and maintains relationships with users to ensure buy-in and adoption of processes and solutions
  • Strong analytical and problem-solving capabilities
42

Data Warehouse & Big Data Solution Architect Resume Examples & Samples

  • Capture and understand requirements, develop solutions for Business Intelligence, Enterprise Data Warehouse, and Big Data
  • Engaging clients, capturing business requirements and translating to technical requirements
  • Leading the development of technical solutions and taking accountability of technical validity of the solutions including, testing, installation and integration
  • Providing leadership, and direction during the full software development lifecycle
  • Managing solutions with multi-vendor BI and Big Data and Analytics products for all types of service providers including wireless, wire-line, cable, or utilities
  • Pre-sales support of Sales teams to promote and position BI, Big Data, and Analytics solutions as well as contributing to customer commercial proposals
  • Responding to RFIs and RFPs, and ensuring quality and consistency of scope, and cost estimates
  • Establishing a solid relationship with clients aimed at increasing Ericsson credibility as the primary partner for delivering BI and Big Data Analytics programs
  • BS or MS in Computer Science, or Computer Engineering or acceptable equivalent
  • Over 10 years experience architecting and integrating large/complex Enterprise Data warehouse and Business Intelligence
  • Experience with Business Intelligence and Data Warehouse design including ETL processes and tools. (e.g. Informatica, Pervasive)
  • Over 5 years customer-facing and project delivery experience
  • Skilled in creating standard solution architecture artifacts (Business Requirements Documents, Functional Specifications and Technical Specifications)
  • Experience in designing and building logical data models
  • Experience in creating automated reports, dashboards, ETL workflows, and mappings
  • Strong database SQL, ETL and data analysis skills
  • Strong experience with data warehouse platforms (e.g. Oracle, Greenplum, Netezza, Teradata)
  • Experience with reporting dashboard products (e.g. Tableau, QlikView, Business Objects)
  • Over 2 Years working with Big Data and Analytics solutions
  • Knowledge and experience with Hadoop/Map Reduce
  • Working knowledge of Pig, Hive, HBase or other NoSQL tools
  • Understanding of Predictive Analytics and Statistical Methods
  • Ability to communicate and articulate value propositions at customer C-Level
  • Exceptional Customer Orientation and Consultative Skills
  • Exceptional Communication skills (Presentation, Interpersonal and Influencing Skill)
  • Excellent oral and written English skills
  • Ability to lead and motivate others and work in a team environment
  • Problem Solving Ability and Creative Thinking
  • Teamwork and collaboration skills
  • Financial Understanding
  • L1-VB1
43

VP-global Data Warehouse Core Lead Resume Examples & Samples

  • Delivery
  • As Core Lead making sure the SDW Data model is followed for any flow/functionality being on boarded
  • Setting up new test environments for QA, SIT, UAT and Prod Parallel so that Compliance/RRC can test their processes
  • In addition to the Core Lead role the scope of responsibility has increased to Project Manage/Own and Deliver Volker Report and Global Analytics Feed for US , EMEA and APAC
  • SME for Netezza and ensure that the knowledge is imparted to RTB for them to manage the administrative Tasks independently
  • SME for Informatica and ensure all the code deployed follows the standards
  • Data warehouse methodologies experience is mandatory (Ralph Kimball preferred)
  • Informatica Power Center experience is mandatory
  • Experience using relational database systems (Oracle) – database modeling, engineering, optimization is mandatory
  • Experience working in Netezza is good to have
  • Cash Equities experience is good to have
  • Strong analytical and problem-solving abilities, should be able to multitask and switch gears quickly
  • Use of tools that will expose data to users via a web based interface
44

Director of Data Warehouse & Business Intelligence Resume Examples & Samples

  • Define and implement the Data Warehouse/Business Intellegence Strategy focusing on enabling business users and business analysts
  • Build a high performance, multi TB, solution from the ground up
  • Work across the organization to ensure that the right data is collected and processed to enable smart, data driven decisions
  • Support all operational aspects of the systems in your purview
  • Leverage your hands-on recruiting skills to build a team comprised of highly motivated engineers and technical leads
  • On-board and mentor your team; guide them to success
  • Cultivate a culture of technical discussion and curiosity, efficient project execution, and lightning-quick service response
  • Be the #1 supporter of industry best practices
  • Deftly manage the team budget, keeping in mind both resources and operational expenses
45

Data Warehouse Business Analyst Resume Examples & Samples

  • Develops and integrates IT solutions (e.g. application module code, purchased package customization) by using appropriate development methodologies and standards, adopting/applying standard architectures/patterns, taking into account critical performance characteristics, security measures and customer requirements
  • Leads translation of logical design into physical program design/specifications
  • Collaborates with others (e.g. System Designer/Analysts, Architects, Senior Developer) to establish the physical application framework
  • Ensures the development and execution of unit test and integration plans and scripts to validate that application modules meet technical specifications
  • Ensures technical inspections are performed at appropriate stages of development
  • Works with others (e.g. Operations, System Designer/Analysts, Developers) to prepare and stage production deployments, and verify production releases meet technical and business expectations
  • Provides technical mentoring to other developers
46

Data Warehouse Test Analyst Resume Examples & Samples

  • Working with the testing team in analyzing requirements, creating and documenting test plan and test cases in a structured and reusable format using HP ALM and coming up with an effective and efficient test approach to ensure full test coverage
  • Timely execution of system tests, integration tests, regression tests, and performance tests in accordance with agreed test cases and test plans in an agile environment
  • Understanding the relevant application architecture, application functionalities and software design life cycle processes unique to Macquarie
  • Reporting defects found in JIRA and tracking it to closure
  • Supporting business testers who may not necessarily have a formal testing background during User Acceptance Testing
  • Accurate and timely reporting of test progress, risk and issues
  • Assisting in preparation and execution of UAT as required
47

Project Senior Application Developer Data Warehouse Team Resume Examples & Samples

  • Microstrategy design, develoipment of projects, performance considerations for end user reporting and analytics
  • Manage and track Microstrategy portfolio of projects, tools, reports, etc. and provide input for longer range development and expansion of functionality
  • Partner with architecture and back end application teams to create conceptual designs, detailed technical specifications, and technical documentation to design Microstrategy solutions
  • Measure performance of the newly implemented solutions against desired results and recommend basic improvements
  • Troubleshooting support tickets for operational issues
  • Must have professional work experience with the following
  • Exposure with the below technologies will be considered a plus: Crystal reports, Business Objects 3.x or greater, PL/SQL development, stored procs, and Windows 2003 skills
  • 5 years database experience – Oracle 10g or higher
  • Bachelor Degree, in computer science or related technical field
48

Director, Enterprise Data Warehouse Resume Examples & Samples

  • Exceptional leadership capabilities
  • Extensive experience managing and developing people and building high performing teams
  • Must work independently with minimal direction and have superior organizational skills
  • Must be visionary and strategic in approach
  • Experience in data architecture, modeling and dimensional design
  • Strong understanding of implementation processes and best practices around Enterprise Data Architecture
  • Extensive experience with SAP BW and related technologies
  • Experience delivering solutions using other established database technologies such as MS SQL Server, Oracle, Sybase, IBM Information Server
  • Strong relationship building and mentoring skills with the ability and desire to drive change and issues resolution
  • Ability to manage multiple priorities efficiently and effectively within specific timeframes
  • Ability to promote standardized data services (data modeling, metadata, data quality, etc.) to the business community via the data officers/stewards and analytics teams
  • Ability to articulate technical aspects in an executive manner to present to executive management
  • Strong team player with excellent interpersonal skills
  • Must be comfortable working in a fast-paced, dynamic environment and committed to meeting deadlines and creating and improving processes
  • Must possess demonstrated skills in analyzing enterprise data warehouse and business intelligence systems, including the integration of data from various sources
  • Excellent analytical and problem-solving skills are required
  • Excellent verbal and written communication skills are required
  • Must be proactive and possess the ability to work with minimal supervision
  • Must demonstrate a strong understanding of SAP BI principles, theories, concepts and techniques including SAP Portals, Netweaver, J2EE and SAP XI , BOBJ
  • In-Depth technical understanding of ABAP coding used in areas of Function Modules, Programs, Start/End Routines, and exit variables
  • Has strong understanding of SAP BW 7.3 functionality such as SPO (Semantically Partitioned Objects), Composite Providers, WorkSpaces, Transient Providers etc
  • Bachelor’s degree in Computer Science, Information Technology, Mathematics, Engineering or related discipline
  • Minimum 10 years’ experience data warehousing with at least 5 in an SAP BW environment
  • Minimum 8 years’ experience with BEx tool suite, including Analyzer, BEx Web, Workbooks, query designer, Web App Designer, and information broadcasting using BW Portal
  • Minimum 2 years’ experience with SAP Netweaver BI 7.01 technology; Knowledge of SAP Solution Manager
  • Solid SAP data modeling experience including data sources, Info providers, Info Packages, Transformations and Update Rules
  • Experience and thorough understanding for SAP BW Accelerator
  • Knowledgeable in SD, MM, FI, PP, BPC and APO module process flows and data structures; AFS experience is a plus
  • Experience with SAP Business Intelligence reporting and analytic tools
49

Data Flow Operations Analyst Genesis Data Warehouse Resume Examples & Samples

  • Participate in the on-boarding of new data feed into Genesis
  • Monitor handoffs of source files according to agreed Service Level Agreements (SLA)
  • Ensure data completeness/integrity during execution of data enrichment & prior to reconciliation
  • Timely identification, communication, and escalation of inbound/outbound processing failures/rejects/exceptions to the relevant resolving team
  • Assist in testing of new sources/interface (User Acceptance Testing)
  • Provide metrics on performance & data quality/integrity
  • Liaise with source contacts on processing issues & data quality
  • Perform maintenance activities on management of data records (groupings or individual), hierarchies, reference tables, new dimensions and operational tools (such as calendars)
  • Review/approve/configure consumer subscription requests
  • Monitor outbound data with the agreed SLA
  • Check for data sanity of outbound data
  • Handle and track all user inquiries via Citi Market Place, Service Now or relevant tracking systems
  • Provide SME support on Genesis data acquisition and subscription process requirements
  • Setup and modify users’ entitlements to the system
  • Maintain all process documentation and guides
  • Other tasks assigned relevant to the process and in compliance of bank policies, international or local rules and regulations
  • Experience in Finance, Data Analysis or Business Analysis (5+ years)
  • Degree in Business or Management Information Systems, or equivalent experience
  • Experience in Banking Systems
  • Database and/or warehouse related skills (e.g. SQL) are preferred
  • Reporting creation experience
  • Possess strong analytical skills
  • Confidence and ability to work with all level of management
50

Data Warehouse Applications Developer Resume Examples & Samples

  • Creating star schema data models, performing ETLs and validating results with business representatives
  • 3 - 5 years experience with relational database management and reporting
  • 3 - 5 years experience with analyzing business MIS requirements
  • 3 - 5 years experience with SQL
  • 3 - 5 years experience with ETL
  • 3 - 5 years experience with Star or Snowflake schemas
  • Knowledge of full project lifecycle; ability to communicate requirements to clients and developers
  • 3 - 5 years experience with report design and testing
51

Data Warehouse & Continuous Improvement Specialist Resume Examples & Samples

  • Managing DWHs to ensure proper reporting and analysis
  • Extracting data from different ERP systems
  • Work directly with internal and external stakeholders to determine reporting requirements and develop appropriate solutions for new reports and modification of existing ones
  • Identify data deviations, root cause analysis and raise them to the Management
  • Querying DWHs to identify causes of data inaccuracy and cut-offs
  • Raise DWH Issues to the relevant Support Teams for investigation
  • Analyze data and make recommendations for improvement and optimization
  • Provide Input for Monthly, Quarterly and Annual Closing process
  • Provide support to Business Planning processes and presentations
  • Design and create tools to actively help operations team to get more efficient in their daily activities
  • Identify and implement process automations
52

Data Warehouse Resume Examples & Samples

  • Bachelor’s Degree or higher in Computer Science, Computer Engineering, or equivalent
  • 5 years of experience as a Data Warehouse / Business Intelligence developer
  • Experience in data warehouse design and dimensional modeling
  • Experience building MOLAP cubes over star and snowflake schemas in SQL Server 2012 or higher
  • Knowledge of Excel 2013 or higher and PowerPivot
  • SQL, MDX, DMX, XMLA, SSIS, SSRS, SSAS, and Active Directory experience
  • Application Lifecycle Management using Visual Studio (SSDT), NuGet, TFS, TFSBuild, Octopus Deploy, and Git
  • Familiarity with Tabular Modeling, SharePoint, Performance Point, and PowerView
  • Knowledge of fixed income and insurance
53

Data Warehouse Business Analyst Resume Examples & Samples

  • Translate business requirements into a data model
  • Develop ETL's and reporting cubes
  • Develop data validation and quality control methods with key application providers
  • Develop scripts to automate data production and reporting
  • Deliver custom reports to senior management
  • Develop a strategic BI solution to support the needs of the business
  • A strong knowledge of MS SQL server is required, including the ability to develop SSIS packages for the integration of raw data
  • The candidate should also have recent experience working on business intelligence development projects and at least 2 years of working in an analytics role
  • Microsoft BI tools including Power Pivot, Power Bi, Power Query, Power View
  • MS Access
  • Any industry leading CRM platform
54

Data Warehouse ETL Developer Resume Examples & Samples

  • Participate in design reviews and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow, and understand and comply with Project Life Cycle Methodology in all planning steps
  • Adhere to IT Control Policies throughout design, development and testing and incorporate Corporate Architectural Standards into application design specifications
  • Prepare deployment groups for migration of code to QA and Production environments
  • Development using Teradata utilities (fast load, multiload, tpump to load data, BTEQ scripts, DML and DDL, Fast export) and Informatica Teradata optimizations (PDO)
  • Create and Test Control-M jobs in Non Prod environments before migrating to Production
  • 6+ years of professional experience in the field of information and technology
  • Proven experience in all phases of the Software Development Life Cycle (SDLC) and experience in production support
  • Experience with issue resolution processes for application production problems
55

Software Eng-data Warehouse Resume Examples & Samples

  • Demonstrates ownership and accountability of application supported by having thorough understanding application
  • 3-5+ years of Tool Administration at an enterprise Level BI tools
  • Identify and improve infrastructure and processes. Ensure environments are stable and available
  • Administer and support SAS Infrastructure including Upgrades, testing, Security Administration, License Management, troubleshoot workbooks, Performance Monitoring and System maintenance
  • Test and explore new releases of SAS Application and drivers, suggest and support user with proper drives install
  • Coordinating across multiple business groups to setup support and user meeting
  • Document best practices for Development and administration of the Platform
  • Maintaining Security and Create/manage users, Groups, Licenses and integrate with Active Directory
  • Ability to train or coordinate business users to setup Site and Access policies
  • Software upgrade. Server refresh. Coordinate independently with Vendors
  • Version Control Tools such as CVS, SubVersion
  • Bug tracking tool JIRA or Bugzilla
  • Technology related Bachelor’s degree or equivalent combination of training and experience
  • 3+ years of experience in SAS Administration, monitoring, disk space management
  • Should have worked on upgrades and metadata and configuration
  • Experience working with (Sun Solaris) UNIX operating systems; some experience with the Windows operating systems as well
  • Should have experience in SAS 9.4 and Higher
  • Manage data in libraries , maps and metadata server
  • Should have SQL knowledge, Working Knowledge of Data Bases like Oracle, SQL, Pivotal GreenPlum and SAS Libraries
  • Knowledge of other data Visualization tools like Tableau, Business Objects is a plus
  • Demonstrated experience managing internal and external technical resources
  • Advanced knowledge working with MS Office Suite of products including Word, Excel, PowerPoint and Outlook
  • Should have a good communication
  • Actively pursues opportunities for learning and self-development
  • Is able to think logically, communicate clearly, and be well organized
  • Identify continuous improvement opportunities
  • Awareness of industry trends and best practices
  • Ability to conduct external research (e.g. web, benchmarking, attends vendor conferences)
  • Understand and follow programming standards and software development life cycle
  • Ability to define, design, build & release process including installation scripts and development of back out plan
  • Understand SDLC/ Quality processes
  • Ability to maintain multiple application environments
  • Understand architectural principles, standards, and strategies
  • Understand infrastructure, hardware and database environments
  • Demonstrate basic understanding of technical architecture principles and standards
  • Demonstrate high level understanding of the technology strategy for the company
  • Demonstrate expert proficiency in one or more programming languages or tools
  • Demonstrate basic knowledge of multiple operating system platforms
  • Demonstrate basic proficiency in Relational / Object Oriented database technologies
  • Develop awareness of industry trends and best practices
  • Demonstrate an understanding of specific business functions within a domain
  • Conduct requested external research (e.g. web, benchmarking, attends vendor conferences)
56

Ccar-data Warehouse Development Engineer Resume Examples & Samples

  • Manage the software development team for DB application services
  • Oversee the platform, day to day requests, long term projects, and strategy
  • Work closely with project/program management as well as managers of related applications
  • Continually improve the performance of the team in regards to SDLC, QA, and deployment practices
  • Act as an expert on the platform in various capacities, strategy meetings, and product development opportunities
  • Manages one or more software development teams on projects of small to moderate size and complexity
  • Recommends most efficient way to produce new products - Evaluates and reports on the progress and results of development efforts
  • Responsible for hiring, firing and performance appraisals
  • Ensures projects are completed on time and according to corporate quality standards
  • Facilitates communication upward and across project team including development status, justifications for variances and technical architecture, design and implementation
  • Serves as focal point for other departments on development status
  • Ensures projects are completed according to product specifications and are properly documented
  • Product architecture and implementation is maintainable and extendible to accommodate future development and maintenance (architecture documentation and architecture design review)
  • Ensure availability of all necessary application/service knowledge and documentation
  • Ensure system stability through enhancement/maintenance periods
  • Ensure in 'Change the Bank; ('CTB') projects that the changes to the application(s) are fully aligned / support the application strategy across the full SDLC with support on
  • Provides cost estimates
  • Functional design
  • Solution architecture together with the solution architect
  • Technical design
  • Ensures a smooth/successful transition to the production (steady-state) environment
  • Manages L3 application support as required
  • Capture Build and Deployment notes, develop Software Product Deployment & Operating Instructions
  • Ensures the delivery of Software Product Operating Instructions
  • Experience building high-performance, enterprise applications at scale
  • Significant prior experience with development technologies; keeps pace with technical innovation
  • Experience managing software developers, preferably in medium/large companies
  • Demonstrated ability in all aspects of hiring - attracting talent, and making great hires
  • Exceptional management and people skills, ability to manage personnel activities of staff (e.g., hires, mentors, coach, trains, appraises, rewards, motivates, and disciplines, and recommends termination as necessary, 1-on-1's, Performance Reviews, etc. of direct reports)
  • Passion for quality and continuous improvement of processes and software, well versed with software engineering practices (e.g. Continuous Engineering, Build/Deploy, Unit Testing, Regression Testing, Test & Staging Environments)
  • Excellent communication and influencing skills
  • Passion about sharing knowledge and best practices
  • Ability to work in virtual teams and in matrixed organisations
57

Data Warehouse Technology AML Specialist Resume Examples & Samples

  • Building, configuration and maintenance of test, production and contingency environments for Data Warehouse system for 10 EMEA countries
  • Implementation of software packages for test, production and contingency environments
  • Supporting UAT and SIT tests
  • Level 3 production support
  • Collaborate with developers and subject matter experts
  • Assist in quality assurance and defining testing strategy and risks. Provide significant contributions in the testing and debugging of new software or enhancements to existing software
  • Troubleshoot in an organized fashion, by breaking down issues into components in order to solve problems
  • Be able to work in a fast paced, dynamic environment with little supervision
  • Be self-motivated and able to take the initiative to work closely with stakeholders
  • Experience with Oracle databases
  • Experience with Red Hat Linux operating system
  • Practical skills of SQL queries and Oracle PL/SQL tools
  • Practical skills of shell scripts creation and operating system tasks scheduling
  • Experience working with delivery teams spread across many countries and time zones
  • Must be a good team player and should be able to collaborate with multiple teams in diverse locations during project execution
  • Teamwork-focused/collaborative work style
  • Problem solving skills evidenced by demonstrated results in past positions
  • Ability to work under tight deadlines and handle multiple/detail-oriented tasks
  • Fluency in English, written and spoken
58

Data Warehouse Software Engineer Resume Examples & Samples

  • SQL developer responsible for designing, implementing and maintaining systems on the analytics platform
  • Ability to conduct requirement and data analysis
  • Ability to analyze, troubleshoot, performance tune and understand existing database applications
  • Collaborate efficiently with business analyst and other team members to translate business into software requirements
  • Ability to manage multiple projects and tasks simultaneously
  • Design, prototype and iterate on innovative solution to meet user requirements
  • Proven experience in building and maintaining database application in an analytics environment
  • Experience in data analysis
  • In-depth knowledge with analytical systems
  • In-depth knowledge with database technologies such as SQL, ETL, data transformation, data loading, data mining
  • In-depth working experience with IBM DB2
  • In-depth working experience with AIX operating system
  • Experience in coding Unix Shell to manipulate data on databases like db2
  • Experience in working in restrictive professional environment
  • Working experience with any Data Visualization tools like Cognos/Business Object is a plus
59

Data Warehouse Business Analyst Resume Examples & Samples

  • Gather business requirement for various enhancement in XIB and generate business requirement specifications
  • Work with multiple teams, analyze data and suggest business solution
  • Act as link between the Business needs and the development and testing team for ensuring technical solutions satisfied business requirements
  • Perform data analysis based on User queries and issues and identify root causes. Ability to run queries is important
  • Represent sales and research business requirements to technology teams; articulate business use cases on behalf of sales and research staff, navigate through compliance, business management as needed
  • High Understanding of the XIB system would need to be developed and understanding of the regression impact areas
  • Should be able to assist in Unit testing , Regression testing and provide support for UAT testing
  • Solid understanding of software quality assurance and processes
  • Strong desire to join and influence a sustainable, high performance test culture
  • Participating in the planning, development and testing of key features
  • Writing great quality test tools and automation
  • Contributing and driving some of the Engineering Excellence efforts such as stress, performance and longevity testing
  • Minimum 7 years' experience in various phases of Business analysis , testing, complex enterprise applications as well technical business analysis
  • Ability to understand Data model and proficient in SQL Query writing and analyzing data
  • Ability to work with multiple teams to arrive at a business solution and discuss with development team for technical implementation
  • White Box testing experience Proven capability in test methodology, automation, and test processes
  • Strong object oriented programming, debugging, and test automation skills with Informatica
  • Excellent communication skills, verbal and written
  • Experience shipping products with high standards on aggressive schedules is required
  • Ability to perform system-wide root cause analyses and drive improvements
  • Advocate customers throughout the product cycle through feedback, test design, collaboration with other functional teams
  • Participate in the delivery of high quality software releases within budget and to schedule
60

ETL / Data Warehouse Tester Resume Examples & Samples

  • Review Business/Functional specifications & design document to ensure full understanding of technical deliverables and provide feedback
  • Identify & document test requirements from specifications & design documents, map test case requirements and design test coverage plan in test strategy document
  • Develop, document and maintain functional, technical & business test cases in HP Quality Center
  • Conduct and facilitate test plan/case reviews with required stakeholders
  • Testing Data Warehouse applications developed in ETL & BO tools and Oracle on Unix/Linux servers
  • Execute and evaluate manual or automated test cases and report test results
  • Analyze test results, identify discrepancies and clearly document and report defects
  • Timely escalation of Issues affecting testing & project timelines
  • Participate in project related meetings
  • Ensure Issue tracking process is followed & enforced
  • Ensure QA & Control & Compliance processes are followed and enforced
  • BS in Computer Science/Informational Technology or relevant experience
  • 8-10+ years relevant experience in testing Data Warehouse or similar kind of applications running on Unix/Linux (We will consider candidates without experience)
  • Expertise in testing Data Warehouse applications developed using ETL & BO tools, and Oracle database on Unix/Linux Servers
  • Expertise in database testing including validating stored procedures, jobs, triggers and other DB objects
  • Strong Oracle SQL knowledge
  • Strong Unix/Linux knowledge
  • Ability to understand and create test Strategy/plan and test cases from specifications and design documents
  • Experience in designing, creating and manipulating test data
  • Work in team environment as well as individual performer
  • Willing to learn new tools and technologies
  • Good Communication skills both written & verbal
  • Strong Analytical problem solving skills
  • Understanding of SDLC process
  • Experience in using HP Quality Center or similar tool
61

Data Warehouse Technical Lead Resume Examples & Samples

  • Follows change management and problem management processes
  • 8+ year’s experience in information technology
  • 5+ years minimum of demonstrable experience in a technical leadership role
  • Expertise in reviewing business requirements, technical requirements documentation
  • Familiarity with use of version control / source code management tools
62

Ccar-data Warehouse Development Engineer Resume Examples & Samples

  • Provide support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other suitable source systems
  • Document technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized
  • This position involves the delivering of huge data integration projects and would therefore require leveraging best practices expertise and experience at implementation; as well as effective technology know-how
  • Consolidate and optimize available data warehouse infrastructure
  • Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients
  • Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
  • Design and implement ETL processes and data architecture to ensure proper functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard
  • Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
  • 7+ years or more experience performing data warehouse architecture development and management
  • Remarkable experience with technologies such as SQL Server 2008, as well as with newer ones like SSIS and stored procedures
  • Exceptional experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database
  • High proficiency in dimensional modeling techniques and their applications Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel
  • Several years working experience with Tableau, SportFire, TIBCO, QlikView, MicroStrategy, Information Builders, and other reporting and analytical tools
  • Experience with Hadoop, Impala, Pig, Hive, YARN, and other “big data” technologies is a plus
  • Work in an agile development SLDC by focusing on the highest priorities and iterating through delivery in a team oriented manner
  • Conduct peer reviews and comprehensive unit testing and building out automated testing framework
63

Specialist Data Warehouse BIS Resume Examples & Samples

  • Identify and implement any transformations and conversions required to maximize consistency and the usability of the data
  • Develop and test data extraction, transformation and loading processes
  • Provide 3rd line support to the ETL Production Support teams
  • Stay abreast with development in ETL technology (e.g. Teradata and Informatica Power Centre, etc.)
  • Mask and scramble data for a specific purpose, according to the business rules provided by the Information Analysts
64

Data Warehouse Solutions Architect Resume Examples & Samples

  • Prepare detailed ETL specifications to design, code and test all SQL/BTEQ scripts and utilities
  • Ability to install, configure and upgrade Teradata server hardware, software, and related products
  • Minimum 5-7 years’ experience as a DBA or similar role working with Teradata databases
  • UNIX shell scripting, Teradata utilities experience required
  • System administration for AIX, Linux SuSe, and NCR MPRAS a plus
  • MS/SQL Server, Oracle database knowledge a plus
  • Windows developer experience a plus
  • ETL/ELT tool knowledge required
  • Control-M job automation tool experience preferred
  • Performance tuning of Teradata database systems
  • Perform database loads, backups and recoveries using Fastload, Multiload, ARC, NetVault, and NetBackup
  • Understanding of data modeling and use of modeling tools a plus, i.e. Erwin, Data Modeler
65

Data Warehouse Applications Developer Resume Examples & Samples

  • Development and test application changes using disciplined software development processes
  • Responsible for Design, Development, Unit Testing and Support During QA/UAT testing
  • Adherence to Development Life Cycle, IT controls and change control policies for all developments
  • Day-to-day maintenance of the application system in operation, including tasks related to identifying and troubleshooting application issues and issues resolution or escalation
  • Application maintenance activities in catering to ad-hoc work requests and implementing change requests
  • Should have approx. 4+ years of experience in DW/BI space
  • Strong understanding of Datawarehousing concepts and data modelling
  • Strong knowledge and working experience in Informatica 9
  • Proven experience in testing and debugging ETL code
  • Should have work experience on UNIX and Shell Scripting
  • Knowledge of database concepts, procedures/functions (Oracle/Sybase IQ )
  • Strong analytical skills and an eagerness to learn new technologies
  • BA/BS Degree in Computer Science or Related Field
66

Data Warehouse Ab Initio Applications Developer Resume Examples & Samples

  • Five plus years of progressive, post-baccalaureate work experience in job offered or five years of progressive, postbaccalaureatework experience in a software engineering-related occupation
  • 5 plus years PL/SQL programming
  • 5 plus years Data Modeling
  • 5 plus years with Oracle
67

Data Warehouse Resume Examples & Samples

  • Bachelor or Master’s Degree in Computer Sciences or Information Technology
  • 7+ years of experience defining advanced relational database designs, architecting complex enterprise data warehouses and business intelligence solutions through implementation and support
  • 5+ years of experience developing logical and physical data models, data mapping, data dictionaries and metadata documents to implement data-driven business solutions
  • Hands-on experience in developing, analyzing and performance tuning complex SQL statements, stored procedures and materialized views to support high-performance, multi-tenant databases
  • Expertise in dimensional data modeling, OLAP cube design, and data mart and data warehouse implementations based on star schema and top down or bottom up methodologies, on Microsoft SQL Server, PostgreSQL or MySQL platforms
  • Proficiency in performance and scalability best practices, data transformation, and data integration strategies using commercial ETL solutions
  • Hands-on experience in installing, configuring, designing and building complex visualizations and dashboards using Tableau, Qlikview, or Jaspersoft software
  • Familiarity with high scale, distributed systems such as Hadoop/MapReduce, and NoSQL databases (key-value stores and graph databases) such as MongoDB/Riak
68

Data Warehouse Ab Initio Application Developer Resume Examples & Samples

  • Education: Bachelor's degree in Computer Science, Engineering or related technical field
  • Five years of progressive, post-baccalaureate work experience in job offered or five years of progressive, postbaccalaureatework experience in a software engineering-related occupation
  • Technical experience must include: 1. ETL/Data warehousing technology - Ab Initio, EME, Co-Op, BRE, or Continuous flow;2. Unix, PERL, Teradata;3. PL/SQL programming;4. Data Modeling;5. Oracle;6. TWS and Control M Schedulers
69

Specialist Data Warehouse BIS Resume Examples & Samples

  • Enhance ETL processes by attending to incidents logged
  • Increase subject area knowledge by doing research and learning through experience and stretched objectives
  • Mask and scramble data for a specific purpose, according to the business rule provided by the Information Analysts
  • Apply consistent business rules for specific data according to the technical specifications
  • Identify and implement any transformation or conversions required to maximise consistency and usability of the data according to the technical specifications
  • Identify data quality issues on the technical specification and liaise with the Information Analysts to address the problems and action the resolution
  • Map the source data to the target data structures designed for the Data Warehouse environment
70

Data Warehouse & Business Intelligence Engineering Resume Examples & Samples

  • Ability to lead, manage and train a staff of Data Warehouse engineers
  • Coordinate development activity along with project due dates to ensure on time delivery. Must be able to report progress based on a Waterfall/Agile methodology
  • Responsible to review technical design documentation to ensure development is being built and tested according to technical standards
  • Support the research and resolution of data warehouse errors. Drive discovery into root cause failures
  • Assist developers with performing work breakdown structure defining all the steps required to complete
  • Partner with other organizations and team members to achieve results. For example, work with Architecture and Operations
  • Coordinate and perform in-depth tests, including end-user reviews, for modified and new processes, and other post-implementation support
71

Data Warehouse Informatica Developer Resume Examples & Samples

  • 12 years of experience in the Data Warehousing and Data Integration projects
  • 5 years of experience as a technical lead
  • Expert technical knowledge of all phases of applications development
  • Expert knowledge of relational database concepts, data modeling, data warehousing
  • Hands-on knowledge in Informatica v 9.6, experience in Informatica BDM and Teradata v14.10
  • Knowledge of programming languages (Java or Python)
  • Lead experience in implementation of several Data Warehousing and Data Integration projects
72

Data Warehouse Specialists Resume Examples & Samples

  • Long-term cooperation
  • In the event of double-interest is a possibility to cross to the full time job (after graduation)
  • Work within Agreement on working activity - Possibility to work 20 hours per a week or more (during the exam period could be less)
  • Good knowledge of English and Czech
  • Necessary knowledge of D8 relation modeling
  • Advantage is knowledge of Oracle, Teradata RDBMS, Informatica, Power Designer, shell scripts and so on
73

Ccar Data Warehouse Development Engineer Resume Examples & Samples

  • Gathering of business requirements and creating architectural designs
  • It involves designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems
  • Review, analyze, modify, and create ETLs, utilizing Informatica, testing, debugging, integration and implementation processes
  • The individual holding this position must be able to perform various complex assignments without much supervision; and must be able to carry out training for company and IT staff
  • Carry out monitoring, tuning, and database performance analysis Perform the design and extension of data marts, meta data, and data models Ensure all data warehouse architecture codes are maintained in a version control system
  • 10+ years or more experience performing data warehouse architecture development and management
  • Working knowledge of SAS and R code used in data processing and modeling tasks
  • Ability and willingness to coach and mentor others and work collaboratively in teams
  • Ability to solve business or production problems
  • Ability to work in virtual teams and in matrixed organizations
74

Data Warehouse Application Lead Resume Examples & Samples

  • 10+ years of full development life cycle experience in large scale Data Warehouse environments
  • Ability to self-organize/manage multiple priorities and projects coupled with the flexibility to quickly adapt to ever-evolving business needs
  • Must be able to communicate complex issues in a crisp and concise fashion to multiple levels of management
  • Must have the ability to work in a complex data environment as well as the ability to partner with the business and IT to find creative data solutions to business problems
  • Experience with SQL Server Integration Services (SSIS) to integrate data from disparate sources, SSAS
  • Financial Services and Commercial banking experience is a plus
75

Associate VP, Group Data Warehouse Resume Examples & Samples

  • Self-driven, motivated to excel, ability to work with minimal supervision, and maintain productivity in a fast-pace and high pressure environment
  • Ability to quickly adapt to changing business needs and communicate applicable strategies internally and externally
  • Robust organizational skills with the ability to work in a dynamic environment and manage multiple deadlines and priorities
  • Detail oriented, able to handle multiple tasks, and adapt quickly to changing business needs to meet deadlines
  • Creative, out-of-the-box thinker, with strong conceptual and problem solving skills
  • Experience working within Shared Services and Offshore development models
76

Data Warehouse Business Systems Analyst Resume Examples & Samples

  • Meet and discuss requested changes with business client ensuring a thorough understanding of specifications
  • Review with technical team to ensure understanding of project requirements
  • Responsible for coordinating estimates for medium projects and performing estimates for assigned component on large projects
  • Facilitate / provide estimates after business requirements and functional phases while establishing time lines and project phases
  • Participate and provide feedback with clients regarding business requirements
77

Technical Data Warehouse Business Analyst Resume Examples & Samples

  • College degree, or specialized training or equivalent work experience
  • Minimum four years of relevant work experience
  • Experience with BI tools, example Power Pivot, Power BI
  • Experience setting up test scenarios
  • Experience/understanding of business process reengineering and business modeling concepts, business systems development and analysis
  • Awareness of the business and IT strategy
  • Basic understanding of the company's business practices and familiarity with the company's products and services
  • Strong analytical skills and writing skills, to include solid experience in writing functional and technical specifications
  • SQL and Database experience a plus
78

Infrastructure Database & Data Warehouse Design Lead Resume Examples & Samples

  • Demonstrated design experience in Information Technology, largely focused in Oracle RAC databases and data warehouse design and/or development in complex IT environments
  • Experience working with Business and Technology - Application, Infrastructure and Architecture team
  • Knowledge of Teradata utilities such as Multi load, Fastexport, BTEQ, Fastload, TPump and Teradata Parallel Transporter (TPT).Familiar with Teradata Viewpoint, data migration from Production environment to Non-Production environment
  • Strong stakeholder and vendor relationship skills and the ability to work in an organisation with teams across geographies and time zones
  • Highly analytical, innovative, and able to think strategically to develop comprehensive solution and solution estimates
  • Oracle Grid 11 & 12
  • Oracle RAC 11 & 12
  • Oracle Clusterware 11 & 12
  • Oracle ASM 11 & 12
  • Oracle Solaris 10 & 11
  • Oracle HA 11 & 12
  • Working knowledge of Oracle Multitenant 12
  • Designing for the Data Warehouse
  • Interpret Logical Data Modelling
  • The normalisation Process
  • De-normalising the Physical Schema
  • Teradata SQL (DML, DDL, DCL)
  • Teradata Database Indexes and Partitioning
  • Teradata Primary Index, Primary AMP Index, and NoPI Objects
  • Teradata Secondary Indexes
  • Teradata Join and Hash Indexes
  • Designing for Database Integrity
  • Using Data Compression
  • Database-Level Capacity Planning Considerations
  • System‑Level Capacity Planning Considerations
  • Design for Tactical Queries
  • Designing Tables for Optimal Performance
  • Compression Methods
79

Data Warehouse SQL Developer Resume Examples & Samples

  • Responsible for planning, processing and performing all jobs in an efficient manner
  • 5-7 years experience
  • Familiarity and competency with SQL database design and programming (include but not exclusive to the following)
  • VB.NET / C#.NET
  • ASP.Net
  • Team Foundation Server
  • MVC
  • SOAP
  • XML
  • Jquery
  • .NET Framework 2.0 – 4.0
  • File operations and permissions
  • Web Servers (IIS)
80

Senior HR Data Warehouse Production Support Lead-VP Resume Examples & Samples

  • Investigate technical issues in production environment
  • Monitor application health
  • Maintain batch job schedule and alter batch schedules to accommodate production activity or green-zones (i.e.: app upgrades)
  • Work with DBAs and application team to troubleshoot long running queries and implement query optimization as needed
  • Environment refresh coordination
  • File transmission setup – inbound and outbound
  • Escalation point for issues encountered in the operational process
  • Proven knowledge and working experience with ETL/ AbInitio
  • Strong relational database knowledge, Oracle is preferred
  • Unix experience is required
  • Computer Science or related bachelor’s degree
  • Ability to multi-task under strict deadlines, demonstrating independent leadership skills
  • Superior communication skills, given exposure/interaction with senior business managers
  • Detail-oriented, with strong analytical skills and ability to synthesize
  • Possess strong team building, planning and work skills, driven by process improvement, ability to lead and work with multinational team
  • Willing to work flexible hours
81

Data Warehouse Resume Examples & Samples

  • Ability to obtain a public trust clearance
  • PL/SQL experience
  • Oracle database is preferred
  • Prior work in a data warehousing, business intelligence environment
  • Strong data analysis and communication skills
  • Experience with Oracle Business Intelligence Enterprise Edition (OBIEE) preferred
  • BA/BS Degree from an accredited college or university in a related field
82

M HIS Data Warehouse Business Analyst Resume Examples & Samples

  • Collaborate with representatives across the organization to define standard processes within our data warehousing environment
  • Work with subject matter experts, define business requirements, business rules, and produce documentation that is client facing as well as technical documentation used by developers
  • Translate the business requirements and documenting business rules into source to target data mappings
  • Create and maintain data mapping documents including data lineage
  • Maintain data dictionary
  • Lead preparation of data warehouse requirements document for development
  • Work hand in hand with Data Modelers, Data Developers, and Business SMEs to ensure the data needs and business rules are accurately captured, understood and delivered
  • Perform data analysis and review business rules with the business stakeholders to refine requirements that will be mapped for ETL developers
  • Validate results from development and work with Data QA on repeatable data validation scripts
  • Respond to questions pertaining to data access and business logic
  • Produce any required documentation output
  • Oversee data acquisition processes and their implementation to ascertain compliance to requirements and business rules
  • Minimum of five (5)+ years of experience performing requirements gathering and analysis
  • Minimum of three (3)+ years in an analyst role documenting business rules and source to target mapping
  • Minimum of five (5)+ years of experience in writing SQL queries for large data warehouses
  • Minimum of two (2)+ years of experience with Microsoft Excel, Word, PowerPoint, Visio, SQL Server Management Studio
  • Experience working in the Healthcare industry
  • Experience working with Star Schema/Dimensional data models
  • Experience working with Microsoft SQL Server
  • Knowledge of medical claims data including claim, member, provider, clinical, etc
  • Strong problem solving skills to breakdown complex problems
  • Work as a member of an agile development organization
  • Must be self-motivated with a strong desire to learn
  • Small project management and project status reporting experience
  • Experience working with both ETL, BI architects, and report developers to communicate data mappings
  • Experience working with SQL Developers as well as ETL Developers that use technology such as Informatica
  • Experience consolidating data from disparate systems is preferred
  • Familiarity with data warehousing and business intelligence terminology
83

Data Warehouse Administrator Resume Examples & Samples

  • Administering IBM Master Data Management solutions, IBM Data Stage ETL solutions, and Oracle data warehousing
  • Installation, configuration, and provisioning of the Data Warehouse
  • Assisting in design, modelling, and development of data models and ETL solutions necessary for Data Warehousing and Business Intelligence solutions
  • Providing support services for database object creation, performance, monitoring, tuning and capacity planning
  • Building physical data structures, and enforces policies and procedures for maintaining the security and integrity of the database
  • Designing, modelling, and developing data models and ETL solutions necessary for Data Warehousing and Business Intelligence solutions, under occasional guidance
  • Building physical data structures
  • Enforcing policies and procedures for maintaining the security and integrity of the database
  • Core Accountabilities
84

Senior DBA, Netezza Data Warehouse Resume Examples & Samples

  • Bachelors’ degree or equivalent experience
  • At least 5 years of IT experience with 3 - 5 years’ experience in Netezza
  • Korn Shell scripting
  • Database SQL in accessing and manipulating data
  • Relational database technology including data modeling (logical and physical)
  • All aspects of the software development lifecycle including: requirements gathering, design, coding, testing and production support
  • Experience with the following desired: Hadoop, Hive, Java Development on Hadoop
  • Experience with the following software desired: AutoSys Job Scheduling Tool, Jira, Remedy Force, Sync Sort for Unix
  • Application Development experience preferred
85

Data Warehouse Reconciliation Developer Resume Examples & Samples

  • Function as data reconciliation SME and supply technical knowledge on required subject-areas and systems
  • Domain experience in required MUFG products and services
  • Plan, design, document, develop, test, implement, monitor, maintain, and support data reconciliation in Enterprise Data Warehouse and Data Marts, including source systems and downstream systems reconciliations
  • Develop and maintain reconciliation for complex ETL mappings and workflows in a normalized/denormalized data warehouse/data mart environment, based on technical specifications and other supporting documentation, using NTier, advanced SQL, and Tidal Enterprise Scheduler
  • Conduct trainings and knowledge sharing sessions
  • Hands-on expertise in developing data reconciliations solutions using NTier in complex large-scale data warehouse and data integration projects in the banking industry. (1+ years)
  • Subject-matter expertise in required business domain in the banking industry
  • Bachelor's Degree in Computer Science, Information Systems, or directly related field
86

Data Warehouse ETL Developer Resume Examples & Samples

  • Function as ETL SME and supply technical knowledge on required subject-areas and systems
  • Plan, design, document, develop, test, implement, monitor, maintain, and support Enterprise Data Warehouse and Enterprise Data Mart solutions, including subject area marts and interfaces to downstream applications
  • Develop and maintain complex ETL mappings, workflows, and Unix shell scripts in a normalized/denormalized data warehouse/data mart environment, based on technical specifications and other supporting documentation, using Informatica PowerCenter, Unix Shell Scripts, advanced SQL, and Tidal Enterprise Scheduler
  • Perform DUT/SIT/UAT/DR/regression testing activities
  • Handle user inquires and production support
  • Ensure best practices, standards, processes, and procedures are followed
  • Support Information Management and other ITD initiatives as required
  • Hands-on expertise in developing Informatica ETL mappings and workflows in complex large-scale data warehouse and data integration projects in the banking industry. (5+ years)
  • Hands-on experience in designing relational and dimensional databases in the banking industry. (3+ years)
  • Hands-on experience in Unix shell scripts. (3+ years)
  • Hands-on experience in advanced SQL and advanced Excel functions. (3+ years)
  • Hands-on experience in Tidal Enterprise Scheduler. (3+ years)
  • Experienced in waterfall and agile SDLC methodologies. (3+ years)
  • Detail-oriented with excellent interpersonal, verbal and written communication, coordination, documentation, analytical, problem solving, leadership, and time management skills
  • UML experience and knowledge a plus
87

Data Warehouse Operations, Director Resume Examples & Samples

  • Oversee the release and change control effort for large projects and ensure successful execution for deployments
  • Manage DWH operations and schedules, security, high availability, best practices across the platform
  • Staff Management & Talent Development – Manage staff of about 10 employees & 10 consultants comprising of various competencies – Operations and job scheduling using Autosys, Informatica ETL and IDQ developers, Wherescape developers, system engineers and tech project leads. Mentor/Coach staff, Conduct Knowledge Transfer sessions; Provide guidance/direction to staff in Operations, Data Architecture, Data Management and DW/BI areas; Ensure best practices and standards
  • Support Global, Regional, and Local initiatives; Support stakeholders & end users
  • Resource Planning, Hiring, Vendor Management, Budget Management, and Project Management
  • Architect and oversee/execute DW/BI Strategy & solutions; Build Roadmaps; Contribute to Data Governance and Executive/Management Reporting initiatives
  • Review and ensure deliverables are within proper standards and time lines and meet business requirements (functional, non-functional, interface and reporting requirements)
  • Ensure that there is alignment between longer term goals of customers and the capability, processes and performance of various teams is meeting it
  • Realign processes, plan recruitment, extend infrastructure to support the near and long term vision
  • Architecture Reviews, Air Traffic Committee reviews
  • Identify, mitigate, and report technology/solution risks
  • Experience in staff management, organizational planning & growth strategies
  • Experience in leading large/complex data warehouse operations
  • Experience in managing departmental budget, cost/expense management, budget forecast, balance score card, KPI management, mid-term plans, etc
  • Full system development life cycle (SDLC) experience
  • Experience with Data Warehouse, BI (strategic, tactical and operational BI), Data Integration and Data Management are a must
  • Experience with Job scheduling tools like Autosys, ETL & BI tools & technologies along with Data Quality & Data Governance tools & technologies
  • Strong database experience coupled with project leadership/management skills
  • Contract Management & Vendor Management skills a plus
  • Banking/Financial Services experience is a must
88

Data Warehouse Resume Examples & Samples

  • Develop data warehouse solutions for BI
  • Create and modify OBIEE physical, business and presentation layer components
  • Good knowledge of RPD design and optimization for performance
  • Knowledge of Weblogic configuration for OBIEE application hosting
  • OBIEE architecture and administration
  • Design and develop PL/SQL code to perform ETL processes
89

Oracle Data Warehouse Modeler / Developer Resume Examples & Samples

  • 5-7 years overall BI experience
  • 5-7 years experience with an enterprise ETL or BI platform
  • 3+ years of data warehouse design and data modeling experience
  • Solid understanding of dimensional modeling, STAR schema design, Snow fake schema design, slowly changing dimensions, confirmed dimensions, etc
  • Has led the design and implementation of at least 1 significant DWH project
  • Able to scope large efforts, conduct meetings, and write technically oriented documents
  • Able to work with functional and technical teams
  • Proven ability delivering complex and time sensitive projects
  • Strong communication (written and oral) and interpersonal skills
  • Bachelor’s Degree (preferably in MIS or Computer Science)
  • Experience extracting data from SAP ECC and / or SAP BW
  • Experience with OLAP cube design and development
  • Experienced with database performance tuning and query optimization techniques
  • BI Platform: SAP Business Objects
  • ETL: SAP Business Objects Data Services
  • Databases: Oracle, SQL Server
  • Languages:PL/SQL, SQL
90

Business Intelligence / Data Warehouse DBA Resume Examples & Samples

  • Bachelor’s degree from a four year college or university
  • Minimum six (6) years of Senior operational DBA supporting data warehousing and business intelligence solutions
  • Expertise in logical and physical data warehouse database design (Oracle, SQL Server), and performance optimization. Should have excellent database design, data modeling knowledge and experience related to large scale, multi-dimensional BI/data warehousing implementations
  • Experience and demonstrated competencies with multi-dimensional design, star schemas, facts and dimensions
  • Comprehensive understanding of data management best practices including demonstrated experience with data profiling, sourcing, and cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching
  • Working knowledge and experience with data, master data and metadata related standards, processes and technologies
  • Deep knowledge and operational experience with Microsoft BI/DW tools, technologies and products (SQL Server, SQL Server Integration Services, Analysis Services, Reporting Services, etc)
  • Experience with schema management and tools such as ERwin, SQL Compare or equivalent tools
  • Must have the ability to travel overnight approx. 5% of the time
  • Experience in working with distributed development teams; offshore, onshore, and near-shore
  • Demonstrated excellence in verbal and written communication at all organizational levels
91

Senior Data Warehouse Administrator Resume Examples & Samples

  • Designing / developing / administering ETL production processes, performing data verification / validation activities and serving as an active member of the Healthcare Informatics Data Management team
  • Solves moderately complex problems and / or conducts moderately complex analysis
  • Translates concepts and develops into an automated production process
  • Acts as a resource for others on assigned production flows / processes
  • Responsible for maintaining and supporting several extracts and reporting deliverables for all customers of the Nevada market
  • Develop and maintain MSSQL SSIS ETL processes
  • Maintain ongoing self-study program to enhance knowledge of PL / SQL, Oracle RDBMS, TOAD, and Informatica PowerCenter
  • Document development activities by within SDLC guidelines
  • 3+ Years of professional experience with SQL database development
  • 3+ Years of professional experience with MS SSIS development
  • 3+ Years of professional experience with structured query language (Preferably: MS T-SQL or Oracle PL / SQL)
  • 3+ Years of professional experience with Extract, Transform, and Load (ETL) tools
  • 3+ Years of professional experience with the entire Software Development Life Cycle (SDLC)
  • 3+ Years of professional experience with Oracle RDBMS
  • 3+ Years of professional experience with MSSQL RDBMS
  • Experience with MS SQL Server DTS
  • Experience with T-SQL and PL/SQL Tuning
92

VP of Data Warehouse Resume Examples & Samples

  • Direct the development activities of data engineering teams
  • Recruit, manage and continuously develop innovative products through leadership and collaborative team building
  • Become an expert in Conversant’s core data platforms and all its various components
  • Be an active spokesperson and evangelist internally and externally by communicating and promoting Conversant’s technology vision and solutions
  • Stay abreast of new technologies and issues in the global ecosystem, including competitive technologies, platforms and associated solutions
  • Assure that the engineering team is equipped to resolve system problems 24 x 7
  • Define, prioritize and execute a flow of product enhancements and operational improvements designed to enhance revenue and efficiency
  • Develop and communicate overall positioning, benefits, features to internal and external stakeholders
  • BS in Computer Science or related technical discipline or equivalent work experience
  • Extensive data warehousing and industry knowledge in Ad Tech and Measurement
  • Proficient in the development of competitive assessments and positioning; product planning and roadmap definition; sales training and presentations
  • High level of business maturity to represent the company in business partnerships and client discussions
  • Excellent management experience to scale a large technology and engineering team & drive direct impact on the business
  • 10+ years of successive experience including previous VP experience
  • MS or PhD in Computer Science
  • Experience with NoSQL databases and “Big Data” technologies
93

Data Warehouse Intern Resume Examples & Samples

  • Will perform software development work in the following technologies: Web application development, Application servers, JAVA/OOP, Oracle databases
  • Learn new technologies such as BI tools, ETL programming
  • Solves problems proactively; actively seeks advice and guidance from senior staff
  • 0-1 years of related experience supporting engineering; information technology or other technical operations
  • Strong proficiency of MS applications
  • Strong ability to work with others; in a team environment; but also comfortable working independently
  • Good organizational skills and multi-tasking
  • Able to work individually and as part of a team
  • Due to the nature of our business; US Citizenship is required
94

Data Warehouse Supervisor Resume Examples & Samples

  • Strong knowledge and experience in OLAP tools including Cognos Series 7 and Cognos 8.2/ 8.3/8.4/10.1 and experience with ETL tools like Informatica 6.0, Cognos Decision stream and Data stage
  • Expertise on a range of Data Warehousing products such as: Cognos 10.1 Suite, Cognos 8 BI, Cognos ReportNet, Impromptu, Impromptu Web Reports; OLAP cube development using Cognos PowerPlay and Transformer, and implementing security using Cognos Access Manager
  • Expertise in Framework Manager Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages) and Complex Report building with Report Studio
  • Proficiency in using SQL Server Analysis Services (SSAS) tool for the analysis of data in both the staging and data warehouse
  • Extensive experience on production support and troubleshooting/test issues with existing reports and cubes
  • ETL development utilizing Data stage, Informatica Power Center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor)
  • Experienced with Multiple Relational Databases including Oracle, MS SQL Server, Teradata and DB2
  • Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills
  • Interacting with the end users on a regular basis for resolving issues pertaining to the reports
  • Minimum 5 years implementing Business Intelligence tools in complex environments
  • Extensive knowledge of analysis and design standards and techniques
  • Broad knowledge of industry standards for data warehouse design
  • Experience creating requirement documents
  • Experience reviewing, developing and approving detailed design documents
  • Experience with ERD analysis tools and ETL data modeling tools
  • Experience with providing query writing support and tuning expertise to end users
  • Experience in documenting code and processes for distribution to interested parties
  • Experience with ORACLE and TOAD for ORACLE
  • Experience with J2EE
  • Excellent interpersonal skills necessary to interact effectively with project managers, developers, business analysts, systems analysts and end users
  • Exceptional Oracle SQL skills
  • Thorough knowledge of data warehouse principals and techniques
  • Highly analytic, with the ability to independently analyze and design eligibility systems
  • At least 5 years database and/or programming experience
  • Experience in designing and building data structures from granular normalized transaction level to de-normalized data warehouse aggregations
  • Extensive experience with data warehouse implementations
  • Strong knowledge of logical and physical data modeling concepts
  • Must have a demonstrated ability to work independently within a team environment
  • Excellent interpersonal communication skills are required to support working in project environments that includes Business Unit and IT customers
  • Solid oral and written presentation skills and a demonstrated ability to clearly articulate design decisions
  • Requires strong analytical, conceptual and problem-solving abilities
  • Knowledge of or desire to learn health care systems, policies and health care related data
  • Experience developing SQL stored procedures, views, triggers, and functions - or similar tools using Oracle
  • Advanced understanding of database design – relational integrity, normalization, star schema
  • Working knowledge of SQL Server 2012 tools - Management Studio, SQL Server Profiler, SQL Reporting Services – or similar tools using Oracle
  • Experience and expertise including development of business specifications and implementing into BI reporting products
  • Working experience with ETL software
  • Working experience with BI Software
  • Performance tuning experience
  • Ability to manage multiple priorities, and assess and adjust quickly to changing priorities
  • IBM Certified Designer - Cognos 10 BI Reports
  • IBM Certified Developer - Cognos 10 BI Metadata Models
  • IBM Certified Administrator - Cognos 10 BI
  • Working knowledge of Agile/Scrum or other development and project management methodologies
  • Experience with Rational Interactive Tools
  • Experience mentoring cross discipline colleagues on creation of UP deliverables
  • BS/ BA degree or equivalent and five or more years of experience in the IT Industry
  • Programming/SQL skills
  • Experience with TAFDC, EAEDC and SNAP(FS) policy
  • Experience with various databases
95

Data Warehouse Project Manager Resume Examples & Samples

  • Undergraduate degree or equivalent experience
  • 5-10 Years Project Lead/Project Management Experience
  • 1+ years Experience managing Data Warehouse related development projects
  • 1+ years Experience managing contract change management
  • Ability to develop and negotiate win/win solutions to project issues
  • Ability to work with end users/customers to understand and developer requirements
  • Ability to facilitate JAD sessions
  • Ability to organize and lead project related meetings with customer, development staff, and sponsor level staff
  • 1+ years experience with Project Schedule Management and Microsoft Project for Project Scheduling and tracking
  • 1+ years experience with Project Status Reporting
  • Experience with Project Quality Management
  • Experience with Project Budget Management
  • Experience with Project Resource/Staffing Management
  • Extensive experience with Project Change Management
  • Extensive experience with Project Issue Management
  • Extensive experience with project development methodology and project management methodology and able to apply methodology in a practical manner
  • Needs to be able to work independently and not rely on customer or other team members for direction
  • Ability to communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector
  • Ability to meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan. Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives. Make appropriate recommendations
  • Required to work on-site in Lansing, MI
  • Full time position at 40 hours per week 8-5 ET Monday through Friday
  • Some extra hours are requested from time to time above 40 hours per week
  • PMI/PMP or equivalent certification
  • Experience with the State of Michigan- PM/SUITE methodology
  • Preferred (but not required) experience with State Government and Medicaid business area
96

Tech Lead Data Warehouse & Integration Resume Examples & Samples

  • 7-10 years of core java/spring experience
  • 6+ years of data warehouse design and implementation (Oracle preferred)
  • LI-TP1
97

Data Warehouse Resume Examples & Samples

  • 5-8 years of related experience
  • 4+ years of Oracle SQL and database programming
  • 2+ years PL/SQL
98

Data Warehouse Software Engineer Resume Examples & Samples

  • Software Development / Report Development ~~ Maintenance & Documentation ~~ Testing & Testing Support ~~ Analyze Performance ~~ Application Subject Matter Expertise ~~ Support
  • Write new code / build new reports in accordance with standards. Analyze end user data and business needs to format final product and ensure user-orientation and optimization of program/system performance. Contribute program and domain knowledge to feature and functionality planning
  • Maintain and modify programs/software. Implement approved changes by amending flow charts, developing detailed programming logic, and making changes to code. Write and maintain development/programming/systems documentation, as well as operations and user guides (as required). Document development/programming problems and resolutions for future reference
  • Effectively unit test all programs and reports prior to releasing them to the quality assurance team. Resolve all unit test issues in a timely manner. Assist in identifying test cases and in creating/mining test data to enable a thorough test of all development deliverables. Respond to all inquiries and issues in a timely manner as the developed code/program moves through the testing process and ultimately into production. Provide implementation/production support as required
  • Analyze performance of programs and make recommendations to correct deficiencies. Provide input into decisions regarding prolonging application life or replacing. Confer with senior development team members to gain understanding of needed changes or modifications of existing programs. Participate in resolution of questions of program intent, data input, output requirements, and inclusion of internal checks and controls
  • Evaluate and understand interrelationships between programs such as whether a contemplated change in one application would impact or cause unwanted results in a related part of that application or other applications/systems. Lend knowledge of assigned application(s) to other members of the technology and business teams to ensure understanding of interrelationships and dependencies. Participate in solution design to ensure quality and minimize impact on other applications and business processes
  • Support the installation for application program requirements. Support the end-user and technical operations staff as required. Assist with the integration of technology within and across the capability domains
  • Perform functional database design as needed to support reporting design/development
  • 5-7+ years of progressive experience development in the Microsoft development environment (i.e. Windows, SQL Server/SSRS/SSAS, .NET/C#, PowerShell, T-SQL)
  • 5-7+ years of experience developing and maintaining programming/systems documentation and technical instructions in the use of programs and/or program modifications
  • 3-5+ years of experience processing data, formatting and generating reports using SSRS
  • 3-5+ years working with SSIS and analyzing, creating and maintaining SSIS Packages
  • 2-3+ years in working with SSAS cubes including analysis, creation and maintenance of cubes
  • Demonstrated understanding of the Software Dev. Life-Cycle
  • Effective oral and written communication skills along with logical, analytical and abstract thinking skills
  • Demonstrated experience and comfort working in a multi-sourced, multi-vendor environment
  • MCSA: SQL Server 2012 credential and associated exams: 461/462/463 (Formerly MCTS and MCITP)
  • MCSE: Data Platform (464/465)
  • MCSE: Business Intelligence (466/467)
99

Senior IT Architect Data Warehouse Resume Examples & Samples

  • Define and evolve the high level architecture for the bank's suite of warehousing and reporting platforms, including the definition of roadmaps
  • Identify and drive key technology investments to remediate technology and process gaps
  • Manage proof-of-concepts for bridging gaps in solutions and for adopting new technologies
  • Establish and enforce standards for data integration and reporting patterns
  • Undergraduate Degree or Technical Certificate
  • Graduate Degree preferred
  • 10+ years relevant experience
  • Expert domain knowledge & experience in Data warehousing and reporting platforms, encompassing data model design, dimensional modeling, naming conventions, cross-cutting concerns, common integration technologies, patterns & standards and emerging technologies
  • Deep experience with tools spanning Business Intelligence, Data Marts, Visualization, OLAP cube and common Reporting technologies. Teradata, OBIE, Tableau, Cognos, BusinessObjects and other common industry tools should be second nature
  • Use specialized tools and techniques to develop data model and enhance existing data model. Experience in ETL, data architecture, data modeling, data analysis and profiling, Metadata Management, Reference Data Management and the Teradata Financial Services Data Model considered an asset
  • Contribute to meeting key project milestones and overall project deliverables on time, within budget, and adhering to relevant standards
  • Develop/maintain a proficient knowledge of system development methodologies, key business initiatives / issues, IT implications for systems or technologies and their impact on business solutions
  • Able to multi-task in a very dynamic environment
  • Build effective relationships with peers across the organization
  • Able to manage effectively in a highly matrixed environment
  • Capable of grasping and challenging low level technical assumptions
  • Strong communicator: excellent oral, written and presentation skills
100

Data Warehouse Informatica ETL Developer Resume Examples & Samples

  • Administering, maintaining, and supporting the Informatica environment
  • Providing Subject Matter expertise in the usage of Informatica
  • Monitoring the system data loads
  • Providing recommendations for tuning the load processes
101

Data Warehouse QA Engineer Resume Examples & Samples

  • 3+ years of experience as an Automated quality assurance engineer. Selenium is a plus. Testing data warehouse/ETL a plus
  • Strong knowledge with SQL with relational databases
  • Experience with SQL and database technologies is essential and required
  • Experience in database validation and writing SQL queries
  • Experience with test automation and load testing tools
  • Experience writing detailed test cases
  • Experience with testing full systems, in addition to knowledge of Change Control and Build Acceptance
  • Experience configuring environments for testing using virtual machines
  • Experience training and mentoring QA personnel
  • Experience in production support processes
  • Experience testing commercial, enterprise software
  • Ability to creatively and accurately test software solutions in a high-energy, fast-paced, and Agile development environment
  • Ability to work in a highly collaborative, teamwork-based, environment
  • Proven problem solving and troubleshooting/diagnostic skill and the capacity to think creatively under pressure
  • Excellent documentation and communication skills
  • Knowledge of the software development lifecycle
  • Quick learner with an ability to understand new concepts, technologies and product functionality
  • Proven understanding of defect tracking systems, defect reporting, and defect recording protocol
  • Ability to prioritize and handle multiple projects simultaneously
  • Results-oriented self-starter in need of limited supervision
  • Education, Licenses, and Certifications
  • Bachelor’s degree in computer science or similar field, or equivalent industry experience required
  • Experience in Agile development practices preferred
  • Experience working with offshore project teams preferred
102

Senior Data Warehouse / ETL Developer Resume Examples & Samples

  • Expert in design/creation/management/business use of very large datasets
  • Prior expertise in Profiling, designing and modeling data
  • Providing data product solutions on multiple data platforms
  • Act as leader and provide suggestions and best practices for data delivery
  • Integrate multiple and complex data sources including transactional and non-transactional, structured and unstructured, etc
  • Database tuning and performance monitoring
  • Clustered or distributed computing a+
  • 10+ Years of Data Warehousing experience
  • 5+ Years of ETL
  • 4+ Years of Healthcare domain (Claims, Rx data)
  • 3+ Years of Oracle/PLSQL
  • 2+ Years of UNIX/Linux
  • Proficiency in Oracle SQL, RDBMS, ETL tools
  • Expertise in handling with complex data sources like XML, X12, HL7, flat files and CSV
  • Proficiency in database concepts and systems types including OLTP, Data Mart
  • Unix/Linux and Windows experience
  • Experience with ODI and OOP design principles
  • Experience with healthcare data (Claims, Rx, GPO, Covered Entities …etc)
  • Strong English verbal and written communication required
103

Data Warehouse Resume Examples & Samples

  • 3+ years of related work experience
  • Experience with Oracle PL/SQL
  • ETL development experience
  • Working knowledge of OBIEE
  • Working knowledge of Oracle Essbase
104

Obiee Data Warehouse Support Analyst Resume Examples & Samples

  • Collaborate with internal and external customers in Finance and Billing Operations as well as OBIEE/DW end users on day to day issues
  • Monitor production environments (OBIEE, DAC, and Informatica) to ensure system availability
  • Work on creating automated processes to improve operational efficiencies
  • Research and determine resolutions for incoming issues
  • Research reported data issues through the use of OBIEE Answers and SQL Developer
  • Determine and document root cause of issues through partnership with the development team
  • Tuning ETLs through Informatica for performance improvement and ability to modify ETLs to resolve production issues
  • 4+ years expertise in analysis and development which includes client needs analysis, installation, migration, integration and deployment of Oracle OBIEE, Informatica ETL, and Oracle DAC
  • Administered Oracle OBIEE, DAC and Informatica applications
  • Proven experience in enterprise-level business intelligence and data warehousing
  • Proven experience in implementing OBIEE metadata (RPD) design and development - including design and definition of logical tables, physical sources, dimensions, columns and Qualified List Items, Target Level’s ,Conforming Dimension etc
  • Proven experience with Informatica PowerCenter, ability to develop and enhance ETLs from various sources, developing Informatica Mappings, analyzing transaction errors, troubleshooting issues in the software, developing bug-fixes, and performance tuning efforts
  • Excellent troubleshooting skills
  • Ability to clearly understand and articulate complex problems
  • Good understanding of OBIEE 10g and 11g versions
  • Very strong interpersonal skills able to work at all levels of the organization
  • Strong PL/SQL, SQL skills
  • Strong UNIX, VI skills
  • Development background in java/j2ee (preferred)
  • Working functional knowledge with some combination of Siebel CRM, Finance, Call Center, and ERP OBIA applications is highly preferred
105

Data Warehouse & Business Intelligence Solution Specialist Resume Examples & Samples

  • Supporting the development of new applications or enhancements to existing applications
  • Designing solutions, estimating, and identifying requirements
  • Be a Single Point of Contact (SPOC) and triage Vendor Product Issues to Production Support Team
  • Tracking down and documenting vendor product infrastructure setup details, team support activities, etc
  • Be a Technical Analyst and SME for Enhancement and new development work categories. It includes -
  • Minimum ten (10) years of related experience
  • BS degree or equivalent required
  • At least 10-12 years of design and development experience in IT Industry
  • Solid knowledge of Oracle database technology at application and database levels
  • Solid experience in Oracle SQL, PL/SQL and SQL Loader
  • Hands-on Unix Skills and Experience – at least 5 plus years
  • Good skillset and experience using vi editor, writing Shell Scripts and Unix Commands
  • Strong experience in debugging and optimizing Oracle and Unix scripts and codes
  • Experience working Data Warehouse and Business Intelligence applications is a PLUS
  • Experienced in Data Integration/ETL toolsets (preferably Informatica) is a PLUS
  • Experience leading teams to deliver new projects and enhancements
  • Ability to design methodologies for full system and solution development life cycles
  • Extensive experience in estimating work efforts for complex project
  • Excellent client management skills
  • Excellent verbal and written communication, documentation, and project/task management skills
  • Good team player and comfortable working in a cross matrix team environments
  • Independent, out of the box thinker with ability to drive alternate solutions
  • Demonstrated ability to work in a fast paced and changing environment with short deadlines, interruptions, and multiple tasks/projects occurring simultaneously
  • Demonstrated ability to leverage and mentor others through technical team leadership
  • Scope, plan, prioritize, and manage multiple tasks and projects
  • Guides other team members on domain knowledge, processes, technical areas
106

SQL Server Data Warehouse DBA Resume Examples & Samples

  • Research, evaluate, identify alternative approaches, recommend, design and code efficient and effective solutions for challenging problems ranging from small to large work efforts for low to moderate complexity problems
  • Support development, QA, and production support teams in SDLC and operational activities
  • Identify opportunities in business processes, system capabilities and delivery methodologies for continuous improvement with an emphasis on DevOps
  • Provide guidance and direction to less-seasoned staff
  • Bachelor’s degree in a technical area of study; OR equivalent professional experience
  • 7+ years Professional IT/Business related experience
  • 4+ years SQL Server Database administration experience
  • 4+ years of SQL development experience (developing procedures, functions, SQL queries, etc.)
  • 4+ years of ETL development experience with SSIS highly preferred
  • 4+ years of experience troubleshooting within a Data Warehouse environment
  • Ability to work non-standard hours as necessary for deployment/load support
  • Experience with multiple programming languages (PowerShell scripting, C#, others)
  • Available locations: Eden Prairie, MN and Chicago, IL
  • Experience with continuous integration and delivery from a data warehouse and ETL perspective
  • Strong analytical and technical aptitude, able to think critically and objectively about process improvement, with emphasis on process automation and streamlining
  • Experience working with production operations teams
  • Knowledge of data warehouse design and development
107

Senior Data Warehouse Business Analyst Resume Examples & Samples

  • Create and interpret functional and technical specifications and design documents
  • Lead analysis projects to build and extend the capabilities and architecture of the Data Warehouse
  • Guide, train, instruct and assist team members to create and interpret business and technical specifications and designs
  • 3+ years of full Business and Systems Analysis experience
  • 3+ years of professional IT experience in a large, enterprise environment
  • Experience creating clear functional requirements documents, technical specifications and other technical documentation
  • Experience in a Business Intelligence environment
108

Senior Architect, Data Warehouse / ETL Resume Examples & Samples

  • The engineer will be the Extract-Transform-Load (ETL) master architect of scalable, well-performing, cohesive, and integrated ETL processes for the data warehouse, intermediate data stores, and data marts for source data acquisition, data hygiene, staging, transformations, loading, error handling, updating, change control, integration, and data transmission to partner organizations
  • Five to seven years leading data warehousing design and development as an ETL Lead, ETL Architect, Senior DW developer, DW consultant, or similar role required
  • Provides direction for diverse and complex initiatives and is accountable for a variety of tasks to architect and deliver data warehousing solutions that exceed customer expectations in content, usability, accuracy, reliability and performance while assuming a leading role within agile teams (both on-shore and off-shore)
  • Interprets business strategy and develops organizational objectives to align with this strategy. Typically manages multiple teams of professionals
  • Development of End to End ETL architecture within the Oracle, Teradata, NoSQL and Hadoop Environments
  • Solid Experience with SQL & BTEQ Scripting: Strong data management and data analysis and performance tuning required
  • Preferred experience with Hive, Pig, Flume, Sqoop, Kafka, and Storm
  • Strong skills in data warehousing process design and development using the Informatica data warehousing tool suite required. (PowerCenter, IDQ)
  • Conscientious of Enterprise Data Warehouse Release management process; Conduct Operations readiness and environment compatibility review of any changes prior to deployment with strong sensitivity around Impact and SLA
  • Experience with data modeling tools a plus
  • Expert in data warehousing methodologies and best practices required
  • Strong verbal and written communication skills required
  • Ability to initiate and follow through on complex projects of both short and long term duration required
  • Excellent analytical and problem solving skills required
  • Works independently, assumes responsibility for job development and training, researches and resolves questions and problems, requests supervisor input and keeps supervisor informed required
  • Develop strong team relationships with Tier 1, Tier 2, and Tier 3 support team for problem resolution and root cause
  • Proactive recommendation for improving the performance and operability of the data warehouse and reporting environment
  • Participate on interdepartmental teams to support organizational goals
  • Punctual, regular, and consistent attendance
  • Advanced Degree in technical discipline preferred or equivalent work experience
  • Generally requires 7-11 years related experience
  • Strong preference End to End System Data Warehouse and ETL Architecture with a minimum 5 years' experience within Oracle and Hadoop Ecosystems
  • End to End System Data Warehouse and ETL Architecture
  • Requires understanding of complete SDLC and Experience with continuous integration, test-driven/behavior-driven development, and agile development methodologies
  • Development of End to End ETL architecture using Linux, Informatica, Teradata, SQL, BTEQ, Hadoop Hive, Pig, Flume, Sqoop, and UC4
  • Experience facilitating user sessions and gathering requirements
  • Experience designing logical and physical architectures for data warehousing solutions
  • Experience working in an Agile development methodology in a data warehouse environment
  • Manage and Co-ordinate 1-5 team resources, Matrix resources and off-shore management
  • Experience with mange service and on-shore and off-shore development experience is must
  • Pentaho experience is strongly preferred
  • Telecommunications experience Knowledge of Telecommunication/Cable billing, customer care systems e.g. DST, CSG and AMDOC etc
  • Two plus years of Java programming, SOA, and software architecture
  • Knowledge of Java virtual machines (JVM) and multithreaded processing
  • Knowledge of NoSQL/AWS/Cloudera platforms
  • Hadoop Developer Certified
109

Data Warehouse ETL Solution Design Analyst Resume Examples & Samples

  • Enhance application based on prioritized change requests by interfacing with Business and IT teams to understand business requirements and translate business requirements into formal technical specification and application code
  • Create ETL designs and technical specifications for the Ford Credit EDW which utilize multiple platform components including Teradata, Oracle, MS SQL Server, DB2, Mainframe, Cobol, and Data stage
  • Develop and execute unit test and integration plans/scripts to validate that application changes meet technical specifications
  • Interact closely with Data and Reporting Solution Design teams, Report Development teams, and the Application Domain Portfolio Architect to design and deliver ETL Solutions
  • Create SQL custom views for Reporting, Security, and Regional access
  • Pro-actively guide and support IT and Business in gathering detailed business requirements
  • Follow iterative system development life cycle methodologies (e.g. Enterprise Project Management (EPM) and USDM/Agile)
  • Ensure that appropriate security and controls are instituted and maintained
  • Institute and maintain Ford/Ford Credit tools and best practices
  • Work with vendors and Ford Enterprise Engineering to recommend and implement upgrades and training
  • Keep management informed of product advancements and their impact to the business
  • Participate in technical reviews at appropriate stages of development
  • Work with business team to complete user acceptance testing and participate in integration testing and launch changes into Production
  • Assume responsibility for enhancing MIS (Management Information Systems) Solutions Design Framework
  • Collaborate with current MIS team members to improve the process and data flow documentation of the Interaction between the various source applications and the EDW/GDW
110

Data Warehouse Ops Engineer Resume Examples & Samples

  • Exposure to Windows, Informatica and/or Cisco TIDAL Scheduler
  • General knowledge of change management tools and practices / SOP
  • Batch tuning and parallel processing
  • Disaster Recovery experience
  • DWH concepts
  • Financial product knowledge
  • BS in computer science preferred
  • 5+ year’s extensive IT experience
  • 3+ year’s data warehouse development (ETL) experience
111

Senior Professional Data Warehouse Resume Examples & Samples

  • Software engineering enhancements to the OBIEE reporting solution for adaptive and perfective maintenance, as funded by the Customer
  • Software engineering resolutions through corrective and preventive maintenance, as directed by the Technical Team Lead in response to live service incidents
  • For all types of software engineering change
  • 8-10 years minimum on OBIEE (and previous product incarnations), including Informatica, DAC, Database, RPD and Webcat. Must have a solid engineering background in both change and service delivery support and any supplementary software engineering experience beyond the minimum OBIEE requirement would be advantageous. Defence industry experience would be very beneficial
112

Azure Cloud Data Warehouse / Lake Architect Resume Examples & Samples

  • Bachelor's degree preferable in computer science, software engineering
  • 6+ years of distributed software development experience
  • 2+ years Microsoft Azure PaaS experience
  • Experience in OLAP (SSAS) and OLTP systems, business intelligence and analytics deployments
  • Experience with Microsoft Azure big data services technologies including Azure Data Lake, Azure Data Factory, Azure HDInsight and/or Azure Stream
  • Experience in hot and cold data storage strategies
  • Experience in enterprise solutions delivering availability, reliability and scalability
  • Experience in complex fleet management IoT solutions
  • Experience in business case development, business process mapping and strategic planning
  • Experienced as a Solution Architect (architecture modeling, building block design, applications and role design and systems integration) and experienced in leading requirement discussions and roadmap creation
  • Experience in managing business change, project management methods and tools, etc
  • Fluent in continuous delivery, continuous integration and A/B testing
  • Scientific computing experience (e.g. R, Matlab, Python, machine learning)
  • Demonstrated strong problem solving and technical skills
  • Demonstrated strong communication skills articulating complex topics to non-technical audiences
  • Proven Leadership, Team working, Inter-personal and Influential skills beyond the span of control
113

Data Warehouse Data Modeler / ETL Developer Resume Examples & Samples

  • 2+ years of experience with Data Warehouse
  • Experience as a database administrator
  • Knowledge of the Agile software development process
  • Possession of excellent analytical and time management skills
  • BS degree in IT, CS, Computer Engineering, or Systems Engineering preferred
  • Professional Certifications related to Database Administration, ETL, or Business Intelligence preferred
114

Contract Data Warehouse Implementation Lead Resume Examples & Samples

  • Bachelor’s degree in business, finance or accounting or equivalent experience. Master’s degree desirable
  • Financial services or technology experience of 5+ years preferable. Strong analytical and investigative skills
  • Prior experience in reporting (management, Basel or regulatory), data mining and analysis, or systems implementation highly desirable
  • Prior technical experience with using ACL, SQL Server, or other analytical tools
  • Prior experience with ERP/GL/Reporting systems needed
  • High proficiency in Excel and Access, including working knowledge of formulas, links, and pivot tables
  • Excellent interpersonal and communications skills (both written and verbal)
  • Good organizational and multi-tasking skills, able to prioritize in a fast-paced, dynamic environment
  • Flexible, adaptable, responsive, positive, Results driven
  • Pursues continuous process and self-improvement opportunities
115

Data Warehouse & Transformation Specialist Resume Examples & Samples

  • Project Managers – Business focused
  • Project Managers – IT focused (i.e. IT Development Managers)
  • Business Analysts
  • Testers
  • IT Business Analysts
  • IT Developers
  • Production Support
  • Service Management
  • Support of Data Deliveries environment which involves a number of different data feeds and back end interfaces
  • Working with the Project Development Team to raise bugs and enhancements
  • Liaise with other team members and business members to ensure that all issues are resolved in an effective manner
  • Identify problems, propose solutions and achieve agreement with the relevant users
  • STP product knowledge spread throughout the Support Team
  • Adherence to documented procedural standards
  • Escalate issues which cannot be resolved by the Analyst
  • Adherence and contribution to change management
  • Use business and application knowledge to investigate issues raised and assist in the production of Incident reports to external 3rd Party Software suppliers
  • Liaise with Project Development areas to ensure that all support documentation is created and that new functionality is handed over in an efficient way
  • Able to work both alone and as part of a team
  • Experience working in a rapidly changing environment
  • Ability to meet tight deadlines
  • Ability to identify problems, propose solutions and achieve agreement with the relevant users
  • Ability to provide remote support in an on call capacity
  • Self-motivation and effective time-management are a pre-requisite
  • Support orientated and client focused
  • Good communication skills, both written and verbal
  • In-depth knowledge and proficient in writing complex SQL queries, stored procedures, creating Indexes, Functions, Database triggers and Sub queries within the following databases
  • Professional qualification in Microsoft SQL
  • Microsoft Professional
  • Professional qualification or equivalent experience in data warehousing
  • ITIL Qualifications in Service Delivery & Support
  • LI-GB1
116

Data Warehouse Tester Resume Examples & Samples

  • Work concurrently on several projects, each with specific instructions that may differ from project to project
  • Create and maintain test cases in Quality Center and / or Test Director
  • Actively participate in walk-through, inspection, review and user group meetings for quality assurance
  • Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and / or functionality within Information Technology software
  • Comply with standards and strategies of the software development life cycle
  • Bachelor’s Degree or equivalent work experience
  • 10+ years of Quality Assurance / Testing experience
  • 8+ years of experience with Quality Assurance testing tools
  • 5+ years of experience leading testing teams
  • 4+ years of experience testing data warehouse systems
  • Proficiency in MS Office (Word, Excel, Outlook, PowerPoint, Access)
  • Proficiency with MS Visio
  • Healthcare Industry experience
  • Understanding of all phases of the Software Development Life Cycle
117

Data Warehouse QA Resume Examples & Samples

  • Perform system and data analysis
  • Responsible for primary development and execution of testing strategies
  • Create test plans, scripts and document all phases of testing
  • Identify, document and resolve data quality/data integrity issues
  • Develop and or test ETL mappings, workflows/sessions and other DW jobs
  • Coordinate work efforts with internal and external team members
  • Respond to business data issues and resolves them
  • Contributes to new concepts, techniques and standards
  • Ensures adherence to locally defined standards for all developed components
  • Assists developers, administrators and architects in all development and testing efforts
118

Developer, Data Warehouse Resume Examples & Samples

  • Successful background as an architect and/or technical lead on an Enterprise Data Warehouse or Enterprise Information Management team
  • Full life cycle experience creating, maintaining and enhancing physical database structures
  • Deep understanding of relational theory
  • Extensive experience working with relational or OLAP database: Oracle, SQL Server, DB2, Teradata, Netezza
  • Extensive knowledge of Relational Database Design, Dimensional Database Design, Semantic Web Design, and Cloud data storage and analytics
  • Strong Data Modeling and data analysis skills (Erwin, ER Studio, UML, PowerDesigner, etc.). · Ability to apply modeling standards to logical and physical ERDs
  • Experience with data modeling concepts (conceptual/logical/physical/semantic, multi-dimensional models (star, snowflake), normalized/denormalized models)
  • Extensive knowledge of ETL and Data integration techniques; SSIS and Alteryx preferred
  • Strong experience with Microsoft products (SSIS, SSRS, OLAP, OLTP and SQL Server)
  • Work independently and with Business Analysts and SMEs to gather, document and explain requirements
  • Bachelor’s degree in computer science, engineering or management information systems
  • 3+ years of experience as a Data Architect
  • 7+ years of DBA experience managing enterprise-level database environments
  • 7+ years of DBA experience with SQL Server and / or Hadoop (or acceptable similar database management systems)
  • 7+ years of DBA experience with managing data warehouses, data marts, cubes and big data
  • 5+ years of experience with implementing data models to support Business Intelligence and Data Warehousing projects
  • Additional technical certifications are a plus
  • Must be able to work in sitting position, use computer and answer telephone
  • Office Work Environment
119

Data Warehouse Data Modeler Resume Examples & Samples

  • Experience with ETL
  • Experience with SQL
  • Experience with Informatica
120

Data Warehouse & Analytics PM / Senior BA Resume Examples & Samples

  • Experience managing complex projects or programs and delivering successfully
  • Experience working with a distributed team of developers, including off-shore contractors
  • Previous demonstrable experience of working on a Analytics projects in a business transformation or improvement environment would be beneficial
  • An excellent collaborative manager, able to take on aboard wide perspectives and influence positively and act as a critical friend
  • Demonstrated ability to drive project success and business outcomes leveraging analytics
121

Data Warehouse System Analyst Resume Examples & Samples

  • Bachelor's or Masters Degree in Computer Science and Engineering, Computer Science or equivalent experience
  • Responsible for the design and development of IT solutions based on business requirements documents
  • Demonstrated experience working within a team environment
  • Minimum of 5+ years of IT work experience focused in software design with emphasis on RUP and UML. Experience with one or more of the following ETL, COBOL, CICS, DB2, MQ, Java / J2EE, Websphere, XML, SOAP, Web Services SOAP/HTTP
  • Advanced RDBMS Database experience (one or more of the following: DB2, Oracle, SQL/Server or comparable) including database modeling, SQL query, and procedural programming
122

Data Warehouse Modeller Resume Examples & Samples

  • Translate business and data requirements into conceptual, logical and physical data models
  • Identify data pattern in the source, structured and semi structured data, and transform into dimensional modelling requirements, to populate the DWH and data marts
  • Develop and maintain DWH packages of turnkey standard model and ETL definitions, for deployment at our clients across the globe
  • Perform system, unit and performance testing of new and existing developments, to ensure accurate and efficient operation that meet the business needs of the users
  • A strong background and experience in dimensional data modelling (Kimball approach) for DWH and business analytics contexts
  • Proven track record of best practise architecture, design, build and support of DWH and data marts, data models and ETL, which are robust and scalable
  • Well-developed business understanding and requirements, analysis skills, including good communication abilities and stakeholder management
  • Master's degree in engineering, computer science or other relevant background
  • Strong SQL proficiency is required
123

Data Warehouse Administrator Resume Examples & Samples

  • Administration of Informatica(EDW), Business Objects and Business Intelligence
  • Manage and optimize all Business Objects services
  • Monitor reports, users, resources and tune as needed
  • Create and enforce report developer best practices
  • Dev, QA and Stage environment support of Data Warehouse infrastructure
  • Support upgrades
  • Support of authentication requirements
  • Help to enhance and debug reports/code as necessary
  • Provides guidance and mentoring to co-workers on use of reporting tools and techniques
  • Run a regularly scheduled User Group meeting
  • Possess strong customer focus, along with effective written and oral communication skills
  • BS/MS in Computer Science or other technology discipline
  • Relevant work experience as typically acquired 4 to 6 years
  • Experience with Informatica(EDW), Business objects and Business Intelligence
  • Data modeling tools and EDW design concepts
  • Database design and tuning
  • Database back-up and recovery strategies
  • Data extraction and manipulation experience
  • Expertise with export, transform and load tools preferred
  • Strong working knowledge of data modeling tools
  • Understanding of Data Warehouse concepts (Kimball)
  • Advanced MS SQL server skills preferred
  • Strong written, verbal and presentation skills
  • Strong analytical and troubleshooting skills
  • Good organizational, prioritization and time management skills
  • Strong interpersonal skills with vendors, co-workers and users
124

Data Warehouse Application Lead-VP Resume Examples & Samples

  • Bachelor's degree in a technical or quantitative field with preferred focus on Information Systems
  • Demonstrated ability to understand and work effectively within complex IT environments containing follow-the-sun resource model, multiple development and testing environments, sharing of environment with multiple teams, load balancing and disaster recovery setup
  • Ability to develop, communicate, and govern best practices and coding standards ensuring adherence to sound data warehouse principles
  • Understanding and experience with the Agile projects
  • Extensive experience with SQL Server database environments leveraging databases, tables/views, stored procedures, agent jobs, etc
  • Demonstrated experience with multiple ETL tools (SSIS, Pentaho, Ab Initio, Informatica)
125

Director, Data Warehouse Operations Resume Examples & Samples

  • Leads strategy around the planning, analysis, and design of warehouse operations aligned with the overall informatics strategy to build out FEP’s and BCBSA’s assets across BCBSA and the Blues system. Maintains alignment of technology solutions with established enterprise architecture standards and the needs of the business customers
  • Collaborates with Enterprise IT peers to engage a development team that balances internal skills and the required levels of staff augmentation, consulting, and development center resources. Collaborates with business consultants, project teams, and business leaders to ensure business customer needs are met
  • Partners with FEP business customers and technical partners to understand business needs, build relationships and manage business customer satisfaction and leverage technical partner capabilities
  • Collaborates with development teams to guide the implementation of project production support for FEP and BCBSA assets. Interfaces with business partners and development teams from the inception of the project assisting with finalizing the production support strategy
  • Responsible for the leadership and technical direction to project managers to ensure consistency and successful delivery of multiple, simultaneous projects within the portfolio
  • Manages financial tracking and budgeting, procurement and vendor management related to project management activities for solutions providers, staff augmentation firms, and software providers to ensure compliance with budget and contract spending limitations, federal and Association procurement and ethics requirements, and timely and accurate payments and accruals
  • Bachelor’s degree in computer science, business administration or related IT or management discipline, or equivalent experience
  • Minimum 10 years progressive experience working in IT- related environment
  • Experience with informatics technologies of ETL, BI, metadata management, database management systems (DBMS), data cleansing and data profiling tools and data warehousing hardware
  • Minimum 5 years of supervisory experience
  • Leadership abilities to work between technology and business, building strong and enthusiastic relationships to achieve desired outcomes
  • Demonstrated leadership skills in the information aggregation and analytics arena
  • Exceptional project management skills for the effective deployment of resources and achievement of multiple projects in a cross-functional environment
  • Excellent oral and written communication skills with the ability to negotiate, persuade, and make effective presentations to varying audiences internal and external to BCBSA
  • A high level of confidence, integrity, and critical thinking skills, establishing credibility and decisiveness while balancing varying business considerations/priorities
  • Professional presence for interacting with and influencing key leadership and decision-makers within FEP, the BCBS system, as well as with external stakeholders
  • Excellent interpersonal skills for building and fostering key relationships
  • Demonstrated experience in the planning and delegating of multiple high-impact, large-scale complex projects
  • Demonstrated experience with vendor management
126

Data Warehouse Senior Business Analyst Resume Examples & Samples

  • Experience driving project implementations right from defining scope, requirements, till delivery
  • Ability to manage project timelines and be the client facing point of contact
  • Gather requirements from multiple stakeholders; identify and understand business needs; write Business Requirements documents and other business artifacts
  • Serve as a liaison between business and IT to ensure the complex business requirements are accurately translated into simple technical specifications
  • Develop reports on analysis, provide recommendations and makes formal presentations to communicate results to various management levels
  • Write user stories; facilitate meetings; work with system architects and developers; use agile development method; participate in sprint planning
  • Review the work of others
  • Develop innovative approaches
  • Serve as a leader / mentor
  • Excellent communication (written and oral), time / project management, problem solving, organizational, and analytical skills
  • Communicate proposed technical solutions to business / stake holders
  • Support all phases of the software development lifecycle (SDLC)
  • Support Data Analysis and Metadata Management / Coordination
  • Support project coordination, tracking project activities, and reporting status
  • Process improvement, workflow, benchmarking and / or evaluation of business processes
  • 8+ Years Project Lead / Business Analyst (BA) experience
  • 3+ years of BA experience in a governmental or quasi-governmental agency and / or Medicaid / Medicare / Healthcare environment
  • 3+ years of experience with development of test data and test scenarios
  • 5+ years of experience on project / team coordination, leading meetings, and reporting
  • 3+ years of experience in metadata management
  • BA experience in a Data Warehouse project environment that include Teradata, SQL Assistant, Data Cleansing, Informatica, Business Objects OR similar environment
  • Experience with JAD and Agile methodologies or SDLC and proven ability to facilitate project requirements gathering meetings / sessions, analyze, develop detailed specifications for reporting, and requirements traceability
  • Recognize, gather, correlate, attention to details, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations
  • Ability to design applications taking into consideration data reconciliation (to the source system) query / reporting performance, and analytical business value
  • Experience supporting project management activities
  • Excellent organizational, presentational skills, written and verbal communication skills with evidence of successfully working with a wide audience including technical and non-technical parties, end users, senior management and private sector vendors
  • Intermediate level of proficiency with PC based software programs and automated database management systems (Word, Excel, Access, PowerPoint)
127

Business Analyst, / Data Warehouse Resume Examples & Samples

  • Reporting Specification Design,
  • Planning, Testing and Maintenance of Data Warehouse reporting activities / database integration activities
  • Conduct work sessions with various business departments to determine needs
  • Document BRDs and Functional Specs
  • Liaise with internal users, department Managers / Bank Managers to facilitate Project Plans
  • Liaison with in-house development team to design & build solutions
  • Document QA test plans and execute test cases
  • Work with users to document UAT test plans
  • Manage UAT testing. Track defects, enhancements & questions
  • Archiving of all project documentation into companywide repository
  • Participate in general PM/BA work including production support and BAU enhancements of in-house developed business applications
  • 5+ years industry experience, preferably in Derivatives and/or Securities settings
  • Bank Rates/FX Derivatives and Securities Dealing Group
  • Advanced SQL Query knowledge
  • Strong database / reporting skills / data analyses / data validation work
  • Fluent in converting user requirements into usable technical specifications for Development
  • Experienced in UAT environment for large-scale database / reporting / extract projects
  • Experience in all facets of standard software development life cycle
  • Strong communication / presentation skills (written and oral) in cross-cultural business environment
  • Experience in creating complex diagrams and flow charts
  • Conversant in financial instruments/risk terminology is a plus
  • Strong Business Analysis skills
  • Able to manage a project end to end
  • Understanding of generic report writers and the extraction of data from database tables
  • Good documentation skills. Able to write BRDs, Functional Specs and TestPlans
  • Strong verbal and written communication skills. Ability to communicate effectively and confidently with users, team members and management. Effectively utilize diagrams and flow charts
  • Strong analytical, strategic thinking and problem solving skills, including a thorough understanding of how to interpret business needs and translate them into application and operational requirements
  • Hands-on experience with manual or automated testing environments
  • Strong work ethic with focus on meeting deadlines and objectives
  • Strong skills working with MS Excel, MS Project, MS Word, MS Power Point, & SharePoint
128

Rohq-cto-genesis Data Warehouse Senior Analyst Resume Examples & Samples

  • Handle and manage a sustainable process related to the onboarding, review and clean-up of data bridge subscriptions. This will include conducting reviews with Tier 1 and 2 clients and regular coordination with the Consumption teams
  • Implement and execute operational procedures, ensuring that key controls and regular review schedules are in place
  • Implement key change management processes to better handle various system and non-system based changes
  • Lead and collaFocus on completing various UAT initiatives and change requests, review pending requirements, prepare test scripts, coordinate execution and operationalize new processes/controls
  • Lead implementation and parallel related activities globally, with focus on activities identified to be critical and/or will impact the operational activities and deliverables of the team, which will include but is not limited to data bridge subscriptions. This will also include representing the team in data consumption design/implementation discussions
  • Support ad hoc senior management identified reporting packages, analysis, and/or initiatives in relation to the overall GENESIS program
  • Escalation point for issues encountered in the onboarding, delivery and performance of subscriptions support function
  • Monitor and manage execution through defined KPIs, metrics
  • Coordination of activities between the regional teams, to ensure fluidity in carrying out tasks
  • With Finance, Business or Management Information Systems related Bachelor’s degree, or equivalent experience
  • 5 years or more Financial and/or regulatory reporting experience from either Finance or Operations standpoint preferred
  • Database and/or warehouse related skills (e.g. SQL) is an advantage
  • Superior communication skills, given exposure/interaction with senior business leads
  • Possess strong team building, planning and work skills, driven by process improvement
129

Data Warehouse Administrator Resume Examples & Samples

  • Live the leadership Framework
  • Continuous improvement
  • Confront, (escalate) and fix problems
  • Communicate to our staff and customers
  • Create the Future
  • Stop creating legacy commitments
  • Make and keep good ones
  • 10+ years of relevant work experience, including experience with database administration and delivery
  • 5+ years of relevant work experience dealing specifically with data warehousing technologies
  • Mastery of advanced SQL to include joining, grouping, and data quality assurance
  • Demonstrated ability to apply statistical or data mining techniques to solve real problems
  • Demonstrated ability to constantly learn outside of a classroom environment, and successfully apply learnings
  • Demonstrated self-motivator
  • Experience using technology to work efficiently with datasets such as MATLAB, Python, or R
  • Ability to draw conclusions from data and recommend actions
  • Ability to succeed in a fast-paced environment, deliver high quality performance on multiple, simultaneous strategic, value-added tasks and priorities
  • Relentless drive, determination, and self-learning ability
  • Highly organized and attentive to detail
  • Demonstrated willingness to both teach others and learn new techniques
130

Data Warehouse / ETL Developer Resume Examples & Samples

  • Develop and maintain ETL jobs for data warehouses/marts
  • Design ETL via source-to-target mapping and design documents that consider security, performance tuning and best practices
  • Test ETL and other technical components and support QA
  • Document technical specifications, data models, process flows, etc
  • Collaborate with delivery and technical team members on design and development
  • Collaborate with business partners to understand business processes, underlying data and reporting needs
  • Conduct data analysis in support of ETL development and other activities
  • Assist with data architecture and data modeling
  • Bachelor’s degree in Computer Science or related field OR equivalent professional experience
  • 5+ years of experience with industry-standard ETL tools
  • 5+ years of experience with data warehouses/marts supporting BI/reporting
  • 5+ years of experience writing complex SQL queries
  • 5+ years of business/data analysis experience
  • Experience with SSIS
  • Healthcare experience
  • Strong soft skills (e.g., communication, interpersonal, collaborative, resilient)
  • Data architecture and data modeling experience
  • Solution architecture experience
  • BI/reporting familiarity (e.g., Tableau, SSRS, SAS)
  • Agile experience
  • QA familiarity
131

Data Warehouse Solution Specialist Resume Examples & Samples

  • Strong technical competencies using SQL/SSAS/ SAS/Cognos/Datastage
  • SSIS Data warehouse design, including build, migration and ETL Configure ETL processes, data mappings & transformations to orchestrate data integrations
  • Use and support database applications and tools for extraction, transformation and analysis of raw data
  • Ability to understand business processes, data entities, data producers, and data dependencies
  • Develop, manage, and validate existing data models including logical and physical models of the data warehouse and source systems
  • Designing and developing exception handling and data cleansing / standardization procedures
  • Evaluate and improve data quality throughout source systems by implementing data quality safeguards
  • Participate in discussions with business users and source system owners to derive business and data rules to be used in data quality assessments
  • Determine the quality and integrity of data required to meet business needs of the end users and work towards resolving the most critical data quality issues
  • Understanding of corporate systems, data environments and reporting tools
  • Primary upward interaction is with direct supervisor. May interact with peers and/or management levels at a client and/or within Accenture
  • Determines methods and procedures on new assignments with guidance. Decisions often impact the team in which they reside. Manages small teams and/or work efforts (if in an individual contributor role) at a client or within Accenture
  • Ability to meet travel requirements
  • Ability to communicate design solutions to both technical and non-technical audiences
  • Bachelor's degree, or equivalent experience
  • Strong analytical and documentation skills
  • 3 + years of experience in data analysis and problem solving with large amounts of data
  • Experience in data architecture, data warehousing, master data management, enterprise information integration and ETL
  • Experience with data analysis, modeling and design specific to a data warehouse
  • Experience with the design of large scale ETL solutions integrating multiple source systems
  • Experience with Business Objects, one or more best of breed BI tools is a plus
  • Proven success in contributing to a team-oriented environment Proven ability to work creatively and analytically in a problem-solving environment Desire to work in an information systems environment Excellent leadership, communication (written and oral) and interpersonal skills
132

Data Warehouse Resume Examples & Samples

  • Participate in workshops with client’s stakeholders in order to validate business requirements & functional specifications
  • Apply modelling skills to design, develop and maintain physical and logical DWH models
  • Leverage data analysis skills to analyze business areas, understand source systems’ data and map them to DWH data model
  • Work closely with subject matter experts & technical team, to ensure the design meets the business requirements
  • Design, build & test, ETL processes (using SQL Server Integration Services packages) to move and transform data based on defined data architectures Participate in the definition of best practices, standards and optimization techniques to enhance the DWH/BI solution
  • Bachelor degree in computer science, information systems, or other quantitative field
  • Master’s degree in computer science or Business Administration (MBA) will be considered as a plus
  • Knowledge of data warehousing concepts (ETL, Staging/Target Area, OLAP, Dimensional Modelling, Data Marts etc.)
  • Strong data modelling skills
  • Solid understanding of data acquisition, cleansing, and integrations processes
  • Previous working experience of 1 to 3 years in DWH/BI projects preferably in the Banking industry
  • Functional knowledge of banking products (lending, deposits, investments) will be considered as a plus
  • Proven experience with at least one commercial DWH/BI stack, preferably Microsoft (Integration Services - SSIS, Analysis Services - SSAS, Reporting Services - SSRS)
  • Expertise in SQL
  • Eagerness to contribute in a team-oriented environment
  • Advanced analytical abilities & problem-solving skills
  • Ability to meet deadlines with high attention to detail
  • Ability to meet travel requirements, when applicable
133

BCU Senior Data Warehouse Dev Resume Examples & Samples

  • Great communication skills both written and oral
  • Collaborate heavily with business analysts, business owners, members of the BI team and DBA to ensure the creation of production-quality designs and implementations
  • Manage multiple tasks and changing business requirements
  • Enforce standards, design styles and best practices
  • Perform full Data Warehouse life-cycle systems development
  • Design BI ETL strategies and solutions using MS SQL Server SSIS
  • Strong experience and understanding of MS SQL Server SSRS/SSAS
  • Create and manage database objects including tables, indexes, procedures, cubes, etc
  • Create MDX and SQL scripts as required for use in MS SQL Server
  • Migrate, maintain and enhance ETL processes
  • Analyze source data of different types and design programs for data integration, cleansing and transformations
  • Develop BI dashboards using Microsoft Excel
  • Ability to thrive in a fast-paced environment with multiple ongoing projects concurrently
  • Requires four-year college degree in computer science or similar concentration or business management with a focus in technology
  • Strong written, verbal, team and customer service skills
  • 5+ years experience developing BI ETL solutions
  • 4+ years experience with MS SQL Server (2008 R2/2012/2014) applications including analysis, design, development, configuration, customization, validation and deployment
  • Strong experience with Kimball Dimensional Modeling
  • Strong MDX skills
  • Strong SQL tuning skills
  • Strong analytical, data validation and problem solving skills
  • Strong knowledge of Data Warehousing and Business Intelligence reporting tools
  • Experience with the following Microsoft software are a plus: MS SQL Server Master Data Services, Data Quality Services, and Data Mining tools are a plus
  • Knowledge of Symitar’s Episys software solutions a plus
  • General knowledge of the financial industry and specific knowledge of the credit union industry
  • Sense of urgency with strong follow-up skills
134

QA Lead-data Warehouse Resume Examples & Samples

  • Ability to write test cases and execute testing within a web service environment
  • Create and maintain test cases in Quality Center, Test Director, or other repository
  • Plan test strategies in accordance with project scope and develop schedules to meet delivery dates
  • Develop testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or defect retests, or usability
  • Develop process for Data Analysis and testing Data flow
  • Document and report defects to Project teams
  • Identify, analyze, and document problems with functionality, output files or tables
  • 4+ years of Quality Assurance/Software Testing experience
  • 3+ years of testing experience with BOTH Data Warehouse and ETL applications
  • 2+ years of experience as a QA team lead in an onshore/offshore model environment
  • Minimum of 3 years of relational database experience (ie, Oracle, SQL Server, Teradata, DB2, etc.)
  • Experience working with databases or data warehouses consisting of at least 20 tables
  • Bachelor’s degree or equivalent professional experience
  • Outstanding verbal and written communication skills
  • Experience validating data utilizing SAS
  • Experience with UNIX
  • Service Oriented Architecture (SOA) experience
135

Oracle Data Warehouse Database Administrator Resume Examples & Samples

  • Implements, monitors, secures and supports Oracle and MS SQL relational, OLTP, OLAP, and star schema databases and other database systems
  • May perform patch application on database servers
  • Adheres to standards for user account, group, and database security and configuration for all production databases and for non-production databases that may contain PHI or other sensitive data protected under HIPAA, Sarbanes Oxley, or other state or federal regulatory requirements
  • Implements, and monitors archive and other essential log file configuration, operation, and location
  • Implements, and monitors backup of critical database files to tape or other approved media, and other database protection or high availability solutions such as replication, mirroring, shadowing, or RAC
  • Monitors performance issues on all production and non-production databases (as applicable) implementing performance monitoring and trending on all production and applicable non-production databases with tools such as Stats Pack, Enterprise Manager, and appropriate third party OS and Oracle or MS SQL performance monitoring tools
  • Provides monthly reports to management on performance on production databases including any performance exceptions and all requested performance data in a summarized, easy-to-read format
  • Implements performance enhancing hardware, OS, or database configuration changes to improve performance using performance data collected to verify performance improvements
  • Implements standard, secure, high-performance configurations for all Oracle and MS SQL database installs
  • Additional duties as needed
  • Provides project management and leadership for database and database systems projects
  • Transfers knowledge to other IT staff
  • Experience creating and maintaining tables
  • Experience using oracle platform for providing data-oriented solutions
  • Knowledge of Oracle gateway product to support web portals
  • Required A Bachelor's Degree in a related field
  • Required or equivalent work experience equivalent experience includes and an additional 3 years of IT experience
  • Required 2+ years of experience in Database Administration
  • Preferred Other Only 1 year of Database administration experience required for candidates that have a Masters degree in a related field
  • Intermediate Demonstrated interpersonal/verbal communication skills
  • Intermediate Demonstrated written communication skills
  • Intermediate Ability to multi-task
  • Ability to analyze and interpret financial data in order to coordinate the preparation of financial records
  • Intermediate Ability to work in a matrixed environment
  • Advanced Ability to work as part of a team
  • Intermediate Other Must be able to understand and follow verbal instructions and written polices and procedures to ensure adherence to standards and to instructions from management
  • Intermediate Other Must be able to document and diagram solutions using standard formats. Documentation must be grammatically correct, factually accurate, and appropriate to the target audience
  • Intermediate Ability to work independently
  • Intermediate Demonstrated analytical skills
  • Intermediate Ability to work in a fast paced environment with changing priorities
  • Preferred Other Professional database certifications are preferred
  • Required Intermediate Other Intermediate experience in at least 1 database technology as demonstrated by 2 years of DBA experience and approved training courses
  • Preferred Intermediate Oracle Database Management System (DBMS)
  • Required Intermediate Microsoft Excel
  • Required Intermediate Microsoft Word
  • Required Intermediate Microsoft PowerPoint
  • Required Intermediate Microsoft Access
  • Required Intermediate Microsoft Outlook
  • Preferred Beginner Microsoft Visio
  • Preferred Beginner Microsoft Project
  • Preferred Intermediate MS SQL
  • Required Intermediate Other Must be able to type at least 25 words a minute for data and configuration entry
  • Required Beginner Other Must be able to communicate effectively verbally and in writing with non-technical staff and end-users for requirements gathering, testing, training, and outcome validation
  • Required Beginner Other Must be able to communicate technical solutions to management for review and approval both verbally and in writing
  • Required Intermediate Other Must have a good understanding of Oracle database security
136

Data Warehouse Resume Examples & Samples

  • 3+ years’ experience with Data Warehousing and Business Intelligence
  • 3+ years’ experience with Business Objects AND Crystal Report development
  • 3+ years’ experience using SQL Server 2008, 2012, Visual Studio, Business
137

Senior Data Warehouse / Analytics Developer Resume Examples & Samples

  • Architect/Design Data Warehouse infrastructure and solutions
  • Develop, enhance, integrate Data Warehouses/Data Marts and Business Intelligence Solutions
  • Lead projects to build and extend the capabilities and architecture of the Oracle-based Data Warehouse
  • Build new ETL (extract, transform and load) processes and maintain existing ETL tools using Oracle PL/SQL and UNIX technology
  • Monitor Oracle/UNIX data warehouse ETL batch processing on daily and weekly basis
  • Create complex data extracts from the Data Warehouse
  • Guide, train, instruct and assist team members with technical issues and designs
  • Understand the business and how various data elements and subject areas are utilized
  • 3+ years of Data warehouse development and design
  • Experience with Unix Shell Scripting
  • Experience with SQL development
  • Strong Data Analysis skills
  • 3+ years PL/SQL
  • Experience with ETL tools such as DataStage, Talend, or Informatica
138

Netezza Data Warehouse Senior DBA Resume Examples & Samples

  • Data repairs
  • New retailer rollouts
  • Database backup and purge
  • Database connectivity and security
  • Retailer file management
  • Disk space management
  • Manual task automation
  • Data issue resolution
  • Data mart replication/synchronization
  • Develop, test, and monitor batch jobs in support of tasks above
  • 7x24 On call Rotation for Production Support of Big Data environment
  • Database Management
  • Security Management
  • Batch Job Management
  • Backup/Purge Management
  • Weekly time card reporting
  • Updating Remedy Force and Jira daily with status of tickets worked
  • Presenting on-call issues in weekly Production Support Meeting
  • Participate in Daily Scrum Meetings
  • Written documentation describing process
  • Change Control Management
  • Communication across teams
  • Vi editor
  • UNIX/Linux operating system
  • Experience with Aginity AMP preferred
  • Exposure to Business Intelligence tools (MicroStrategy, Tableau, Hyperion IRS query and reporting tool)
139

Healthcare Data Warehouse Account Resume Examples & Samples

  • Act as principal interface for Optum with the State customer
  • Schedule and provision resources
  • Present all formal communication and correspondence to the State customer
  • Leverage diversity and inclusion to drive employee engagement and foster teamwork and collaboration
  • Manage and ensure compliance with IT structures/processes/technologies
  • Maintain knowledge of and leverage IT industry/marketplace technologies and trends
  • Manage teams of Business Analysts, Technical, Training, and Documentation Specialists, ETL staff, and BI developers
  • Ensure that projects are delivered on-time and of high quality
  • Create schedules, resource plans, and implementation documentation for medium-to-large size projects
  • Ability to create, manage, and track progress toward revenue and budgetary goals
  • Ability to work closely with clients at various levels within the organization
  • Manage vendor contracts (Statements of Work [SOW]) for Hardware, Software, and Service
  • Business development planning; developing integration services proposals; government procurement; providing pre-sales technical support and designing technical solutions
  • Organize and lead project related meetings with customers, development staff, and sponsor level staff
  • Develop/maintain formal Project Schedule
  • Responsible for Project Resource / Staffing Management
  • 4+ years of experience managing delivery of complex data warehouse and/or analytics projects
  • 4+ years of experience managing projects with 10 or more resources, both direct reports and matrixed resources
  • 3+ years of experience managing a contract for a program valued at $5 million in revenue or greater
  • 5+ years of experience leading projects, with responsibility for ensuring deliverable quality, tracking progress, and reporting status
  • 3+ years of experience with healthcare payer data
  • 5+ years of hands-on experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, and relational database management systems
  • 3+ years of formal personnel management experience
  • 5+ years of account management experience for a government or private sector health care payer
  • Bachelors’ degree in a Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology or a related field of study
  • Must reside in, or be prepared to relocate to, the Albany, NY area
  • Certified Project Management Professional (or actively pursuing certification)
  • Master's degree of greater
  • Experience with Oracle and/or other RDBMS platforms
  • Experience with Tableau, Cognos, and/or other BI and analytic tools
  • Experience managing large data warehouse implementation projects
  • Experience leading requirements sessions with client teams
  • Experience working on Medicare/Medicaid projects
  • Certified Business Intelligence Professional certification
  • Excellent communications skills, writing skills, small group facilitation skills and formal presentation skills
140

Data Warehouse Solution Architect Resume Examples & Samples

  • Provides domain expertise in cloud data warehousing platforms like AWS RedShift, Azure SQL Data Warehouse, and Oracle Cloud BI Services
  • Provides domain expertise in modern business intelligence and self-service data visualization tools (e.g. Tableau, QlikView, ZoomData), business intelligence reporting and dashboards (e.g. Cognos, BusinessObjects, OBIEE), and custom UX (e.g. D3, HTML-5, Java)
  • Provides domain expertise in modern data warehousing frameworks that combine NoSQL and relational data, database query languages like SQL, Extract, transform and load (ETL) functions, Metadata processes, Data modeling, dimensional modeling
  • Provides domain expertise of open-source and commercial relational DBMS (Oracle, SQL Server, PostgreSQL, AWS RDS, Azure) and NoSQL databases (e.g. MongoDB, Cassandra, Accumulo) databases
  • Provides domain expertise on hybrid data architectures that combine big data with enterprise data warehouses, data lakes, data hubs, and streaming data
  • Drive market demand for Data and Analytics solutions by providing concise messages tailored for CSRA customers and their desired outcomes
  • Help define our go to market strategy for Modern data management, data warehousing, big data, and advanced analytics offerings
  • Collaborates closely with our leveraged service center to incubate, design and deliver leveraged Data and Analytics offerings
  • Help activate, energize and engage a community of data management engineers and practitioners to build a strong sense of community, to provide career mobility, achieve meaningful corporate reach back and to design training and certification pathways
  • Bachelor's degree or equivalent combination of education and experience
  • Bachelor's degree in business administration, computer science, information technology or related field preferred
  • Twelve or more years of BI/DW solutions experience; three years of Cloud, Big Data, or Modern BI platforms
  • Experience working with company products and services, business processes and re-engineering
  • Experience working with appropriate programming languages, operating systems, product-line hardware and software
  • Experience working with office productivity tools; delivery assurance and/or industry standards on deliverables
  • Experience working in a global organization of size, scope and complexity
  • Experience working with administrative and/or workflow systems
  • Requires expertise and experience implementing two or more of the following modern technology areas: big data, NoSQL, self-service BI and Analytics, streaming data
  • Requires expertise and experience implementing three or more of the following technology areas: database design, data warehousing, master data management, data analytics
  • Deep knowledge of data formats and structures, data storage, retrieval, transport, optimization, and serialization
  • Demonstrated experience developing engineering solutions for both structured and unstructured data
  • Experience working with large datasets including data integration, data migration, analysis and visualization
  • Strong communication skills to communicate with customers, support personnel and management
  • Strong skills at managing risks during product launches
  • Strong creative thinking, problem solving, planning, time-management and organization skills to balance and prioritize work
  • Strong human relations skills to select, develop, mentor, discipline and reward employees
  • Strong ability to manage multiple programs, handle multiple assignments simultaneously, and switch between assignments quickly
  • Strong ability to create and maintain formal and informal networks
  • Strong ability to lead and work in a team environment
  • Strong ability to manage by influence
  • Willingness to travel
141

Data Warehouse Business Analyst, Assistant VP Resume Examples & Samples

  • Work on Business Requirement Analysis for various projects with Data Warehouse Market Division
  • Identify Data requirements for various Market Downstream systems
  • End to end Data analysis and Data Lineage tracking from Source Legacy System, DWH to Target Downstream System
  • Identify all Operational Requirements such as calculation, override, and validation rules and document all requirements correctly in BRD, FDD
  • Create Use case documents with supporting data sets analysis
  • Create Unit Test Plan and ensue quality of deliverables with Test plan results tracking
  • Participate in SIT, UAT testing as coordinator and control and monitor Defects with team
  • Work with Project Lead and Manager to identify and track Project Risk
  • Develop & Maintain Data Dictionary and rules, mapping documents
  • Work as effective Liaison between Business and Development team
  • 8-10 Years of Strong Financial industry experience
  • 5+ Years working as Business analyst
  • 3+ Year working experience on Database SQL skills
  • Understand High level work flow of Markets products like Forex, OTC Derivatives, Options, Futures, and Swap is must
  • Understanding Financial products like Fixed Income Product, Collateral management is added plus
  • Understanding of Risk Calculations in Financial market is big plus
  • Knowledge of Extract, transfer & Load (ETL) procedures will be advantageous
  • Knowledge of Excel, Word, Visio, HPQC, JIRA tools skills is mandatory
  • Ability to analyze Data at various hops is required
  • Understanding of basic data modelling concept will be helpful
  • Strategic Thinker
  • Strong Written, Oral Communication skills and good team player
142

Data Warehouse Oracle Developer Resume Examples & Samples

  • 3-5+ years of full development life cycle experience in large scale Data Warehouse environments
  • Extensive experience with Oracle database environments leveraging databases, tables/views, stored procedures, agent jobs, etc
  • Experience with other SQL Server relational database is desired
  • Strong Experience with UNIX shell scripting to automate file preparation and database loads
  • Experience with Pentaho and other ETL tools (SSIS, Ab Initio, Informatica)
  • Experience with multiple reporting tools (SSRS, SSAS, Cognos, Business Objects)
  • Ability to manage multiple priorities and projects coupled with the flexibility to quickly adapt to ever-evolving business needs
  • Demonstrated independent problem solving skills and ability to develop solutions to complex analytical/data-driven problems
143

Data Warehouse Project Manager Resume Examples & Samples

  • Manages project delivery to ensure that it meets all scope, time, budget and quality expectations, through planning, controlling and managing customer projects
  • Facilitates needs assessment and the development of recommended project control solutions to be used for scheduling, and tracking projects through integration of various Project Management tools
  • Manages all project economics to include monitoring actuals from a budget resourcing perspective, and project staffing requirements
  • Controls project requirements, scope, risks and change management issues
  • Establishes appropriate metrics for measuring key project criteria
  • Undertakes status review meetings among project team members and clients
  • Manages team members to accomplish project goals, to meet established schedules, and resolve technical/operational issues
  • Builds stakeholder relationships, drives business growth through client relationships, teaming partners and technology vendors
  • Applies experience and subject matter knowledge to solve common and complex business issues within established guidelines and recommends appropriate alternatives. Works on problems / projects of diverse complexity and scope
  • Familiar with technology products for analytics, i.e. SQL, Business Objects, TOAD, dashboards, reporting, UNIX scripts, Web applications, Microsoft Office Software and Informatica ETL
  • Knowledge of data analysis and information reporting related to healthcare data
  • Excellent verbal, written and interpersonal communication skills with the ability to interface with all client management levels, supporting technical and business stakeholders through project engagement
  • Experience with Microsoft Project or other scheduling tools
  • Experience with SLC processes and documentation (project plans, implementation plans, issue logs and financial plans.)
  • Experience building diverse, remote, cross-functional teams
  • Flexibility to work off hours during project deliverables and oncall support
  • 3+ years of experience leading IT projects
  • 2+ years of experience in Healthcare
  • 2+ years of experience in Business Intelligence/Data Warehouse
  • On the PMP certification path
144

Enterprise Data Warehouse Resume Examples & Samples

  • Working knowledge of tools like Informatica, Teradata Utilities, Bteq, Mload, Fload, Tpump, Advanced SQL, Viewpoint, etc
  • Knowledge of best practices in using Consumption tools like Tableau, Qlik, R, etc that interact with Teradata
  • Ability to work seamlessly as part of a multi-site, multicultural development team
  • Self-motivated, driven to achieve committed milestones
  • Extreme attention to detail and commitment to quality
  • Strong collaboration skills, ability to mentor and be mentored
  • BS or MS degree in Computer science or equivalent experience
145

Senior Data Warehouse Technical Analyst Resume Examples & Samples

  • Able to focus on deadlines and deliverables in an autonomous manner
  • Enthusiastic about his field and related technologies
  • Able to present the team as well as our products in a positive and professional manner
  • Abilities to showcase the team accomplishments to the rest of the team and stakeholders when the occasion rises (Sprint Demo, User Acceptance testing…)
  • Proven Track record extracting/sharing actionable technical requirements from High level requirement for Data warehousing developments
  • Ability to drive the requirements review/acceptance process
  • Ability to act as referent for Dev and QA resources during the development sprint
  • Ability to review test plans for coverage and support UAT activities
  • Technical writing skillset
  • Proficient with a broad set of authoring tool set: MS Office suite including Visio, Wiki…
  • ETL/Date warehouse experience
  • SQL proficient (ORACLE preferably)
  • Ability to navigate and perform data profiling on data warehousing tables (star and Snowflake schema)
  • Ability to propose data model updates to the data architect: New marts/dimensions for a specific business need
  • Ability to review existing data elements vs. business requirements and propose
  • Bachelor or Masters of Science in Computer Science or Computer Engineering or equivalent
  • 5+ year experience in a similar role building industry proven Data Warehousing/Business Intelligence solutions
  • Experience integrating in a Scrum driven development team
  • Multi-cultural experience on geographically distributed projects
  • Travel Industry related experience is a plus
146

Oracle Data Warehouse Apps Developer Resume Examples & Samples

  • Development of sophisticated data warehouse solutions based on good understanding of overall system architecture and data flow and usage within GLOBALFOUNDRIES
  • Full Software Development Life Cycle activities for implementing solutions including requirements analysis, design, development, testing, deployment and production support
  • Oracle Data Warehouse ETL application development, using ETL tools such as Ab Initio and programming/scripting languages including Java, C, and Perl
  • Oracle Database application performance tuning and optimization
  • Collaborate with internal and external team members to deliver solutions
  • Level 3 application support for solutions deployed into GLOBALFOUNDRIES production environments
  • Assure creation / maintenance of required documentation, including design specifications, architectural diagrams, and application release notes
  • Bachelor degree in Information Technology, Electrical Engineering or similar relevant fields
  • One year experience in database administration, applications development or related in project, internship or industry experience
  • Master's degree in Information Technology, Electrical Engineering or related discipline
  • Knowledge of data warehouse architecture approaches and trends (big data), and high interest to apply and further develop that knowledge
  • Development and documentation abilities pared with very good communication & technical documentation skills, e.g. ability to understand and document complex data flows as part of business / production processes
  • Knowledge in collecting, structuring and summarizing requirements in a data warehouse environment
  • Knowledge in turning requirements into data warehouse design artifacts (ETL framework design, data modeling, source-target-mapping)
  • Knowledge in SQL and thorough knowledge of XML
  • Ideally knowledge with one or more industry-leading ETL tools, preferably Ab Initio, and respective infrastructure
  • Knowledge of modern Relational Database Systems such as Oracle, DB2, or SQL Server
  • Knowledge of one or more modern programming languages, preferably Java
  • Familiarity with SDLC concepts and processes,
  • Ability to work in the US
  • Availability for occasional international business travel
  • Familiarity with the semiconductor industry,
  • Familiarity with reporting data solutions and business intelligence tools
  • Familiarity with statistical data analysis and data mining,
  • Familiarity with ITIL
147

Data Warehouse Database Administrator Resume Examples & Samples

  • College diploma or university degree in computer systems design or computer science, and/or 10+ years in depth experience with infrastructure, operations, development, and database technologies
  • Minimum of 2 years’ experience providing Oracle Data Warehouse database administration. Experienced with partitioning, materialized views and parallel execution
  • Experience working in an Exadata/Exalogic environment
  • Extensive patch analysis and application experience
  • Experience with Oracle Enterprise Manager will be considered an asset
  • Experience in shell scripting in a UNIX or Linux environment is mandatory
  • Experience in Oracle WLST is mandatory
148

Data Warehouse Solution Architect Resume Examples & Samples

  • Work with business partners to understand the business requirements and business processes
  • Design data warehouse schema and define Extract/Translate/Load (ETL) processes for the data warehouse
  • Provide direction for diverse and complex initiatives and be accountable for a variety of tasks to architect and deliver data warehousing solutions
  • Provide proactive recommendations for improving the performance and operability of the data warehouse and reporting environment
  • Participate in the development and championing of advanced data techniques, including data modeling, data access, data integration, data discovery, database design and implementation
  • Provide assistance to data warehouse team members with issues requiring technical expertise or knowledge of complex systems and/or programming
  • Provide on the job training for new or less experienced team members
  • Provide day to day support for the data warehouse environment
  • Bachelor’s degree in Computer Science, Information Systems or similar fields
  • 5+ years of data warehouse design and development as an ETL architect, data warehouse developer, data warehouse architect or a similar role
  • Proven knowledge of SQL and an understanding of database structures enabling research and discovery
  • Proven experience in dimensional data modeling (such as star schemas, snowflakes, normalized and de-normalized models) and handling slowly changing dimensions and attributes
  • In depth knowledge of relational databases structures and design – experience with Oracle 10g and higher preferred
  • Experience with data modeling tools (ER/Studio, Erwin, etc…)
  • Outstanding verbal, written and visual presentation skills
  • Proven consensus building abilities
  • Ability to work independently, establishing objectives, project plans, and milestone goals
  • Experience providing practical direction on information and analytics platforms in conjunction with data warehouse tools and technologies
  • Experience analyzing complex source systems and data structures
  • Ability to interact with all levels of the organization and work in a fast paced environment
149

Data Warehouse Tech Lead, ETL Resume Examples & Samples

  • Act as technical lead. Answer any technical questions related to SSIS and datawarehousing
  • Help to mentor jr, mid, sr ETL development staff
  • Design and construct large ETL mappings, packages workflows etc
  • Integrate new data with existing Enterprise Data warehouse structure
  • Design and code ETL processes to enable initial load and incremental processing, error and exception handling, restart ability and recovery, data cleansing, validation and monitoring
  • Analyze, design, build and support current and new data feeds from various data sources to the data warehouse
  • Work with the current Enterprise Data Warehouse data model, data marts and cubes, extending and improving it for flexibility, performance and accuracy
  • Learn tabular cube development and dax programming
  • Create Entity Relationship models to capture business concepts
  • Work closely with the BI report developers, Data Warehouse Administrator, SQL Server DBA and Project Managers
  • Bachelor’s Degree in Computer Science (or related field), Master’s degree preferred
  • At least 4-6 years of Enterprise Data Warehouse dimensional modeling experience
  • At least 4 years of ETL design, development, and performance tuning on Microsoft SSIS 2014 R2 (2016 experience a plus)
  • 1+ year leading a small team in a management or tech lead position
  • Microsoft certification a plus
  • Expert T-SQL Programming skills
  • Skilled on Microsoft SQL Server 2014 R2 (2016 experience a plus)
  • Ability to manage multiple efforts concurrently
  • Possesses strong business acumen, with ability to assist in development of business requirements definitions
  • Able to work quickly and under tight delivery deadlines with focus on details
  • Interface with key customers from all functional areas - Analytic skills are needed and Effective collaboration of tasks across the business and technical teams
  • Proven and recent experience of implementing solutions from requirements gathering and process design to functional production deployment
  • Demonstrated ability to produce high quality deliverables
  • Ability to establish and maintain positive and effective work relationships with management, coworkers, and business users
  • Strong knowledge of emerging technologies and tools
150

Data Warehouse & Business Intelligence Engineering Resume Examples & Samples

  • 3 - 5 years of progressive experience in database design, development and programming throughout all phases of the software development life cycle in an Oracle 10g (or higher) RDBMS environment
  • Proven experience with technical requirements analysis, business process modeling/mapping, methodology development, and data modeling
  • Demonstrated Oracle application development experience and tuning (i.e. SQL, PL/SQL, SQL*Plus, Quest Software’s Toad or similar tool)
  • Experience with Informatica PowerCenter, SAP Business Objects, Microsoft Reporting Services, Microsoft Analysis Services
  • Excellent listening, interpersonal, written, and oral communication skills
  • Ability to write and enforce technical standards to drive a continuous improvement process for all newly created objects. Ability to oversee effective testing and migration from Dev/Test environments into Production
151

Data Warehouse Intern Resume Examples & Samples

  • Will perform work with excel and other MS products to assist the team manage deadlines and deliverables
  • Responsible for managing user lists and profiles within Oracle applications
  • Responsible for assisting project team members with communication and tracking responses
  • Will be providing application support with the Team Site and for managing content
  • Strong ability to work with others; in a team environment also comfortable working independently
  • Good organizational skills and multi-tasking ? Strong analytical and documentation skills
  • Ability to learn new technologies and products quickly
152

Senior Data Warehouse Tester Resume Examples & Samples

  • Work with BIC Team and Data Warehouse developers throughout the software development cycle to develop and document test strategy and plan
  • Develop and implement efficient and effective test plans including detailed test cases based on project artifacts, such as business requirements, functional specifications, source to target mappings, analytic specifications and technical specifications for Data Warehousing environments
  • Develop complex SQL scripts that validate business requirements and source to target mapping within the data warehouse
  • Use source applications to research data quality concerns in the Enterprise data warehouse to explain discrepancies in data or to identify issues in translation and load of the data stored in the Enterprise Data Warehouse
  • Define and develop appropriate controls to monitor quality of daily and weekly data loads. Automate the controls where possible to ensure consistent and efficient testing of the on-going data load
  • Effectively document defects using automated defect tracking tool
  • 4 years SQL experience
  • 6 years of software test experience
  • 5 years of ETL testing experience
  • 1 - 2 years management or lead responsibilities
  • Strong backend testing from a data warehouse environment
  • Strong skills writing complex SQL queries
  • Knowledge of data warehousing concepts (ETL processes, and general knowledge of Business Intelligence)
  • Ability to train, mentor and guide others
  • M.S or B. S. in Computer Science, Mathematics, Engineering or related disciplines
153

Data Warehouse / ETL Developer Resume Examples & Samples

  • Bachelor's degree in Computer Science or related field OR equivalent professional experience
  • 5+ years of development experience with industry-standard ETL tools
  • 2+ years of development experience with SSIS
  • Data architecture experience
154

Senior Data Warehouse Tester Resume Examples & Samples

  • Develop Test plan/strategy & Test scenarios
  • Individual contributor. Test ETL data feeds from various data sources to ware house
  • Test reports and dashboards ensure it meets end-user business requirements
  • Coordinate with onshore/offshore resources in executing tasks
  • Manage resources to deliver tasks on time
  • Handle multiple tasks efficiently
  • Status reporting, Bug identification & working through developer and BI team to test it
  • Build automate regression scripts to identify / validate critical and problematic areas of the warehouse and source data
  • 6+ years of software testing experience
  • 5+ years of experience in Data warehouse/ETL testing
  • Proficiency in writing complex SQL queries in oracle
  • Enthusiastic about learning new techniques
  • Strong analytical and problem-solving skill
  • Automation experience knowledge in Selenium / QTP
155

QA Lead, Data Warehouse Resume Examples & Samples

  • Ensure that quality processes are carried out through all phases of the Software Development Lifecycle
  • Analyze and dissect system requirements and technical specifications to create and execute test cases for large business initiatives
  • Assist business users in defining User Acceptance Testing, test cases and plans
  • Create and maintain test cases in Quality Center and/or Test Director
  • Work with business users, system analysts, designers and programmers to create and analyze various required project documents
  • Comply with standards of the software development life cycle and follow strategies, plans and procedures within information Technology software
  • Apply solid understanding of the Software Development Life Cycle, Data Warehouse ETL and QA process
  • Participate in Requirements and Design reviews, plan and estimate the QA effort
  • Document defects, using a HP Quality Center, and report defects to Project teams
  • Bachelor's degree or equivalent professional experience
  • 2+ years of experience leading QA on projects in an onshore/offshore model environment
  • 3+ years of experience working with full Software Development Life Cycle within a formal development methodology
  • 3+ years of relational database experience (i.e., Oracle, SQL Server, Teradata, DB2, etc.)
  • Experience working with multiple data sources and variety of data source formats
  • Experience validating data sources via various methods
156

Senior Data & Business Intelligence Developer Data Warehouse Resume Examples & Samples

  • Must have a Bachelor’s degree or foreign equivalent in Computer Science, Management Information Systems, Computer Engineering, or a closely related field
  • Must have at least 5 years of post-Bachelor’s degree work experience as a Systems Analyst, Business Analyst, Software Engineer, or in a closely related IT role, including at least 5 years of post-Bachelor’s degree work experience implementing and maintaining ERP systems for a multinational company working with data warehouses as well as relevant tools and technologies including Oracle, SQL, and Informatica
  • All experience may be gained concurrently
157

Data Warehouse Systems Analyst Resume Examples & Samples

  • Assists business analysts by clarifying requirements during requirements development
  • Effective at analyzing business requirements and current system behavior and collaborating to create system design specification documents including functional specifications, system use cases, mock-ups, design models and so forth
  • Proven ability to work w/ minimal supervision & adhere to schedules
  • Strong written and verbal communication skills are required
  • Experience with Source Control, Requirements Management, and UML Modeling tools (Rational suite or comparable)
  • Highly desirable to have Familiarity with Agile SCRUM
158

Enterprise Data Warehouse Test Lead Resume Examples & Samples

  • Bachelor’s Degree and 4 or more years of experience in the Systems Testing area OR High School Diploma or Equivalent AND 6 or more years of experience in the Systems Testing area
  • Deep understanding of BI/EDW, ETL testing and leadership experience
  • Financial or Insurance background preferred
  • Cognos experience preferred but a BI tools (e.g. Business Objects, etc.) and Advanced SQL is a must
  • Required experience with Quality Tool Systems Administration (i.e. Quality Center)/VSTS
  • Required experience with Defect Tracking Management/Reporting
  • Prior experience with DataHub, InfoCenter & Cognos preferred
  • Experience with Project Tracking and Reporting and Project/Program Management tools and techniques, preferably using Agile/Scrum methodologies
  • Ability to work independently and be self-accountable to deliver a high level of performance
  • Strong communication skills that can be effective working in person as well as in remote situations
  • Desire to work in a diverse environment interacting with many roles and teams made up of passionate industry experts working towards a common goal
  • Experience working with co-located/off-shore teams
159

Data Warehouse Resume Examples & Samples

  • Does development and testing tasks, ensures adherence to agreed timelines, communicates status of tasks to team lead
  • Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies
  • Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ
  • Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members
  • Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc
  • Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets
  • Bachelor’s Degree in Computer Science or related field required
  • 4 - 6 years of experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures
  • Strong Database knowledge in the areas of general SQL
  • Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor
  • Good knowledge of analytical and logical conceptual level programming skills
  • Good knowledge of Erwin model generation tools (logical and physical)
  • Data analysis, data mapping, data loading, and data validation
  • Understand reusability, parameterization, workflow design, etc
  • Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
  • Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies
  • Performance tuning and end-to-end lifescycle experience with Enterprise wide data warehouse
160

Tech Lead, Data Warehouse Resume Examples & Samples

  • Interact with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions
  • Oversee activities for all assigned projects from planning to delivery and sustaining support to ensure that projects meet established business objectives, time and budget constraints
  • Works closely with fellow IT staff and project management to document standards and procedures for the definition of reference architectures (architecture roadmap)
  • Facilitates communication upward and across project teams
  • 6+ year’s experience in information technology
  • Full SDLC experience
  • Comfortable working with all project stakeholders (business users, architects, project managers, business analysts, developers, test analysts, production support team) Entertainment industry experience is strongly desired
161

Data Warehouse Ab Initio Resume Examples & Samples

  • Incorporate security requirements into design; and provide input to information/data flow. Understand and comply with Project Life Cycle Methodology in all planning steps
  • Document the detailed application specifications, translate technical requirements into programmed application modules and develop/enhance software application modules. Participate in code reviews and ensure all solutions are aligned to pre-defined architectural specifications
  • Analyze impact of proposed data warehouse solutions across the business, develop use cases, functional specification and source to target mappings to demonstrate business requirements to IT team, and contribute a business or process perspective during design reviews
  • Hands on experience in PL/SQL programming
  • Hands on experience on data mart design & development
  • Skilled in problem solving and analytical reasoning
  • Ability to work well in a team oriented, agile environment
162

Quality Assurance Test Lead-data Warehouse Resume Examples & Samples

  • Minimum 7 years experience in software quality assurance
  • In-depth working knowledge of ESB software. Webmethods knowledge highly preferred
  • Specialized in testing and validating XML, Web Services, JSOM, REST, HTTP, SOAP messaging
  • Solid knowledge of Integration testing best practices and SOA/ESB test automation framework
  • Solid understanding of QA methodology and test environments
  • Strong SQL query skills and data analysis experience required as well as the ability to understand complex database structures
  • Experience in Waterfall and Agile Software Development Methodology
  • Hands on experience with HP Application Lifecycle Management
  • Development experience or technical background a plus
163

Data Warehouse / ETL Lead Developer Resume Examples & Samples

  • 8+ year experience and hands on proficiency in the following tools/skill sets are a must: Informatica, Oracle and UNIX scripting, delivering high quality solutions
  • Knowledgeable with data warehouse concepts such as: SCDs, star schema, hierarchy, aggregation
  • Possess good communications skills
164

Data Warehouse ETL Developer Resume Examples & Samples

  • Extensive experience with Pentaho ETL
  • Experience with other ETL tools (SSIS, Ab Initio, Informatica)
  • Experience with SQL Server and Oracle database environments leveraging databases, tables/views, stored procedures, agent jobs, etc
  • Demonstrated experience with multiple reporting tools (SSRS, SSAS, Cognos, Business Objects)
  • Strong development discipline and adherence to best practices and standards
165

Data Warehouse Ssis Developer Resume Examples & Samples

  • Develop, maintain, and administer complex ETL processes using MS SQL Server 2005/2008/2012 (DTS and SSIS)
  • Provide thought leadership on data and system architecture, system administration, schedule management, performance tuning, and expansion
  • Participate in ongoing DW/BI performance tuning activities
  • Provide maintenance and 2nd-tier production support for a self-service business intelligence environment
  • Develop, troubleshoot and fine tune existing and new reports
  • Evaluate and implement products and implement best-practices to enhance our BI/DW solution
  • Provide expertise on decisions and priorities regarding the enterprise’s overall data warehouse architecture
  • Facilitate the development of data integration efforts with the development team
  • Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements
  • Expand the company’s use of data as a strategic enabler of corporate goals and objectives
  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments
  • Be able to define requirements, analyze data, design solutions, program, test, implement, and train end-users and fellow IT team members
  • Other duties as directed by management
  • B.S. in Computer Science or similar field, M.S. or MBA preferred
  • 5 years of experience developing, maintaining and administering MS SQL Server 2005/2008/2012 databases
  • 7 years of experience with Business Intelligence and Data Warehouse products
  • 5 years of hands on ETL experience with complicated SSIS Package coding and maintenance
  • Business Objects XI/BI4.X experience desired
  • Experience with installation, configuration and stabilization of medium- to large-scale Business Intelligence implementations
  • 5 years of experience with Data Modeling tools such as Erwin
  • Experience working with and managing SAN technology preferred
  • Knowledge of LDAP and Active Directory preferred
  • Goal driven, highly motivated, with a desire to take the lead
  • Proven analytical and problem solving skills
  • Strong customer service skills and passion to work through obstacles to produce results
  • Demonstrable technical thought leadership and influencing skills
  • Strong oral and written communication skills
  • Able to work in a projects-based, team environment
  • Proficient in multi-tasking and managing multiple projects, able to meet target completion dates
166

Data Warehouse Resume Examples & Samples

  • Monitor generic mail boxes in terms of requests/issues/questions relating to the Enterprise Data Warehouse environment
  • Working closely with users and business sponsors, understanding business needs and requirements, resolving production issues and ensuring that expectations are met of user’s pertaining to their questions/issues/requests
  • Achieve expected Service Level Agreements with business users
  • Understanding of Teradata/Oracle Business Intelligence Access Request process and monitors all requests ensuring appropriate manager and Data Steward Approval is in place before granting access
  • Develops and maintains strong relationships with business partners and internal/external team members
  • Manage the logging and tracking of Problems and Incidents through to resolution, providing project managing, business system analysis, documentation, and validation by work on problem tracking records via HP Quality Center that requires more analysis and investigation
  • Continually enhances skills and builds knowledge in all aspects of the organization, the business and information systems
  • Handling Oracle Business Intelligence requests/issues/questions as they arise
  • Assigned special projects as required
167

Data Warehouse QA Analyst Resume Examples & Samples

  • Strong background in functional testing with the ability to design and develop test strategy and test cases
  • Ability to review technical requirements with data warehouse and business intelligence terminology to produce test strategies, test scenarios, and test cases for the data warehouse team
  • Creates the Test Plan for the software release, defining resources, and test suites required for each test cycle, dependencies, risks, and the overall strategy for testing complex systems and applications
  • Performs all aspects of verification, including functional, structural, regression and system testing
  • Experience participating in all aspects of a full-lifecycle development methodology, and related quality concepts and processes
  • Ability to lead a distributed testing effort
  • Ability to work in an agile environment with an iterative approach to development
168

Data Warehouse Engineers ETL & SAS Specialists Resume Examples & Samples

  • Work on the design and development of complex ETL/data integration processes
  • Identify and tune ETL performance issues, monitoring ETL jobs in multiple database environments
  • Support transformation processes towards a data centric culture, perform data analysis, source to target mapping, job scheduling, development and testing of ETL programs
  • Collaborate with our business experts in domains such as risk management, business optimization and customer intelligence to translate business requirements into high-quality technical solutions
  • Work together with our data engineers, data architects and data scientists, providing support to our clients as part of our global service
  • Experience with Agile methodologies (ideally SCRUM)
  • Practical knowledge of at least one programming language such as Java, SAS, R or Python
169

Senior PM With EDW / Data Warehouse Resume Examples & Samples

  • *Must have 7+ years of professional Project Management experience
  • *Must have experience working on Data Warehouse, EDW or large scale Business Intelligence projects
  • Requires leadership on multiple medium and large internal IT or business projects – including financial, scope, schedule and risk management responsibilities
  • Basic familiarity with Clarity or other Portfolio / Program Management Software
  • Bachelor’s degree in Computer Science, or a related discipline
  • Matrix supervisory responsibilities with project teams varying in size up to 75 people
  • Participates in PMO process improvement initiatives and supports PM onboarding for new staff
170

Enterprise Data Warehouse Leader Resume Examples & Samples

  • 4-8 years of experience including
  • Data Warehousing and Business Intelligence experience
  • Experience with SQL and/or PL/SQL programming
  • Data analysis and visualization skills
  • Ability to prioritize, coordinate and manage multiple parallel streams of work
  • Financial services
  • Project planning and delivery experience
  • Process analysis, documentation and re-engineering skills
  • Ability to think strategically at an enterprise level
  • Data governance, metadata management, master data experience
  • Database design and/or data modeling
  • Ability to influence and build consensus with executive/senior-level colleagues
  • Banking industry/regulatory/management reporting
  • Experience with Fiserv Informent product suite
171

Senior Data Warehouse Designer Resume Examples & Samples

  • Be the main point of contact for Enterprise Data Warehouse
  • Ability to think strategically at both the technical and business oriented level
  • Define technical requirements, technical and data architectures for the data warehouse and the analytics ecosystem
  • Focused on cost savings, high performance, high reliability, quality of user experience and architectural alignment of solutions
  • Coaches/Mentors others in application of data warehouse and analytics architectural standards
  • Create models for new data warehouse development and/or changes to existing data stores
  • Identify inefficiencies and gaps in current data warehouses and leverage solutions
  • Generates ideas to improve overall system design and/or streamline delivery of product/system
  • Design redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets. Plan capacity and resource expansion to ensure data warehouse scalability
  • Identify metrics for measuring the ongoing effectiveness of the data warehouse
  • Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity
  • Understands impact on adjacent systems and long term impact of technical decisions
  • Ensures high quality code is delivered that meets specifications and adheres to development standards
  • Develop, implement, and maintain change control and testing processes for modifications to data systems
  • Experience with best practices associated with end to end requirements/design/development/testing/implementation practices as they relate to data
  • Prior travel industry experience is desired with understanding of how GDS's operate and work
  • Extensive experience required in Informatica Power Centre, Reporting tools (Cognos), Pentaho data integrator, DB2, Unix shell scripting
  • Current knowledge of the data warehouse market, vendors, and standards bodies
  • Highly analytical with strong research skills, able to discern key issues and information in
172

Business Analysis for Data Warehouse Project Resume Examples & Samples

  • Fulfill Business analysis requirement for the OGC and Tax Dataware house project
  • Work with Business , IT and Subject matter experts to further define requirements
  • Work closely with Business and understand current state and future state view of the Business process
  • Create artifacts to support project deliverables for requirements and high level design
  • Support the project manager in planning, creation and execution
  • Participate in the estimation process for overall project
  • Familiar with Clien/Industry standard processes, procedures, and organization
  • Experienced working with multiple IT teams across the organization and working with global teams
  • Experience in Requirements gathering, authoring of Use Cases and defining Non functional requirements
  • Customer Relationship Management skills
  • Self-Starter who can work in ambiguous situations and drive to a solution
  • Experience with collecting and documenting SCRP/ACR/ICR information/
  • Strong organizational skills; able to advance multiple work streams concurrently
  • Tax Domain Experience
  • Background in Data warehouse
  • Experience in identifying Build vs Buy solutions
  • COTS product implementation
  • Masters in Information Systems or equivalent
173

Data Warehouse ETL Architect / Developer Resume Examples & Samples

  • The main responsibilities are ETL design and development for the Data Warehouse and Business Intelligence Solutions
  • Handle areas related to Metadata/Repository creation and management, Internal database administrator (DBA), Technical/Data architecture, Oracle Business Intelligence, BI client/servers related configuration
  • Reports to DWH/BI Technical Lead, interacts with Modeler, QA, IT, Data Analysis, BI Developer, and DWH/BI technical lead and all members of DWH/BI technical and functional teams
  • Design ETL processes; Develop default strategies for extracting data, archiving extracted data, policing data quality, dimension change management
  • Design strategy to meet availability requirements, Design data auditing subsystem, Design the structure of the ETL staging area
  • Develop plan for maintaining dimension hierarchies
  • Build dimension table surrogate key management system and the Audit system
  • Develop ETL subsystems as architected
  • Test historic load and primary dataset for incremental load
  • Conduct live tests with real data
  • Test all over process, system integration and month-end or unusual conditions
  • Inventory metadata elements, locations and relationships
  • Educate team on metadata situation and responsibilities
  • Identify key elements to manage
  • Create systems to capture additional metadata
  • Create tools to synchronize metadata
  • Design and implement metadata delivery system and Document metadata strategy
  • Ongoing metadata management and monitoring
  • Populate BI tool metadata; Create business metadata
  • Test BI tools, Setup user security and report process metadata system
  • Test monitor and tune query performance
  • Candidates should hold B. Sc. Degree in Computer Science, IT, or Computer Engineering
  • 7+ years of solid experience in field of Data Warehouse ETL Architect and ETL Development
  • Involved in various projects related to reflecting repositories from data modeling and dimensional design, Star Schema
  • Linux, Windows, Microsoft SQL Server, Oracle BI technologies, SQL, and PL/SQL
  • Dimensional modeling extensive background. ODI (Oracle data integrator) and BI Administrator RPD
  • 4+ years of solid relevant experience in the field of data warehouse metadata implementation and management
  • Database Administrator experience and previous experience in manual ETL/ELT
  • Integration and transformation professionalism
  • Advance logical, reasoning and conceptual capacity, multi-tasking and overload tolerance
174

Data Warehouse & Business Intelligence Lead Resume Examples & Samples

  • The main responsibilities are Lead and supervise specialized technical team of Data Warehouse DWH/BI
  • Co-Develop default strategies for extraction and archiving extracted data
  • Additionally, handle Business Intelligence Security and BI Access management, creating BI materials
  • Reports to EPD Sector Manager, interacts with ETL Developer/Designer, modeler, QA, IT, Data Analysts, BI Developer and DWH/BI Team, IT and other departments
  • Establish Project identity, identify project resources and prepare project plan
  • Develop project communication plan, process to manage scope/control changes and develop process to measure success
  • Ongoing project management (techno-functional)
  • Establish governance responsibility/process, establish program communication plan, Establish program best practices
  • Conduct periodic program assessments and ongoing program management
  • Monitor security privileges by individual and Audit security violations
  • Design BI Security Architecture, BI access services and BI Authentication services
  • Centralize authentication and access control; implement security monitoring and compliance system
  • Review and sign-off all DWH Designs, DWH/BI road maps and plans, DWH ETL design and development, dashboard and indicators
  • Develop advance Dashboards and CSI’s (KPI’s and Metrics)
  • Candidates should hold B.Sc. degree in computer sciences, MIS, IT or Computer Engineering
  • 12 years in relative information system areas having at least 5 years of experience in business intelligence and advanced Data Warehouse methodology and having at least 2 years of experience on enterprise user access and information security management
  • Experience in leading full implementation of integrated DWH/BI
  • Experience leading technical team members of DWH/BI Teams
  • Previous working experience in all (or most of) government sector (Investment, Infrastructure, budget and Finance, Supply chain, Operation and Maintenance, Healthcare, Education, Employment, Population and Census)
  • Solid knowledge of advanced DWH/BI system development life cycle and agile DWH implementation, experience in proven methodologies and ability to engage customized approach blending DWH life cycle methodology with agile
  • Solid exposure to all major areas of DWH/BI (Design, Modeling, ETL, Security, Dashboard, Ad-hoc, Advanced Database, Master data management, Integration, repositories) and good experience in Oracle technologies and ERP
  • Advance logical, reasoning and conceptual capacity
  • 2 years’ experience working city-wide in economic/Industrial cities
  • Tableau rapid analytics experience (optical as plus point not mandatory)
  • At least 3 years’ experience in OBIEE
  • Previous experience in SQL, PL/SQL
  • Leading Technical specialized teams and vendor management experience is a must
175

Data Warehouse / Business Intelligence Intern Resume Examples & Samples

  • Demonstrates rapid learning and flexibility and proactively pursues training
  • Strong analytical and technical/programming skills
  • Flexible and dependable
  • Quickly able to learn new technologies and products
  • Due to the nature of our business, US Citizenship is required
176

Senior Data Warehouse Business & Data Analyst Resume Examples & Samples

  • Determine analytical IT business solutions and assist in implementing them
  • Conduct requirements-gathering activities like end user interviews
  • Support our business partners by describing analytical reporting capabilities and doing data analysis
  • Evaluate reporting services using a variety of internal and external data sources
  • Assist in quality control and project management
  • Identify people and systems impacted by functional and non-functional requirements
  • Worked in similar positions before and are an experienced data warehouse business and data analyst,
  • The ability to apply business analysis and data warehouse modelling techniques (UML, Kimball, Inmon),
  • Proficient SQL skills in relational DB environments, handling multiple and complex data sources,
  • Data visualization skills with business intelligence tools (Business Objects, Cognos, MicroStrategy, Tableau, etc.),
  • Data Modelling skills (Normalform and Star-/Snowflake)
  • DWH Know-How (what is an MART, ETL, STAGING, etc.)
  • The ability to interpret sets of data, design data marts and apply statistical methods,
  • Business domain knowledge in the financial industry (Securities, Payments, Risk),
  • Understanding of the software development lifecycle,
  • Strong analytical, problem-solving and synthesizing skills
  • Passionate about working with data and designing analytical applications,
  • Proactive, looking for creative and innovative solutions,
  • Adaptable, able to work across teams and functions and to engage with senior management,
  • Known for hitting deadlines and staying within budget,
  • Good German is a very big asset
177

Developer Business Intelligence & Data Warehouse Resume Examples & Samples

  • Develops and maintains data structures (both new and existing) based on current needs
  • Assists with design criteria for data model development
  • Develops and maintains analysis models
  • Assist in design and development of ETL processes to compliment cubes where necessary
  • Assists with metrics and project plans
  • Provide project estimates and deliverables/status updates
  • Support testing, researching and resolving bugs, assessing and reporting change impact testing
  • Support production applications
  • Strives to make overall efficiency improvements; performance tuning
  • Consulting directly with business users and decision-makers to gather requirements and define scope
  • Develop effective, detailed design documentation
  • Understands and demonstrates Essendant’s Core Values
  • Demonstrated experience/expertise in SQL
  • Demonstrated experience with MDX programming (preferred) or another multidimensional query tool
  • Report development experience using SSRS, SSAS
  • Experience with data modeling
  • Ability to organize, prioritize and meet deadlines in a fast paced environment
  • Ability to manage assigned responsibilities independently, or execute effectively within a team
  • Solid analytical background and associated skills
  • Proficient follow-through and follow-up skills
  • Experience with MS Office applications; advanced skills in Excel
  • Bachelor’s Degree or equivalent experience preferred
  • 2+ years of Business Intelligence experience required
178

Data Warehouse ETL Unix Developer Resume Examples & Samples

  • Proficiency in writing advance SQL and shell scripting under AIX and Linux environments
  • Code, test, modify, debug, document, and implement shell scripts
  • Develop technical specification documents
  • Assist in developing test cases/plans to complete the unit testing and support System testing
  • Participate in design reviews / code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation
  • Adhere to deployment code migration strategies from one environment to another
  • Assume ownership and accountability for the assigned deliverables thru all phases of the development lifecycle
  • Strong organizational and prioritizing skills
  • Ability to multi-task and handle multiple priorities
  • Embraces team-based approach
  • Proactive, strong, clear communication skills
  • Strives for Continuous Improvement
  • Teradata 15.x with strong SQL experience, as well as Oracle/SQLServer experience
  • Unix / Linux K-shell scripting experience
  • Data Warehousing experience
  • Familiarity with database tools ( SQL Assistant / TOAD / /SQL Workbench)
  • Familiarity with SSIS ETL Tool (a plus)
179

Enterprise Data Warehouse Resume Examples & Samples

  • Interface with senior business and IT leaders to identify their data & analytics requirements
  • Evangelize self-service BI and visual discovery while helping to change legacy Reporting/BI culture
  • Collaborate with Enterprise Architects in translating business strategy to execution via EA Roadmaps, conceptual/solution architectures and governance
  • Develop and maintain the DW/BI Roadmap for success given project prioritization and budget
  • Develop business cases and ROI to get project buy-in from senior management
  • Set direction and architecture patterns for target state data store designs (e.g. Operational Data Store, Data Warehouse, Data Mart, Sandbox, etc.)
  • Develop and owns the enterprise data warehouse conceptual and logical models and ensures project level data model alignment
  • Provide oversight across projects to ensure Data Models and ETL/BI designs align to standards and best practices for achieving maximum consistency, performance and efficiency of the DW/BI ecosystem
  • Acts as a champion for data quality, integrity and reliability by ensuring operational and analytic systems are designed for optimal information management
  • Work closely with DW/BI director and managers to ensure prioritization and resourcing to achieve delivery of the DW/BI Roadmap
  • Provide leadership and coaching to DW/BI team members for issues requiring methods, technical expertise or complex design/development knowledge
  • Provide on-the-job training for new or less experienced team members and technical training to external team members to foster stronger cross-departmental relations
  • Participate in the planning for retirement of systems programs, and migration of systems infrastructure
  • Duties, responsibilities and activities may be assigned or changed from time to time
  • 10+ years of experience defining, designing and delivering data warehousing/business intelligence solutions
  • 10+ years of experience with OLTP and OLAP data modeling, data transformation and movement and business intelligence applications
  • Highly capable of acting as client liaison and interacting with senior leaders and key customers while passionately maintaining a customer-centric view. Ability to inspire the ‘art of the possible&#8217
  • Excellent communication and presentation skills (verbal, written, presentation) across all levels of the organization. Ability to translate ambiguous concepts into tangible ideas
  • Strong analytical and problem solving skills, often in light of ill-defined issues or conflicting information
  • In-depth knowledge and experience with data and information architecture patterns and implementation approaches for Operational Data Stores, Data Warehouses, Data Marts, Data Lakes, Virtualization, Integration Layers, etc
  • In-depth experience with DW/BI methodologies and practices to include Agile
  • Demonstrated experienced with the following: Data Governance, Data Architecture, Data Modeling & Design, Metadata, Master Data, Data Quality (to include data profiling), Content Management, Data Warehousing & Business Intelligence, Database Management (including Changed Data Capture (CDC)), Data Security, Data Integration (to include streaming data)
  • Excellent time management and organizational skills and the ability to manage multiple priorities
  • Bachelor’s Degree in related field or equivalent experience
  • Database Technology: SQL Server, Netezza, Oracle, Hadoop, Cloudera
  • ETL Technology: SSIS, Informatica, DataStage, CRON scripting, Perl
  • BI Technology: SSRS, SSAS, OBIEE, Business Objects, Cognos, Microstrategy, Tableau
  • Advanced Analytics Practices: Time series analysis, clustering, decision trees and neural networks
  • DAMA Professional Certifications: CDMP, CBIP, CDGP etc
  • Master’s Degree Computer Science or Statistics
180

Senior Data Warehouse Integration Architect Resume Examples & Samples

  • Build a next generation real-time streaming data lake and data warehouse from cloud solutions (Salesforce, Workday) to AWS (S3, Redshift, EMR)
  • Knowledge of big data technologies with a hunger to learn and innovate and the ability to implement process and behavior changes will be key to success in this key role
  • Ability to perform data analysis and perform troubleshooting and resolution of ELT processes
  • Understanding of how to develop an integration framework of re-usable pattern based solutions to solve problems, minimize support needs and increase agility
  • Lead the integration and validation of data in the global data lake and data warehouse landscape (including all ELT and data warehousing processes and technologies required)
  • Using problem-solving, critical thinking skills, and independent thinking to overcome challenges
  • Lead the translation of business needs to requirements through requirement gathering sessions and collaboration with stakeholders
  • Closely interact with business groups and technical teams throughout the company such as, Engineering, Sales and Finance groups
  • Create documentation and formulate training approach to assist business users and IT members in designing & effectively using the solutions developed
  • Hands-on experience with the process and technologies used for modeling data in motion as well as data at rest across various formats and platforms like REST, SOAP, HTTP, XML, JSON, ODBC/SQL and schema on read platforms like HADOOP
  • 3+ Python and/or Java development and best practices
  • Expert level knowledge of SQL
  • 10+ years of experience working with business intelligence applications and Data Warehouse Architecture
  • Experience streaming/integrating and transforming data in AWS S3, Redshift and/or Hadoop utilizing oMapReduce, etc
  • Deep understanding of Master Data, Reference Data, Data Warehouses, Data Marts, ETL Best Practices, BI Reporting, Data Modelling
  • Experience with MPP columnar databases such as Redshift, Vertica, Greenplum
  • Strong communication skills, both verbal and written, and the ability to work as part of a team are essential
  • Superior analytical and problem-solving skills
  • Ability to prioritize and be self-sufficient in identifying and accomplishing goals
181

Principal Data Warehouse Administrator Resume Examples & Samples

  • Providing leadership in the design, implementation, and maintenance of Data Warehouse solutions
  • Providing technical oversight for database object creation, performance, monitoring, tuning and capacity planning
  • Tuning queries and database processes for efficiency
  • Setting up and administering ETL processes
  • Recommending, developing and enforcing policies and procedures for maintaining the security and integrity of the database, and functions as lead on projects
  • Coaching the development of other Data Warehouse Admins
  • Implementing complex large/multiple development projects
  • Administering a data warehouse in an Oracle Environment
  • Setting up ETL processes with tools such as Datastage and/or Oracle Data Integrator
  • Business Intelligence (BI) tools such as Oracle BI, Tableau, Business Objects, and/or Cognos
  • Leading data warehouse administrators and teams
182

Analyst, Data Warehouse Resume Examples & Samples

  • Thorough understanding of relational databases
  • Working knowledge of Microsoft SQL Server tools (SSAS, SSRS, SSIS)
  • Data Warehouse planning and analysis
  • Relational/Dimensional Data Modeling
  • Demonstrated knowledge of current and emerging technologies and trends in data warehousing
  • Monitoring and pro-active management of databases, data warehouse and production environment
  • Develop and implement standard and ad-hoc reporting requirements
  • Insure accurate and reliable data integrity within and between all database systems
183

Lead Data Warehouse Business Systems Analyst Resume Examples & Samples

  • Work with business to understand opportunities and provide BI and reporting solutions
  • Hands-on work of complete life cycle of application development. Conduct data modeling, extract-transform-load design, and report development with BI solutions and other analytical tools with data from Oracle applications and other sources
  • Analyze, design/enhance, test and document interface specifications, training material
  • Support the training, conversion, and implementation of business systems
  • Must have at least 5 years of experience working with business intelligence tools working directly with the business, including Manufacturing Operations, Finance and Sales
  • Demonstrated expertise in BI/DW, data modeling, transformation, data analysis and tools, ideally with Cognos and Oracle. Hands on experience in BI/DW tools is a plus
  • Must be able to travel occasionally to internationally
  • Excellent written and verbal English communication skills
184

P&L Data Warehouse & Analytics Lead Resume Examples & Samples

  • Business and Data Analysis
  • Technical Design
  • Design and implementation of the data ware house
  • Development of ETL Scripts, Reports and BI Dashboards
  • Maintenance, enhancements and rebuilding of existing application
  • Data and Server Architecture
  • Dimensional data modeling
  • System and Query Performance Tuning
  • 8+ years of hands-on experience building Reporting or Business Intelligence solutions and/or a Data Warehouse, using the latest versions of Informatica, Oracle, Cognos and/or QlikView
  • Experience working on a Data Warehouse or Business Intelligence project is required; within Investment Banking is strongly desired
  • Knowledge of Prime Brokerage, Stock Lending, Custody & Fund Services, Clearing and Executions or Portfolio Swaps data flows and business processes is strongly desired
  • Previous experience of leading a small team would be advantageous to candidates applying for the senior role
  • Oracle
  • Cognos / Business Objects
  • Informatica/Pentaho
  • Qlikview or similar BI tools
  • Control-M / Autosys
  • Some knowledge of Java is a huge plus
185

Director Data Warehouse Resume Examples & Samples

  • BS or MS in Engineering, Computer Science or Information Systems
  • 10+ years of data engineering and development experience; 5+ years with ecommerce
  • Minimum of 5+ years of increased leadership experience, preferably in data and/or software engineering
  • Extensive experience in one or more database technologies: MS SQL, Oracle DBs, MySQL, Big Data, MongoDB, Cloud technologies, SQL, PL/SQL, UNIX shell
  • 5+ years of experience in business intelligence, analysis and reporting systems
  • Strong sense of self-motivation, organization and attention to detail
  • Proficient knowledge in designs practices including OLTP, reporting, and OLAP; big data processing and analytic technologies including Hadoop, R, and stream processing; standard and ad hoc reporting solutions; ETL and MDM data management tools
  • Experience with agile and waterfall development methodologies
  • Experience in leading and working with co-located teams
186

Data Warehouse Resume Examples & Samples

  • Troubleshoot and resolve reporting issues
  • Run reporting schedules for business users
  • Ability to troubleshoot and resolve issues
  • Identify permanent fixes to recurring problems
  • Support, identify and define reports, with both users and developers
  • Utilizes, escalates and assigns tasks to other members in the department, as required or needed
  • Supports end users to include troubleshooting locally and over the phone
  • Contributes to the documentation and coordination of problem resolution procedures
  • Logs and tracks calls using problem management database, and maintains history records and related problem documentation
  • Ability to communicate any problems or issues, facilitate and track through an escalation process; work with peers to assist with resolutions
  • Responsible to provide status to management as requested
  • 2 to 10 Years Programming/Reporting Experience in OBIEE, Informatica, Hyperion
  • 2 to 7 Years of Full SDLC Business Analysis Experience or Strong Analytical Aptitude
  • Experience with Excel, Power Point, Word, Visio, Share Point, MS Project
  • Experience with OBIEE, Informatica, Hyperion
  • Knowledge of system life cycle / application reporting alternatives
  • Aptitude for complex problem analysis / resolution
  • Excellent communication skills; ability to effectively communicate to target audience
  • Ability to effectively work with all levels of personnel within the organization
  • Detail-orientated; uses sound judgment; and is self-motivated with the ability to handle multiple tasks
  • Very good organization and time management skills
  • Additional industry certifications are a plus
187

Data Warehouse / Modelling Resume Examples & Samples

  • Good knowledge on Data-Warehouse concepts
  • Good in NFORMATICA POWER EXCHANGE
  • Fluent in writing queries in Hive / familiar with Spark framework
  • Good UNIX skills
  • Good SQL skills
  • Understanding of the SDLC, good practices and experience with different development and change management tools
  • Strong Analysis and Problem Solving Skills
  • Prior Experience in Wealth Management
188

Senior QA Test Lead, Data Warehouse Resume Examples & Samples

  • Work with business partners, systems analyst, designers and programmers to create/analyze required project documents and ensures that quality assurance processes are incorporated
  • Product test and driving defect resolution
  • Establish and maintain test cases and test data
  • Actively participate in walkthrough, inspection, review and user group meetings for quality assurance
  • Participate in production implementation verification and being accountable for validating system quality
  • Plan, document, evaluate and track testing results to ensure system applications are free from defects
  • Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and /or functionality within Information Technology software
  • Design test plans, scenarios, scripts, or procedures
  • Test system modifications to prepare for implementation
  • Monitor defect resolution efforts and track successes
  • Create Metrics and status reports for projects
  • Support QA management with information for issues escalation or concerns
  • 4+ years of quality assurance / software testing experience
  • 1+ years of experience testing large, complex Data Warehouse / ETL applications (within the last 2 years)
  • 3+ years of relational database experience such as Oracle, SQL Server, Teradata or DB2 (within the last 2 years)
  • 2+ years of experience writing complex SQL scripts including complex select statements using multiple joins on a regular basis (within the last 2 years)
  • Proficiency in MS Office (Word, Excel, Outlook)
  • Experience with defect management solutions such as Quality Center/ALM
  • Experience writing UNIX scripts within the last 2 years
  • Experience working with multiple data sources and validating a variety of data source formats
  • Agile methodology experience
  • Proficiency with MS Visio and MS PowerPoint
  • Healthcare industry experience
  • Experience working with Informatica
  • Experience with Data Stage
189

Data Warehouse & Big Data Lake Lead Resume Examples & Samples

  • Develop new datamart / datasets on Hadoop that can be used by downstream application
  • Lead a functional area / deliverable
  • Participate in design discussions and contribute to the architecture process
  • Adhere to application development guidelines and help improve the guidelines
  • Understand and implement security guidelines and best practices
  • Collaborate as team to deliver complex deliverables
  • Conduct knowledge sharing sessions for the team
  • Exposure to Financial Domain. Have participated in requirement analysis and design discussion
  • Worked on Data-Warehouse / Data Lake projects
  • Driven and self-motivated
190

Developer, Data Warehouse Resume Examples & Samples

  • Design, develop and implement logic to extract, transform & load data from transactional applications into the DW using Oracle Data Integrator (ODI) and PL/SQL
  • Partner with Database Administrators and DW developers to achieve great performance
  • Help DW end users understand and query data to accomplish their business purposes
  • Gather requirements for a change by meeting with customers and listening actively
  • Meet your time and cost estimates when implementing a change
  • At least 3 years DW design and development experience; 3 years Information Systems experience
  • Familiarity with Oracle Application Express
  • Experience with Oracle (preferably version 11)
  • Knowledge of Unix Scripting and job scheduling
191

Data Warehouse Business Analyst Resume Examples & Samples

  • Analysis and Solution Definition
  • 3 Years Business Analysis - Domain Knowledge - Healthcare and Life Sciences
  • 3 Years Business Analysis - Data Analysis
  • 3 Years Data Warehouse Knowledge & Skills
192

Director, Data Governance & Data Warehouse Resume Examples & Samples

  • Establish and enforce data policies and standards, including enterprise-wide business data definitions and data quality standards. Includes full data lifecycle (includes data creation, usage, retention and deletion)
  • Identify new business opportunities available through more effective and creative use of data
  • Measure the effectiveness of data-related projects
  • Develop and deliver the benchmarking, identification of best practices, metrics and reporting on health of the data governance programs
  • Communicate data policies and enforcement with senior management
  • Lead group of Data Stewards (strategic data and process governance)
  • Drive overall future state MDM application architecture, including model for maintenance post-implementation and data retention
  • Manage change management relative to the information governance and data quality. Partner with IT on large enterprise level projects
  • Align with all business units who use customer master data to understand customer data attributes, reference data and metadata
  • Lead initiative to identify, document and implement processes for creating, maintaining and reporting customer master data
  • Ensure adherence to the data governance policy
  • Provide gap analysis and stakeholder analysis to show current to future state roadmap
  • Build a team/organization comprising of subject matter experts (SME’s) that understand all facets (data attributing, hierarchies, and consumer facing, including e-comm)
  • Define, develop and implement the vision, strategy and methods by which the organization acquires, analyzes, governs and manages the quality of data
  • Identify new business opportunities available through more effective and creative use of data. Provide guidance, strategy and oversight for data-related initiatives
  • Measure the effectiveness of data-related projects. Develop and deliver the benchmarking, identification of best practices, metrics and reporting on data health
  • Responsible for managing data warehouse enhancements with IT, work on new system integration, define business requirements and review and approve technical designs
  • Manage quality assurance and user acceptance testing and manage data issues proactively
  • Responsible for managing Customer and Digital data integration with Vendors and IT, campaign metadata and Marketing Resource Management Solution implementation, strategy and maintenance
  • Manage vendor invoicing, budgeting and tracking
  • 8+ years of experience
  • 5+ years of experience leading enterprise wide data governance initiative
  • Working with complex data and systems infrastructure, 3rd party data partners, including hands-on experience managing technical data governance issues
  • 5+ years’ experience in a people leadership position
  • Significant senior level experience establishing a global Customer Data Management capability within a global organization with focus on customer experience, productivity of our people, and reporting/BI
  • Have established customer data management programs that have enabled cross-company decision making that address the needs of individual business units while also enabling success of global programs
  • Bachelor’s degree; master’s degree preferred
  • Data driven with analytical outlook on role
  • Ability to understand and communicate technical concepts to both technical and non-technical audiences
  • Excellent organizational skills with attention to detail and commitment to follow-through
  • Must be flexible, self-motivated and possess the ability to multi-task and adjust to changing priorities in a fast-paced working environment
  • Strong business acumen and enthusiasm about identifying trends and marketing opportunities
  • Excellent excel skills and ability to effectively present and communicate your analysis
193

SQL Data Warehouse Resume Examples & Samples

  • Must be US Citizen or US Permanent Resident
  • Current MBI and VA access a plus
  • Microsoft SQL Server 2008
  • Creating, tuning, and maintaining complex SQL queries
  • Data warehousing, and data warehouse concepts
  • Procedural programming in SQL Server using Transact-SQL
  • Microsoft Business Intelligence Development Studio, SQL Server Integration Services (SSIS), and SQL Server Reporting
194

Director Data Warehouse & An Resume Examples & Samples

  • A minimum of ten years of clinical or business management, financial or information management experience in health care, preferably at an academic medical center
  • Minimum of seven years of leadership and management experience
  • Direct experience building analytics capabilities and business intelligence functions and platforms with a large health system, vendor or consulting firm with a strong strategic background as well as direct implementation experience
  • Expertise in analyzing large clinical and administrative data sets
  • Deep knowledge of using analytics to drive health system performance and leveraging predictive analytics. Familiarity with Epic systems a plus
  • Strong understanding of mechanics of data structures, provider pricing methodologies, consumer analytics, risk/gain-share payment models
  • Strong business acumen and judgment with an ability to work through complex problems finding new and creative ways to achieve goals such as seeking out grant funding from the NIH to support analytic goals
  • Demonstrated track record in creating, building and executing business intelligence and analytics initiatives across a matrix organization
  • Advanced understanding of how to enable data and intelligence as a business partner
  • Strong communication skills: Ability to translate technical concepts to business translation and vice versa
  • Execution focus, results orientation
  • Ability to build successful teams and create a positive work environment
  • Change agent: ability to drive cultural change
  • High integrity and interpersonal skills
  • Strong analytic skills: Ability to turn data into information, information into insights, and insights into action
  • High sense of urgency and accountability
  • Team player: Collaborative with ability to build relationships and drive consensus
  • Ability to be decisive, and to work cross-functionally with agility
  • Forward looking
  • Creative thinking
195

QA Software Engineer Lead-data Warehouse Resume Examples & Samples

  • Leads multiple medium to large test team efforts and work concurrently on several projects and driving them to completion with high quality
  • Lead the testing teams, ensure timely delivery of projects along with QA deliverable to be audit compliant
  • Ensure that quality processes are carried out through all phases of the Software Development Lifecycle and -Leads the implementation of process improvements and/or testing strategies
  • Advises others on testing approaches and issues, and leads training seminars
  • Evaluate test scripts and processes in order to identify and create automated test solutions
  • Work with business partners, data analysts, and development teams to analyze required project documents and ensures that quality assurance processes are incorporated
  • Can lead all test work teams in absence of management
  • Analyze business requirements and technical specifications to provide estimates, create test plans and test cases
  • Execute test cases. Set up triage calls and driving defect resolution
  • Participate in production implementation verification and being accountable for validating data quality
  • Communicate and interact with appropriate stakeholders on problems, changes and enhancements that may impact data quality
  • Create Metrics and status reports for projects. Support QA management with information for issues escalation or concerns
  • Lead Hadoop migration program work streams
  • 5+ years of experience in leading large testing efforts
  • 8+ years of hands-on testing experience with relational Database systems
  • 8+ years of developing complex SQL Queries to derive expected results, set up desired data loads for execution of functional scenarios
  • 8+ years working with Oracle , Informatica
  • 5+ years of experience in Unix, Shell or Perl or Python
  • 5+ years of experience in batch jobs development using tools such as Control M, or CA
  • 8+ years of experience with Data Warehouse technologies and structures
  • 8+ years of experience with Quality assurance processes and tools including HP ALM, JIRA
  • Strong Knowledge of big data technologies like Hadoop
  • Should have strong data analysis skills
  • Bachelor’s or Masters degree in a related field such as Information Technology / Computer Science, Analytics or Communications
  • Strong verbal and written communication with the ability to forge lasting relationships with the team(s) you are part of
  • Strong organizational and multi-tasking skills are critical
  • Experience with full Software Development Lifecycle methodologies including Agile
  • Mortgage banking industry experience is preferred
196

Data Warehouse Solutions Architect Resume Examples & Samples

  • Work with a diverse set of business and technical stakeholders/clients at all levels on technical infrastructure, data repositories/flows, applications, and processes. The solution architect works to understand problems, document current state environments, design future state solutions based on client needs and best practices, and create a plan for migration
  • Create design documentation deliverables including, but not limited to Process Models, Process Decomposition Diagrams, Application Architecture Diagrams, Data Models, Data Flow Diagrams, and Entity Relationship Diagrams
  • Elicit high quality Functional and Non-Functional requirements and design solutions to meet them
  • Must be able to design solutions that make optimal use of infrastructure resources
  • Some experience rationalizing an application portfolio and developing roadmaps for consolidation/simplification
  • Use a combination of advanced technical aptitude and consultative capabilities with a sales and business focus
  • Ensure adherence to client or best practice development and architecture standards, procedures, and design methodologies
  • Understanding and development of application development frameworks and standardization of design patterns
  • Independently develop internal and external system design specifications
  • Lead efforts to evaluate new vendor software or existing system and make recommendations
  • 4 year College Degree - a Bachelor's Degree or equivalent (Math, Computer Science, or MIS)
  • 10+ years of experience in information technology, data management, and application development
  • 10 + years of experience in designing and building Data warehouse/Data marts/ Operational Data Stores(ODS)
  • 6+ years in application and solution architecture in the Data warehouse/Business Intelligence domain
  • 8+ years managing projects
  • 6+ years of experience in Data Profiling & data analysis in a DW environment on Teradata/Oracle/MS SQL Server
  • 6+ years of experience in creating Source to Target Mappings
  • 6 + years of Data/Dimensional modelling and EDW implementation experience in Teradata/Oracle/MS SQL Server
  • 6+ years of ETL design using SSIS/Informatica/DataStage or other Data Integration Tools
  • Healthcare experience required with healthcare payer experience a plus
  • Prior consulting experience highly preferred
  • Expert level experience in data modeling, process modeling, and structured analysis and design techniques
  • Ability to translate technical concepts into business level language and effectively communicate ideas and direction with all levels of business management and staff
  • Must be flexible, creative, and able to "think outside the box." Ability to adapt to a dynamic, rapidly changing business and technical environment is required
  • Experience in ETL architecture and design, data architecture and modeling, data governance and stewardship, business intelligence tools (such as Cognos, Business Objects, etc.) and reporting and analysis
  • Ability to design and build out reusable components
  • Knowledge of Data Profiling Tools like Informatica IDE/IDQ, Data Flux etc
  • Ability to perform Data profiling and analysis of structured and unstructured data
  • Ability to Define new interface layouts (custom or healthcare industry standards) for integrating into the data warehouse
  • Expert Knowledge of Dimensional Modelling and Proficiency in modeling tools like ERWIN
  • Expert Knowledge in creating source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
  • Proficient in creating Process Flows using Visio
  • Proficiency in Performance tuning of ETL processes
  • Knowledge of Automation tools like Tivoli Maestro
  • Experience in working with sensitive/de-identified data environments
  • Expert knowledge and past experience driving to system development life cycle methodology (SDLC)
  • Agile experience is a plus and understanding of transitional strategies from the traditional Waterfall approach to an Agile approach is a plus
  • Proven ability to manage key stakeholder interests, simultaneously managing conflicting priorities and business interests. Ability to collaborate across all IT and business functions
  • Work with each client and team to ensure they are informed as to project status on an ongoing basis
  • Excellent analytical, organizational and problem solving skills, including the proven ability to adapt to a dynamic project environment and manage multiple projects
  • Excellent communication skills, strong interpersonal and relationship management skills with excellent conflict resolution and negotiation skills
  • Demonstrated experience managing customer-facing, strategic projects as well as Application Development projects
  • Travel required **(see note)
  • Typical travel scenario – Travel is based on project size, scope and location. Projects may require up to 80% travel. If travel is required , typical travel schedule is out early Monday, back late Thursday with telecommute from home on Friday
197

Director, Enterprise Data Warehouse Resume Examples & Samples

  • Bachelor’s degree or equivalent work experience. Degree in Computer Science or Information Systems a plus. Advance degree is preferred
  • 10+ of experience in technically supporting, planning and managing information systems in medium to large environments
  • 5+ years of senior management responsibility of overseeing project teams responsible for systems implementation and support
  • 5+ years of experience with technologies such as Oracle, Informatica, Cognos and Tableau
  • Experience with the Epic EMR and its host of data warehouse and BI tools preferred (Clarity, Caboodle, Cognito, etc)
  • Healthcare Information Systems knowledge is preferred. Non project IS experience should include responsibilities in areas such as disaster recovery, backup systems, security, computer operations, and hardware planning
  • Must be able to work well in a fast-paced, heterogeneous environment
  • Project management skills including prior experience with system implementations, programming, integration, conversion and testing
  • Ability to work and tactfully communicate effectively with all levels of management throughout the organization(s) being supported
198

Data Warehouse PMO Resume Examples & Samples

  • H/She is responsible to collect and manage the overall planning for DWH (development and maintenance) and Data Quality, creating periodical recap for the management
  • H/She manages the planning, the relationship with stakeholders (IT delivery/IT Services, Business, Demand) in order to collect needs, highlight issues, identify solutions and manage the escalation process
  • H/She leads the overall process to manage invoices and report resource utilizations versus budget
  • H/She collects specific requirements from users to prioritize requests
  • H/She analyzes and raises potential planning issues and overlapping
  • H/She manages common tasks and conflicts between the overall planning and the special projects
  • H/She gives particular attention in managing Minimum Standards and operative model, checks the delivery of all the required documents related to development and planning activities and to DWH Risk Control Self Assessment (RCSA)
  • H/She reports on weekly/monthly basis overall situations related to open Risk issues impacting data quality and DWH processes
  • Strong risk awareness
  • Excellent relationship skills
  • Excellent planning skills
  • Result oriented
  • Excellence in execution
199

Technical Business Analyst Data Warehouse Resume Examples & Samples

  • Bachelor's degree in business or technical-related discipline, or equivalent work experience required, advanced degree preferred, 8-10 years of experience in providing consulting advice to senior IT and business management required, experience in the securities or financial services industry is a plus
  • Preferred 10+ years of experience of working as technical business analyst on a large IT data project involving data warehouse/data mart build, data process flow, conceptual and logical data and dimensional modelling
  • Extensive experience with Transactional and dimensional level data in an enterprise data warehouse environment
  • Experience in writing user stories and acceptance criteria based on business requirement in an agile development environment
  • Must be a strong performer, capable of consistently producing deliverables on time
  • Must possess strong SQL skills
  • Experience working in a global team involving onshore/offshore model
  • A self-motivated personality, and able to work efficiently independently, as well as, in a team
  • Experience working in agile (scrum) development environment
  • Domain knowledge on Banking and Financial & Regulatory Reporting is a plus
  • Technical expertise working on database appliances, columnar database and big data (specifically Hadoop, ExaData, Vertica, SQL Server ), ETL (Pentaho) and BI ( JasperSoft ) is desirable
  • Experience working with regulatory projects (e.g. Basel III, CCAR, BCBS 239) is desirable
200

Data Warehouse Ab Initio Developer Resume Examples & Samples

  • Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution. Participate in design reviews and provide input to the design recommendations
  • Incorporate security requirements into design; and provide input to information/data flow, and understand and comply with Project Life Cycle Methodology in all planning steps
  • Document the detailed application specifications, translate technical requirements into programmed application modules and develop/enhance software application modules
  • Participate in code reviews and ensure all solutions are aligned to pre-defined architectural specifications. Identify and troubleshoot application code-related issues; and review and provide feedback to the final user documentation
  • Conduct research to determine if solutions to business requirements currently exist within or outside the business unit, and if not, whether new solutions are feasible
  • Facilitate implementation of new functionality through training sessions, demos, and the development of appropriate documentation
  • Coordinate with development team to implement data warehouse and business intelligence
  • Bachelor's degree in Computer Science, Engineering or related technical field
  • Five plus years of progressive work experience in described job or five years of progressive work experience in a software engineering-related occupation
  • 5 plus years with TWS and Control M Schedulers
201

Data Warehouse Ab Initio Software Engineer Resume Examples & Samples

  • Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution
  • Identify and troubleshoot application code-related issues and provide solutions
  • Conduct research to determine if solutions to business requirements currently exist within or outside the business unit and if not, whether new solutions are feasible
  • Coordinate with development team to implement data warehouse and business intelligence solutions or strategies
  • Experience: 3 years of progressive, post-baccalaureate work experience in job offered or five years of progressive, post-baccalaureate
  • Experience must include
  • Experience in Abinitio technologies including, but not limited to Ab Initio graph development, EME, Co-Op, BRE, Continuous flow
202

Data Warehouse & Business Intelligence Architect Resume Examples & Samples

  • 8-10 years of directly related computer programming experience
  • Strong analytical problem solving ability
  • Oracle SQL programming experience - 3+ years
  • Oracle PL/SQL 1-2 years preferred
  • Data Warehouse design/development 4+ years
  • Self-starter with the ability to work independently or as part of a project team
  • US Citizenship Required**
203

Senior Data Warehouse / ETL Analyst Resume Examples & Samples

  • Gather and analyze business requirements
  • Architect / Design Data Warehouse infrastructure and solutions
  • Develop, enhance, integrate Data Warehouses / Data Marts and Business Intelligence Solutions
  • Test Data Warehouses / Data Marts
  • Deploy and Maintain Data Warehouses / Data Marts
  • Data warehouse development and design
  • Interpret business requirements; design, build and test processes to ensure a high level of data quality and optimal system performance for large volumes of data
  • Build new ETL (extract, transform and load) processes and maintain existing ETL tools using Oracle PL / SQL and UNIX technology
  • Monitor Oracle / UNIX data warehouse ETL batch processing on daily and weekly basis
  • Experience with mid - high volume ETL (100,000+ records)
  • 3+ years PL / SQL
  • Healthcare data experience
  • Hadoop Big Data model experience
204

Data Warehouse Technical Delivery Lead Resume Examples & Samples

  • Track all milestone dates, raise alerts on time, manage risks and provide mitigation plans
  • Work with multiple systems to make sure project deliverables are met on time and on budget
  • Attend client meetings, track changes and work with resources to get it delivered
  • Manage resource forecast and estimates
  • Provide weekly status updates to leadership
  • Responsible for other duties as assigned
205

Data Warehouse Tech Lead Resume Examples & Samples

  • Initially will be the single resource responsible for construction of all objects necessary within the Data Warehouse
  • Provides scoping and estimating on Data Warehouse activities
  • 5+ years of experience in Data Warehouse solutions
  • 5+ year’s experience with ETL tools like Informatica Power Center
  • Experience with Oracle SQL (DML & DDL), PL/SQL, packages, stored procedures, triggers
  • Extensive experience with developing, unit testing, break/fix support of Informatica ETL
  • Skilled in performance tuning, query plan / explain plan analysis, indexing, table partitioning
  • Excellent communication skills, both verbal and written
  • Experience leading technical teams
  • Well organized, detail oriented, ability to multi-task
206

Data Warehouse Development Lead Resume Examples & Samples

  • Minimum 6 years experience
  • Minimum of 3 years of experience in the data warehouse, analytics, and business intelligence business area
  • Worked on at least one data warehouse replacement project
  • Expert knowledge of Health care or related data warehouse
  • Minimum 3 years of data warehouse functionality testing experience
  • Minimum 3 years business analysis skills and experience
  • Medicaid data warehouse system/MMIS experience preferred
  • Experience managing teams of part-time participants to meet project objectives
  • Must be able to travel to client site in Baltimore, MD
207

Software Engineer, Data Warehouse Resume Examples & Samples

  • Work with stakeholders to define the functional needs of an organization and recommend solutions
  • Assess available technologies to meet needs, and then define technical specifications and designs
  • Develop and maintain technology systems, addressing functional, performance, security, quality, operations and monitoring needs
  • Create detailed test scenarios, perform testing and analyze results
  • Document all technology changes through appropriate change control
  • Requires staying current on engineering approaches, technologies and techniques
  • Demonstrate good judgment in selecting software engineering techniques, best practices and conventions
  • Mentor associate software engineers to improve their skills, and make them more effective
  • Provides support and troubleshooting of prior developed technology solutions
  • Ensures work is completed in such a way to comply with established IT Policies and other internal controls
  • Software development and support using the Oracle/BO framework including PL/SQL, Data Integrator, and Grid Control features
  • Responsible for all physical and logical data modeling
  • Ensures overall data security is in accordance with IT policies
  • Assists with Oracle Backup and Recovery Strategies, including RMAN and Data Guard replication
  • Technical expert on applications assigned, being the lead person for all issues/questions that arise
  • Provides leadership on major projects, coordinating all resources and tasks
  • Has close interaction with the Business Customer and Business Analyst in the requirements gathering, design, development, and maintenance of software solutions
  • Translates functional specifications into technical specifications to meet and resolve business needs
  • Responsible for identifying and creating all automated unit and integrated test cases needed to ensure quality
  • Creates all necessary documentation and planning needed to deploy applications into Production
  • A minimum of 4 years of related experience in various software development technologies and practices
  • Undergraduate degree in Computer Science, a related field, or equivalent
  • Professional experience with a full understanding of software development; resolving a wide range of issues in creative ways
  • Thorough understanding of Oracle development environments such as SQLDeveloper/Toad
  • Experience with work on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors
  • A thorough understanding of the tools of the trade, including a key modern programming languages, current technologies and platforms
  • An understanding of the business practices and processes
  • Effective in technical communication with peers and non-technical colleagues
  • This position is eligible for the Employee Referral Bonus Program #LI-TH1
208

Data Warehouse Software Engineer Resume Examples & Samples

  • Analyze and discuss requirements of the business unit Contract Logistics and transfer them into efficient ETL and BI solutions based on our standards
  • Bachelor or Master in computer science or similar degree
  • Experience in Oracle SQL and Oracle PL/SQL programming
  • Strong experience in logical and physical relational data modeling (OLTP) and dimensional data modeling (OLAP) including VLDB concepts and processing of high volume data
  • Knowledge about positioned flat files and XML
  • Experience with BI tools, ideally SAP BusinessObjects or Tableau as well as experience in Java programming, is a plus
  • Strong analytical, conceptual and problem-solving skills
  • Team-oriented, reliable and self-contained
  • High level of written and spoken English
  • Willingness to take part in 24/7 on-call support
209

Senior Data Warehouse Modeller Resume Examples & Samples

  • Take the technical lead for feature elaboration working closely with the business owners, business analysts and other relevant teams to ensure that all work products broken down appropriately
  • Work with the data governance, architecture & infrastructure teams to ensure that downstream architectural considerations and roadmap are fed into ongoing feature work
  • Work with the business and/or business analysis teams on, and be responsible for, proposing fast track solutions for key business requirements
  • Be aware of key emerging technologies, communicate across the teams and apply through Proofs of Concept
  • Responsible for technical process documentation and standardisation within team & perform design and code reviews and be accountable for all design decisions
  • Represent Business Intelligence & Decision Support Development on all key strategic programmes
  • Be a technical leader across scrums ensuring consistent quality and that best practices are followed throughout design, development, unit testing, and maintenance of software components across Premier Farnell global data warehouses and decision support applications
  • Collaborate with Business Users or Global Test Teams to ensure quality deliverables
  • 5+ years’ work experience
  • Experience with working with Microsoft BI development tools: Integration Services, Reporting Services Data Modelling Integration and Analysis Services Data Modelling and SQL Server normalized/de-normalized database/system design patterns within Kimball Model) & QlikView: Source Document & Data Modelling integration
  • Provide technical leadership to development team members
  • Demonstrable experience of designing and implementing large scale performance solutions
  • Experience of working directly with customers in the business and requirements elaboration
  • Good knowledge of databases such as Oracle, MySQL, DB2, and SQL Server
  • Experience in dealing with nuances of user configurations in order to provide quality technical support for internal customers
  • Strong analytical and conceptual skills with the ability to work hands-on in a fast paced environment
  • Strong understanding of business intelligence and productivity industry standards and terminology
  • Willing to learn new processes and apply to daily work
  • Ability to deliver on-time and on budget in a fluid environment
  • 15+ documented mid to large successful projects
  • Strong written and verbal communication skills with an ability to communicate across all levels of the organisation, including developers, architects and senior management
  • Experience working in global teams
  • Experience with Agile process (SCRUM is preferred) using Team Foundation Server
  • Experience working with multi - language, multi – currency database that are integrated with wide range of business systems
210

Business Analyst for Data Warehouse System Resume Examples & Samples

  • Strong background in computer system validation & GxP (GMP) understanding
  • 2 to 3 years of working experience on SAP® Business Objects - Business Intelligence (BI) Reporting tool‎
  • Ability to manage stakeholders
  • Responsible in delivering world-class systems and services ensuring that they meet business requirements
  • Excellent business and system understanding
  • Demonstrate pro-activeness and ownership
  • Drive/Participate in activities related to implementation of system enhancements
  • ITIL related support, including Change/Release and Problem management
  • Enhancing good team spirit and high degree of knowledge sharing
  • Responsible in communicating and collaborating closely with the key stakeholders including follow-up on vendor deliverables and services according to agreements
  • Responsible in Carrying out end to end release management cycle of the IT System
  • Responsible for the operation and maintenance of several critical IT systems located and used in different departments
  • Open for business travel
  • Excellent Communication skills (Verbal & Written)
  • Good analytical and problem resolving skills
  • Good at reporting and analysis for the same
  • Should be independent to handle any tasks and self-learner
  • Knowledge of Computer System Validation required
  • Experience on pharma domain
211

Data Warehouse QA Analyst Resume Examples & Samples

  • Bachelors' Degree
  • Minimum 5 years software testing experience required
  • Minimum 5 years of project management and software product quality assurance experience required
212

Access Management Data Warehouse Resume Examples & Samples

  • Bachelor or Master degree with >2 years of hands-on database development (e.g. building stored procedure) and ETL
  • Solid experience in DB2 or other RDBMS platform, performance tuning, Data warehouse, ETL/Reporting tools
  • Strong English verbal and written communication skills
  • Strong analytical / problem solving skills
  • Excellent team player that is capable of collaborating effectively with colleagues across the globe
  • Database design and data modeling
  • Data Analytics using QlikView, Python or other languages
  • Scripting language, e.g., Perl or Python
  • Understanding with Linux/Unix development environment
  • Programming experience (e.g. Java)
213

Analyst, Data Warehouse Resume Examples & Samples

  • Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports, and reporting environments
  • Designs dimensional models with conformed dimensions, following the business’ processes
  • Develops and automates ETL processes that involves error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS)
  • Utilizes SAP Business Objects in designing and building the reporting environment
  • Writes reports, adds new fields, creates Business Objects filters, measures and objects; and creates dashboards to improve current data warehouse
  • Creates processes for maintaining or/and capturing metadata
  • Studies and understands the company’s business processes and applications, including their effect on data and reporting, and applies the knowledge gained in designing data warehouses and reports
  • Identifies and documents all requirements for both the current data warehouse components and reports by working with end users
  • Creates Business Objects reports and assists clients with data warehouse
  • Assembles performance statistics, analyzes them, and makes recommendations for improvements
  • Establishes system documentation and ensures it is continually sustained
  • Must have prior Data Warehouse implementation experience working
  • Contribute to the data warehouse design and data preparation by implementing a solid, robust, extensible design that supports key business flows
  • Perform all of the necessary data analysis and transformations to populate data into a warehouse table structure that is optimized for reporting
  • Design, integrate and document technical components for seamless data extraction and analysis from the data warehouse
  • Provide operational excellence through root cause analysis and continuous improvement for data warehouse technologies and processes
  • Experience with Data Warehouse design, ETL (Extraction, Transformation & Load) development, architecting efficient software designs for DW platform
  • Knowledge of database modeling and design in a Data warehousing context
  • Strong familiarity with data warehouse best practices
  • Experience with SAP tools, WebI and Explorer and Universe Designer
  • Certification in one or more of the Clarity data models (Optime, Anestheisa, Inpatient)
  • Certification in Epic application an added plus
  • Manage data warehouse plans
  • Interface with subject matter experts, engineers, and application analysts to understand data needs
  • Build data expertise and own data quality for allocated areas of ownership
  • Design, build and launch new data models in production
  • Design, build and launch new data extraction, transformation and loading processes
  • Support existing processes running in production
  • Define and manage SLA for all data sets in allocated areas of ownership
  • Work with data infrastructure to triage issues and drive to resolution
214

Data Warehouse Business Analyst Resume Examples & Samples

  • Bachelors Degree, specialized training or a minimum of 3+ years equivalent work experience as a Data Analyst/Business Analyst
  • 3+ years experience with industry logical models
  • 3+ years experience using data modeling tools like Erwin
  • Experience in performing data modeling studies and participation in developing conceptual and logical data models
  • Experience in translating business requirements into conceptual and logical models
  • Experience with full application development lifecycle (analysis, architecture, design, development, testing and deployment)
  • Ability to work in a fast paced environment
  • Familiarity with Business Intelligence reporting and analytical tools such as Cognos, Business Objects, MicroStrategy, SAS
  • Familiarity with retail banking applications such as loan originations and servicing, financial reporting and credit risk
  • Excellent visual information skills (e.g. Instance diagrams, data-oriented use cases)
  • Good background working in complex data schemas
215

Data Warehouse Workload Automation Lead Resume Examples & Samples

  • Provide technical leadership for CCB Workload Automation Team
  • Lead and/or Manage DevOps operating model for Workload Automation
  • Become subject matter expert in Control-M environment
  • Responsible to support process improvements to continuously improve the stability and performance of the applications
  • Design and lead solution required for Control-M to interface with tools needed to support DevOps model, environment includes Subversion, Netcool, Atrium, Oracle, Edge, Change to
  • Analyze Workload data for performance and metrics based reporting
  • Prioritize workload, provide timely and accurate solutions
  • Effectively perform root cause analysis of issues and report the outcome to business community and Management as needed for Workload environment
  • Strong sense of ownership - Feeling of personal accountability for all areas directly or indirectly supporting the business/service area for which they are responsible. Willingness to drive people on all sides of an issue to a common understanding and then drive them toward resolution
  • Communication – Should be able to clearly communicate ideas in technical or business terms with senior business leadership, leadership outside the LOB (internal or external), their peers across IT, as well as their team
  • Self Directed - Has a strong sense of self and purpose. Understands tasks and role, and does not need daily reassurances, yet maintains an open dialogue with all of the stakeholders
  • 10+ building and/or supporting applications in a large Unix and RDBMS environment
  • 5+ year coding Unix shell scripts, or other scripting language, to support large space applications
  • Experience with Batch Scheduling tools such as Control-M
  • Experience with Linux and AIX platforms
  • Ability to analyze data using complex SQL
  • Proven ability to learn quickly and adapt evolving technology
  • Experience Control-M
  • Experience with ETL tools, Abinitio, Informatica
  • Experience with big data platforms, Hadoop, Teradata,
  • Web services and using REST API
  • Experience with AWK
216

Data Warehouse ETL Developer Resume Examples & Samples

  • Build a Metadata-Driven ETL Platform in a by Extending Microsoft SSIS for Teradata platform
  • Design and develop the system components for the extract and transform or conversion of data from source systems to the target applications
  • Create data structures or data models that support data across all stages of the extract, transform and load process
  • Design and maintain supporting Slowly Changing Dimensions (SCD) using SSIS
  • Design and build a Change Data Capture (CDC) solution using SSIS
  • Maintain accurate records related to data lineage
  • Reverse engineer data from various systems
  • Develop default strategies for policing data quality
  • Design data auditing subsystem
  • Design detailed ETL plans for each table
  • Set up initial job sequencing
  • Unit testing ETL code to ensure it can be delivered and run in a system testing environment
  • Document the ETL system specification. Develop new documentation, departmental technical procedures and user guides
  • Strong analytical and problem solving skills with production support experience
  • Clear understanding of Data warehouse & ETL basic concepts of data flow, data enrichment, data consolidation, change data capture & transformation ,meta data management
  • Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries
  • Develop ETL scripts using SSIS and Teradata Parallel Transporter (TPT)
  • 5+ years’ of practical experience in developing database ETL environments using SSIS for business intelligence applications
  • Demonstrate strong knowledge of BI and data warehousing design principles and industry best practices
  • Basic knowledge of UNIX
  • Ability to communicate at all levels of management and with peer associates. Demonstrated skills both written and oral are required
  • Experience in the development of retail business solutions is a strong plus
  • Self-starter with a strong work ethic
  • Exhibits leadership
  • Possesses advanced analytical and problem solving skills
  • Teradata/Oracle Experience
  • Data Warehousing experience is must
  • Familiarity with SSIS ETL Tool
  • Familiarity with Control-M job scheduler (a plus)
217

Architect, Data Warehouse & Security Resume Examples & Samples

  • Analyze, design, and provide development guidance of the company integration layers (real-time, batch, etc.) and data source access across multiple application, data base technologies, and file structures
  • Create data maps and the corresponding design for the work and data flows including event driven data, data handlers and all transaction types for use by the Application Analysts in delivering the end-to-end solution
  • Develop feasibility studies, and improve on an ongoing basis the data management, quality, integrity, security, and standardization of the application, integration, and data management environments
  • Ensure current and future integrations and operational environments can meet stringent business Service Level Agreements (SLA) as required for high volume integration processing, batch, security, and data management and recovery processes
  • Lead architectural design and development and assist in reviewing and monitoring task assignments by the project or technical lead
  • Design in accordance with the use of security and Personally Identifiable Information (PII), Payment Card Industry (PCI) technologies in applications, data storage, and integration development
  • Assist the Manager in leading and managing the use and future direction of the application and data integration toolsets, methods, and processes
  • Bachelor’s degree in Computer Science
  • 8+ years of experience in data warehouse architecture and development including ODS, Data Marts, Big Data solutions, Data Security, relational database and integration technologies
  • Experience in architecture analysis, design, and construction of high volume data warehouse integrations using the following set of technologies
  • Strong Informatica experience. [1] Significant experience with Informatica Power Center version 9.x. including Secure@Source, Test Data manager, Dynamic Data Masking, Workflow Manager, Workflow Monitor, Repository Manager, Designer, Server Manager, Power Exchange and ETL. [2] Significant experience with developing UNIX shell scripts (Korn shell)
  • Strong experience with the Microsoft PL/SQL. [1] Solid understanding of PL/SQL developer, functions, procedures, packages and triggers. [2] Solid understanding of SQL Navigator and/or Toad
  • Strong experience developing on Oracle databases. [1] Significant experience developing on Oracle 11G+. [2] Solid understanding of the concept of code objects re-use and business rules standardization. [3] Data Modeling experience utilizing Erwin and/or Embarcadero
  • Other advanced programming techniques: [1] Knowledgeable in Business Intelligence tools Hyperion, Tableau, and SAS. [2] Prior exposure to the Hadoop framework utilizing Cloudera or Hortonworks
  • Business Functional and Domain experience. [1] Prior experience in Sales and Marketing campaign management tool integration, direct mail and email campaigns, house-holding rules, personalization, and personally identifiable information (PII) risk management. [2] Prior experience in Reservation and Financial systems application integration including revenue forecasting, statistical analysis, and price modelling
  • Data Modeling experience utilizing Erwin and/or Embarcadero
218

Test Analyst, Data Warehouse Resume Examples & Samples

  • Under general supervision, debugs complex software products through the use of systematic tests to develop, apply, and maintain quality standards for company products
  • Participate in project teams to analyze and write quality test standards and procedures
  • Ensure information systems, products and services meet organization standards and end-user requirements
  • Maintains documentation of test results to assist in debugging and modification of software
  • Consults with development engineers in resolution of problems
  • Minimize production support incidents
  • Develop, maintain and execute manual and automated testing for user requirement validation, integration, regression, performance and usability testing
  • Share and execute strategies to effectively perform quality assurance testing
  • Gather and report QA performance metrics that identify QA activities efficacy and QA process appropriateness
  • Ensures quality computer integration into the overall functions of scientific computation, data acquisition, and processing
  • Scope and plan testing needs which to satisfy business requirements
  • Responsive to emerging issues
  • Understand customers’ needs and show insight that caters to evolving business needs
  • Identify risks and recommend process improvements
  • Learn the Business Process Your Application Supports so your testing will better support the business
  • Improve your department’s product and processes
  • Decrease incidents and increase uptime of the department’s products
  • Ability to develop and execute software test cases
  • Ability to clearly document test results, including defects and issues
  • Understanding of processes involved with quality assurance testing
  • Ability to work in a fast-paced environment with competing priorities
  • Define and manage collection of QA metrics on a comprehensive and project level to measure effectiveness
  • Able to effectively collaborate with other members of the team and management
  • Focused on the outcome of the team and the company
  • Eager to provide intrinsic value to the team and the company
  • Direct : Communicate clearly and objectively; don’t be afraid of difficult conversations. Raise concerns through the proper channels
219

Data Warehouse Ab Initio Resume Examples & Samples

  • Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation
  • Bachelor's degree in Computer Science, or related field with minimum 5+ years of Application Development work experience
  • Minimum 5+ years of Application Development work experience
  • Minimum of 5 years of work experience in Data Warehousing environment, experience in handling large volume of data
  • 5+ years of experience with data mart design & development on Teradata
  • 5+ years of hands-on experience with Unix Shell Scripting
  • 5+ years of experience with Teradata Utilities such as BTEQ, FastLoad, MultiLoad, FastExport, Tpump, etc
  • Minimum 5 years of experience with AB-Initio
  • Knowledge on Big Data Technologies is a plus
  • Ability to work well in an agile environment
  • Strong analytical skills and eagerness to learn new technologies
220

Data Warehouse QA Resume Examples & Samples

  • Respond to business data issues and resolves them * Contributes to new concepts, techniques and standards
  • Assists developers, administrators and architects in all development and testing efforts Other Requirements
  • Bachelor's degree in Computer Science or relevant discipline
  • 7+ years of experience in systems analysis including data analysis, profiling and/or design
  • Proficient in writing SQL queries using toad or any other front-end toll
  • Proficient with Data Warehouse concepts
  • Sound data analysis skills required
  • Strong teamwork skills essential
  • Effective oral and written communication skills required
  • Metadata management and data integrity skills will be an added benefit
  • Background of ETL tool preferably Informatica
  • UNIX experience is a plus
221

Principal Data Warehouse Business Intelligence Developer Resume Examples & Samples

  • Develop a broad and in-depth knowledge of Staples business processes and system environment. Analyze data and build data warehouse objects
  • Create high level and detailed technical design documentations
  • Create or modify programs, modules, routines, scripts and data objects from a detailed design where performance, efficiency, and reliability are critical to the entire system
  • Generate automated test cases for regression testing utilizing test plans created in advance. Lead and provide support to business UAT members by articulating technical terms in business language
  • May lead and coordinate onsite and offshore resources provided by our off-shoring program partners and associates on assigned projects
  • Provide 3rd level and on-call development side support as necessary to Data Warehouse Support/Operations team
222

Senior Data Warehouse Business Intelligence Developer Resume Examples & Samples

  • Successful delivery of Business intelligent data products by using agile methodology
  • Create data models, perform ETL and validate results matching to expected results
  • Perform source system analysis and create business rules repository. Analyze data in source systems to assess data cleanliness and make recommendations for addressing within the source systems or as part of the data warehouse ETL process
  • Document and execute implementation plans to deploy data integration solutions in the Enterprise Data Warehouse environment. Support the code promotion process through development, QAT and production as required
  • Develop, implement and maintain schedule/dependency logic for automated ETL processing. Develop monitoring, error notification processes to ensure data is updated as expected with high quality and accuracy
  • Develop simple dashboards as needed for development team usage
223

Temp Data Warehouse Senior Informatica Resume Examples & Samples

  • Develops software at all layers by programming, designing and testing code to meet requirements
  • Gains a thorough understanding of functional requirements for new software requests
  • Works with Business Systems Analysts to understand and clarify software requirements and translate into working software
  • Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products
  • Partners with software teams in the development of the software engineering processes
  • Works to identify and resolves technical or product problems
  • Participates in software project meetings and provides status reports
  • Maintains existing applications by enhancing software and troubleshooting issues
  • Collaborates with team members and partners with others as needed to ensure successful completion of assigned software development tasks
  • 7+ years of experience with Informatica Platform and knowledge of Informatica best practices for Informatica Power Center 9.6.1
  • Deep hands-on knowledge of Mappings, Workflows, and Applications
  • Understand reusability, parameterization, workflow design, ETL
  • Strong Informatica technical knowledge in the areas of Informatica Developer Components – Parser, Match, Comparison, Case Converter, labeler, Key Generator etc…
  • 5+ years of programming experience in PL/SQL and UNIX shell scripting
224

Data Warehouse / Quality Engineer Resume Examples & Samples

  • Ensures data quality between source system(s) and the data warehouse used for our BI product(s)
  • Provides feedback to and works closely with development team members to expand and maintain SQL scripts used in testing data quality for various types of testing
  • Writes and reviews test case scripts to validate ETL processes
  • Responsible for overall test integration for new features with existing processes to insure data integrity
  • Formulation of test strategies
  • Preparation of testing matrices such as test cases, user cases, RTM etc
  • Defect tracking
  • Working knowledge in UNIX/LINUX environment and running Cron Jobs
  • Knowledge on any Non Relational Database. Preferably RedShift or Vertica
225

Data Warehouse Solution Design Analyst Resume Examples & Samples

  • Understand key Ford Credit business domain’s data models and business process flows to identify their interaction with EDW/GDW
  • Collaborate with current MIS team members to build the documentation of the process and data flow of the various interaction from the source applications to the EDW/GDW
  • Work with the Architects, Business, IT, and Global Data Insight and Analytics (GDI&A) to ensure compliance with architecture standards, guidelines, blueprints, and roadmaps
  • Work with Data Architects (DAs) to define, create and modify EDW/GDW data models
  • Work with Business teams (Central Information Group (CIG) and Analytics) to understand business requirements for Enterprise Program Management (EPM) projects/enhancements with emphasis on changes to EDW/GDW data models
  • Work with project teams or complex programs to analyze and translate desired business capabilities into solution concepts and models to deliver business value
  • Create Solution Design for both ETL (Extract, Transform and Load) and Reporting needs for the Data Warehouse which utilize multiple platform components including Teradata, Oracle, MS SQL Server, DB2, Mainframe, Cobol, and Data stage
  • Follow iterative system development life cycle methodologies (e.g. EPM and USDM/Agile)
  • Must be flexible to respond to changing priorities
  • Adhere to all Ford/Ford Credit processes, tools and methodologies
  • Adhere to all security and control, Sarbanes-Oxley, Application Control Review (ACR) updates and change control processes
  • Bachelor’s degree in IT or related technical field
  • 5+ years of Experience in Application and Solution Design
  • 5+ years of Experience in the implementation of complex IT solutions involving multiple interfaces
  • 5+ years of analytical experience of complex applications and data relationships
  • 5+ years of Experience with application design using Teradata, Oracle, SQL Server, Datastage, Mainframe, Cobol, or DB2
  • 5+ years of Experience with SQL involving multiple, complex queries
  • 3+ years of Experience with prioritizing changes requests and incidents to manage workload of the team
  • 3+ years of Experience in obtaining and understanding business requirements
  • 3+ years of Experience in creating technical specification as well as creating and executing detailed test plans
  • Knowledge of IT policy, corporate directives, data privacy implications, and architecture standards
  • Experience managing an ETL design team
  • Experience with financial business functions
  • Experience with security and controls, Business Continuity, and Disaster Recovery planning
  • Strong written/oral communication and interpersonal skills
  • Excellent analytical, problem-solving and planning skills
  • Ability to have strong drive for results and ability to work independently
  • Demonstrated commitment to quality and project timing
  • Demonstrated ability to document complex systems
  • Demonstrated ability to multi-task and adjust resources/assignments based on changing priorities
226

Clinical Data Warehouse Management Analyst Resume Examples & Samples

  • Three years’ experience in data management, preferably in a health care
  • Proficient in the use of Excel
  • Competent in managing and analyzing large amounts of data
  • Experience with data reporting and analytical programs
227

Azure Data Warehouse Platform Architect Resume Examples & Samples

  • Ensure our Azure BI and analytics platform is fully optimized for performance and stability
  • Ensures that BI solutions have an enterprise and strategic perspective and support strategies
  • Promotes high level BI enterprise architecture strategy
  • Review solution designs (ETL, Security, technology…) and approve or recommend options for improvement
  • Work with other architects (ETL, data, solution, security, storage, network, DB…) to ensure a fully integrated, supportable, extendable, scalable environment
  • Ensure platform standards and guidelines are adhered to
  • Ensure the platform performance is maintained
  • Ensure platform is kept current with new and appropriate technology
  • Ensure platform security architecture is in compliance and current
  • Ensure platform documentation is complete and current
  • Guide others in solution designs
  • Consult in requirements gathering sessions with business and technical staff to ensure platform BI and analytics features and functions are being used correctly and optimally
  • Collaborate with Quality Assurance and Data Development resources to debug defects or issues
  • Ensure production support has the right level of monitoring that allow proactive issues identification within our environment
  • Ensure we design for both internal and external accesses and PCs to smart devices
  • Has an enterprise approach to managing a cloud based BI and analytics environment. (e.g., good governance skills and experience with large DW required processed)
  • Solid experience with architecting large end to end cloud based BI and analytic environments
  • Has a very strong understanding (both breadth and depth )of the Azure BI and Analytic features and functions and the pros and cons of using certain features and functions
  • Demonstrated experience with data models, database design development, data profiling, and analysis tools
  • Demonstrates a rational and organized approach to the tasks undertaken and an awareness of the need to achieve quality
  • Demonstrates high standards of professional behavior in dealings with clients, colleagues and staff
  • Demonstrates the ability to take significant responsibility and shows skill in the management of change and can handle contacts of all types and at all levels
  • Is able to make sound and far reaching decisions alone on major issues and to take full responsibility for them on a technical or managerial basis
  • Is effective and persuasive in both written and oral communication
  • Minimum of 6 years’ experience with end to end architecting, designing, deploying and managing BI and Analytic Data Warehouse’s
  • At last 2-3 years’ experience with Azure BI platform and offerings
  • Experience with MS and or Tableau Metadata management
  • Experience with mobile devices: publishing and consuming interactively
  • Good understanding of Azure user authentication and implementation with enterprise security
  • Azure certifications are a major plus
  • MDM experience is a major plus
  • Must be currently eligible to work in the US for any employer without sponsorship
  • Must consent to and successfully clear all required pre-employment screenings
228

Data Warehouse Resume Examples & Samples

  • Bachelor’s degree required. Master degree in management / technology or related field or a combination of related experience and education a plus; 5-10 years working in insurance and/or technology preferred
  • Experience managing large scale programs or projects both in SDLC and Agile Scrum methodology
  • Minimum of 5 years of experience in large-scale and complex data warehousing solutions, production support, business intelligence, reporting, data analysis or other technology related field
  • Experience directly managing staff of entry- and senior-level analysts (business, systems, vended application, etc.), application developers, etc
  • Proven experience managing a matrix global teams
  • Demonstrated leadership skills; must be able to work directly with individuals at all levels of the company
  • Strong customer-service orientation that places high value on customer satisfaction
  • Analytical background with extremely strong problem solving and negotiation skills
  • Must demonstrate broad business knowledge and organizational awareness
  • Strong interpersonal collaboration and team skills including working with cross-functional teams to achieve shared goals
  • Strong verbal and written communication, facilitation, and interpersonal skills
  • Insurance and / or Financial Industry experience a plus
229

Data Warehouse Cloud Lead Resume Examples & Samples

  • Leads the technical architecture and design for a new Data platforms
  • Build new and innovative solutions that can help solve business and technical challenges
  • Build prototypes and Proofs-of-concept to validate ideas
  • Provide architecture and technology leadership across platform in Big Data and Cloud Data technologies
  • Help transition from our current Data Analytics infrastructure to a high performance, scalable analytics platform
  • Interacts and works directly with customer team members on projects and support issues
  • 6+ years’ experience in information technology in the data space
  • 3+ years minimum of demonstrable experience in a technical leadership role
  • Real time experience in Cloud Data Warehouse implementations
  • Strong Knowledge of Data Warehouse architecture and Data Integration concepts
  • Expertise in Informatica Power center and Informatica Cloud
  • Hands-on experience with major big data platforms and languages such as Hadoop, MapReduce, BigQuery, RedShift, Azure SQL DWH, Kinetica, Python, PHP, Ruby and/or R
230

Data Engineer, Data Warehouse Team Resume Examples & Samples

  • 5+ years experience working as an expert in Java and Python
  • 5+ years experience building batch and streaming data pipelines and proficiency with tools such as Spark, Airflow, and cloud-based data services like Google’s BigQuery, Dataproc, and Pub/Sub
  • 2+ years experience running and supporting a production enterprise-wide data platform
  • Experience with source control management tools, like Git and GitHub
  • Experience with automation, testing, build tools, and release engineering
  • Bachelors or Masters degree in Computer Science, software engineering, or a related field
  • Bonus: Working knowledge of machine learning
231

Senior Data Warehouse Application Developer Resume Examples & Samples

  • Design, develop and unit test data warehouse applications
  • Technical expert for designated technical areas such as programming languages, operating systems, databases and/or packaged systems
  • Works with cross functional team members to develop system and software designs
  • Ability to effectively problem solve and present information in one-on-one and small group situations to customers and other associates
  • 3 - 5 Years
  • Excellent written & verbal communication skills
  • Business acumen
  • Organizational abilities
232

Lead Data Warehouse Application Developer Resume Examples & Samples

  • Design, develop and unit test data warehouse applications and ETL processes in a large scale Hadoop environment
  • Work with cross-functional team members to recommend technical solutions and design options to business issues and/or system issues. Make technical recommendations for more efficient troubleshooting and issue resolution
  • Acts as code reviewer for other application developer output to enforce accepted programming standards and techniques
  • Applies generally accepted programming standards and techniques to assure efficient program logic, ETL, data manipulation, data modeling, and information presentation
  • 7 - 10 Years
  • 8+ years developing commercial grade applications with large scale deployments
  • Strong experience in current software engineering and solution delivery methodologies
  • Cross functional Retail/e-Commerce knowledge
  • Oracle 11g experience a plus
  • Netezza or Teradata experience a plus
  • Strong Interpersonal and client consultation skills
  • Strong presentation skills
  • Supervisory and leadership capabilities
  • Execution Skills
  • Project management knowledge
  • In depth analytical Skills
  • Superior organizational abilities
  • Process & Procedure Oriented
233

Devops / Data Warehouse Automation Resume Examples & Samples

  • Associate’s degree from a two-year college or technical school or equivalent combination of education and/or work related experience
  • Bachelor’s degree from a four-year college or university preferred
  • At least one of the following Operating System training/certifications preferred
  • Microsoft Certified System Administration or Engineer training/certifications
  • Current Unix/Linux Operating Syst4em training/certifications
  • Current VMWare training/certification
  • At least three years of computer systems analysis/network administration and user support. Linux system administration in a large distributed computing environment preferred
  • Experience working with provisioning software such as Salt, Ansible or Puppet preferred
  • Proficient with at least two of the common programming/scripting languages such as Python, Perl, PHP, C, C++, BASH
  • Experience with various flavors of Linux to include Scientific, CentOS, and Ubuntu preferred
  • Working knowledge of UNIX/Linux system administration, including NFS filesystems, Samba, Linux server configurations (including CentOS, Ubuntu), TCP/IP network, DNS, and DHCP, Remote Desktop, shell scripting preferred
  • Excellent attention to detail preferred
  • Strong multi-tasking, analytical and communication skills, including the ability to explain technical concepts to end-users and non-technical staff
  • Demonstrated strong proficiency using multiple hardware/software platforms and/or significant expertise in a particular technology
  • Demonstrated leadership skills preferred
  • May require weekend or evening hours and being on call 24 hours a day, seven days a week
  • Strong interpersonal skills, including the ability to effectively build relationships; promote, and work well in, a collaborative team environment; and influence others preferred
234

Medicaid Data Warehouse Business Analyst Resume Examples & Samples

  • Work closely with customers to gather business requirements and translate requirements clearly into accurate specifications for the configuration of large data warehouse systems
  • Use Application Lifecycle Management (ALM) tools such as DevSuite to develop traceability of requirements and test cases
  • Research MMIS managed care and fee for service policy to ensure system specifications are accurate to policy
  • Review deliverables and enforce the approval process of deliverables to ensure that quality assurance processes are strictly followed
  • Proven ability to work with customers, DBAs, ETL programmers, Business intelligence architects, and PMO staff in a collaborative manner
  • Demonstrated knowledge of the use of Application Lifecycle Management tools (such as Rational, HP, DevSuite)
  • Excellent communication and presentation skills with the ability to communicate complex technical concepts to business users in a clear and concise manner
  • Thorough understanding ICD-9, ICD-10, CPT-4, NDC and other medical coding standards
  • Business Intelligence experience with at least one of the following tools: Tableau, Cognos, Business Objects, MS Analysis Services, Hyperion, Oracle
  • Knowledge of Federal and State healthcare programs (i.e., Medicaid, CHIP) and related eligibility/enrollment principles, and claims data
  • Experience contributing to and managing the planning and execution activities for the following SDLC phases
  • Understanding of ETL tools including Informatica and business intelligence tools including Tableau
  • Understanding of relational & dimensional modeling
  • Understanding of HIPAA privacy & security rules
  • Knowledge of Medicaid payment policy and MMIS data
  • Knowledge of Agile and waterfall development techniques
235

Informatica Health Care Data Warehouse ETL Developer Resume Examples & Samples

  • Define Informatica workflow and mapping standards so development is consistent across all development resources (i.e., no hard coding, leverage of maplet, reuse concepts, etc.)
  • Conduct ETL optimization, troubleshooting and debugging
  • Design and develop test plans for ETL unit testing and integration testing
  • Tune and optimize ETL jobs for performance and throughput. Interact with data modelers and data base administrator on data architecture optimization for ETL performance
  • Provide development support, including walk through approvals, to other ETL application resources to insure that standards are followed and optimized workflow is implemented
  • Document and maintain operational procedures in the form of an operations manual for all ETL workflow
  • Lead troubleshooting efforts for ETL job issues related to pre-production and production
  • Leverage Informatica Data Quality as a mandatory process step for profiling data prior to downstream transformation
  • Design and develop data validation processes using Informatica Data Quality
  • Design and develop exception and error handling through data governance so that data stewardship is leveraged to assist with anomalies
  • 5+ years of experience with Informatica PowerCenter
  • 2+ years of experience with Master Data Management (MDM) concepts using any MDM tool
  • 1+ years of experience with Informatica Data Quality
  • 1+ years of experience with Informatica MDM
  • 1+ years of experience with Informatica Test Data Manager
  • 1+ years of experience of regulatory security requirements regarding HIPAA and other regulatory security requirements
  • 1+ years of experience with leading other ETL Developers
  • Must reside in / or be willing to reside or travel to our offices in Richmond, VA
  • Data Experience across Medicaid, Medicare, Exchange and commercial payer environments
  • Teradata experience
  • Experience with dealing with 837 transactions
  • Experience with Informatica Meta Manager
  • Knowledge of data modeling and Erwin
236

Financial Data Warehouse Functional Delivery Resume Examples & Samples

  • Teradata SQL
  • Ability to communicate with the business unit sponsors effectively
  • Ability to coordinate with various teams to deliver projects successfully
  • Working knowledge of agile development practices including Test Driven Development, continuous integration and SCRUM
  • Perl- Greenplum
  • DB2
  • MPP Data Modelling
  • Power Designer
  • Knowledge of Financial reporting and accounting
237

Senior Data Warehouse & Business Intelligence Developer Resume Examples & Samples

  • Responsible for leading hands on ETL development
  • Responsible for adhering to Agile development practices
  • Responsible for participating in the business requirements gathering process
  • Responsible for participating in architecture. data modeling, and overall design sessions
  • Responsible for working with testers to ensure quality data results
  • Assisting to help develop reports on various platforms
  • Responsible for ensuring daily ETL processes execute successfully
  • Responsible for leading hands on report and analytics development for a business critical ERP solution
  • Responsible for Tableau extract development
  • Responsible for production support
  • Responsible for creating and maintaining documentation
  • Three years of experience in a dedicated data warehouse or business intelligence development role with a bachelor’s degree or five years of equivalent experience in a dedicated data warehouse or business intelligence development role without a bachelor’s degree
  • Two or more years Data Warehousing, ETL Development with Tools such as SQL Server Integration Services or Informatica is a plus
  • Two or more years’ experience with Business Intelligence Tools such as Crystal Reports, SQL Server Reporting Services, Tableau, SQL Server Analysis Services (SSAS), or Business Objects is a plus
  • Two or more years’ experience with SQL Server or Oracle is a plus
  • Expert SQL skills
  • Understanding of dimensional models
  • Understanding of data warehousing philosophies and how to implement those philosophies
  • Experience working with Data Warehousing Appliances such as Netezza or TeraData is a plus
  • Experience leading projects and reporting project statuses
  • Experience working with Financial data and calculations
  • Experience with Enterprise ERP System Functionality (GL, AP, AR)
  • Experience working with various programming languages: C#, Java, etc. is a plus
  • Experience in the Manufacturing Industry is a plus
  • Experience with Lawson M3 and/or IBM DB2 are a plus
238

Data Warehouse Modeler Resume Examples & Samples

  • Experience working in a Sr. Data Modeler or Data Architect capacity with hands on experience in SQL based Data Analysis, as well as extensive background in data modeling and data warehousing
  • Understand the data requirements for the project and drive the solution based on the information needs
  • Adhere to Data Model and Data Architecture Best Practices
  • Requires solid knowledge about ETL, data architecture, data modeling and Software Development Lifecycles
  • Ability to explain complex data challenges to business users and work in cross-functional team environment
  • Performs other duties & responsibilities as required or assigned by supervisor
  • O Adhering to and complying with all applicable, federal and state laws, regulations and guidance, including those related to Anti-Money Laundering (i.e. Bank Secrecy Act, USA PATRIOT Act, etc.)
  • 10+ years of experience working in a Sr. Data Modeler or Data Architect capacity with hands on experience in SQL Server or related databases, as well as extensive background in data modeling and data warehousing
  • Understanding of star/snowflake schemas, indexing, aggregate tables, dimension tables, constraints, keys, and fact tables required
  • Technical expertise regarding data models, database design development, data mining and segmentation techniques
  • Strong knowledge of and experience with ETL frameworks and reporting packages, databases, SQL programming
  • Ability to understand the implications & understand how the data will be used in upstream/downstream applications and accordingly guide the team on logical / physical models
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Adept at queries, identifying errors in data and presenting findings
  • Data warehousing expertise/tools: Data Marts/ Materialized Views/Star Schema, Erwin
  • Furthers the Bank’s culture and values
239

Data Warehouse Production Support Lead Resume Examples & Samples

  • The Team Leader will serve as the escalation point for major incidents and representation of the Data Warehouse team to key business stakeholders, partners and vendors
  • The Team Leader will provide guidance on production support of the Data Warehouse ETL jobs internally to the team and externally to other business groups in the Bank. The Lead will assign work responsibilities to the production support team
  • Experience in a Data Warehouse 24x7 support environment with exposure to database and ETL technologies
  • Experience partnering with development, QA and release management teams on ETL code development handoff and production release management activities
  • Must have experience with managing onsite/offshore and FTE resources
  • Adhere to ETL/Data Warehouse Standards and process and procedures
  • Identifies and escalates any issues requiring Management assistance for effective resolution
  • Ensures operational procedures are documented for execution consistency, relevancy, and auditability
  • Contributes to annual reviews of team members and provides input to Management on focus of review conversations
  • Responsible for documentation for Data Warehouse and Control-M Runbooks, Technical Specifications, Production Support, Root Cause Analysis for ETL jobs and end user communications
  • Excellent written and oral communication skills and the ability to interact positively with end-users, vendors, and management on a daily basis
  • Knowledge and prior work experience in Banking or related financial services is a plus
  • Strong interpersonal and organizational skills and the ability to direct teams in the work environment
  • Perform duties & responsibilities specific to department functions & activities
  • Adhering to and complying with the applicable, federal and state laws, regulations and guidance, including those related to Anti-Money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.)
  • Adhering to Bank policies and procedures
  • Completing required training
  • Identifying and reporting suspicious activity to the AML Officer
  • 7+ Years of MS SQL Server Database Development and/or 7+ Years of Oracle Database experience
  • 7+ Years of MS SSIS experience and SQL Server Management Studio and/or 7+ Years of Informatica PowerCenter hands on experience
  • 7+ Years of Data Warehousing experience
  • 3-5 years working on production support process improvement strategies including monitoring and alerting, effective status updates, measurement and reporting analysis in order to implement long-term solutions that resolve issues and achieve targeted outcomes and benefits
  • 3-5 years of production support optimization including cost reduction, minimizing system disruptions and upgrades/enhancements
  • 3-5 years production support experience generating metrics; from definition to data collection through data analysis
  • Experience with VLDB's
  • Experience with change management, SDLC, ITIL, PagerDuty, DNS, Windows, Linux and with problems and incident process and procedures
  • Experience with production support in a 24x7 capacity and the ability to work competently under stressful conditions, which may arise periodically in the environment. Ability to work extended hours as work situations dictate and act as escalation point for issues
240

Developer for the SAP Hana Data Warehouse Foundation Team Resume Examples & Samples

  • Developing HANA XS Advanced based services and functionality for Big Data Warehousing and Data Management
  • Assist in the product development process by supporting CI related tasks and by taking over responsibility for product standards
  • Customer-centric and demand-driven project-based development
  • Close cooperation with the other Big Data Warehousing teams
  • Alignment and cooperation with HANA engine teams
  • Deep understanding of the architecture and strengths of the HANA engine(s)
  • Maintain and support the customers using HANA as Data Warehousing and Data Management platform
  • Ideally programming experience in JavaScript, SQL Script
  • Ideally HANA and XS Advanced engine experience
  • Familiar with the concept of the XSA architecture and the deployment processes behind it
  • Familiar with Continuous Integration tools such as Jenkins and GitHub
  • Ideally familiar with the concepts of Data Lifecycle Manager and with technologies such as Hadoop, Dynamic Tiering, Sybase IQ and HANA Vora
  • Fluency in written and oral German and English
  • Ability to work in a team of experienced colleagues
  • Analytical and communication skills
  • Familiar with Data Warehousing concepts, HANA & Hadoop technology and trends
  • Experienced in the usage of Jenkins as a CI tool
  • Good knowledge of Git & GitHub
241

Admn Data Warehouse Resume Examples & Samples

  • 4+ years experience gathering, understanding, and documenting business reporting requirements for complex data warehouse solutions for deployment using InfoSphere products including: Information Data Architect, Datastage, Quality Stage, Business Glossary, Information Analyzer, and FastTrack in a Data Warehouse environment
  • 4+ years quality assurance experience in a data warehouse environment working directly with business users
  • 4+ years experience gathering and documenting testing requirements working directly with business users
  • 4+ years experience defining data quality procedures, supporting data governance procedures, defining/following data security policies, and supporting master data management strategies using appropriate tools
242

Greenplum Data Warehouse / Administrator Resume Examples & Samples

  • Experience in Greenplum Database 4.2 or higher
  • Greenplum database administration including installation of Greenplum database software, configuration, troubleshooting , database object creation, routine maintenance tasks
  • Greenplum performance monitoring and troubleshooting
  • Familiarity with Postgres database
  • Greenplum Database Design
  • Greenplum Command Center
  • Greenplum Workload Management
  • Greenplum Query Tuning
  • Experience with Greenplum Data Loading using gpload/external tables
  • Experience in working with EMC/Pivotal Support
  • Experience with Production Support and working on shifts/on-call rotation
  • Proficiency in Unix OS and shell/perl/python scripting
243

Data Warehouse / IT Business Analyst Resume Examples & Samples

  • 4+ years as a business analyst
  • Ability to work well with business users to gather requirements
  • Ability to interpret business needs and translate those needs affectively to the Data Warehouse development staff
  • Experience with SQL and relational database query – Oracle preferred
  • Ability to investigate and analyze information and to draw conclusions
  • Experience working in Business Analysis area for IT projects
  • Ability to independently query transactional and Data Warehouse databases
  • Excellent documentation and analytical skills
  • Experience with Health care, Health Insurance and/or Medicaid
  • Experience with data quality and remediation, data flows and mapping, or comparable experience (system or Data conversions, for example)
244

Data Warehouse Admin Resume Examples & Samples

  • Minimum of 2 years college coursework
  • 4 years’ experience designing & developing complex solutions utilizing InfoSphere Information Server version 8.5 products including: Datastage, Quality Stage, Business Glossary, Information Analyzer, Metadata Workbench, Information Services Director, Blueprint Director, Fast Track, and Optim in a Data Warehouse environment
  • 4 years’ experience with Relational Databases and SQL Query language DB2; Oracle also preferred. 4+ years’ experience translating source and target models into detailed technical specifications and participating in reviewing technical specifications and developed solutions
  • 4 years’ experience translating source and target models into detailed technical specifications and participating in reviewing technical specifications and developed solutions
  • Support and Maintenance
245

Data Warehouse Resume Examples & Samples

  • Work on all phases of the software development life cycle from requirements analysis, design, coding to acceptance testing and documentation
  • Working on any of these phases for the Division of Educational Informatics projects as needed
  • Innovation and exploration of new technologies is also fundamental to the position
  • Proficiency in SQL required
  • Professional experience with ETL concepts and processes required
  • Knowledge of Query tuning and use of query hints & indexes preferred
  • Strong knowledge of data visualization techniques and dashboard design preferred
  • Professional Experience building dashboards using Tableau or similar BI tools preferred
  • Business Intelligence (BI) experience including
  • Data Warehousing concepts
  • Data Modeling concepts
  • Database Design
246

Developer, Data Warehouse Resume Examples & Samples

  • Must have deep expertise (2-5 years) in data warehouse and data mart development, data integration techniques, star/dimensional schemas. Hands-on expertise in developing ETL/ELT based programs across heterogeneous sources and targets
  • Must have at least 4-6 project implementations building data warehouses/data marts where he/she will show demonstrated expertise in engaging with business/technical stakeholders to understand business stakeholders, translate to technical requirements, build Source to target mapping documents, develop and test the ETL/ELT routines and support user acceptance testing
  • Must have demonstrated experience developing business intelligence reporting tools metadata and reports (at least 2-3 years) preferably using IBI Webfocus, atleast 2 projects implementations experience. Also demonstrated experience in IBI tool administration, performance tuning techniques at server and metadata level
  • Must have excellent written and spoken communication skills and ability to engage with teams who may be remote
  • Nice to have experience in data modeling (normalized, dimensional), data architecture, reference and master data management
  • Nice to have Healthcare experience
  • Technology Must haves -, Microsoft SQL server, T-SQL, Stored procedures, SSIS
  • Technology Nice to have - IBI Webfocus or any leading BI reporting tool, Microsoft APS, Hadoop
  • 5+ years of experience as a ETL/ELT developer
  • 3+ years of experience developing Data Marts/Data warehouses
  • 2+ years of experience as a Report/BI Metadata developer
247

Data Warehouse / Database Developer Resume Examples & Samples

  • Design, develop, and maintain databases for large scale enterprise applications using cutting-edge software application tools
  • Design and develop high performance and high availability applications, reports, and systems to meet the Company’s strategic objectives
  • Integrate databases with other information systems, such as Enterprise Resource Planning (ERP) or Customer Relationship Management (CRM) systems, including cloud-based services
  • Develop and modify database objects such as stored procedures, triggers, views, and ad-hoc queries as part of project implementation
  • Works with the leadership of the functional team in assessing requirements and providing technical assistance for architecting, executing and developing the right database architecture
  • Incorporate commercial off the shelf (COTS) solutions with an organization’s internally created software solutions and legacy IT systems
  • Ability around database modeling, optimization, modernization, and performance improvement
  • Participate with a project team to develop and implement databases, and manage, monitor, troubleshoot, and tune database performance
  • Collaborate with Application Developers, Database Administrator’s (DBAs), Quality Assurance, System Analysts, and Product Owners
  • Proven experience with data modeling – OLAP & OLTP
  • Participate in design and code reviews, following coding, documentation and design standards
  • May participate in multiple projects simultaneously as a senior development team member
  • Stay current with rapidly changing technology, industry best practices, and apply it to business needs
  • Team player who is willing to jump in and make things happen
  • Working knowledge of various report formats, integration of graphics, advanced formatting of reports and use of multiple data sources
  • Adhere to all established procedures, policies, and safety rules as outlined by the Company
  • Work 40 hours/week; some overtime may be required including nights, weekends and holidays as needed
  • Work schedule will typically reflect normal business hours, but may require occasional flexibility as required by projects and business demands, including occasional on-call shifts
  • Experience in 3-tiered applications, enterprise architecture, or Service Oriented Architecture (SOA) design
  • Bachelor’s in Computer Science or equivalent experience
  • In-depth understanding of database design principles
  • Proficient knowledge of data warehouses technologies and design methodologies
  • Familiarity with inventory supply chain and fulfillment, e-commerce sales, or financials beneficial
  • Knowledge of performance tuning on databases, indexing, replication and clustering, and writing stored procedures
  • Working knowledge of SQL Server 2014, documented databases (MongoDB) or Big Data technologies (Hadoop), a plus
  • Greenfield experience in data warehouse or integration projects
  • Possess extensive experience with Transact-SQL
  • Experience with ETL - Data Services and SSIS
  • Experience with SAP systems including table structure and field definitions and usage
  • Experience with data structures from custom-built systems (i.e. web front-end systems)
  • Ability to clearly interpret business requirements into efficient code and communicate results
  • Ability to effectively communicate technical information to both technical and non-technical personnel
  • Strong analytical and problem-solving skills
  • Strong interpersonal skills with the ability to work effectively as part of a project or program team and foster team cooperation
  • Understanding of the Agile/Scrum project management process
  • Ability to perform multiple tasks at one time
  • Work is generally sedentary in nature, but may require standing and walking up to 10% of the time
  • Ability to work at a computer station and view a computer screen for extended periods of time
  • Ability to frequently read, comprehend, write, perform basic mathematic calculations, communicate orally, and reason and analyze
248

Data Warehouse Business Analyst Resume Examples & Samples

  • Gather and analyze business requirements, while leveraging knowledge of healthcare and clinical systems and data
  • Analyze new data sources of health claims, member, clinical, and financial data for integration into existing data models
  • Collaborate with QA and development teams to ensure a high level of data integrity and quality for processes involving large volumes of data
  • Understand the business and how various data elements and subject areas are utilized in order to develop and deliver data dictionaries, data mappings and user-friendly metadata documentation
  • 2+ years of full Business and Systems Analysis experience
  • 2+ years of professional IT experience in a large, enterprise environment
  • Knowledge of SDLC processes, roles, responsibilities and deliverables
  • Data Warehouse and / or Data Modeling / Architect experience
  • Metadata management experience
  • Excellent interpersonal, verbal and written communications skills
249

Senior Data Warehouse Solution Architect Resume Examples & Samples

  • Responsibility for the overall design of the application and ownership of the architectural vision of the solution
  • Responsibility for the development of key common frameworks/functions
  • Evaluate design alternatives and perform cost benefit analyses
  • Manage the solution architecture decision process within the program
  • Responsibility for creating of the overall system architecture models for the program
  • Ensure alignment to the departmental architecture and the enterprise architecture within the bank
  • Document existing solutions
  • Experience in designing a data warehouse solution
  • Experience in Oracle (SQL and PL-SQL) and ETL
  • Experience in KSH scripting
  • Very good English language skills
  • Ability to work within a fast pace environment with regulatory deadlines
  • 5+ year experience as a solution architect in the financial services industry
  • Experience in architecting solutions within an agile project / program
  • Experience in data modelling and UML design
  • Willingness to explore new technologies like big data, in memory data bases etc
250

Senior Analyst / Data Warehouse & Mining Resume Examples & Samples

  • Manage development and delivery of data to new consumer centric health informatics applications
  • Create API enabled digital assets to be leveraged by web, mobile and internal CRM applications
  • Develop data specific artifacts to support simplified navigation of healthcare environment
  • Lead efforts to create and deliver data/information which is personalized to each member and anticipates needs
  • Develop data sources which support the creation of member centric “recommendations” for informatics applications
  • Lead cross-divisional project teams in the implementation of data driven projects for consumers, providers and accounts
  • Provide data delivery expertise to our customers
  • Provide support for operational reporting of data warehouse metrics
  • Lead teams to identify, recommend, and implement system enhancements to the data warehousing environment and related BCBSMA systems to improve customer satisfaction and BCBSMA processing efficiencies
  • Act as liaison with other business areas to assist them in the data definitions required for successful project implementation
  • Foster an environment of openness, trust, and acceptance in dealing with all BCBSMA associates, leaders, and customers (internal and external)
  • Possess excellent analytical, problem resolution, and risk management skills in data design and modeling skills with a concentration on practical implementation/applicationManage development of enterprise analytics applications supporting financial, clinical and operational reporting areas