DATA ANALYST

EverIT Solutions Limited
Solihull, United Kingdom
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
£ 31K

Job location

Solihull, United Kingdom

Tech stack

Microsoft Windows
Agile Methodologies
Unix
Databases
Continuous Integration
ETL
Data Mapping
Data Warehousing
Relational Databases
Database Queries
Document-Oriented Databases
Metadata
Object-Oriented Software Development
Oracle
Oracle Applications
Oracle SQL Developer
Red Hat Enterprise Linux - RHEL
Software Engineering
XML
Test Driven Development
Informatica Powercenter
React

Requirements

  • 3-5 years of experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager

  • Experience in administration and configuration of Informatica PowerCenter Server in Windows and Unix using Admin Console and Metadata Manager

  • Experience with Unix/Linux (Specifically, RHEL)

  • Experience in backup repository and implementation migration to different environments

  • Experience in Informatica Velocity proven methodology and ETL industry standards

  • Troubleshoot and perform tune existing ETL solutions; Competent to work at the highest technical level of all phases of data warehouse systems analysis/programming activities

  • Experience as database developer on data warehousing/database projects

  • Experience using Oracle PL/SQL

  • Work with Business Analysts and Data Modelers to understand requirements

  • Design and develop sustainable database ETL applications to support those requirements

  • Create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules

  • Informatica Administration/Troubleshooting * React to and correct day-to-day operational errors.

  • Experience with Object-Oriented methodologies, Test-First Development, Continuous Integration, and Agile Development processes

  • Strong SQL skills with the ability to tune and optimize complex queries

  • Experience with Unix/Linux (Specifically RHEL)

  • Experience in software development using Oracle and XML

  • Relational databases (Oracle 11g)

  • Experience at physical database modeling, * Bachelor's degree in a related discipline or equivalent work experience.

  • Be able to communicate fluently

  • Experience: 3 to 5 years

Apply for this position