Senior ETL Developer

BNP Paribas   •  

San Ramon, CA

Industry: Financial Services


5 - 7 years

Posted 395 days ago

What sets Bank of the West apart from other banks is our team members–they embody the optimistic spirit of the West. There is a spirit here that drives us to do more. Our team of more than 10,000 employees is vital to the success of our Bank. They reflect our modern western values—straightforward, entrepreneurial and optimistic. We seek to create a corporate culture that fosters and rewards excellence, encourages creative thinking and respects diversity – an environment where team members are engaged, supportive of one another and enthusiastic about serving our customers. Bank of the West offers the stability of a company that has a 135 year history and is part of BNP Paribas, a European leader in global banking and financial services and one of the 6 strongest banks in the world. We offer opportunities across our diverse business lines – Retail Banking, Commercial Banking, National Finance, and Wealth Management.

Essential Job Functions
• Perform full SDLC life cycle work, including analysis, design, development, enhancement, testing, maintenance and technical support for this project
• Manage development and testing tasks and ensuring adherence to previously agreed to timelines communicating status
• Evaluate the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies
• Counsel team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit
• Apply 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
• Develop ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
• Implement data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets
• Enterprise-level ETL development and ETL architecture using Informatica and understanding/ using the COBOL file structures
• Work on Oracle Database using SQL and PL/SQL
• Work on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor
• Perform data analysis, data mapping, data loading, and data validation; reusability, parameterization, workflow design, etc.
• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
• Perform performance tuning and work end-to-end lifecycle using Enterprise wide data warehouse



·    Bachelor’s Degree  - Required

·    5 years


Requirements and Responsibilities:
 • Experience with designing, developing, testing, and supporting applications
 • Detailed understanding of Informatica Power center Components 9.x
 • Expertise working with different kinds of sources - XML, flat files, Web services etc.
 • Good experience in Unix Scripting
 • Excellent Understanding of Oracle, Microsoft Sqlserver. Need to be able to write complex queries with ease & Performance tuning
 • Excellent data analysis and debugging
 • Exposure IDQ preferred
 • Good knowledge on Informatica Data Services (IDS)
 • Informatica Analyst
 • Informatica Developer
 • Experience developing web services-based applications or applications that interact with SOA
 • Data mapping experience - mapping data sources to and from multiple applications
 • Design, develop and implement data feeds and transformations with minimal to no guidance
 • Team Player with excellent collaborative skills
 • Minimum 6 years’ experience in Data Warehousing and Business Intelligence
 • Minimum 6 years overall Informatica experience
 • Desired experience in IDQ (Informatica Data Quality)
 • Strong experience in developing Informatica mappings and reusable components.
 • Strong knowledge of data warehousing concepts
 • Understand Logical and Physical data modeling best practices and techniques
 • Experience in developing slowly changing dimensions, error handling and performance tuning
 • Strong Data Analysis skills
 • Strong Oracle skills