Lead ETL Engineer -- New York -- Only GC or Citizen -- F2F is Required

Skip to first unread message

Nick Walker

Jan 2, 2013, 11:09:11 AM1/2/13
to nick....@panzersolutions.com

Please Respond to nick....@panzersolutions.com

Dear IT Professional,
Hope you are doing well,
This is Nick Walker from Panzer Solutions, LLC
If you feel perfect match with the below requirement please reply me with the best
number to reach and i will appreciate if you could send me a most updated word
formatted resume.

Job Title: Lead ETL Engineer
Duration: 6+ months
Location: New York, NY
Interview process: 1st round by phone, 2nd round is on site.

This position is a hands-on, technical position with a leadership role.
The ideal candidate will have a diverse background in data integration technologies, with a specialty in Informatica.
The candidate will have a solid architectural background and a firm grasp on the various database architectures for OLTP, ODS and Data Warehouse databases. Additionally, the candidate will have experience working with application architects and engineers to optimize data access paths while at the same time maintaining solid structural integrity and performance for integrating with backend data stores. The candidate will also possess excellent communication and presentation skills that are required for socializing technical concepts and building consensus.

Perform hands-on application integration data engineering tasks in the development of application integration solutions that involve complex, large-scale, (multi-terabyte size) data footprints leveraging ETL technologies
Perform capacity planning activities as related to application usage of resources that include storage, CPU, memory and network utilization
Optimize the ETL environments with respect to data access methods, access performance, storage, data integrity, system performance and system availability
Work closely with developers to optimize for, and efficiently integrate application into the ETL environment
Work closely with application developers to optimize data access and integrate the database platforms with application server environments
Develop tooling to better automate the application integration tasks
Liaise with the vendor and external support on issues such as upgrades, technical problems and solutions
Provide technical support to developers in the development environment
Document application integration standards for the ETL environments and processes
Provide engineering support for Informatica Data Quality, Informatica Data Explorer, and Informatica Power Exchange
Upgrade of existing Informatica plant v8.6 to v9.1 or v9.5  

Skills Required:
7+ years of solid Informatica administration and engineering
7+ years of solid relational database experience on MPP database systems
Experience with clustering technologies for performance and availability
Hands on experience with Informatica PowerCenter Enterprise Grid option on RedHat Linux platform; upgrade Informatica to v9.1/v9.5 from 8.6; Informatica Data Quality, Informatica Data Explorer, and Informatica Power Exchange
Experience in designing and configuring data solutions that scale in the terabyte range
Performance tuning skills for large MPP and non-partitioned databases
Understand RI concepts and real world trade-offs of the varying implementations
SQL coding skills
Understand dimensional data modeling, star and snowflake schema
Good analytical ability, strong consultative and communication skills
Ability to work in a team environment
College degree in computer science/related fields or equivalent experience

Required Management Skills:
Excellent verbal and written communication skills, as well as organizational skills
Experience with project management software
Ability to manage multiple high priority projects simultaneously 

Skills Desired:
DB2/UDB, Microsoft SQL Server and Teradata experience, knowledge of Informatica 9.x is a plus 

Best Regards,
Nick Walker | Sr Technical Recruiter
Panzer Solutions LLC
45 Stuart Ave, K Unit                                    
Norwalk CT 06850 USA
Email: nick....@Panzersolutions.com
Voice : 203-717-2989

Notice of Confidentiality:
The information contained herein is intended only for the confidential use of the recipient.
If the reader of this message is neither the intended recipient, nor the person responsible for delivering it to the intended recipient,
you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution, or copying of
this communication is strictly prohibited. If you receive this in error, please notify the sender immediately by telephone,
and destroy this e-mail message OR reply with the subject ?REMOVE? such that your email would be taken out of our distribution list.

Reply all
Reply to author
0 new messages