| Oracle ETL consultantat New York, NY ( Local) at New York, New York, USA |
| Email: [email protected] |
| From: Sonali Tiwari, TekInspirations [email protected] Reply to: [email protected] Job Description - Job Designation: Oracle ETL consultant Job Location: New York, NY ( Hybrid)-- Need Local candidate with Active LinkedIn Profile LTimindtree Job Description: Experience 8-12 Years Technical skills : Informatica Power Center, Data Ware Housing, SQL Experience: 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 modeling. 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 Responsibilities: Designs, develops, automates, and supports complex applications to extract, transform, and load data. Ensures data quality. Plans and conducts ETL unit and development tests; monitors result and takes corrective action. Work on basic and advanced transformations such as normalization, cleansing, aggregation, summarization, and integration. 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 data access, transformation, and movement requirements into functional requirements and mapping designs. Designs automation processes to control data access, transformation, and movement. Ensures source system 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. Keywords: business intelligence procedural language New York |
| [email protected] View all |
| Wed Oct 18 02:26:00 UTC 2023 |