Previous Job
Role - Informatica Designer
Ref No.: 16-08861
Location: SFO, California
Desire Skills for Informatica Lead Designer/Developer:
  • 8 + years' experience in Data Integration/ ETL development with considerable experience with informatica ETL
  • In-depth experience in Informatica environment and the various product tool set features and functions
  • 5+ years of ETL development experience preferably in Informatica
  • Experience in data analysis, data profiling, data integration, and data quality
  • 5+ years' experience performing data analysis and profiling, and designing ETL systems/programs
  • Expert SQL skills
  • In depth understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, etc.
  • Understanding of data warehouse best practices
  • Good communication skills
  • Good interpersonal skills and the ability to collaborate with other technical teams, project management, client management and business analysts
  • Experience working in an agile or continuous improvement environment.
  • Analytical background with deep problem solving skills
  • Ability to work independently once guidance and goals are provided
  • Ability to work well as a team

Job description:
  • Develop detailed systems documentation including installation guide, release notes, mapping documents, templates, maps, etc.
  • Provide high-level analysis and design reviews to solve conceptual problems and avoid duplication of efforts within the development group.
  • Ensure design, structure, and content meet performance guidelines; may assist with test planning and testing.
  • Analyze the performance of current code as well as new code to ensure reasonable performance is met.
  • Participate in designing, coding, testing, debugging, configuring, and documenting software and may include relations to operating systems. Apply generally accepted programming standards and techniques to assure efficient program logic and data manipulation.
  • Implement designs following software development processes to ensure adherence to design objectives and performs evaluations and code reviews throughout the development phase.
  • Communicate with all levels of staff with regard to technical concepts and design in order to create the best product which meets all of the customer requirements.
  • Gathers, Evaluates, Defines and Document the customer business functions and processes
  • Monitors project progress by tracking activity; resolving problems; recommending actions
  • Maintains user confidence and protects operations by keeping information confidential
  • Thorough Knowledge of ETL (Informatica Power Center), Oracle PL/SQL, DataModel@ER Studio and Data Warehousing Design and Architecture are a must
  • Ability to write Test cases, Queries in SQL@Oracle and Test Summaries are a must
  • Guide the Business Analyst to align the needs of both Business and IT leads in getting it documented per the standards
  • Good Experience in interacting with End Users, Analysts, and Technical Teams is needed.
  • Quickly come up to speed and a self-learner
  • Solid understanding of Agile methodology
  • Must be a Team Player.