Hi Associates,
Hope you are doing great,
Please let me know on jigar@riderconsultinginc.com if you have any good resources for the below position mentioned
Role : Lead ETL Engineer
Duration: 6+ months
Location: New York, NY
Interview process: 1st round by phone, 2nd round is on site. Local candidates only
Lead ETL Engineer – 6+ months – New York, NY
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.
Responsibilities:
· 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
Jigar Patel
Rider Consulting Inc
E-mail:- jigar@riderconsultinginc.com
Web Site :- www.riderconsultinginc.com
Ph No:- (813) 862-1576
No comments:
Post a Comment