*Please send resumes to pre...@hclglobal.com <pre...@hclglobal.com>* *Yahoo! IM: premreddyg <premred...@yahoo.in>*
*Teradata with Informatica Consultant* *Location: **Englewood, CO * *Duration: 6 Months+* *Job Description: * *Skills:* Teradata, Informatica Powercenter, Data Integration, UNIX Shell Scripting, ETL *Job Requirements: * *Data Integration:* - Should be able to develop technological solution of any complexity independently for the intended delivery competency to meet business requirements of a department. - Should be able to make effective use of available best practices and standards. - UNIX Shell Scripting (L1) - Shell Basics & Sub shells *Shell types:* - Bourne, Korn, C, and bash - Korn Shell Environment - Startup Scripts (.profile, .kshrc) Using ENV for automatic environment tailoring (PATH etc.) [Shell Command Syntax] - Commands & Options - Manipulating Input and Output Redirection (Pipes) - Aliases (alias,unalias) - How the Shell Finds Commands - Command History and Editing[Variables] - Assigning Values to Variables (set, unset and Special Variables) - Built-in Variables Known to Login Shell - The Shell Environment and predefined variables - Exporting Variables [Input/Output] - Working with files and file attributes - Working with Directories *Basic I/O Features:* - String and Field Processing - Streams and pipes (exec) - Terminal Information(COLUMNS, LINES, TERM) - ETL (L2)-Should have good understanding of Business Intelligence & Data warehousing, project life cycle Phases. Should have awareness of best practices in ETL Architecture, Design and Load Performance Experience in architecting ETL Feeds in the role of a Technical Lead for ETL Architecture, Design and implementation. - Should have experience in design and implementation of ETL solution in at least one DWH development projects. Should have expertise in data standardization and data modeling (i.e. conceptual, logical and physical model design, experience with ODS, EDWH and DM ) Should have expert knowledge in at least one leading ETL Tools (Informatica, AbInitio, DataStage etc.) and familiarity with one or two leading ETL tools Should have expert knowledge of RDBMS and PL/SQL skills. Should have design and implementation experience with at least one leading ETL Tool. - Should have design and implementation knowledge of job scheduling and job dependency setups. Should be proficient in at least two of leading RDBMS databases like Teradata, Oracle, MS SQL Server, DB2 and in Unix/Linux as well as Windows platform. - Should have sound knowledge of concepts including Data Profile, Data Quality, Meta Data, Data Governance, MDM concepts. Should have functional knowledge of Enterprise architectures. - Should have strong aptitude, reviewing skills, problem solving skills and a zeal to learn new tools and technologies - Should possess strong communication and client management skills. - Should be able to lead and manage project execution modules bringing in technical, functional, process or other core ERP product created expertise. Should be able to lead small cross functional teams to ensure delivery and effectively coordinate between onsite an offshore. Regards, G.Prem | Sr. Talent Acquisition HCL Global Systems Inc., 24543 Indoplex Circle, Suite 220, Farmington Hills, MI 48335 Email: pre...@hclglobal.com | Ph: 248-216-0031 www.hclglobal.com Certified Minority Business Enterprise (MBE) -- -- To unsubscribe from this group, send email to cbe-software-engineer-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/CBE-Software-Engineer?hl=en --- You received this message because you are subscribed to the Google Groups "CBE Software Engineer" group. To unsubscribe from this group and stop receiving emails from it, send an email to cbe-software-engineer+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.