Job Description
The ETL Developer/Tester will be responsible for Extract Transport and Load (ETL) development, tuning, data loading and testing.
This person will be part of a team of developers/testers in building out and testing ETL jobs supporting a data warehouse holding Project and program data.
The ETL Developer must have a sound understanding of Business Intelligence (BI) best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, ETL, and data warehousing.
The Data Warehouse ETL Developer/Tester is responsible for the successful loading of data in a data warehouse and multiple data marts to deliver BI information to the entire organization.
This person will be experienced in BI development and implementations, data architecture and data warehousing. Additional responsibilities include:
Creating, maintaining, and supporting Informatica ETLs
Validating results with business representatives
SQL testing
Monitoring the data loads
Tuning the load processes
Addressing user questions concerning data integrity Additional Detail Communicating functional and technical issues
Qualifications- All candidates must have 3 5 years experience with the following:
Informatica ETL
Relational database management and reporting
Analyzing business MIS requirements
Strong SQL
Star or Snowflake schemas
Shell scripting and java programming preferable
Full project lifecycle; ability to communicate requirements to clients and developers
Working as a member of a te Experience 3 to 5yrs
Employement Category:
Employement Type: Full time
Industry: IT Services & Consulting
Role Category: General / Other Software
Functional Area: Not Applicable
Role/Responsibilies: AB Initio Developer - Advanced Position
Keyskills:
ab initio
data marts
data loading
data modeling
shell scripting
data architecture
database management
business intelligence
java programming
testing