Oracle ETL Consultant

3 weeks ago


New York, United States ClifyX Full time

1257293
$70/hr
LTIMindtree
Oracle ETL Consultant
Preferred Location:
New York City, NY
Role: Oracle ETL Consultant
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.



  • New York, United States Perfict Full time

    About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...

  • Oracle Consultant

    1 week ago


    New York, United States TALENDICA Full time

    Role:- Oracle HCM Lead Consultant Job Location: Richmond, VA Duration: 6+ Months Visa Type:- Only USC/GC Responsibilities: · Proven experience as a Lead consultant to drive HR technology implementations through planning, process design, configuration, Process playback, user acceptance testing, cutover and production launch. ·Lead the Design and...


  • New York, United States Capgemini America, Inc. Full time

    As a Senior Oracle Fusion Analytics Warehouse Consultant, you will be responsible for leading and overseeing the implementation, customization, and optimization of Oracle Fusion Analytics Warehouse solutions for our clients. Your expertise in Oracle Fusion Analytics Warehouse will be critical in providing strategic guidance, designing solutions, and...

  • Oracle Consultant

    1 week ago


    New York, United States TechnoGen, Inc. Full time

    Job Title: Oracle SCM Cloud Techno FunctionalLocation: RemoteDuration: Long Term. Job Description:As an Oracle SCM Cloud Techno-Functional Consultant, you will be responsible for providing expertise in both technical and functional aspects of Oracle Supply Chain Management Cloud applications. You will collaborate with stakeholders to understand business...

  • Oracle Developer

    18 hours ago


    New York, United States Capleo Global Full time

    Title: Oracle Developer Locations: New York City, NY / Jersey City, NJ - Onsite Type : Fulltime Opportunity Job Description: Proven experience working with Oracle Database, SQL and PUSQL. Strong knowledge of database management and design. Excellent understanding of performance tuning and optimization. Familiarity with ETL (Extract, Transform,...


  • New York, United States TekStream Solutions Full time

    Sr. ETL Administrator Department: Technology Services Location: Remote/Reston, VA Description We are currently seeking an Application Administrator to work within a team that provides Data Warehouse and Business Intelligence services to our government customer using Agile scrum processes. You will work with varying data sources with different schemas and...

  • Oracle Apex Developer

    1 month ago


    New York, United States 22nd Century Technologies Inc. Full time

    Strong knowledge and experience in Oracle APEXExceptional intelligence and problem solving skillsMust be able to convert functional requirements into technical specificationsMust possess strong communication skills and the ability to work well in project team environment and a self-starter5+ years RDBMS analysis and designing and development of data models...

  • Oracle Apex Developer

    2 weeks ago


    New York, United States 22nd Century Technologies Inc. Full time

    Strong knowledge and experience in Oracle APEXExceptional intelligence and problem solving skillsMust be able to convert functional requirements into technical specificationsMust possess strong communication skills and the ability to work well in project team environment and a self-starter5+ years RDBMS analysis and designing and development of data models...

  • Oracle Apex Developer

    16 hours ago


    New York, United States 22nd Century Technologies Full time

    Strong knowledge and experience in Oracle APEXExceptional intelligence and problem solving skillsMust be able to convert functional requirements into technical specificationsMust possess strong communication skills and the ability to work well in project team environment and a self-starter5+ years RDBMS analysis and designing and development of data models...

  • Oracle Apex Developer

    1 month ago


    New York, United States 22nd Century Technologies Inc. Full time

    Strong knowledge and experience in Oracle APEXExceptional intelligence and problem solving skillsMust be able to convert functional requirements into technical specificationsMust possess strong communication skills and the ability to work well in project team environment and a self-starter5+ years RDBMS analysis and designing and development of data models...


  • New York, United States Cogent IBS, Inc Full time

    Position 1. Business Analyst (2)Needs to travel to New Yorklong Term 5 8 years of experience with Oracle ERP Financials, Procurement, Project management Strong understanding of business process and accounting BA with Oracle ERP Consultant


  • New York, United States Spiceorb Full time

    Hi, Hope you are doing great . Spiceorb is hiring for Oracle Cloud PLM Functional Consultant for one of his client on remote basis. Please share resume with visa and DL . Oracle Cloud PLM Functional Consultant


  • New York, United States Oracle Full time

    Work Location: Should be able to travel 40% for meetings in Cleveland, OH We are seeking an accomplished technology professional with experience in developing Java software solutions that complement, customize, or extend Oracle Communications or telecom products. What you've done: 7+ years of experience in the telecommunications industry developing Java...

  • ETL Developer

    2 weeks ago


    New York, United States TechTriad Full time

    Role: ETL Developer (Data Warehouse)Location: NYC, NY – Remote with occasional travelDuration: Long TermThis consultant shall be responsible for maintaining and enhancing of existing ICMS Data Warehouse and any other databases hosted is support of reporting solutions to business Involve in troubleshooting any data issues as and when arisen and resolve help...

  • ETL Developer

    1 week ago


    New York, United States TechTriad Inc Full time

    Role: ETL Developer (Data Warehouse) Location: NYC, NY Remote with occasional travel Duration: Long Term This consultant shall be responsible for maintaining and enhancing of existing ICMS Data Warehouse and any other databases hosted is support of reporting solutions to business Involve in troubleshooting any data issues as and when arisen and resolve help...

  • ETL Developer

    2 weeks ago


    New York, United States TechTriad Full time

    Role: ETL Developer (Data Warehouse)Location: NYC, NY – Remote with occasional travelDuration: Long TermThis consultant shall be responsible for maintaining and enhancing of existing ICMS Data Warehouse and any other databases hosted is support of reporting solutions to business Involve in troubleshooting any data issues as and when arisen and resolve help...


  • New York, United States Estuate Inc. Full time

    As an Oracle Fusion Advanced HCM Controls Implementation Consultant, your primary responsibility is to lead the implementation and configuration of Oracle Fusion Advanced HCM Controls modules for clients. Here's a breakdown of your job description:Key Responsibilities:Requirement Analysis: Collaborate with clients to gather and analyze their business...


  • New York, New York, United States TEKsystems Full time

    ***6 month+ contract******W2***Must be fully covid vaccinated, even for remote rolesDescription:Our healthcare client is looking for a Sr. Oracle DBA on a 6 month contract for a migration to Exadata (OCI). The primary responsibility of the Oracle DBA will be to plan, design, and execute complex database migrations from one environment to another, such as...

  • Oracle CDM Consultant

    14 hours ago


    New York, United States The Dignify Solutions LLC Full time

    Conversion of customer data from Legacy to Oracle CDM Work directly with business to understand current landscape of customer data and fit that into Oracle CDM Oracle Cloud CDM Implementation Experience. Minimum 1 end to end implementation Oracle Cloud MDM Implementation Experience. Minimum 2 end to end implementation Oracle Cloud SCM Implementation...


  • New York, United States Capgemini America, Inc. Full time

    As an Oracle Fusion Advanced HCM Controls Implementation Consultant, your primary responsibility is to lead the implementation and configuration of Oracle Fusion Advanced HCM Controls modules for clients. Here's a breakdown of your job description:Key Responsibilities:Requirement Analysis: Collaborate with clients to gather and analyze their business...