|
Responsible for the design, development and administration of transactional and analytical data constructs/structures. Included within those responsibilities are the areas of data access and delivery technologies. Includes Oracle, Teradata. DB2, SQL Server, and DMS II. Duties include performance tuning, monitoring, software installs and upgrades, UNIX shell scripting, and physical and logical database design. Some Oracle and Teradata databases are very large, with a minimum size of 500 GB and 1000 users. Familiarity with ETL Tools like AbInitio, DataStage, Informatica, etc. Familiarity with Web Applications
Hands on experience with Microsoft Windows XP or higher version. Hands on experience with Microsoft Office Word and Excel.
Work Experience 5+ years
Financial Services Experience 3+ years Experience
-Good understanding of logical modeling concepts
- Ability to produce physical data model from logical using ERWIN or similar tool
-Experience with security administration using roles and profiles
-Experience with performance tuning implementations of complex SQL
-In depth knowledge of Teradata Utilities such as MultiLoad, FastExport, FastLoad, TPump, and BTEQ
-Solid understanding of Teradata Client Tools
Works independently
Familiarity with other data bases, ETL tools, web applications and or other programming languages
COF Experience - Desired but not required
Develops advanced domain specific technology solutions and guides their development into a final product
ETL experience in implementation and design
Ability to effectively communicate across multiple levels (Executive Sponsors to team members).
|
