HI,
Job title: Lead ETL Developer - Ab Initio
Location : Portland, OR
Duration : 6 months
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 KPIT groups.
Will also be responsible to perform detailed data requirements analysis and create design specifications & operational documentation, serve as subject matter expert on assigned Production Services processes, products and technologies to all areas of the business.
Responsibilities
. 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.
.Data Warehouse/ETL design and development methodologies knowledge and experience is preferred.
.Design, implement, and develop ETL processes against high-volume and complex data sources .Extensive experience in estimating work efforts for complex projects .Perform Quality Assurance, unit and system testing as well as complete documentation of deliverables .Experience designing, documenting ETL and performance tuning .Able to trouble shoot and create customized jobs .Experience with data cleansing and data quality processes .Scope, plan, prioritize, and manage multiple tasks and projects .Provides primary level support overall to systems and teams as necessary to ensure proper and efficient use of systems.
.Ability to analyze and design methodologies for full system development life cycles. Ability to analyze and design data conversions and integration tools, processes, and practices Solid communication, documentation, and project/task management skills
Top 3 - 5 Daily responsibilities
Perform data requirements analysis and create design specification & operational documentation.
Analyze functional requirements, mapping documents, assist in problem solving and trouble shooting.
Coding, testing, debugging, documenting and implementing AB INITIO graphs to meet product/project specific requirements Establish and implement ETL best practices and guidelines
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
Soft Skills
Strong customer service orientation
Ability to prioritize tasks
Ability to work closely with other technical team members Comfortable with fast-paced environment Able to "switch gears" when priorities change
# of people supervised
3-5 (each position)
Size of the team
10-15
Stage of the project
Development
Is a 4 yr degree required?
Yes
With Regards
Murthati Nagender
ALTUS TECHNOLOGIES INC
Phone : 703.310.7053 Ext 1012 | Direct Line : 703.260.6033 | Fax : 703.738.7745
e-mail : murthati.nagender@altustek.com website : www.altustek.com
