Oracle ETL Architect- C2C Contract Position

3 weeks ago

Albany, United States Fortuna BMC Full time

Are you passionate about architecting efficient data solutions within the Oracle ecosystem? Do you thrive in designing and optimizing Extract, Transform, Load (ETL) processes to drive data-driven insights and decision-making?As an Oracle ETL Architect, you will play a pivotal role in designing, implementing, and optimizing ETL solutions using Oracle technologies. You will collaborate closely with stakeholders to understand data requirements, design scalable ETL architectures, and ensure seamless data integration across systems. Your expertise in Oracle databases, ETL tools, and data modeling will be instrumental in driving the success of our data initiatives.If you are a proactive problem-solver with a knack for optimizing data workflows and a passion for leveraging Oracle technologies to unlock the full potential of data, we want to hear from you.This position is 100% onsite in Menards, NY and a C2C contract for 30 months.WHAT YOU'LL DO:Working with large and complex Oracle data warehouses, data marts and OLTP databases.Overseeing the creation/modification of Oracle database tables of the appropriate type for the situation.Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Center and Rhapsody.Guiding the ETL team in shaping, enhancing and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture.Investigating and resolving difficult design and build issues, data loading and data integrity issues.Performance tuning Informatica/Rhapsody workflows.Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets.WHAT YOU'LL BRING:Experience (12+ Years) Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.84 Months Experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings.48 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring and managing millions of records of data including XML and HL7 message formats.84 Months Experience using Informatica 8.x or higher, including 10.2, in a data warehouse environment including warehousing concepts, design and development of complex mappings.84 Months Experience with Informatica Data Quality 8.x or higher, including 10.2, processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge.84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing.72 Months Experience working with Health Data with HIPAA, HL7 or similar standards.#J-18808-Ljbffr

by Jobble

  • ETL Data Warehouse Architect

    7 days ago

    Albany, United States Xyant Technology Full time

    Job Description _ Please send your updated resume to vinoth.xyant@gmail. com_ Job Title: ETL / Data Warehouse Architect. Location: Albany, NY (Onsite) Duration: Long-term Contract Direct Client Need Responsibilities: Manages the planning and delivery of data warehouse and storage architecture. Manages relationships stays capable of working with software and...

  • ETL Data Warehouse Architect

    3 weeks ago

    Albany, New York, United States Xyant Technology, Inc. Full time

    Job Description Please send your updated resume to vinoth.xyant@gmail. com Job Title: ETL / Data Warehouse Architect. Location: Albany, NY (Onsite) Duration: Long-term Contract Direct Client Need   Responsibilities: Manages the planning and delivery of data warehouse and storage architecture. Manages relationships stays capable of working with...

  • ETL/DataStage Developer

    3 weeks ago

    Albany, United States Absolute Staffing & Consulting Solutions Full time

    Job DescriptionJob DescriptionAbsolute Staffing is searching for a ETL/DataStage Developer to work with our client. Location: Albany, NY - HYBRIDDuration: 30 Months (Contract )72 Months ETL development experience in Oracle environment with IBM DataStage 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming84 Months...

  • ETL Developer

    13 hours ago

    Albany, United States Sigma Full time

    13392 ETL Developer, Albany, NY, 30 months Contract Sigma Inc is currently looking for an ETL Developer at Albany, NY. Working Hours: 7:00am - 5:30pm (Starting time is negotiable) 50% On-Site, mandatory no exceptions, Applicants should be prepared to report on-site 100% 50% non negotiable Description: Ensuring application documentation is complete,...

  • Need for INFORMATICA ETL + ALBANY,NY

    27 minutes ago

    Albany, United States 3A Soft Inc Full time

    84 Months Experience using Informatica Powercenter 9.6.x or higher in a data warehouse environment including familiarity with advanced warehousing concepts, and design and development of complex mappings 84 Months Experience with Informatica Powercenter Administration including Installation, Patching, Metadata analysis, ETL code migration, and repository...

  • Oracle APEX Developer

    3 weeks ago

    Albany, New York, United States System Edge (USA) L.L.C. Full time

    Hello, We are urgently hiring for the below contractual role with our Direct clientNYS:Job Title: Oracle APEX DeveloperClient: State of New YorkAgency: Office of the New York State Comptroller (OSC)Task ID: HBITS Location: 110 State Street Albany, NY 12236Duration: 12 monthsRate: $60/hr on C2C (all incl.) This is a long term opportunity on the Hourly-Based...

  • Sr. IBM ETL DataStage Developer

    4 days ago

    Albany, United States Sligo Software Solutions Full time

    Job DescriptionJob DescriptionDescriptionThis position will assist in supporting critical DOL operational functions focused on the development and optimization of DOL Data Management processes, respond to critical requests, and assist in the transition of legacy processes to the Worker Protection Consolidation Project. DutiesEnsuring application...

  • Need for Oracle SQL Developer with healthcare Exp + ALBANY, NY

    19 hours ago

    Albany, United States 3A Soft Inc Full time

    84 months experience in the area of: Public Health information Systems such as Medicaid or the Childs Health Insurance Program 84 months experience using Oracle products including: SQL Developer, SQL plus and executing SQL scripts using DBeaver to query Vertica and Oracle Databases 84 months experience Working with Stakeholders and vendor in the entire...

  • Database Architect- Expert

    7 days ago

    Albany, United States Mindlance Full time

    Provide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Interact with Agency/business subject matter experts to...

  • Systems Developer Expert

    7 days ago

    Albany, United States Cedar Park Group Full time

    Cedar Park Group is looking for an Expert Systems Developer. 50% Remote. Full-time. 8AM-5PM. 11 month contract. Duties: Develops and implements applications and programs for the backend processing systems used in businesses and organizations. Work in coordination with a team of developers to write the new Facility Application Management system in ASP.net...

  • Software Developer

    4 weeks ago

    Albany, United States Castletop Logistics LLC Full time

    Overview: We are seeking a Software Developer (Oracle APEX) Consultant to act as a Software Developer for the APEX Team in the OSC Division of the Chief Information Officer (CIO). **Responsibilities**: - Work under the guidance of the APEX Team Manager and Supervisor. - Help OSC management develop APEX Roadmap and Strategy. - Contribute to the development...

  • Software Architect

    12 hours ago

    Albany, United States Five Cubes, Inc. Full time

    Job Title: Software Architect - 13184 Location: Albany, NY Duration: 30 Months Direct ClientJob Description: Daily Tasks include but not limited to the following: Evaluate existing and emerging technology, business requirements for the purpose of architecting efficient, portable and scalable solutions. Analysis, modeling, design, coding, testing and...

  • Java Architect

    20 hours ago

    Albany, United States Bits & Bytes Technology Solutions Full time

    Java ArchitectDuration: 30 monthsLocation: Albany, NY (2-3 days remote every week)Client: State of New YorkJob Description:1.84 months experience in developing applications that are implemented with JAVA Development Kit (JDK 1.8 or higher).2.84 months experience with web development using JSF/JSP, HTML, CSS, and JavaScript.3.84 months experience in...

  • Enterprise Architect

    6 days ago

    Albany, United States Experienced Recruiting Partners Full time

    Contract roleLocation: Albany, NY Hybrid - The consultant will be expected to work onsite 50%. The remainder will be remote or traveling.Travel: Approximately 30-50%. This could vary based on client need. Length: currently until 7/30/2025Overview: As an Enterprise Architect, you'll play a vital role in guiding digital transformation through transformation...

  • IT Specialist

    2 weeks ago

    Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionHi ,We are looking to hire suitable candidates for HBITS-05-13391 - ETL developer opportunity with one of our clients in Albany, NY.We are a prime vendor to the New York State and work on their HBITS: Hourly-Based IT Services (New York Statewide) requirements.Position Name: ETL developerJob ID: HBITS-05-13391Duration: 30+ Months...

  • IT Specialist Expert

    3 days ago

    Albany, United States UrBench Full time

    Job DescriptionJob DescriptionHBITS-05-13392 - IT Specialist ExpertNew York State Department of LaborState Offices Harriman Campus Building 12 Albany, NY 12240USC/GC/GC-EAD/H4-EAD$65/hr72 Months ETL development experience in Oracle environment with IBM DataStage.84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming.84...

  • Network Architect

    7 days ago

    Albany, United States Indsafri Full time

    Job Description:Title: Network ArchitectLocation: Albany, NY (Hybrid)Position Type: ContractContract Duration: 30 Months Requirements:84 Months of Experience in Network Architecture designing, implementing, and supporting multivendor platforms including, but not limited to Cisco, Palo Alto, Aruba and Meraki solutions.84 Months of Experience with Routing,...

  • Network Architect

    1 week ago

    Albany, United States Indsafri Full time

    Job Description:Title: Network ArchitectLocation: Albany, NY (Hybrid)Position Type: ContractContract Duration: 30 Months Requirements:84 Months of Experience in Network Architecture designing, implementing, and supporting multivendor platforms including, but not limited to Cisco, Palo Alto, Aruba and Meraki solutions.84 Months of Experience with Routing,...

  • Network Architect

    1 week ago

    Albany, United States Indsafri Full time

    Job Description:Title: Network ArchitectLocation: Albany, NY (Hybrid)Position Type: ContractContract Duration: 30 Months Requirements:84 Months of Experience in Network Architecture designing, implementing, and supporting multivendor platforms including, but not limited to Cisco, Palo Alto, Aruba and Meraki solutions.84 Months of Experience with Routing,...

  • Network Architect

    1 week ago

    Albany, United States Indsafri Full time

    Job Description:Title: Network ArchitectLocation: Albany, NY (Hybrid)Position Type: ContractContract Duration: 30 Months Requirements:84 Months of Experience in Network Architecture designing, implementing, and supporting multivendor platforms including, but not limited to Cisco, Palo Alto, Aruba and Meraki solutions.84 Months of Experience with Routing,...