The bank for a changing world

We are looking for

BOW - Sr. ETL Developer/Tech Lead

Apply REF: TRA000964


About BNP Paribas Group:

Worldwide, BNP Paribas has a presence in 74 countries with more than 190,000 employees. It has key positions in its three main activities: Domestic Markets and International Financial Services (whose retail-banking networks and financial services are covered by Retail Banking & Services) and Corporate & Institutional Banking, which serves two client franchises: corporate clients and institutional investors. In Asia Pacific, BNP Paribas is one of the best-positioned international financial institutions with an uninterrupted presence since 1860. Currently with over 15,000 employees* and a presence in 14 markets, it provides clients with product and service solutions tailored to their specific needs, and continues to develop its franchise in the region.



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:

Tech Lead

Date:

05/27/2019

Department:

Bank of the West IT

Location:

Mumbai

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

·           6 - 9 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.

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 7 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 7 yearsSchedule: Full-time Behavioural competency: Decision Making, Ability to collaborate / TeamworkTransversal competency: Analytical Ability, Ability to understand, explain and support change