Job Description :
TeraData with Informatica developer
Richmond, VA
12 Months
Key Skills: Teradata, FASTLOAD, MLOAD, FASTEXPORT, Informatica, TNIX Shell Scripting, bteq, oracle
Description:
Experience on Teradata External loader connections MLoad, Upsert and Update, Fast load
Loading data into the staging and target tables in Teradata Database.
Data profiling, Data mapping on source database to determine primary keys
Experience Informatica tool to load data from data files into landing zone tables
Experience Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows
Lead the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
Coded the data loads from the landing zone into the stage and data warehouse tables using unix scripts and Bteq.
Requirements gathering and data gathering for handling the design specification.
Prepared Unit Test Specification Requirements.