Informatica Developer/Senior Developer

Job Description

About BNP Paribas Group:BNP Paribas is a top-ranking bank in Europe with an international profile. It operates in 71 countries and has almost 199 000 employees. The Group ranks highly in its three core areas of activity: Domestic Markets and International Financial Services (whose retail banking networks and financial services are grouped together under Retail Banking & Services) and Corporate & Institutional Banking, centred on corporate and institutional clients. The Group helps all of its clients (retail, associations, businesses, SMEs, large corporates and institutional) to implement their projects by providing them with services in financing, investment, savings and protection. In its Corporate & Institutional Banking and International Financial Services activities, BNP Paribas enjoys leading positions in Europe, a strong presence in the Americas and has a solid and fast-growing network in the Asia/Pacific region..About BNP Paribas India Solutions:Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, a leading bank in Europe with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 6000 employees, to provide support and develop best-in-class solutions. 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 developerDate:9 Oct 2020Department:Bank of the West ITLocation:MumbaiBusiness Line / Function:BOTW Enterprise Data ServicesReports to: (Direct) -----Grade: (if applicable)NA (Functional) Number of Direct Reports:NADirectorship / Registration:NAPosition 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 ResponsibilitiesDoes 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 PC, 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 - 7 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 drivenCommunication skills - oral & writtenAdaptabilityClient focusedTransversal Skills: (Please select up to 5 skills)Analytical AbilityAbility to understand, explain and support changeAbility to anticipate business / strategic evolutionChoose an item.Choose an item.Education Level: Bachelor Degree or equivalent Experience Level At least 3 years Other/Specific Qualifications (if required), *

Keyskills :
big datasqldata mappingglobal deliverymappingdata qualityunixsql serverdata analysisretail bankingetlenterprise datadata loadingdata serviceslife cyclecomputer sciencedata cleansinginformatica