Informatica Architect and Netezza
LOCATION: anywhere US near a major airport
50% Travel and expenses will be covered.
This position is for a US team member of the Data Integration Practice of Datavail, which champions advanced Database Development, Tuning and Automation projects for various MNCs ranging from US SMEs to Fortune 500 companies.
This position demands an EXPERT technical skillset with Informatica ETL product and related BI suit . The typical work involves customer facing, requirement gathering, designing solutions, plus designing, troubleshooting, maintaining and administering Informatica ETL systems and Netezza
A minimum 6+ years of experience in Informatica administration and development
Excellent verbal and written communication skills.
Strong organizational and documentation skills.
Customer interaction, pre-sales support, designing and presenting solutions
Scope, plan, co-ordinate project activities with onshore
Supervise offshore team work efforts
Hands-on experience with:
Informatica Development & Tuning
Experience in Informatica Power Centre (ETL) - (Designer, Repository Manager, Workflow Manager), Job Schedulers.
Responsible for the operational support of Informatica environment including but not limited to automation, design, job scheduling, dependencies, monitoring, and maintenance
Manages and administers systems performance including on-going optimization and tuning of Informatica environment
Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the Enterprise Data Warehouse, and Data Marts
Assist data warehouse team in completing current data warehouse initiative projects
Strong experience in Data Migration and Data Quality initiatives
Must have experience in building complex SQL queries and Shell scripting.
Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.
Must have Netezaa experience
70% of time will work with Informatica (hands on) and 30% Netezza
Strong design & development background with demonstrable implementation experience
Ensure the overall health and performance of Informatica to include performance tuning, environment reliability and availability, and system recoverability from Hosting point.
Install, configure, and administer the Informatica platform for maximum utilization and throughput
Perform Upgrades and apply patches.
Serve as a subject matter expert for Informatica, demonstrating expertise in Data Quality, Metadata Manager, and Informatica Reporting Services
Strong knowledge of security framework within Informatica
Creation and management of Informatica users, project folders, shared folders and connectors and their permissions.
Technical Troubleshooting--Knowledge of approaches, tools and techniques for anticipating, recognizing, and resolving technical (hardware, software, application or operational) problems.
Backup/ recovery of Informatica software, repository and configurations.
6 months CTH
DLH Consulting, LLC