Senior ETL Developer

BNP Paribas   •  

Tempe, AZ

Industry: Accounting, Finance & Insurance

  •  

8 - 10 years

Posted 71 days ago

This job is no longer available.

Job Description Summary


Perform full SDLC life cycle work, including analysis, design, development, enhancement, testing, maintenance and technical support for this project.

• Design, implement, automate and maintain large scale enterprise data ETLprocesses.• Evaluate the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies• Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members.• Develop ETLprocesses 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 ETLarchitecture 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 ETLdevelopers; providing mentoring, technical assistance,troubleshooting and alternative development solutions.• Perform performance tuning and work end-to-end lifecycle using Enterprise wide data warehouse.

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 and Informatica Developer • 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. *LI-IB1

Requirements and Responsibilities:

• Experience with designing, developing, testing, andsupporting applications.• Detailed understanding of Informatica Power center Components 9.x• Expertiseworking with different kinds of sources - XML, flat files, Web services etc.• Goodexperience 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 IDQpreferred.• Good knowledge on Informatica Data Services (IDS), Informatica Analyst and Informatica Developer• Data mappingexperience - 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.

Qualifications:

• Bachelor's degree in a technical field such as computer science, computer engineering or related field required • Minimum 8 years of overall IT experience • 6-8 years overall Informatica, Data Warehousing and Business Intelligence experience. • Desired experience in IDQ (Informatica Data Quality) • Expert knowledge of relational databases, flat files and non-relational database structures. • 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 SQL/PL SQL skills. • Strong Unix /Shell scripting skills • Scripting languages like Python is desired.

REF: 041457