Informatica ETL Developer

Capco is a global technology and business consultancy, focused on the financial services sector. We are passionate about helping our clients succeed in an ever-changing industry.

We are/have:

  • Experts in banking and payments, capital markets and wealth and asset management
  • Deep knowledge in financial services offering, including e.g. Finance, Risk and Compliance, Financial Crime, Core Banking etc.
  • Committed to growing our business and hiring the best talent to help us get there
  • Focused on maintaining our nimble, agile and entrepreneurial culture

Why Join Capco?

You will work on engaging projects with some of the largest banks in the world, on projects that will transform the financial services industry.

We offer:

  • A work culture focused on innovation and building lasting value for our clients and employees
  • Ongoing learning opportunities to help you acquire new skills or deepen existing expertise
  • A flat, non-hierarchical structure that will enable you to work with senior partners and directly with clients
  • A diverse, inclusive, meritocratic culture

As a ETL Developer at Capco you will be working with consulting teams for the world’s largest financial services firms.

Job Description

This role provides regulatory data analytics using data from different geography. The primary responsibilities would be:

  • Prepare Data model for Risk and Finance Data
  • Support Source to Target transformation team(ETL)
  • Coordinate with Data analysis team to prepare Logical data model & Conceptual data model
  • Prepare physical data model
  • Perform model creation for large set of data which are being sourced to Big Data


·         Expert in ETL (Extract Transform Load) development

·         Hands on experience in Big Data, HIVE, Pentaho (ETL Tool) architecture

·         Data Extraction from Teradata, HIVE, Oracle, and Flat files

·         Experience in Creating Mappings, Mapplets, and Transformations for loading Target tables



  • The successful candidate is expected to have a good working knowledge and delivery experience preferably within a Banking MI and Data Risk systems environment.
  • Demonstrated ability to multi-task and work independently, as well as work collaboratively with other teams, some of which may be geographically distributed.
  • Proven problem solving and analytical abilities including the ability to critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details and apply sound business and technical domain knowledge.
  • Knowledge of the reporting approaches to Risk Management Information.
  • Experience of large global system infrastructure projects a business change environment and good understanding of data infrastructure and architecture would be an advantage. The latter may include exposure to solution or enterprise architecture.
  • Experience of process re-engineering and process management.
  • Knowledge of BCBS239, IFRS-9, Stress Testing or experience of any other Banking regulatory environment is a big plus.
  • Communicate openly and honestly. Advanced oral, written and visual communication and presentation skills - the ability to communicate efficiently at a global level is paramount.
  • Ability to deliver materials of the highest quality to management against tight deadlines.
  • Ability to work effectively under pressure with competing and rapidly changing priorities


Apply for this Job

* Required

Capco Demographics Questionnaire

Individuals seeking employment at Capco are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

I identify my gender as (Select one)