Role : Informatica/Teradata lead
Location : Charlotte NC
Duration : 8 Months
Hire Type : Corp to Corp
Skills : Infa -pc, Teradata utilities like BTEQ, FASTLOAD, MLOAD, TPUMP, FASTEXPORT, Teradata Studio
Job Description:
§ Experience in Life Science Domain, should be able to handle Business queries and relate it to the data in the back end.
§ Experience in Informatica Power Center 9.x and above (ETL - Designer, Workflow Manager), Job Schedulers.
§ Must have experience in building complex SQL queries and Shell scripting.
§ Strong on DW Fundamentals & DW concepts.
§ Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.
§ Extensive experience in Data Modeling & Architecture.
§ Experience in full lifecycle data warehouse development.
§ Excellent understanding of various relational database design concepts.
§ Experience in managing BI App Support & Maintenance projects.
§ Experience in Data Migration and Data Quality initiatives.
§ Error handling and Performance Improvements.