Informatica data engineer nyc ny ref

Company Profile esrhealthcare.com.mysmartjobboard.com Infa data engineer NYC ny Experience level: Mid-senior Experience required: 8 Years Education level: All education level Job function: Information Technology Industry: Insurance Pay rate : $75 per hour Total position: 3 Relocation assistance: No NOTE FROM HM: The Candidate needs to be strong enough in Informatica Power center Development and Data Warehouse Multi-Dimensional modelling along with good SQL and PL/SQL skills. Please screen candidates thoroughly on these skills. Job Summary The Data Engineer is part of a Corporate Analytics team responsible for supporting data and analytics solutions for Client s Corporate Functions. This individual will collaborate with analytics team to design and implement Client corporate data strategy, ensuring reliable data infrastructure and creating data solutions for variety of business use cases. This individual will primarily support on enterprise financial data warehouse and multiple data marts working with various stakeholders and reporting applications team, successfully delivering the data requirement solutions. What you need to have: • 8+ years of experience with Oracle and SQL Server databases • 8+ years of experience with Informatica Power Center. • 8+ years software development experience in one or more of the following areas: ETL, BI and DW • 8+ years of experience in DW Multi-Dimensional modelling. • Understanding of the Project Delivery Framework and SDLC • Understanding of Waterfall and Agile Project Management Methodology • Strong analytical, communication and interpersonal skills. • Excellent and proven collaboration skills We will count on you to: • Designs, develops, automates, and supports complex applications to extract, transform, and load data. • Ensures data quality of the warehouse and data marts. • Plans and conducts ETL unit and development tests; monitors result and takes corrective action. • Work on basic and advanced transformations in informatica power center independently. • Performance Tuning of SQLs and handles huge volumes of data. • Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds • Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process. • Translates transformation and movement requirements into functional requirements and mapping designs. • Designs automation processes to control data access, transformation, and movement. • Ensures source data availability and update accessibility, data integrity, restart ability, and error handling. • Participates in the overall development process via architecture guidance, design and code reviews, and estimation and planning assistance • Performs other related duties as required Knowledge, Skills, And Abilities • Documents and troubleshoot problems and effectively communicate with business and technical team members at all levels What makes you stand out? Excellent communication and presentation skills Domain knowledge in one of more of corporate functions such as HR, Finance, Real Estate is preferred Excellent Problem-solving skills with innovative and proactive approach Ability to recommend and implement best practices and processes Powered by Webbtree