Job Description :
Manages development and testing tasks and ensuring adherence to previously agreed to timelines communicating status;
Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies;
Apply data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of powercenter
Technical walk-throughs to communicate design/coded solution
Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets.
Responsible for analysis, design, programming, testing and implementation for new and existing business application software, and production support for systems with medium complexity.
Qualifications include good organizational skills, strong analytical and problem solving skills, good time management skills, ability to work independently, and effectively communicate with customers.
The incumbent must be capable of working at a broad technical level in all phases of the application systems project life-cycle, and must be able to apply business knowledge and technical skills to systems development.


2 - 5 years of experience in Information Technology
Experience in Healthcare or Health Insurance Industry
Extensive experience in Informatica PowerCenter toolkit is required for this role
Experience at Enterprise-level ETL development and ETL architecture using Informatica
Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor;
Good knowledge of analytical and logical conceptual level programming skills;
Good knowledge of Erwin model generation tools (logical and physical);
Data analysis, data mapping, data loading, and data validation;
Understand reusability, parameterization, workflow design, etc.;
Understanding of Entire life cycle of Software and various Software Engineering Methodologies;

Certification: Cogons



Java/JavaScript Framework, Data Warehousing, Business Object, .net, Visual Age, C/C++, Microsoft Office, SQL, MQ Series, Unix, JAVA, JAVA Applets, JAVA Servlets, JAVA Script, UML, XML, JSP, EJB, Broadvision, Rational Rose, JBuilder, OO Concepts and Patterns, ICE Faces, SPRING, Harvest, MyEclipse, ClearCase. 2.0, EJB 3.0, AJAX, JSF 2.0, PL/SQL, JUnit, HTMLUnit, Websphere 7.0, JAVA 6, JPA, MyEclipse Blue, UML, J2EE 1.5, SQL, Oracle 11g, CA Software Change Manager, PEGA and Angular JS