Role : ETL/Informatica Developer
Location : CLEVELAND,OH
Duration : 6+ Months
Rate : $50/hr on C2C(Max)
Job Description :
Required Skills Seeking Data warehousing ETL Developer, with expert skills in Informatica 9.5
Below are the requirements of this role
Data Warehousing ETL development and testing experience using Informatica 9.5 or higher
Experience in Extraction, Transformation and Loading (ETL) data from various sources into a Data Warehouse/Data Mart/ODS
Working knowledge of the Informatica Power Center Client tools - Mapping Designer, Repository Manager and Workflow Manager/Monitor.
Experience in working with relational databases such as Oracle 11g or higher, DB2 as well as with the flat files and XML using the Informatica XML Parser
Experience in developing Stored Procedures, Functions, Views, Triggers, Complex SQL queries using Oracle PL/SQL
Experience in resolving maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
Production support and application maintenance experience
Good interpersonal and communication skills
Must have skills
1. Production support and application maintenance knowledge
2. Informatica 9.5 or higher - 6+ years in-depth knowledge
3. Informatica Power Center Client tools - 6+ years in-depth knowledge
4. Oracle 11g, DB2, XML Parsing with Informatica - 6+ years work experience
5. Stored Procedures, Functions, Views, Triggers, Complex SQL queries using Oracle PL/SQL
6. Strong verbal and written communication skills
Must have Domain experience Knowledge and understanding of insurance domain