The bank for a changing world

We are looking for

BOW - Informatica developer

Apply REF: BNP018320

   

 

 

About BNP Paribas Group:

 

  

“BNP Paribas Group is a leading European bank with a strong global footprint across 72 markets and more than 202,000 employees. The Group provides corporates, institutional and private investors with product and service solutions tailored to their specific needs. It offers a wide range of financial services covering corporate & institutional banking, wealth management, asset management, insurance, as well as retail banking and consumer financing through strategic partnerships”.

.

 

 

 

About BNP Paribas India Solutions:

 

 

Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas Group, a leading bank in Europe with an international reach. With delivery centers located in Mumbai and Chennai, we are a 24x7 global delivery center. We partner various business lines of BNP Paribas such as Corporate and Institutional Banking, Wealth Management, Retail Banking through three verticals - Information Technology, Operations and Finance Shared Services.

 

 

 

About Businessline/Function :

 

 

Bank of the West is seeking a qualified and motivated candidate to be responsible for proper ETL development, standards and best practices, collaborating with existing ETL resources to set cutting edge industry standards.

 

 

 

Job Title:

 

 

 

Informatica developer

 

 

Date:

 

 

 

11/18/2019

 

 

Department:

 

 

 

Bank of the West IT

 

 

Location:

 

 

Mumbai/ Chennai

 

 

Business Line / Function:

 

 

BOTW – Enterprise Data Services

 

 

 

Reports to:

 

(Direct)

 

 

-----

 

 

Grade:

 

(if applicable)

 

 

NA

 

 

(Functional)

 

 

 

 

Number of Direct Reports:

 

 

NA

 

 

Directorship / Registration:

 

 

NA

 

 

 

 

 

Position Purpose

 

 

Bank of the West is seeking a qualified and motivated candidate to be responsible for proper ETL development, standards and best practices, collaborating with existing ETL resources to set cutting edge industry standards.

 

 

Responsibilities

 

 

 

Direct Responsibilities

 

 

 

·         Does development and testing tasks, ensures adherence to agreed timelines, and 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

 

 

 

 

 

Technical & Behavioral Competencies

 

 

·  3 - 5 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.

 

·         Big date experience or Big data certification is a plus

·          

 

 

Specific Qualifications (if required)

 

 

 

·         Bachelor’s Degree in Computer Science or related field required

 

·         Good knowledge of analytical and logical conceptual level programming skills

 

·         Data analysis, data mapping, data loading, and data validation.

 

·         Understand reusability, parameterization, workflow design, etc.

 

·         Support other ETL developers; 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

 

        

 

 

 

 

Skills Referential

 

 

Behavioural Skills: (Please select up to 4 skills)

 

 

Ability to deliver / Results driven

 

 

Communication skills - oral & written

 

 

Adaptability

 

 

Client focused

 

 

Transversal Skills: (Please select up to 5 skills)

 

 

 

 

Analytical Ability

 

 

Ability to understand, explain and support change

 

 

Ability to anticipate business / strategic evolution

 

 

Choose an item.

 

 

Choose an item.

 

 

Education Level:

 

 

Bachelor Degree or equivalent

 

 

Experience Level

 

 

At least 3 years

 

 

Other/Specific Qualifications (if required)

 

 

 

 

 

 

 

 


   

Primary Location: IN-MH-MumbaiJob Type: Standard / PermanentJob: INFORMATION TECHNOLOGYEducation Level: Bachelor Degree or equivalent (>= 3 years)Experience Level: At least 3 yearsSchedule: Full-time Behavioural competency: Decision Making, Ability to collaborate / TeamworkTransversal competency: Analytical Ability, Ability to understand, explain and support change