Job Description :
Job Title: Informatica Tech Lead
Location: Billerica,MA
Duration:Long term contract
Requisition Details:
Overview:
An Informatica Architect with primary focus of this position to provide technology leadership, architectural guidance, technological recommendations and reusable solutions that support the development and implementation of DW/BI solutions in Business Insurance area.
Requirements:
Candidate must be experienced working in ETL based projects involving Informatica.
Other ideal qualifications include experiences in:
Informatica (Technical Expert)
Oracle / Teradata (or equivalent RDBMS)
Understands where to obtain information needed to make the appropriate decisions
Demonstrates ability to break down a problem to manageable pieces and implement effective, timely solutions
Identifies the problem versus the symptom
Manages problems that require involvement of others to solve
Reaches sound decisions quickly
Carefully evaluates alternative risks and solutions before taking action
Optimizes the use of all available resources
Develops solutions to meet business needs that reflect a clear understanding of the objectives, practices and procedures of the corporation, department and business unit
Responsibilities:
Under the direction of the Portfolio Architect, assists with ETL design and solutions
Supports maintenance of plans to address significant architecture gaps between current and target state
Collaborates with business leaders to determine how to best use technology to enable growth and success (e.g. operational reporting and advanced analytics
Participates in defining and driving architecture competencies, processes, and best practices across Business Insurance.
Understands potential impacts of proposed solutions on other systems, processes or projects. Articulates and documents designs, considering tradeoffs, costs, and benefits.
Participates in day-to-day execution of the architecture strategy
Works within a single project to develop, communicate, and mentor others on design/implementation standards, guidelines and best practices
Stakeholder Management
Skills:
10-12 years of work experience in Informatica and other ETL tools
Good analytical and logical skills in writing SQLs, Stored Procedures and creating Marts/Views in Oracle
A good end to end knowledge in ETL landscape; starting from source system, warehouse, mart and reports
Very strong ETL Concepts and hands-on experience on Ab Initio ETL Tool (Basic & Advanced)
4-year degree in a related field (or equivalent experience)
Experience working within a highly-matrixed organization
Strong communication and presentation skills