This individual will act as the ETL Developer for the project and will be responsible for developing ETL application using Informatica. This position requires demonstrated experience using the Informatica Suite of tools including Power Center, B2B, and Power. This position will develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data loading tasks in support of project’s data sources. The Database environment for the project is Oracle and for the data sources, it will vary depending upon the data source. Prior experience with SQL on Oracle databases will be required.
Duties:
. Develop new ETL application using Informatica Power Center to load large amount of data from multiple data sources into project’s Repository using Oracle database - 40%
. Develop Data Integration procedures using Informatica suite of tools including B2B and Power Exchange - 10%
. Develop SQL programs and Stored Procedures as required for the ETL processes and Data Integration activities - 10%
Provide support to technical team, write the necessary required documentation as per the development methodology for ETL processes, and Develop unit test plan, test cases and resolve ETL related test problems - 20%.
. Coordinate, plan, communicate, develop and review client presentations and documentation required under the Enterprise Lifecycle - 10%.Work with the application teams to understand the nature of ETL interfaces and the architecture of the application. Design the appropriate interface interactions for each, while being cognizant of opportunities for reuse and standardization of interactions across applications - 10%.
Skills:
1. Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments.
2. Data warehouse data modeling experience.
3. Demonstrated Strong experience using the Informatica Suite of Tools - Power Center version 8 or higher, Power Exchange version 8 or higher, B2B Data Transformation.
4. Strong experience in the design and development of mappings, transformations, sessions and workflows in PowerCenter.
5. Strong experience in SQL in the Oracle environment.
Nice to have:
1. Healthcare system experience.
2. Massively parallel database experience.
3. Ability to create technical documentation content and templates.