ETL Informatica Specialist

2 weeks ago


Orlando, Florida, United States Saxon Global Full time
Key Responsibilities:

- Manage incoming data feeds from various sources including flat files and databases.

- Utilize Informatica to transfer data to the staging area and data warehouse efficiently.

- Oversee the Data Warehouse and ETL processes, ensuring smooth operations.

- Provide solutions for any failover situations, leveraging PLSQL for backend SQL tasks.

- Perform minor adjustments to existing Unix scripts as needed.

- Utilize JAMS for scheduling and monitor for any failures that may arise.

- Prioritize troubleshooting across all processes.

- Participate in the roadmap to transition Informatica to cloud-based solutions; familiarity with cloud technologies is advantageous.

- Work with Informatica version 10+ and manage Oracle packages effectively.

- Address reporting needs and debug both frontend and backend issues.

- Exhibit strong analytical skills as an ETL generalist, with experience in API integrations, XML, JSON, and other tools.

- Possess at least 1 year of scripting experience in Bash, Shell, or Python, along with experience in dashboard development using Microstrategy or similar visualization tools.

Required Qualifications:
- Minimum of 6 years of experience with Informatica (ETL).
- Proficient in Oracle packages.
- Experience with batch scripting.
- Strong SQL skills, capable of analyzing databases, staging tables, and understanding data flow.

Preferred Qualifications:
- Experience with cloud technologies.
- Knowledge of Data Lake/Data Strategy.
- Proficiency in Python.
- Familiarity with APIs for data retrieval and flat file setup.
- Experience with JAMS or similar scheduling tools.
- Background in Power BI or Tableau.
- Administrative experience, including server management and security configurations.

Additional Information:
- Extensive experience in ETL processes using Informatica V. 10+.
- Proven ability to trace issues back to their source and effectively resolve root causes.
- Hands-on experience with parallel job design and strong SQL coding capabilities.
- Comprehensive understanding of DBMS concepts, preferably with Oracle.
- Deep knowledge of best practices in data architecture and data warehousing/BI.
- Ability to prepare detailed design documentation for ongoing maintenance.
- Capable of troubleshooting failures and providing resolutions through scheduling tools.

  • Orlando, Florida, United States Saxon Global Full time

    Responsabilidades Diarias: El candidato seleccionado será responsable de gestionar la ingesta de datos provenientes de archivos planos y otras bases de datos. Utilizará Informatica para transferir estos datos a la zona de preparación y al almacén de datos. Se espera que administre el almacén de datos y los procesos de ETL, asegurando la continuidad...


  • Orlando, Florida, United States CardWorks Full time

    Position Overview:As a Principal Data Engineer at CardWorks, you will play a pivotal role in advancing data-driven initiatives within the Data Strategy and Architecture (DSA) division. Your primary focus will be on enhancing data operations and analytics platforms, ensuring data is readily available for consumption by various stakeholders, including data...


  • Orlando, Florida, United States Irvine Technology Corporation Full time

    Position OverviewTechnical Systems Specialist (Hybrid)We are seeking a contract Technical Systems Specialist to support a prominent global media and entertainment organization. This role will focus on enhancing key merchandise systems applications and strategic initiatives for the merchandise division.Location: HybridCompensation: Competitive hourly rate...

  • Senior Data Engineer

    3 weeks ago


    Orlando, Florida, United States NBC Universal Full time

    At Fandango, we love movies. From showtimes and ticketing, to engaging content and innovations in movie going- we strive to deliver the perfect movie going experience—anytime, anywhere. And to be the go-to destination for moviegoers, we think it's all about collaboration. Anyone can build a website or app, but it takes a special group across many...


  • Orlando, Florida, United States 4 Corner Resources Full time

    About the Role4 Corner Resources is seeking a highly skilled Business Intelligence Analyst to join our team. As a key member of our organization, you will be responsible for creating innovative solutions in relative applications like SharePoint and Microsoft Power BI.This is a six-month contract-to-hire role that offers remote flexibility with monthly onsite...


  • Orlando, Florida, United States AssistRx Full time

    Job OverviewThe Healthcare Data Analyst plays a pivotal role in the management, acquisition, and analysis of data that is crucial for internal teams, clients, and partners. This position is essential for overseeing the onboarding process of electronic data trading partners and ensuring the successful implementation of these partnerships.Key...


  • Orlando, Florida, United States AssistRx Full time

    Job OverviewThe Healthcare Data Analyst plays a pivotal role in the acquisition, management, and analysis of critical data that supports internal teams, clients, and partners. This position is essential for overseeing the onboarding process of electronic data trading partners and ensuring the successful implementation of these partnerships.Key...


  • Orlando, Florida, United States AssistRx Full time

    Job OverviewThe Healthcare Data Analyst plays a crucial role in managing, acquiring, and interpreting data that is shared with internal teams, clients, and partners. This position leads the integration of electronic data trading partners and ensures the successful implementation of these partnerships. The Analyst is tasked with overseeing client data...


  • Orlando, Florida, United States Trilon Group Full time

    Job OverviewWe are looking for a skilled and knowledgeable Microsoft Power Platform Consultant to become a vital part of our IT department. This position involves the design, development, and deployment of innovative solutions utilizing Microsoft Power Platform technologies, such as Power Apps, Power Automate, Power BI, and Power Virtual Agents. The...

  • Informatica Developer

    1 month ago


    Orlando, United States Saxon Global Full time

    Day to Day Responsibilities/typical day look like: Have incoming feeds from flat files and other DB's They use informatica to get them to the staging area and data warehouse Managing the Data Ware house and ETL processes If there is any failover needs to be able to provide solutions PLSQL - this will be the SQL tool on the back end Unix - scripts are...

  • Informatica Developer

    2 weeks ago


    Orlando, United States Saxon Global Full time

    Day to Day Responsibilities/typical day look like: Have incoming feeds from flat files and other DB's They use informatica to get them to the staging area and data warehouse Managing the Data Ware house and ETL processes If there is any failover needs to be able to provide solutions PLSQL - this will be the SQL tool on the back end Unix - scripts are...

  • Senior Developer

    3 weeks ago


    Orlando, United States CardWorks Full time

    Position Summary:As a Senior Data Engineer, you will support data related initiatives within Data Strategy and Architecture (DSA) department with a focus on enabling data operations and analytics platform and enabling data for consumption by data operations, reporting, business intelligence and analytics user community. This role is responsible for...

  • Senior Data Engineer

    2 months ago


    Orlando, United States CardWorks Full time

    Position Summary:As a Senior Data Engineer, you will support data related initiatives within Data Strategy and Architecture (DSA) department with a focus on enabling data operations and analytics platform and enabling data for consumption by data operations, reporting, business intelligence and analytics user community. This role is responsible for...

  • Technical Lead

    3 months ago


    Orlando, United States eTeam Full time

    5+ years of relevant experience of IICS Responsible for the set-up, maintenance and ongoing development of CI/CD continuous build/ integration infrastructure 5+ years relevant experience of Oracle SQL / SQL Server and Stored procedures and should have knowledge on how to debug an Oracle Package/Stored Procedure. Design and development of ETL/ data pipelines...

  • Technical Lead

    3 months ago


    Orlando, United States eTeam Full time

    5+ years of relevant experience of IICS Responsible for the set-up, maintenance and ongoing development of CI/CD continuous build/ integration infrastructure 5+ years relevant experience of Oracle SQL / SQL Server and Stored procedures and should have knowledge on how to debug an Oracle Package/Stored Procedure. Design and development of ETL/ data pipelines...

  • Data Engineer

    2 months ago


    Orlando, United States Tandym Group Full time

    We are seeking a Data Engineer to join our team and lead the design and implementation of our data strategy. This role is critical in ensuring the success of our data architecture in Azure, as well as in governing, managing, and maintaining high data quality standards. The ideal candidate will have extensive experience in Azure and knowledge of relevant data...

  • Integration Specialist

    3 months ago


    Orlando, United States Tews Company Full time

    Job DescriptionJob DescriptionThis person needs to have Informatica & some exposure to PeopleSoft.Heavy on the integrations side. They will be doing a lot of integrations with Canvas  Experience with Canvas is a big plus but if they have integrated with other LMS systems that will work as well.SKILLS-API's-Informatica/Strong...

  • Software Engineer

    2 months ago


    Orlando, United States 4 Corner Resources Full time

    4 Corner Resources is looking for a passionate Software Engineer . We are seeking candidates with experience in major application development languages, including Java, .NET, C#, HTML, and COTS. Proficiency in SQL and a strong understanding of services such as micro-services, SOA, and APIs are essential. This role will start on a contract basis and will...

  • Software Engineer

    1 month ago


    Orlando, United States 4 Corner Resources Full time

    4 Corner Resources is looking for a passionate Software Engineer . We are seeking candidates with experience in major application development languages, including Java, .NET, C#, HTML, and COTS. Proficiency in SQL and a strong understanding of services such as micro-services, SOA, and APIs are essential. This role will start on a contract basis and will...

  • Cloud Data Architect

    3 months ago


    Orlando, United States AssistRx Full time

    Job DescriptionJob DescriptionTheCloud Data Solutions Architects is responsible for turning transactional and 3rd party data into data products. These self-service data assets are utilized by BI Developers, Data Scientists and Analysts across AssistRx to gain insights, make predictions and recommendations RequirementsTranslate business requirements into data...

  • Senior Data Engineer

    3 weeks ago


    Orlando, United States NBC Universal Full time

    At Fandango, we love movies. From showtimes and ticketing, to engaging content and innovations in movie going- we strive to deliver the perfect movie going experience—anytime, anywhere. And to be the go-to destination for moviegoers, we think it’s all about collaboration. Anyone can build a website or app, but it takes a special group across many...

  • Data Specialist

    7 days ago


    Orlando, United States Loyal Source Government Services Full time

    POSITION PURPOSEWe are in search of a highly skilled and driven Data Analyst to join our dynamic team. As a Data Analyst, you will play a pivotal role in gathering, analyzing, and interpreting vast datasets to generate actionable insights that support strategic decision-making. Collaborating with cross-functional teams, you will identify trends, drive...

  • Data Specialist

    7 days ago


    Orlando, United States Loyal Source Government Services Full time

    POSITION PURPOSEWe are in search of a highly skilled and driven Data Analyst to join our dynamic team. As a Data Analyst, you will play a pivotal role in gathering, analyzing, and interpreting vast datasets to generate actionable insights that support strategic decision-making. Collaborating with cross-functional teams, you will identify trends, drive...

  • SAP Specialist

    1 month ago


    Orlando, United States aKUBE Full time

    City: Orlando FL 32819Onsite/ Hybrid/ Remote: Onsite, 4 days a weekDuration: 15 monthsRate Range: $96/hr on W2 depending on experience (no C2C or 1099 or sub-contract)Work Authorization: GC, USC, All valid EADs except H1DescriptionThe candidate must be able to work at the strategic program level and at the tactical project level. The successful candidate...