1) Informatica PowerCenter Developer:
Seeking a senior Informatica PowerCenter Developer with BI/DW experience needed to develop and enhance ETLs from various sources to Oracle data warehouse. Responsible for devising data conversion strategy for a system focused on delivering an advanced analytical capability to the client. Duties may include creation of new Informatica scripts, transition of PL/SQL ETLs to new Informatica scripts, or modification of existing scripts. The candidate will be involved in developing Informatica Mappings and writing complex Oracle PL/SQL programs for the Data Warehouse. Other tasks involve analyzing transaction errors, troubleshooting issues in the software, developing bug-fixes, involving in performance tuning efforts, apart from providing operational - must have strong Oracle PL/SQL experience - must have strong Oracle database structure creation, modification experience - must have active TS clearance - ability to work in fast paced environment (2 week agile delivery cycles) and stringent deadlines MicroStrategy BI reporting experience a plus, Informatica IDQ and other Informatica modules experience a plus.
• Informatica PowerCenter development experience, • Oracle 11G PL/SQL expertise • 5 years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes • Experience in developing and deploying Informatica in Unix and Oracle 11g database environment • Ability to analyze and retrieve metadata from Informatica repository • Ability to architect an ETL solution and data conversion strategy • Project experience with developing complex SQL query • Project experience with dimensional data model • Strong communication skill to work with client, business users and team members • Ability to work independently once guidance and goals are provided • Ability to work well as a team
• Good understanding of MicroStrategy • 5 years of System Development Lifecycle experience from an engineering perspective • Business knowledge of FBI • Knowledge and usage of defect tracking tools and processes for production maintenance • Knowledge and usage of software versioning/revisions control system such as Subversion SVN • Solid understanding and practical experience of software development life cycles, with emphasis on release engineering functions