Assistant Vice President – TS9950113]

Deutsche Bank•Cary, NC

15h•Onsite

About The Position

DB Global Technology, Inc. seeks an Assistant Vice President in Cary, NC to collaborate with senior stakeholders to provide clear and insightful reports and metrics to support effective project planning. We strive for a culture in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively. Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group. We welcome applications from all people and promote a positive, fair and inclusive work environment.

Requirements

Bachelor’s degree in Computer Engineering, Electronic Engineering, or a related field or equivalent
Five (5) years of progressively responsible experience performing user requirement design study and analysis of systems
Five (5) years of experience performing database analysis in order to fetch required sets of data using relational databases including SQL Server, Oracle, PostgreSQL, DB2 and IBM Netezza
Five (5) years of experience applying methodologies including advanced SQL query optimization, ETL processes (Informatica PowerCenter), metadata analysis, and data profiling techniques for data analysis
Five (5) years of experience designing and developing ETL structures to extract, transform, and load data from multiple data sources into data warehouses and other databases based on business requirements
Five (5) years of experience troubleshooting issues post-release deployment including support for data warehouse production projects and solution proposals to solve complex production issues using SQL, Python, Hadoop ecosystem tools (HDFS, Hive), Databricks, and cloud monitoring solutions
Five (5) years of experience working on enhancements related to business requirements and providing support to delivered jobs in production
Five (5) years of experience identifying source and target tables and creating data mapping documents
Five (5) years of experience developing Test Case and Test Plan documents in order to drive User Acceptance Testing (UAT) and Post Implementation (PI) testing on Integrated Data Warehouses
Five (5) years of experience streamlining end-to-end processes to support large-scale data intake
Proficiency in Hadoop ecosystem (HDFS, Hive), SQL, Python, ETL, Databricks, Cloud Migration, Metadata Analysis, Cognos, and Power BI

Responsibilities

Collaborate with senior stakeholders to provide clear and insightful reports and metrics to support effective project planning.
Perform user requirement design study and analysis of systems.
Perform database analysis in order to fetch required sets of data using relational databases including SQL Server, Oracle, PostgreSQL, DB2 and IBM Netezza.
Apply methodologies including advanced SQL query optimization, ETL processes (Informatica PowerCenter), metadata analysis, and data profiling techniques for data analysis.
Design and develop ETL structures to extract, transform, and load data from multiple data sources into data warehouses and other databases based on business requirements.
Troubleshoot issues post-release deployment including support for data warehouse production projects and solution proposals to solve complex production issues using SQL, Python, Hadoop ecosystem tools (HDFS, Hive), Databricks, and cloud monitoring solutions.
Work on enhancements related to business requirements and provide support to delivered jobs in production.
Identify source and target tables and create data mapping documents.
Develop Test Case and Test Plan documents in order to drive User Acceptance Testing (UAT) and Post Implementation (PI) testing on Integrated Data Warehouses.
Streamline end-to-end processes to support large-scale data intake.