- Responsible for Informatica ETL and Data Quality (DQ) development and implementations.
- Mentor junior staff on all IT Transversal Function activities including CMMi, business analysis and project management
- Manage/drive client projects as needed, including those spanning multiple ITO TF teams and other BNP Paribas branches.
- Create and maintain detailed technical documentation on developments
- Consult with users, management, and technical personnel to clarify and validate business requirements.
- Design innovative ETL/DQ solutions aligned with BNPP's informational architecture.
- Write/analyze functional requirements based on obtained business requirements.
- Design ETL/DQ solutions and write ETL/DQ technical specifications.
- Develop ETL interfaces and processes.
- Develop DQ rules in accordance with the Data governance specifications.
- Implement data integration best practices and conventions.
- Develop PL/SQL packages and procedures by following the best practices / conventions within the team
- Perform workload and risk analysis related to these solutions.
- Help deploy applications to UAT and production environments, and handle bug-fixes and implement possible system redesigns during these periods.
- Insure quality of solutions by establishing strict code quality processes (design standards, code review - ).
- Design testing strategy and elaborate test data sets.
- Validate testing results.
- Identify potential problems and proactively suggest changes and solutions.
- Act as a reference for data integration and reporting solution.
- Informatica ETL (Power Center) and Data Quality
- Good knowledge & practice of Oracle SQL and PL/SQL.
- Autosys experience or experience with other scheduling/monitoring tools
Data Quality Data Integration Etl Sql Informatica Informatica Etl Pl/sql Oracle Sql