Software Systems

Letterkenny Co Donegal


Pramerica is seeking an experienced Informatica Developer to support establishing an Informatica Centre of Excellence. The selected candidate will be responsible for creating and managing ETL processes that load data from various sources into relational/non-relational targets including Mainframe data sets. Also participating in design, development, testing, execution and quality assurance of both automated and manual data integration and exchange processes using various Informatica tools. This is an exciting opportunity which will involve working closely with wide range of professions across the organization to implement the overall data strategy.

Job responsibilities:

  • Design and develop enterprise ETL solutions using Informatica Velocity methodology
  • Coordinate activities with data source application owners to ensure integration, data integrity and data quality
  • Translate business requirements into ETL designs, mapping specifications, Test scenarios and validations
  • Defining and converting Business rules into ETL processes
  • Create robust and high-performing ETL mappings using Informatica PowerCenter and other Informatica tools
  • Provide technical knowledge support to the team
  • Implementing technology improvements to our Data integration environment
  • Contributing to technical and process flow documentation
  • Contribute to the establishment of a COE by defining standards/guidelines/practices
  • Implement solutions in alignment with strategic vision

Position requirement and Education:

Essential Skills

  • Minimum of a Bachelor's degree in Computer Science, Engineering, or equivalent required
  • 5-8 years of ETL development experience 
  • In-depth knowledge of all Informatica transformations, mapplets, variables, workflow creation, incremental logic and error management
  • Experience with optimization or performance tuning of ETL Jobs, SQL, PL/SQL
  • Experience in developing Informatica ETL mappings to load data from different source systems into relational/non-relational targets including Mainframe data sets
  • Developing and executing scripts on UNIX/Linux platforms
  • Proactively monitor jobs with good debugging skills
  • Experience with Agile environment
  • Experience in Informatica Velocity: Informatica Best Practices & Methodology
  • Interacting with business partners in the US

Desired Profile

  • A person who continually researches and stays ahead of what is latest and greatest out there
  • Experience with Continuous Integration tools like Jenkins, SVN/Bitbucket are important
  • Exposure to SQL DB, No SQL DB, Big Data, Pentaho, Data streaming, Unstructured data is an advantage
  • The candidate must have excellent verbal and written communication skills, and be able to work independently and in a team environment
  • Candidate must have the ability to manage multiple project tasks simultaneously while managing all maintenance and support tasks.
  • Experience with financial services applications preferred
  • Proven ability to turn complex design challenges into elegant solutions and understand the need to solve both business and user problems