*Hi,* * *
*We have an urgent opening for **ETL (Informatica) Sr.Informatica developer & ETL Tech Lead* * * *Position: ETL (Informatica) Sr.Informatica developer & ETL Tech Lead* *Location: Dover, NH* *Duration:6 Months* Description: • Required: ETL design, development, and configuration management experience in Informatica - must be very hands on with Informatica Designer Components - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation developer, Workflow Manager and Workflow Monitor • Must be proficient in configuring and connecting transformations such as Aggregators, Joiners, Lookup, Normalizer, Update Strategy. Should have developed reusable transformations and mapplets • Required: Experience in Teradata. Must have used Teradata tools/utilities such as Teradata SQL Assistant, BTEQ, Fast Load, Multi Load, Fast Export • Required: Must be proficient in writing complex SQLs handling Terabytes of Data. Should be able to quote real time examples from project worked. Should also able to code queries using advanced analytical functions. Must be proficient in writing queries to handle temporal data (time based) • Required: Should have experience in Performance Tuning Informatica components as well as SQL queries. Should be able to read and understand EXPLAIN PLAN output. Should have an understanding on how Teradata works and the impact of collecting statistics. Should also have good understanding of the usage of various indexes in Teradata platform • Required: Extensive experience in data loading strategies using Informatica and/or Teradata • Required: Proficient in troubleshooting issues and bug fixing with Informatica mapping, workflow and SQL (embedded in Views, stored procedures, macros etc) • Required: 1+ years development experience using Unix Shell scripting with good understanding of utilities like SED, AWK etc. Should be able to code “file watcher” scripts, scripts to parse data from control files, and scripts to manage data on Teradata from ETL server. If you interest pls share your updating resume .. at [email protected] Thanks & Regards, Raja Javaji Systems Solutions Inc. [email protected] Direct: 703-880-4214 Yahoo IM: rajajavaji www.javaji.com -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
