*Job Title * ETL and MDM Developer
*Duration of assignment (in Months) * Long Term (12-24 Months) *Work Location (State, City ) * Indianapolis, Indiana *Relevant Experience & Experience Required* *(in Yrs)* · 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 *Key words to search in resume* · Informatica · PL/SQL · Master Data Management · ETL *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. *Shakeel Ahmad* IDC Technologies, 1851 McCarthy Blvd Milpitas, CA 95035 Call :408-459-5618 Email: *[email protected] <[email protected]>* Website: www.idctechnologies.com -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oracle-users. For more options, visit https://groups.google.com/d/optout.
