About BNP Paribas Group
Job Description – Data warehouse / Database Developer
“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
This role is with CIB IT- NAR Core Build – AML ETL team IT team that provides ETL development services to Compliance, Control and Legal functions within BNP Paribas CIB. The key stakeholders are spread across North America
Job Title
Datawarehouse/Database Developer
Date
1 Aug 2020
Department
ISPL CIB Transversal IT
Location:
Mumbai
Business Line / Function
CIB IT
Reports To
(Direct)
Project Manager
Grade
(if applicable)
(Functional)
Number Of Direct Reports
0
Directorship / Registration
NA
Position Purpose
The North American IT Transversal Functions is working on implementing IT solutions to support various clients: Finance, Human Resources, Procurement, Premises & Logistics, Business Continuity Management, IT Security, etc.
We are looking for a talented individual looking to join a dynamic environment where they can raise the bar for the industry. The person will be responsible for the success of IT TF projects by developing new, maintaining existing and supporting a number of in-house/vendor applications from the data warehouse, database and business intelligence perspective. The work will require analyzing business requirements, interpreting and understanding technical specifications and following instruction from the team lead, peer developers, business analysts and project managers.
Responsibilities
Direct Responsibilities
Principal Duties :-
The scope of the engagement will include but not be limited to:
Review, understand, interpret and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples) Perform problem analysis, structured analysis, design and programming techniques Use Data Modeling, Database Query Optimization and Data Access techniques and concepts Use Database knowledge in areas of import and export, users, roles, privileges, schema and object management, session monitoring, etc. Code, maintain, test and provide code reviews for developed processes and procedures (e.g. queries, scripts, stored procedures, database objects, indices, triggers, etc.) Apply strong performance tuning knowledge in SQL to interpret plans, identify bottlenecks in queries and remediate them Apply strong knowledge in Python and Shell Scripting required for file processing and database connections Work proactively to solve issues and problems Create use cases and assist in UAT testing efforts for the developed solutions Document, effectively track and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate) Provide weekly progress reports of work performed Work with the project team to assist in other aspects of the project Follow and adhere to BNP Paribas development standards, the software development lifecycle, vendor application / project standards and guidelines Embrace the opportunity to take on special projects outside of specific roles and responsibilities Closely interact with onshore stakeholders and onshore teams on a regular basis.
Contributing Responsibilities
Contribute towards knowledge sharing initiatives across the team Contribute towards Innovation and Creativity initiatives across the team and the organization.
Technical & Behavioral Competencies
Oracle: SQL, PL/SQL, SQL Loader, Data Pump (Mandatory)Unix Scripting (Mandatory)Python Scripting (Mandatory)AutoSysT-SQL, MS SQLOracle: Warehouse Builder, Data IntegratorGood working knowledge of data warehouse, database and business intelligence environments, concepts and techniques- Good understanding of SDLC processes.
Good understanding of concepts and techniques for design, development and implementation of ETL and data quality- Strong coordination and organizational skills.
- Excellent communication skills (written and verbal) with the ability to explain complex issues in a simple concise manner
- Smooth communication with business users and be able to withstand the pressure.
- Multi-tasking capabilities.
- Candidate will be required to work in afternoon shift
Skills Referential
Specific Qualifications (if required)
Behavioural Skills: (Please select up to 4 skills)
Organizational skills
Ability to collaborate / Teamwork
Attention to detail / rigor
Communication skills - oral & written
Transversal Skills: (Please select up to 5 skills)
Analytical Ability
Ability to develop and adapt a process
Ability to understand, explain and support change
Ability to develop and leverage networks
Choose an item.
Education Level
Bachelor Degree or equivalent
Experience Level
At least 3 years
Other/Specific Qualifications (if Required)
Technical & Behavioral Competencies
Oracle: SQL, PL/SQL, SQL Loader, Data Pump (Mandatory)Unix Scripting (Mandatory)Python Scripting (Mandatory)AutoSysT-SQL, MS SQLOracle: Warehouse Builder, Data IntegratorGood working knowledge of data warehouse, database and business intelligence environments, concepts and techniques
- Good understanding of SDLC processes.
Good understanding of concepts and techniques for design, development and implementation of ETL and data quality
- Strong coordination and organizational skills.
- Excellent communication skills (written and verbal) with the ability to explain complex issues in a simple concise manner
- Smooth communication with business users and be able to withstand the pressure.
- Multi-tasking capabilities.
- Candidate will be required to work in afternoon shift
Skills Referential
Behavioural Skills: (Please select up to 4 skills)
Organizational skills
Ability to collaborate / Teamwork
Attention to detail / rigor
Communication skills - oral & written
Transversal Skills: (Please select up to 5 skills)
Analytical Ability
Ability to develop and adapt a process
Ability to understand, explain and support change
Ability to develop and leverage networks
Choose an item.
Bachelor Degree or equivalent
At least 3 years
Primary Location
IN-MH-Mumbai
Job Type
Standard / Permanent
Job
INFORMATION TECHNOLOGY
Education Level
Bachelor Degree or equivalent (>= 3 years)
Experience Level
At least 3 years
Schedule
Full-time