Data Modeler ETL Dvlp, BI/DW Mid.

PLANO (PLN)

Brief Summary

                            Data Modeler ETL Dvlp, BI/DW Mid.
 (Business Intelligence/Data Warehouse) 

Work experience:    
Minimum 3 years experience

Minimum Requirements:  
Supplier resources will have the following skills / experience / background:
•	Strong individual contributor in complex Data Warehousing and Business Intelligence project implementations
•	Advanced ETL experience using either Informatica or Data Stage
•	Strong collaboration skills
•	Strong SQL skills including complex query building and query performance tuning
•	Data analysis skills - ability to dig in and understand complex models and business processes  
•	UDB, SQL Server, Oracle, My SQL, Netezza or Teradata database experience
•	Strong understanding of Data warehousing design concepts/skills
•	Strong UNIX shell scripting skills  (primarily in COBOL, Perl)
•	Data profiling experience
•	Defining and implementing data integration architecture
•	Strong ETL performance tuning skills.  The ability to quickly and efficiently analyze and resolve performance issues within variety of operational environments
•	Proven problem-solving / problem resolution abilities. 
•	Demonstrated ability to translate business processes to applicable requirement types (functional, technical, etc)
•	Microsoft Office (Outlook, Excel, Word, PowerPoint, Access)

Required:
-	Data Models – Experienced in Data Mart (Star Structures) and Warehouse Data Model designs (Normalized)
-	SQL
-	ETL experience using either Informatica or Data Stage or an equivalent technology
-	UNIX shell scripting


Preferred:
•	- Familiar with Agile Development Methodology 
•	- UDB/DB2  
•	-Netezza
•	Dimensional data modeling skills
•	StarTeam Software Configuration Management Tool
•	SAS Experience
•	Business Objects (Webi, Xcelsius, Crystal Reports) or an equivalent technology
•	MS Analysis Services
•	General Host Knowledge
•	StarTeam Software Configuration Management Tool
•	Control-m scheduling tool
•	Proficiency in scripting (in order of preference):  Korn, Perl