Job Description :
Relevant Experience & Experience Required (in Yrs):
3-5 Years MDM development experience
3-5 yrs Informatica development experience
2-3 yrs of Unix working experience
Relevant experience in Analysis, Design, Development, Implementation
Testing and trouble shooting of applications using Informatica, PL/SQL, Master Data Management, Unix shell scripting and RDBMS systems like Oracle.
Good experience in Unit Testing, System Integration Testing, UAT and production support.
Dimensional Data Modeling Concepts and Data warehousing methodologies
6-10 years of total IT experience

Technical/Functional Skills -MUST HAVE SKILLS:

Expertise in Analysis, Design, Development, Implementation, Testing and trouble shooting of applications using Informatica, PL/SQL, Master Data Management (MDM), Unix shell scripting and RDBMS systems like Oracle.
Domain expertise in Pharmaceutical and Workforce area.
Informatica Designer tools like Source Analyzer, Transformation Developer, Mapping Designer and Mapplet Designer.
Experience in using a variety of transformations such as joiners, filter, lookup, router, aggregator, normalizer and union in Informatica mappings.

Roles & Responsibilities:
Maintaining central data repository of enterprise-wide data and providing BI solutions for the distribution of the data across the departments through data subscriptions and web services.
Unit Testing, System Integration Testing, UAT and production support.
Responsible for maintaining a Central data repository of enterprise-wide data.
Meeting with the business users and stakeholders to gather requirements and translating these business requirements into technical specifications for code development.
Work closely with business analysts and gather functional requirements. Prepare technical design documents for ETL process.
Develop and maintain ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle, and Flat Files.
Debugging using Session Logs, Reject Files, and Session Logs from workflow monitor and Metadata Repository.
Assist the offshore team in the development, configuration and modification of integrated business and enterprise solutions for data distribution across the organization using ETL tools such as Informatica.
Liaison with offshore team on production support and development tasks.

Client : IT services, consulting and business solutions organization that delivers real results to global business