Job Description :
We are looking for Senior Informatica developer for onsite in Houston Long term contract for Development and support role Informatica ETL Developer capable of developing, enhancing, debugging, maintaining Informatica based software. • Create Informatica mappings with PL/SQL store procedures/functions to incorporate critical business functionality to load data. • Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance. • Develop procedures and functions using PL/SQL and develop critical reports. • Develop PL/SQL functions/procedures/cursors/packages/database triggers to implement business logic. • Work with relational databases like PostgreSQL, SQL Server. • Detail table design and index selection in PostgreSQL, SQL Server databases using SQL. • Develop mappings with XML as target and formatting the target data according to the requirement. • Work with logical, physical, conceptual, star, snow flake schema data models. • Extract data from flat files, and load the data into the PostgreSQL, SQL Server database. • Create and use debugger sessions to debug sessions and create breakpoints for better analysis of mappings. • Work with various data sources--relational, flat file (fix width, delimitate) and XML. • Involve in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration. • Create various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter. • Provide documented operation and user procedures, when require, and perform supporting training for other team members. • Provide on call support for Production issues