*Title: Informatica Developer* *Work authorization: **any (candidate must be authorized to work in US)* *Location: * Tallahassee, FL *Duration:* 12+ months
*Must-have skills: * Informatica, Oracle, SQL, PL/SQL, ETL, Informatica Power Center and CDC, UNIX *Requirements:* • 6-8 years of experience as Informatica lead • Knowledge of Oracle databases • Experience working in UNIX operating system • Ability to work independently and to resolve complex Oracle issues • Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure • Ability to write SQL, PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers • Efficiently code SQL, PL/SQL Oracle Stored Procedures, Functions and import the objects to ETL logic to mitigate complex data sync issues • Ability to Tune Oracle SQL and PL/SQL performance • Experience in logical database design and data models • Advanced experience with ETL and data transformation solutions • Experience working with Batch Processing Preferred KSA’s: • Experience working Informatica Power Center and CDC • Take charge, can-do attitude • Facilitation skills • Excellent Written and verbal communication Responsibilities: • Responsible for Informatica development and deployment services • Developing and testing mappings/workflows staring with data design and requirements to delivering finished mappings in CDC and batch mode. • Use requirements to create mappings, run mappings in appropriate workflow architecture, design tests, fine tune mappings and workflows in CDC and batch modes as needed for the situation. • Develop & design processes/procedures for the following: Power Exchange Processes, PowerCenter Workflows, Error Detection, tracking and resolution, Batch handling, Error Reporting, Notifications • Performance Tuning shall include, but not be limited to, the following: Power Center configuration, configuration for Power Exchange Processes, Workflow configuration, Session configuration Experience in configuring and Administering Informatica servers and Power exchange tools on the environment • Develop Proof of concepts for new business/technical requirements in Informatica with real time Change data capture, Error handling etc. • Analyze the legacy, source application behavior, modify ETL logic for optimal OLTP performance. • Analyze the source, intermediate, target data involved in synchronization to ensure ETL logic comply’ s with business rules. • Work with data stewards, data architects, and perform the gap analysis on data sync business rule. • Collaborate with team members to collect, analyze data failures involved in synchronization. • Work with Business Analysts, data stewards, and other associates to process the rejected records during data synchronization. • Effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure. Thanks... Uday Varanganti Recruiting Specialist [email protected] O: (785)380 8559 <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> -- You received this message because you are subscribed to "rtc-linux". Membership options at http://groups.google.com/group/rtc-linux . Please read http://groups.google.com/group/rtc-linux/web/checklist before submitting a driver. --- You received this message because you are subscribed to the Google Groups "rtc-linux" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rtc-linux/CAEmiLYsJD_R-Uyp47hpPhrzeUzmjknsi12PUg46qh4xj3QtOdQ%40mail.gmail.com.
