*Position: ETL Informatica Developer :: [Locals Only]Location: **East Rochester, NY*
*.Duration: 6+ Months On-Site contract plus extension* *Interview mode: Phone than F2F.Job Description:*Looking for strong *Informatica Developer with SQL, Unix and Oracle DB experience*. *Summary:* Key responsibilities are designing, developing and testing large scale, high volume, transaction processing databases and Operational Data Stores (ODS). Also, provide detailed design, documentation, implementation and testing of extract programs and Extract, Transform & Load (ETL) modules. *Essential Responsibilities/Accountabilities* • Physical database design and development of large scale, high volume, transaction processing databases and Operational Data Stores in a real-time SQL environment. • Provide technical leadership and consultation with respect to the direction of ETL solutions across Excellus. • Provide leadership in establishing architectural guidelines, best practices and standards for ETL development with Informatica ETL products. • Analyze source data, complete source-to-target data maps and business-driven transformation rules. • Design, development and testing of *Extract, Transform & Load (ETL) modules using Informatica PowerExchange and PowerCenter. * • Populate and maintain technical metadata repositories and related documentation. • Design, development and testing of data extract programs using Cobol. • Produces detailed design documents from high-level requirements and functional specifications. *Minimum Qualifications* • BS or BA in Computer Science or equivalent. • Demonstrated expertise in design and development of large scale, high volume, transaction processing databases or Operational Data Stores in a real-time SQL environment. • Knowledge of database internals, data structures and tuning strategies. • Extensive experience in SQL programming including advanced queries, stored procedures and triggers in DB2, Oracle or SQL Server environments. • Experience in *ETL tools including Informatica PowerCenter and PowerExchange.* • Experience in structured programming using Cobol in IMS or CICS batch and online transaction processing environments. • Experience with Modeling Tools (Rational Rose, ERWin), Report Generation Tools (Cognos), Database Tools (TOAD, AQT). • Experience in model-driven architecture, ER modeling and Object-Oriented Analysis & Design (OOAD). • Ability to analyze problems, sort through complex issues, provide a comparative analysis of alternatives and solution recommendations. • Ability to work in a team environment and communicate effectively to management and peers, both written and verbal. Thanks Regards *Steven Olson* (Technical Lead) *Ennovace Inc* Ph: 214 541 9081 F: 972-262-9006 [email protected] www.ennovace.com 1801 S O'connor Rd Irving TX 75061 Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intendedrecipient(s) and may contain confidential and privileged information.Any unauthorized review, use,disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "SAP Resource Center" 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/sap-resource-center. For more options, visit https://groups.google.com/d/optout.
