ETL Engineer

Datastage Engineer

Responsibilities:

Datastage is the current ETL tool for the team. Python, Kafka, Java would be an added bonus. Interfaces with key Technical Managers, Developers, and Build Experts in order to understand the technology requested and the business complexities as they relate to IT requirements. Determine and implement the most efficient and cost-effective solution. Support and uphold Architecture/Design standards. Design, develop and deliver/implement data solutions to include: architecture design, proof of concept, development of standards, design and development of test plans, code and module design, development and testing, data solution debugging, design and implementation of a solution that follows efficient design techniques. Design and engineer across multiple platform types. Example – DB2, UDB, SQL Server, Oracle, Teradata, Netezza, BI Tools, ETL, CDC and application servers. Accountable for components of the overall Data management and engineering, Data Integration, Information system including software installation, configuration and administration and performance evaluation and enhancements. Engineer physical design of data, sub systems, data integration and overall solution of each domain. Test and debug Software including SQLs and infrastructure components. Develop and execute scripting as a way to improve or enhance systems or subsystem operational efficiency. Keep abreast of hardware and software developments, including theory and technique. Assure quality, security and compliance requirement are met for supported area and oversees updating and testing of the business continuation plan. Modify, install and prepare technical documentation for system software applications. Diagnose, isolate and de-bug software problems and performs problem resolution. Create documentation and user support guides. Uphold and support documentation standards, procedures and approval hierarchies. Lead self and provides technical leadership on projects. Foster teamwork and manage multiple delivery work streams. Identify and provide guidance to less experienced team members and/or resolve highly complex production problems.

Location: PHX

Can this role work remotely: No

Role Description:

Design and develop complex transformation, data loading techniques to process massive volume of data in and out of data reservoir. Collaborate with data analysts and data scientists in finding and applying best practices within the Data and Analytics department as well as defining the business's data requirements, which will ensure that the collected data is of a high quality and optimal for use across the department and the business at large.

Overview of Project Work Scope: Datastage Engineer of Enterprise Business Intelligence program

Top 3-5 Required Skills:

4-year degree (Computer Science, Information Systems or relational functional field) and/or equivalent combination of education or work experience. Advanced degree preferred. 5+ years experience in specific domain, systems and infrastructures, subsystems and application integration. Strong understanding of information systems, Data Structures, programming, graphical user interfaces and control languages.

Additional Required Skills:

Knowledge of several query languages. Good understanding of company's Information, application systems and its relationships. Strong organizational and troubleshooting skills with attention to detail. Ability to understand client expectations and to resolve issues that may affect delivery. Strong interpersonal skills with the ability to work effectively in a matrix organization. Ability to work with teams that are geographically distributed and work across different time zones. Self-starter, with a demonstrated ability to learn beyond formal training with a strong aptitude for delivering quality products. One or more of the globally accepted certifications and credentials in the applicable technology domain.

3-5 Screening Questions:

Tell me about a time when you accomplished something against significant obstacles. Tell me about a time you had to solve a problem twice, when the first solution wasn't right. How will you determine the sequence of jobs to load into data warehouse (i.e. Aggregates, Dimensions, Facts)? How do you delete duplicate rows from a table in Oracle? Differentiate Database data and Data warehouse data.