ETL/Informatica Data Quality Consultant
Project Performance Corporation (PPC) was named one of the Washington, DC area’s “Best Places to Work” by Washingtonian Magazine in 2007. We are part of a 350 -person multi-disciplinary team of information technology professionals, project management experts, scientific and technical experts, and legal and regulatory specialists dedicated to providing fully integrated and business-oriented solutions. Our cutting edge IT and management solutions benefit Fortune 500 decision makers and governments around the world.
We are currently hiring experienced ETL consultant with experience using Informatica Data Quality (IDQ) for open position within our Information Solution Group (ISG). As a member of the ISG the consultant will be responsible for providing consultation to end users to understand and document business and functional requirements for complex projects, including full software development life cycle, DW/BI/ETL tools and other related technologies.
Participating in consulting-related projects in creative and collaborative sessions to build solid relationships with clients; developing an awareness of client requirements and business drivers associated with client business intelligence (BI) and data warehouse (DW) information management needs. Tasking will include:
Evaluating enterprise DW architecture feasibility, risk and technologies related to business change (i.e. assessing, identifying and recommending BI and related business stakeholders' data requirements; BI solution prototyping and development; processes and performance from business and technical standpoints; and the impact of data changes on business and/or IT processes)
Advising CXO's on emerging BI/DW technologies and strategies consistent with clients' business strategies
Prioritizing, preparing and implementing BI and/or DW architectural improvements (i.e. developing and recommending alternative DW technical and data management solutions, methodologies, strategies and architectural improvement plans)
Developing and validating business stakeholders' conceptual data models, including socializing and implementing logical and physical DW/Datamart data models; identifying data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements.
This position will focus on Functional Informatica Data Quality efforts necessary to perform ETL and Informatica administration for Data Quality (DQ) projects and tasks. Inclusive of design, create, test, manage, and documentation of the complex Informatica functions and manipulations.
B.S. in Computer Science, or equivalent degree; or equivalent industry experience.
Minimum 5 years software solution development/deployment experience required, preferably on enterprise Data Integration/DQ projects.
Qualified candidates will have demonstrated experience in the effective use and deployment of Informatica Data Quality tools, including IDQ, Informatica Data Explorer ("IDE") and Informatica Identity Resolution ("IIR"), along with the ability to work either independently or within a team environment, and possess a combination of technical depth, excellent written/verbal communication skills and client management skills.
Successful candidates will have Minimum of 3+ years of experience in the following skills:
Enterprise data management, data warehousing and/or business intelligence; data modeling, integration and/or synchronization, quality, security, conversion and analysis; database administration; and/or enterprise data management policies, procedures, compliance & risk management. This includes a minimum of having participated in two full life cycle implementations
Architecture, design and development of enterprise business intelligence and data warehousing solutions, including utilizing leading ETL/BI tools and the ability to architect a solution
Design and development of data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching that leverages knowledge within data, master data, metadata and technology management.
Experience configuring and deploying complex client/server software on Unix and Windows servers required.
Strong database skills required.
Significant experience delivering and managing solutions around Data Integration, DW/BI deployment a plus.
Familiarity with current trends in Data Quality technologies.
Excellent written and verbal communications skills.
U.S. citizen or otherwise presently authorized to work full-time in the United States.
Up to 75% travel in Washington DC and Baltimore MD metropolitan area.
Experience with IBM QualityStage, SAP BusinessObjects DQ, DataFlux and/or Trillium DQ software desired.
Experience with Informatica PowerCenter strongly preferred.
Oracle experience/certification highly preferred.
PPC is an Equal Opportunity Employer