SDET Engineer/ETL Testing at Tubman Technologies Inc
ALPHARETTA, GA 30004
About the Job
Job Purpose:
Supports business decision-making by evaluating, planning, and implementing data warehouse technical enhancements.
Duties:
* Understands data warehouse functionality provided to users by studying applications, business requirements, and documentation.
* Evaluates data warehouse enhancements by organizing user requests; examining logical and physical models, ETL strategies, including schema; transformation rules and summarization strategies, and data maps from source to target; conducting impact analysis; recommending solution.
* Plans enhancements by proposing program, process, and procedure solutions for data acquisition, extraction, cleansing, transformation, integration, loading, and replication, filtering, formatting, and data delivery processes to data marts, visualization and access methods, and application reports and testing.
* Implements enhancements by building SQL code, stored procedures, and triggers; creating views; coordinating distribution of requirements to support groups; monitoring project status; managing release; documenting enhancements.
* Ensures data quality by re-defining load validation, meta data updating, data integrity processes, quality standards, monitoring systems, and audit and reconciliation processes.
* Maintains database performance by supporting system operation cycle; coordinating requirements and actions between applications and operating area staffs; monitoring standards; modifying system documentation.
* Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
* Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.
Skills/Qualifications:
Operations Research, Process Improvement, Building Relationships, Requirements Analysis, Operating Systems, Data Warehousing, Presenting Technical Information, Data Modeling, Database Management, Business Knowledge, Integrity
Supports business decision-making by evaluating, planning, and implementing data warehouse technical enhancements.
Duties:
* Understands data warehouse functionality provided to users by studying applications, business requirements, and documentation.
* Evaluates data warehouse enhancements by organizing user requests; examining logical and physical models, ETL strategies, including schema; transformation rules and summarization strategies, and data maps from source to target; conducting impact analysis; recommending solution.
* Plans enhancements by proposing program, process, and procedure solutions for data acquisition, extraction, cleansing, transformation, integration, loading, and replication, filtering, formatting, and data delivery processes to data marts, visualization and access methods, and application reports and testing.
* Implements enhancements by building SQL code, stored procedures, and triggers; creating views; coordinating distribution of requirements to support groups; monitoring project status; managing release; documenting enhancements.
* Ensures data quality by re-defining load validation, meta data updating, data integrity processes, quality standards, monitoring systems, and audit and reconciliation processes.
* Maintains database performance by supporting system operation cycle; coordinating requirements and actions between applications and operating area staffs; monitoring standards; modifying system documentation.
* Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
* Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.
Skills/Qualifications:
Operations Research, Process Improvement, Building Relationships, Requirements Analysis, Operating Systems, Data Warehousing, Presenting Technical Information, Data Modeling, Database Management, Business Knowledge, Integrity
Salary
71,000 - 107,000 /year