EDW Quality Assurance : Performance Optimization Job - (austin, texas)
EDW Quality Assurance :
Performance Optimization:
INF0008293 About the General Motors Enterprise Data Warehouse (EDW) team:
About the role:
The EDW Quality Assurance :
Performance Optimization role is a technical position with responsibility for collecting and reviewing performance metrics of the EDW ETL batch, and tuning/optimizing the ETL jobs and reports for maximum performance.
Responsible for creation/review of project artifacts related to ETL batch optimization and approve prior to production deployment.
Responsible for batch and report SLA attainment.
A key responsibility for the role will be to work with other EDW teams such as Business Analysts, Data Architects, Data Modelers, ETL Developers, Enterprise Architects, BI Developers, Project Managers, Platform Architects, Release Managers, Operations and Support, DBAs, to continually communicate and ensure the quality and performance of production launches.
Qualifications
Qualifications:
Minimum
Qualifications:
:
4 Year IT College Degree/Masters preferred or equivalent work experience :
7
years in large scale data warehouse with data integration implementations :
Full lifecycle project and/or platform development using standard frameworks and repeatable best practices :
Experience working with data tools and technologies:
data modeling, ETL tools, metadata management tools, master data management tools, database technologies and design, business intelligence and enterprise reporting :
Collaborates with key stakeholders including infrastructure engineers, business analysts, development teams, project managers, to report performance metrics and escalate issues requiring attention.
:
Experience writing SQL and reviewing explain plans for tuning.
:
Experience gathering and reviewing CPU, memory and IO information on the platform.
:
Experience with establishing and analyzing metrics and recommending new tools and processes to ensure quality :
Proactively engages in the remediation of test and software issues related to code quality, security, and/or pattern/frameworks.
:
Experience automating operations metrics collection and reporting processes.
:
Strong organization skills, communication, and drive for results Preferred
Qualifications:
:
A master's degree in a technical discipline :
Demonstrable experience using Data Integration platforms, tools and techniques (DataStage, Informatica) :
Experience using heterogeneous data replication techniques (Oracle GoldenGate, IBM DataMirror etc) :
Experience with industry leading large scale data platforms (i.
e.
Hadoop, Teradata, IBM DB2, IBM BigInsights, HP Neoview, HP Vertica, HP Autonomy, Greenplum, Oracle ExaData, SAS) :
Experience with open source technologies (i.
e.
Hadoop, Pig, Hive, JAQL, HCatalog, JSON) :
Interaction with end user query developers to design and improve database queries Why General Motors? At GM, we've charged ourselves with one mission:
to design, build and sell the world's best vehicles.
And to achieve our goals, we're currently undergoing one of the largest Source:
http:
//www.
tiptopjob.
com/jobs/28571927_job.
asp?source=trovit.
Estimated Salary: $20 to $28 per hour based on qualifications.
Performance Optimization:
INF0008293 About the General Motors Enterprise Data Warehouse (EDW) team:
About the role:
The EDW Quality Assurance :
Performance Optimization role is a technical position with responsibility for collecting and reviewing performance metrics of the EDW ETL batch, and tuning/optimizing the ETL jobs and reports for maximum performance.
Responsible for creation/review of project artifacts related to ETL batch optimization and approve prior to production deployment.
Responsible for batch and report SLA attainment.
A key responsibility for the role will be to work with other EDW teams such as Business Analysts, Data Architects, Data Modelers, ETL Developers, Enterprise Architects, BI Developers, Project Managers, Platform Architects, Release Managers, Operations and Support, DBAs, to continually communicate and ensure the quality and performance of production launches.
Qualifications
Qualifications:
Minimum
Qualifications:
:
4 Year IT College Degree/Masters preferred or equivalent work experience :
7
years in large scale data warehouse with data integration implementations :
Full lifecycle project and/or platform development using standard frameworks and repeatable best practices :
Experience working with data tools and technologies:
data modeling, ETL tools, metadata management tools, master data management tools, database technologies and design, business intelligence and enterprise reporting :
Collaborates with key stakeholders including infrastructure engineers, business analysts, development teams, project managers, to report performance metrics and escalate issues requiring attention.
:
Experience writing SQL and reviewing explain plans for tuning.
:
Experience gathering and reviewing CPU, memory and IO information on the platform.
:
Experience with establishing and analyzing metrics and recommending new tools and processes to ensure quality :
Proactively engages in the remediation of test and software issues related to code quality, security, and/or pattern/frameworks.
:
Experience automating operations metrics collection and reporting processes.
:
Strong organization skills, communication, and drive for results Preferred
Qualifications:
:
A master's degree in a technical discipline :
Demonstrable experience using Data Integration platforms, tools and techniques (DataStage, Informatica) :
Experience using heterogeneous data replication techniques (Oracle GoldenGate, IBM DataMirror etc) :
Experience with industry leading large scale data platforms (i.
e.
Hadoop, Teradata, IBM DB2, IBM BigInsights, HP Neoview, HP Vertica, HP Autonomy, Greenplum, Oracle ExaData, SAS) :
Experience with open source technologies (i.
e.
Hadoop, Pig, Hive, JAQL, HCatalog, JSON) :
Interaction with end user query developers to design and improve database queries Why General Motors? At GM, we've charged ourselves with one mission:
to design, build and sell the world's best vehicles.
And to achieve our goals, we're currently undergoing one of the largest Source:
http:
//www.
tiptopjob.
com/jobs/28571927_job.
asp?source=trovit.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
