Oracle ETL Architect- C2C Contract Position

1 week 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.

  • Sr. .NET Developer with Oracle DB-C2C Contract Position

    7 days ago

    Albany, United States Fortuna BMC Full time

    We are seeking a skilled Systems Developer proficient in .NET technologies and Oracle Database. The successful candidate will be responsible for designing, developing, and maintaining .NET applications using C#, MVC, Bootstrap, .NET Core, and Oracle. This role involves collaborating with a team of developers to enhance existing systems, working closely with...

  • ETL Data Warehouse Architect

    Found in: Resume Library US A2 - 7 days 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

    1 day 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...

  • Database Architect Expert

    1 week ago

    Albany, United States PSI International Full time

    HBITS-05-13380 Database Architect Expert Agency Name: Information Technology Services (ITS) Is this a Project/Program specific Position? Yes If YES, list the Project/Program Name: Enterprise Data Warehouse and various Health Cluster projects within the agency. provide a short description of the Position: Data warehouse database and ETL(Extract, Transform,...

  • Oracle APEX Developer

    Found in: beBee jobs US - 3 days 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...

  • Oracle Consultant

    6 days ago

    Albany, United States CareerBuilder Full time

    84 months of experience in creating and reviewing designs, design patterns, development and implementation of JAVA, J2EE, JavaScript, Hibernate, REST web service, SOAP web service, Oracle, Oracle 12C OEM, JDeveloper, Eclipse, Visual Studio, JBoss, Subversion SVN, Linux, UML, JIRA, HP ALM, SOAPUI,POSTMAN,SQLDEVELOPER. 84 months of experience in SOA...

  • Database Architect

    1 week ago

    Albany, United States LanceSoft Full time

    Responsibilities: 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,...

  • Oracle Database Developer

    5 days ago

    Albany, United States CareerBuilder Full time

    Job Description: We are seeking an experienced Oracle Systems Developer to join our team and contribute to the development and maintenance of backend processing systems for businesses and organizations. As an Oracle Systems Developer, you will be responsible for developing and implementing applications and programs, with a focus on Oracle technologies....

  • Systems

    1 week ago

    Albany, United States Five Cubes, Inc. Full time

    Job Title: Systems Developer_Expert-13178 Location: Albany, NY Duration: 24+ Months Direct ClientJob Description: Work in coordination with a team of developers to expand the current Data Warehouse. Design/model, construct, load, and validate the data tables through the enterprise Data Warehouse architecture. Work with Business Analyst & customers on...

  • Oracle Database Developer

    1 week ago

    Albany, United States Oscar Full time

    Job Description:We are seeking an experienced Oracle Systems Developer to join our team and contribute to the development and maintenance of backend processing systems for businesses and organizations. As an Oracle Systems Developer, you will be responsible for developing and implementing applications and programs, with a focus on Oracle...

  • Oracle Database Developer

    1 week ago

    Albany, United States Oscar Full time

    Job Description:We are seeking an experienced Oracle Systems Developer to join our team and contribute to the development and maintenance of backend processing systems for businesses and organizations. As an Oracle Systems Developer, you will be responsible for developing and implementing applications and programs, with a focus on Oracle...

  • Oracle Database Developer

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago

    Albany, United States Oscar Full time

    Job Description:We are seeking an experienced Oracle Systems Developer to join our team and contribute to the development and maintenance of backend processing systems for businesses and organizations. As an Oracle Systems Developer, you will be responsible for developing and implementing applications and programs, with a focus on Oracle...

  • Oracle Database Developer

    Found in: Appcast US C2 - 1 week ago

    Albany, United States Oscar Full time

    Job Description:We are seeking an experienced Oracle Systems Developer to join our team and contribute to the development and maintenance of backend processing systems for businesses and organizations. As an Oracle Systems Developer, you will be responsible for developing and implementing applications and programs, with a focus on Oracle...

  • Oracle Database Developer

    1 day ago

    Albany, United States Oscar Full time

    Job Description: We are seeking an experienced Oracle Systems Developer to join our team and contribute to the development and maintenance of backend processing systems for businesses and organizations. As an Oracle Systems Developer, you will be responsible for developing and implementing applications and programs, with a focus on Oracle technologies....

  • Software Architect Expert

    1 week ago

    Albany, United States CareerBuilder Full time

    Cedar Park Group is looking for an Expert Software Architect. 50% Remote. Full-time. 7.30AM-4.00PM and 9AM-5.30PM. 30 month contract. Duties: Staff augmentation providing application development, enhancement, support, ongoing maintenance, mentoring and architecting expertise in an Oracle Java application environment and related Secure Software Development...

  • Android Developer with Jetpack and Kotlin

    1 week ago

    Albany, United States Fortuna BMC Full time

    As an Android Developer specializing in Jetpack and Kotlin, you will be responsible for designing, developing, and maintaining high-quality Android applications that meet the needs of our users. You will collaborate closely with cross-functional teams to translate requirements into technical solutions, leveraging the latest tools and technologies in the...

  • IT Digital Transformation Data Engineer/Architect

    1 week ago

    Albany, United States Tunabear Full time

    Job DescriptionJob DescriptionONSITELocation: Albany, NYContract Length: 18 month contract Contract Type: 1099 | C2CNot open visa workers including but not limited to H1B, EAD, OPTNot open to 3rd party agenciesDescriptionThe Data Engineer/Architect will thoroughly assess the data ecosystem to design an effective data architecture, driving organizational...

  • IT Digital Transformation Data Engineer/Architect

    2 days ago

    Albany, United States Tunabear Full time

    Job DescriptionJob DescriptionONSITELocation: Albany, NYContract Length: 18 month contract Contract Type: 1099 | C2CNot open visa workers including but not limited to H1B, EAD, OPTNot open to 3rd party agenciesDescriptionThe Data Engineer/Architect will thoroughly assess the data ecosystem to design an effective data architecture, driving organizational...

  • Oracle Database Administrator

    1 week ago

    Albany, United States CareerBuilder Full time

    Hello, We are urgently hiring for the below contractual role with our Direct client NYS: Job Title: Oracle Database Administrator (OBIEE / AIX) Client:State of New York Agency: NYS OPWDD Task ID:HBITS-05-13353 Location: 500 Balltown Road, Schenectady, NY 12304 Duration: 30 months This is a long term opportunity on the Hourly-Based IT Services (HBITS)...

  • Architect

    Found in: beBee S US - 2 weeks ago

    Albany, United States General Services Administration Full time

    Summary As a As an Architect, you will perform all aspects of professional architectural/engineering duties pertaining to project planning, design, construction and repair of buildings.Location of position: Design and Construction Division, Public Buildings Service, Albany, NY, Buffalo,...