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 or higher in Cleveland, OH.
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 .
Practitioners of the IT Application Development and Maintenance profession primarily focus on providing high quality, cost effective information technology solutions to business partners by creating new or modifying and/or supporting existing software applications. Associates are expected to design, code, analyze, configure, unit test, and maintain applications.
Top-level technical expert in one or more highly specialized phases of applications programming. Provides technical consulting on complex projects. Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. Responsible for program design, coding, testing, debugging, and documentation. Has full technical knowledge of all phases of applications programming.
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