Job Order #3136

Email this Job to a Friend
Posted Date: 12/5/2019
Job Category:
Position Title: Informatica Architect
Salary Range:
Location: Pittsburgh, Pennsylvania, USA
Desired Skills:

• Fully understands the business requirements and translates the business requirements and logical model into technical requirements and communicates these to the development team
• Takes lead to perform detailed design (the Physical Data Model and transformations), based on understanding of the Logical Data Model (the business requirements) and the information captured in the workshops.
• Perform source data mapping to map the data from source systems to the target data model
• Design, and develop Informatica solutions and lead the technical team for successful deliveries.
• World class technical professional who has had a successful career driving database architecture, overseeing data management, data warehousing and DBA functions and guiding scalable, stable environments.
• Ability to manage/work with remote teams located globally.
• teaming and interpersonal skills; effectively communicates and collaborates cross functionally.
• Reputation for creating and leading a high performance work culture; a high energy individual who can motivate and energize others.
• Knowledge of project development lifecycle from business discovery through to user acceptance.
• Knowledge of datawarehouse implementation methodology and best practices.
• Demonstrate knowledge of data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, & end-user tools
• Proven ability to guide the architecture and design of large scale data warehouse solutions (20 TB or more) and integrating with data integration and BI tools.
• Knowledge and experience in implementing large scale data warehouses using different designs for centralized and federated database architecture .
• Hands on experience and extensive knowledge in large scale databases (Oracle, Teradata, DB2, SQL Server).
• In depth knowledge of database internals - query plans and execution, performance tuning, security etc.
• Hands on experience with logical data models and object Models with Tools such as Erwin data model, Rational, or Enterprise Architect.
• Proficient in data modeling concepts - different modeling paradigms like 3rd normal form and dimensional modeling for data warehouses and a clear grasp of the differences between the two techniques.
• Experience in the logical (LDM) to physical data model (PDM) translation
• Deep understanding of Data quality, metadata management, master data management and customer data integration solutions
• Experience with IBM /Informatica and understanding of various data integration strategies like real time data integration, CDC and ELT concepts.
• Hands on experience with Analytics and reporting tools such as SAS, Cognos, Business Objects or MicroStrategy.


• Degree in IT or related degree or equivalent desirable.
• Expertise in developing and delivering working documents that communicate and corroborate complex ideas
• 10+ years of Informatica Experience
• 3+ years experience in a solution architect or development lead role
• 5+ Years of Consulting experience with a good Project Management experience

• Location: Pittsburgh, PA (50% of travel to Client location is required with some remote option)
• Project Duration: 6 months
• Contract Renewal: Likely

Share this job: