Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior ETL Consultant

AITA Consulting Services, Inc.

Only W2

Onsite/Hybrid

Job Description:


The candidate will be responsible for designing, developing, implementing, and supporting enterprise data integration solutions using Oracle Data Integrator (ODI) to meet business and operational needs.

This individual will be expected to participate in the following activities:

  • Manages ETL solutions for data warehouse projects.
  • Perform ETL application analysis, design, development and implementation, including: data analysis, data access, data structures, data manipulation, data reporting solutions, database, and technical and user documentation.
  • Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
  • Work with the Infrastructure team to execute activities such as performance test planning and execution failure failover planning and execution, endurance testing and deployment planning and testing.
  • Perform oversight of development activities which may include data analysis, data access, data structures, data manipulation, preparing logical database models, testing and implementation.
  • Prepare, and/or review technical documentation such as designs, schemas, etc., as appropriate.
  • Provide technical guidance to team of developers.
Requested Qualifications:
  • 72 months experience developing ETL/E-LT objects including Mapping, Packages, Scenarios and Procedures using Oracle Data Integrator.
  • 72 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents.
  • 72 months experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages in Oracle database 12c or higher.
  • 72 months experience working with Oracle Data Integrator 12c or later.
  • 60 months experience as a technical team lead responsible for data warehouse and ETL platform architecture.
  • 24 months experience developing, implementing, and integrating systems related to Criminal Justice processing at the state or federal level using Criminal Justice terminology and nomenclatures.
Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Senior ETL Consultant in Albany, NY vacancy
  • $97.2k - $121.51k

     ...DescriptionRamboll is a global architecture, engineering, and consultancy company. As a foundation-owned people company, founded in Denmark...  ...close the gap to a sustainable future.Your new roleAs our new Senior Lead Consultant with air quality compliance & permitting... 
    Senior
    Full time
    Local area

    Ramboll Management Consulting

    Albany, NY
    4 days ago
  •  ...The Consultant must meet or exceed the following Mandatory Criteria: • Five years' experience troubleshooting complex technical problems...  ...using Oracle Warehouse Builder ("OWB") to create complex ETL processes; • A minimum of one year experience working with Oracle... 
    Senior

    3B Staffing LLC

    Albany, NY
    3 days ago
  • $77k - $202k

     ...At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping...  ...designing, and implementing GIS applications-based solutions. As a Senior Associate you analyze complex problems, mentor others, and... 
    Senior
    H1b

    PwC

    Albany, NY
    3 days ago
  •  ...End Client: State of New York Job Title: IT Specialist/ Senior Data Warehouse ETL Developer Duration: 30+ Months Location: Albany, NY 12240 (Hybrid) Position Type: Contract Interview Type: Webcasting Ceipal ID: SNY_DATA907_KV Job Code: HBITS-08-14907 Department: NYS Department... 
    Senior
    Contract work
    Work at office
    Local area

    V Group

    Albany, NY
    3 days ago
  • $70.4k - $116.2k

     ...priority as InsuraMatch seeks to diversify its operations and advance Travelers' broader objectives. As the Wholesale/E&S Senior Quality Assurance Consultant, you will be responsible for designing, implementing, and maintaining a quality assurance program that ensures... 
    Senior
    Local area

    Travelers Insurance

    Albany, NY
    4 days ago
  • $140k

     ...platforms and AI, you’ll do the most meaningful work of your career and see your impact at scale. Job Description Job Summary The Senior Consultant is responsible for providing expert advice and solutions to clients within the organization. This role requires strong... 
    Work at office
    Local area

    Epiq

    Albany, NY
    2 days ago
  •  ...The Principal Workfront Consultant (Adobe Practice) will serve as the primary advocate for client success, ensuring maximum value realization from a client’s Adobe Workfront investment. This role is the technical lead for Adobe Workfront engagements. You will combine... 
    Internship
    Local area
    Remote work

    Acxiom

    Albany, NY
    2 days ago
  •  ...managing InRule environments (installation, configuration, validation across DEV/QA) and deploying FHS/HRS Java applications, including ETL job troubleshooting and scheduling (OpCons). Two or more years of experience administering middleware, databases, and messaging... 
    Senior

    3B Staffing LLC

    Albany, NY
    15 hours ago
  •  ...Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified...  ....SummaryType: ContractFunction: Information TechnologyExperience level: Mid-Senior LevelIndustry: Information Technology And Services
    Worldwide

    USM Systems

    Albany, NY
    1 day ago
  •  ...are Accenture, a global professional services company, searching for a Workday Workday Certified Time Tracking/Absence/Scheduling Consultant.This individual will be part of a team of advisory professionals focused on cloud-based data-reporting operations that integrate... 
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Albany, NY
    3 days ago
  •  ...laboratory processes. Our people have a combination of scientific and laboratory informatics expertise, tied with strategic and business consulting experience, and industry platforms knowledge. We provide an innovative approach and global scale s across a variety of industries... 
    Full time
    Live in
    Work at office
    Local area

    Accenture

    Albany, NY
    2 days ago
  •  ...experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360 value,... 
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Albany, NY
    3 days ago
  •  ...reality.You are:A highly experienced Manhattan WMS Application Consultant with deep expertise in designing, architecting, and implementing...  ...understanding, and the ability to partner directly with senior stakeholders. You thrive in complex environments, solve ambiguous... 
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Albany, NY
    2 days ago
  • $70.35k - $205.8k

     ...lifesaving medicines and products to patients through harnessing the power of advanced technologies.The Work:Accenture is seeking a Consultant to drive project execution in Digital CMC and PLM transformation work within our Supply Chain & Engineering practice for Life... 
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Albany, NY
    3 days ago
  •  ...Senior Snowflake Database Architect, (Hybrid), Albany, NY 10 years of experienced candidates required . Local candidate to NY/NJ...  ...integrity Troubleshoot failures, tune performance Documentation ETL process, security policies, system architecture, user guides and... 
    Senior
    Local area

    Nexiva Inc

    Albany, NY
    1 day ago
  •  ...on the team you will also mentor junior/senior engineers on the team.Define and lead the...  ...data swamps.Provide senior level technical consulting to application development teams during...  ...experience in dimensional data modeling, ETL development, and Data Warehousing5+ years... 
    Work experience placement

    NTT DATA

    Albany, NY
    2 days ago
  •  ...with OT networks, systems, assets, devices, and security solutions. Bonus points if you haveMinimum 2 years of experience providing consulting services to clients with experience in relevant industry verticals such as Oil and Gas, Utilities, Manufacturing, Chemical, and... 
    Full time
    Work experience placement
    Live in
    Work at office
    Local area
    Remote work

    Accenture

    Albany, NY
    15 hours ago
  • $108.6k

     ...expert understanding of HCM and Payroll application functionality and business process configuration options to provide thoughtful consultative leadership to create impactful, effective, and efficient solutions. The incumbent will support all Enterprise business areas and... 
    Work at office
    Local area

    Highmark Health

    Albany, NY
    3 days ago
  •  ...Tableau Consultant Location: Albany, NY 12229 Duration: 2-3 years Contract Position Requirements: ~60 months experience developing detailed management reports in Tableau ~30 months experience developing detailed management reports in Power BI ~60 months... 
    Contract work

    InterSources

    Albany, NY
    4 days ago
  • $186.07k - $218.9k

     ...sessions called “surges.”learn more about working at Coinbase. Senior Software Engineer (EAA) The EAA Compliance CXAE team, part of...  ...databases, and service communication patterns (gRPC, GraphQL, ETL), with experience authoring and contributing to technical architecture... 
    Senior
    Local area

    Coinbase

    Albany, NY
    1 day ago
  • $151k - $215k

     ...needs. It's our driving force to help patients live longer and healthier lives. Join us and be part of our inspiring journey. The Senior Principal Biostatistician (Epidemiology) will represent the Biostatistics department on all aspects of the clinical development... 
    Senior
    Full time
    Remote work

    Edwards Lifesciences

    Albany, NY
    4 days ago
  • $160k - $210k

    a { text-decoration: none; } tr th, tr td { } tr th { } Established (100+ Years) Premier Firm Seeking Senior Personal Injury Attorney for Plaintiff-Side Personal Injury in Albany, New YorkAn established firm based in Albany, New York with over 100+ years in practice... 
    Senior

    CyberCoders

    Albany, NY
    2 days ago
  • TAX SENIORWell established, highly profitable regional CPA firm seeks a Tax Senior to specialize in estate and trust tax. Hybrid work environment. Candidates must have estate and trust tax experience. We offer a very reasonable work life balance, excellent benefits including... 
    Senior

    Career Development Partners

    Albany, NY
    2 days ago
  •  ..., solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song...  ...processes and outcomes.You Are:You are a senior data architect who designs enterprise...  ...years of experience with data integration/ETL/ELT and metadata & lineage toolingMinimum... 
    Senior
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Albany, NY
    1 day ago
  • $143k - $193.05k

     ...people truly BELIEVE in what they're doing! Job Description Summary: The Infrastructure Modernization business unit is seeking a Senior Principal Software Engineer to serve as a visionary and hands-on technical leader for our Workload Automation solutions. The... 
    Senior
    Full time
    Remote work
    Worldwide

    Rocket Software

    Albany, NY
    4 days ago
  •  ...The University at Albany's Massry School of Business seeks a Senior Director of Development for Major Gifts to lead philanthropic strategy and secure gifts from high-net-worth alumni and friends. The role involves designing solicitation plans, collaborating with the dean... 
    Senior

    University At Albany

    Albany, NY
    15 hours ago
  • $16 - $18 per hour

     ...and on-going provision of peer support services within the project. This position will also provide a consumer perspective and consultation on program implementation. Peer support services are distinct from case management, behavioral health and substance use disorder... 
    Hourly pay
    Work experience placement
    Local area

    Whitney M. Young Jr. Health Center

    Albany, NY
    15 hours ago
  • $47k - $48k

    Student Support Specialist The Student Support Specialist is responsible for providing exceptional support to students and all internal/external stakeholders, ensuring their inquiries, concerns, and issues are resolved promptly and professionally. This role is critical...
    Full time
    Work at office
    Work from home
    Home office

    Excelsior University

    Albany, NY
    15 hours ago
  •  ...Senior Data Architect Location: Saratoga Springs / Albany, NY Must have experience working with prior higher education university/clients. This is a critical Phase 1 initiative focused on assessing and documenting the university’s data warehouse environment.... 
    Senior

    Kaav Inc.

    Albany, NY
    4 days ago
  •  ...A federal contracting company in Albany, NY, is seeking a Senior FOIA Disclosure Product Manager to lead product management for the SecureRelease initiative. Candidates should possess a strong background in product management, market analysis, and exceptional communication... 
    Senior

    CGS Federal (Contact Government Services)

    Albany, NY
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior ETL Consultant. Be the first to apply!