Dear Business Partner,
This is AJ with Hire IT People. Please find the below *Sr ETL / Informatica Lead Developer* consultants availability. Please let me know if you have any job opportunity for my below consultant. Please send me your requirements to *[email protected]* <[email protected]> *Sr ETL / Informatica Lead Developer with 11+ Years of Experience.* Current Location: *Phoenix, AZ* Availability:* Immediate* Re-Location: *Yes* Visa Status*: H1-B* *Summary:-* - *Informatica developer *with 11+ Y*ears *of solid experience in *Data warehousing *& *Extraction, Transformation & Load (ETL) *data from various sources into Data Warehouses and Data Marts using *Informatica Power Center 9.1/8.x/7.x/6.x/5.x* (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server), *Informatica Power Exchange*, Autosys - *Experience include Banking, Pharmaceutical and Insurance Domains* - *Nine Plus (9+) years* of experience with Database objects, writing *stored procedures*, *functions, triggers*, *DDL*, *DML SQL query performance tuning* using *Oracle 11gR2/10g/9i/8i,* PL/SQL, SQL*Plus, SQL*Loader - Extensive experience in tuning Informatica *Mappings* and *Sessions* for optimum performance. - Excellent working knowledge of ODS, Datawarehouse models using Star and Snow-Flake scheme. Efficient utilization of “Bottom-up” and “Top-Down” methodologies. · Experience in command line programs such as* pmcmd, infacmd, infasetup and pmrep.* · Extensively worked with Teradata utilities like *BTEQ, Fast Export, Fast Load, Multi Load* to export and load data to/from different source systems including flat files. · Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle. · Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies. · Experienced with *dimensional *and relational *database design*. - Good experience of working with process models like CMMi Level5 - Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica. - Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations. - Expert in implementing business rules by creating *Re-Usable Transformations* like Mapplets and Mappings - Proficient in using Informatica Repository Manager to create & schedule sessions and batches. - Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings. - Experience in *PL/SQL* development and *SQL Query Tuning* for better performance. - Good working knowledge on *SQL*Loader* for Bulk Loading. - Good knowledge in Scheduling ETL Jobs tool like Autosys. - Experience in UNIX shell scripting, FTP, SFTP and file management in various UNIX environments. - Production support, handling new enhancements and customer support. - Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives. - Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently. - Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint. *TECHNICAL S**KILL** SET**:* *Technologies: *Informatica Power Center 8.x, 9.1, Informatica Power Exchange. *Work Model: *Waterfall model, Agile *Configuration Management Tools:* Subversion, Perforce, Visual source safe. *RDBMS:* Oracle 11g, Teradata, SQL Server *O**perating Systems:* Windows 7/2003/2013/Unix *Others:* Autosys Thank you... Aj Resource Specialist Direct: 732-444-2850 // 202- 719-0200 Ext: 116 [email protected] *Hire IT People Inc* 1761 S Street NW, Suite # LL4 Washington DC 20009 http://www.hireitpeople.com *Please note before submitting our Candidates*: We do not work in layers; you must be the Preferred/Tier 1 Vendor to the Client. If you are a layer, we have the right to work directly with the Preferred/Tier 1 Vendor. Please note that this clause is automatically incorporated and supersedes any related clauses in agreements that we may have signed or will sign with your company. Thank you -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
