We're looking for someone who can do Informatica coding and ETL, but they also should have broader data mart and data warehouse design skills. They must understand dimensional modeling. This candidate will need to analyze data, help design the data model for the data mart, document the data definitions and Informatica mappings, as well as code the mappings.
***Strongly prefer local candidates
1. Extremely knowledgeable Informatica & DB2 development (Strong Informatica Mapping) 2. Extremely proficient in SQL development 3. Extremely proficient in understanding dimensional modeling 4. Extremely proficient in designing data warehouse and data marts 5. Extremely proficient in data analysis and problem solving 6. Ability to document designs and clearly communicate alternatives 7. Knowledge of data warehousing concepts and methodologies 8. Understanding of the differences and similarities between Inmon and Kimball 9. Understanding of Data Warehouse CDC (ChangeDataCapture) processing and challenges 10. Demonstrated modeling skills in 3rd Normal form and dimensional techniques 11.***Excellent communication skills a must.
--Strongly Desired Skills--
1. Strong Business Objects 6.0 developer experience with the following:
a. Full Client and designer experience
b. Universe development experience
3. Data Modeling
4. DB2 & Oracle database
Please have the candidates respond to the following three questions and put their response in the initial submittal, in addition to their resume.
1. At your last two Informatica assignments, how many mappings have you personally built? (Not how many has your team done - how many have you personally done?) 2. What size warehouses have you worked on? (Numbers of rows, file sizes, etc.) Not exposed to, but warehouses that you have actually worked with.
3. When troubleshooting a bottleneck, how do you go about identifying and solving the issue? Again, not how your team approached this - how you personally approached the issue.
Regal Computer Systems, Inc - 16 months ago