ETL Lead

ETL Consultant

Overview: A ETL Consultant with a 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

Requirements:
Candidate must be experienced working in ETL based projects involving Informatica. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.

• Must be fully versed in working with Informatica

• Must have an understanding of ERP business processes, data warehouse and BI concepts and ability to apply educational and practical experience to improvise business intelligence application

• Must be able to provide simplified and standardized solutions to achieve the business objectives.

• Ability to provide both innovative and improvement solutions to current and anticipated business challenges.

• Expert knowledge of data warehouse architecture

• Well versed with database administration tasks and working with DBAs to monitor and resolve ETL (Informatica) issues

• Well versed with SQL and MDX concepts.

• Independent problems solving skills.

• Strong interpersonal and communication skills and ability to interact positively with peer groups within IT and outside IT and management

Responsibilities:

• Provide support to end users of BI Applications from system analysis to BI/ ETL (Informatica) development and support.
• Use appropriate software development methodologies prescribed by Res Med.
• Interact with users to gather requirements from various departments and document business requirements; and to prepare functional specifications and mockup designs as necessary.
• Troubleshoot data warehouse and BI issues using SQL development and querying tools (e.g. Toad), Provide production support and help resolve nightly ETL (Informatica) data & Cube refresh issues.
• Interact with local. remote development teams and other regional BI teams for production support
• Troubleshoot, debug and diagnose BI / ETL (Informatica) issues
• Develop and/or enhance ETL (Informatica) solutions - expert knowledge of Informatica and Oracle PL/ SQL programming required
• Provide performance tuning and enhancement of ETL (Informatica) processes, including supporting technical documentation
• Provide BI training to various business users and on new BI projects.

Candidates requiring visa sponsorship WILL NOT be considered at this time. 'We are an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion,sex, national origin, gender identity, sexual orientation, disability status, protected veteran status, or any other characteristic protected by law.