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














Bank of the West IT






Mumbai/ Chennai



Business Line / Function:



BOTW – Enterprise Data Services




Reports to:










(if applicable)











Number of Direct Reports:






Directorship / Registration:









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.







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






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