Description
ETL Developer - Ab Initio
OREGON
MAJOR HEALTH CORPORATION has an immediate need for a, ETL-Developer - Ab Initio
Lead ETL Developer - Ab Initio
As a Lead ETL developer, you will serve as a hands-on Technical (ETL) Project Lead to deliver multiple projects. Participate in designing, developing/unit testing, and delivering large scale multi-terabyte Data Warehousing solutions. Position will work closely with the ETL Lead, DBA, QA, and other IT groups.
Perform data requirements analysis and create design specification & operational documentation.
Serve as a subject matter expert on assigned Projects, Production Services processes, products and technologies to all areas of the business.
Analyze functional requirements, mapping documents, assist in problem solving and trouble shooting.
Create high performance and highly scalable ETL designs
Create and maintain Technical Design document, ETL Mappings and Production Support & Administration document
Coding, testing, debugging, documenting and implementing AB INITIO graphs to meet product/project specific requirements
Establish and implement ETL best practices and guidelines
Creating test plans and unit test cases
Provide Testing support for the ETL process
Deploy ETL Process in production and provide support for the data mart environment
Performance Tuning of AB INITIO graphs, processes and load routines.
Act as a mentor to other/junior ETL resources.
Qualifications
Bachelor's Degree in Computer Science or related area of study.
Minimum 10 + years of experience working with large scale applications.
7+ years dedicated ETL design/development using AB INITIO ETL solutions
Very good knowledge of Oracle, SQL, UNIX and Shell Scripting etc.
Top 3 - 5 Required Skills
7+ years dedicated ETL design/development using Ab Initio ETL solutions
Minimum 10 years of experience working with large scale applications
Very good knowledge of Oracle, SQL, UNIX and Shell Scripting
Ability to scope, plan, prioritize and manage multiple tasks and projects
Solid communication, documentation and project/task management skills
Desired skills
Knowledge of data warehouse/ETL design and development methodologies
Experience designing, documenting ETL and performance tuning
Experience with data cleansing and data quality processes