Previous Job
Informatica Lead
Ref No.: 18-00449
Location: Denver, Colorado
Position Type:Contract
Start Date: 08/21/2018
Role: Informatica Developer
Location: Denver, CO
Duration: 12 Months
Mandatory Skills: Informatica
Experience: 7 Yrs


Informatica Lead
Job Description: Candidate will have the responsibility of leading the team from technical and functional perspective. Gather and analyze the requirements, Design and guide the team in implementation and participate in implementation. Reviewing the implementation and making sure good quality of the code/solution is delivered.

  • Conducts data requirements assessment and design sessions with customers.
  • Works with analysts to establish clearly defined business requirements.
  • Works with data suppliers to establish input and interface specifications.
  • Guides the DW team on how to performs data analysis for source system data.
  • Directs the design of conceptual, logical and physical models for healthcare data warehouse implementations.
  • Leads the team on best practices when designing and managing data models in data modelling product.
  • Directs and performs the development of third normal form and dimensional models that adhere to data warehouse best practices.
  • Facilitates the design of time-variant models that support both point-in-time (historical) and current state analysis.
  • Reviews DDL from model for RDBMS (Oracle, Teradata, ...).
  • Provides professional documentation describing data architecture.
  • Represents DW team and collaborates with the customer and other agencies to conduct data risk assessments, document data mappings/lifecycle, and help build a data governance model, policies and programs.
  • Collaborate with ongoing customer enterprise wide MDM and metadata projects.
  • Understands customer's Data Management program and environment and identifies the next generation of processes and products to refine and extend the lifecycle of the program.
  • Develops the approach for the implementation of Data Management lifecycle components (examples include master data management, conformance with reference architecture, metadata strategy, data warehousing strategy, data classification programs, data quality,)
  • Collaborates across the organization to understand the value of these components and obtains alignment in the approach and benefits.
  • Leads project teams in the implementation of the data management lifecycle components.
  • Provides direction and reviews solutions with regard to data architecture, working with software development teams and enterprise and application architects to ensure consistency and coherence with the enterprise architecture.
  • Based on knowledge of data centric technology trends in the marketplaces, determines their applicability to the customer; evaluates and recommends data related technology products based on client's overall directional goals.
  • Demonstrates an ability to quickly identify the most likely problem area in a complex, integrated data environment

Skills and Experience:
  • 8+ yrs hands on experience in ETL Informatica 10.x, DW technical development; data architecture, data integration, business intelligence and data analysis tools
  • 5+ yrs developing technical architecture and leading implementation teams
  • Healthcare related data modelling experience
  • Strong ETL Informatica experience
  • Oracle DBMS experience
  • Exposure to Business Intelligence platforms (e.g., Cognos,)
  • Excellent Communication Interpersonal skills
  • Complete understanding of the different integration points of Healthcare transactions
  • Success as a DW technical lead, delivering solutions for large projects integrating diverse technologies and products
  • In-depth understanding of DW implementation and application development best practices
  • Excellent documentation skills, ability to produce diagrams and schematics that visualize technical solutions
  • In-depth understanding of RDBMS applications as well as relational & dimensional data modelling practices
  • In-depth understanding of data integration best practices, leading industry applications & features such as master data management, entity resolution, data quality assessment, metadata management
  • In-depth understanding of security models and methods to protect information in the DW solution