Penndot - Tas1 A4 Sc3 (Sr. Data Warehouse Developer)

hace 2 semanas


Panamá, Panamá, Panamá Honorvet Technologies A tiempo completo

Responsibilities -Informatica architecture and technical support, Informatica ETL development and troubleshooting, Azure data engineering (which includes working with Azure Synapse, Azure SQL, and Azure Data Factory), dimensional modeling, SQL and PL/SQL development, Oracle performance tuning, and BI development support.

-Involvement in all phases of data warehouse implementation, including requirements gathering, design, and testing. -Design and develop ETL using Oracle PL/SQL, Informatica PowerCenter 10.4 and above, IICS & Azure.

-Create and maintain tables, create views, write queries, build PL/SQL packages, write stored procedures, triggers, and functions, and design and develop complex ETL processes.


  • Read and interpret physical data models, primarily dimensional models. Use Informatica PowerCenter 10.4 and above, IICS (Informatica Intelligence Cloud Services), Oracle 12c, PL/SQL, Azure Synapse, Azure SQL, Azure Data Factory, Erwin 2020 R2 SP2 to accomplish project deliverables and to provide data solutions for the business areas we support. Handson development (estimated 75%) and data architecturerelated work (estimated 25%).

Specific Duties:
1.DW/BI projects and initiatives, including business analysis, independent technical design, and development.

  • Informatica architecture and troubleshooting support. 3.Provide Informatica expertise where needed. 4.Oracle SQL and PL/SQL performance tuning and troubleshooting. 5.Data architecture duties, including OLAP and OLTP data modeling.
  • Intensive data analysis on source system databases. Analysis of source system databases, identification of required data, and data profiling. 7.Diagnose, analyze, troubleshoot, and choose the appropriate solution to fix data-related issues. 8.Support the BI development team in building data visualization, reporting, and dashboards, specifically on the data side of that development.
  • Implement data-related processes, functionality, and structures including data ingestion pipelines, cleansing, and transformation activities, and data stores for analytical workload in Azure

Skills and Experience 1Required:
10+ years of IT experience

2Required:
7+ years of data warehouse development with 1 year or more of team lead experience

3Required:
5+ years of data integration and ETL development experience with Informatica Power Center.

4.

Required:

7+ years of Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning

5Required:
1+ years of data modeling experience with at least 6 months of doing dimensional modeling

6Required:

3+ years:
Data analysis and requirements gathering and testing

7Required:
Strong oral and written communication skills.

8.

Desired:

2+ years of Azure data development/engineering experience

9Desired:
3+ years of MS SQL Server and/or DB2 experience

10Desired:
6+ months of IICS (Informatica Intelligent Cloud Services) experience

11Desired:
6+ months of experience using Erwin data modeling tool.
  • BI Architect/developer

    hace 2 semanas


    Panamá, Panamá, Panamá Edi Staffing A tiempo completo

    Overview As a member of the Global BI team, the BI Architect will collaborate with other team members to enable the delivery of reporting and analytics insights to business users. The architect will assist with development of technical and functional elements necessary to support the BI solutions. Responsibilities Assist with the design, development, and...

  • Sr. Data Specialist

    hace 2 semanas


    Panamá, Panamá, Panamá Philips A tiempo completo

    JOB DESCRIPTION Job Title Sr. Data Specialist Job Description Sr. Data Specialist (Panama City, Panama) The Service Part Supply chain (SPS) Master Data Management team is responsible for maintaining global master data processes, monitoring SPS master data quality and bringing reported master data issues to closure. You will be maintaining close...


  • Panamá, Panamá, Panamá Grainger Panama Services A tiempo completo

    As part of Grainger's vision to become a global leader in product information and the most trusted site in B2B distribution, robust product master data governance is critical to ensuring consistently high data quality which creates strong customer and supplier confidence. As stewards of product information quality, Grainger's governance team will protect...

  • Sr. Data Specialist

    hace 5 días


    Panamá, Panamá, Panamá Philips A tiempo completo

    Job TitleSr. Data SpecialistJob DescriptionSr. Data Specialist (Panama City, Panama)The Service Part Supply chain (SPS) Master Data Management team is responsible for maintaining global master data processes, monitoring SPS master data quality and bringing reported master data issues to closure. You will be maintaining close communication lines with the SPS...

  • BI Developer

    hace 2 semanas


    Panamá, Panamá, Panamá Konzerta A tiempo completo

    Objetivo del puesto: Convertir los datos en informacin para la toma de decisiones, integrando data relacional y no relacional. Desarrollar modelos analticos descriptivos, predictivos para las diferentes verticales de negocios.Requisitos:Graduado Universitario. Fuertes conocimientos de almacenes de datos (Data Warehouse).Conocimiento en herramientas de...


  • Panamá, Panamá, Panamá Caterpillar A tiempo completo

    Career Area: Digital Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about...

  • Sr. Data Modeler

    hace 2 semanas


    Panamá, Panamá, Panamá Millicom A tiempo completo

    Data ModelerRole.Understand and translate information into data model that conforms architectural standards and guidelineCreates Logical Data Model and physical data model Creates Naming standards Contributes and maintains Metadata, Data lineage, business glossary Creates source to Target mapping Maintains database, works on fine tuning data base...


  • Panamá, Panamá, Panamá Caterpillar A tiempo completo

    Career Area:Digital**:Your Work Shapes the World at Caterpillar Inc.When you join Caterpillar, you're joining a global team who cares not just about the work we do - but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation...


  • Panamá, Panamá, Panamá Grainger Panama Services A tiempo completo

    The Sr. Sourcing Quality Specialist is responsible for daily support of Sourcing Execution Team ( Quotes & Support). The Sr. Sourcing Quality Specialist role is responsible for maintaining and monitoring customer touch points through Verint Quality Phone System and other systems designed to identify opportunities of improvement.Perform root-cause analysis of...


  • Panamá, Panamá, Panamá Estée Lauder Companies Gmbh A tiempo completo

    Sr Analyst FP&A Regions, Data Engineer Grow your career with The Estée Lauder Companies The Estée Lauder Companies Inc. is one of the world's leading manufacturers and marketers of quality skin care, makeup, fragrance and hair care products. As the global leader in prestige beauty, we touch over half a billion consumers a year.Our Company's products are...


  • Panamá, Panamá, Panamá Estée Lauder Companies Gmbh A tiempo completo

    Sr Analyst FP&A Regions, Data Engineer Description Grow your career with The Estée Lauder Companies The Estée Lauder Companies Inc. is one of the world's leading manufacturers and marketers of quality skin care, makeup, fragrance and hair care products. As the global leader in prestige beauty, we touch over half a billion consumers a year.Our Company's...

  • Data Engineer Leader

    hace 2 semanas


    Panamá, Panamá, Panamá Addmore Group Inc A tiempo completo

    Our client is looking for a Data Engineer Leader - Supply Chain*:for a contract position Start date: March/April Duration: 6 months with possibility of REN Location: Panama or close to this country (Mexico, Equator, Colombia, Argentina) Work model: Hybrid 1 or 2 days onsite per week or REMOTE (if willing to travel) Language: Bilingualism (English and...

  • Data Engineer Leader

    hace 2 semanas


    Panamá, Panamá, Panamá Addmore Group Inc A tiempo completo

    Our client is looking for a Data Engineer Leader - Supply Chain*:for a contract position Start date: March/April Duration: 6 months with possibility of REN Location: Panama or close to this country (Mexico, Ecuador, Colombia, Argentina) Work model: Hybrid 1 or 2 days onsite per week or REMOTE (if willing to travel) Language: Bilingualism (English and...

  • Officer, Warehouse

    hace 2 semanas


    Panamá, Panamá, Panamá Ciudad del Saber A tiempo completo

    Fecha límite: 16 de Febrero de 2023Organizational context (where the job is located in the Organization)The International Federation of Red Cross and Red Crescent Societies (IFRC or "the Federation") is the world's largest volunteer-based humanitarian network. The Federation is a membership organisation established by and comprised of its member National...

  • Officer, Warehouse

    hace 2 semanas


    Panamá, Panamá, Panamá International Federation of Red Cross and Red Crescent Societies A tiempo completo

    JobnumberS02917Contract TypeEmployeeClosing date16-Feb-2023Posting Start Date02-Feb-2023LocationPANAMADuty StationPanama City, PanamaDuty Station StatusN/ADuration3Accompanied StatusN/AGradeNational StaffOrganizational Context:The International Federation of Red Cross and Red Crescent Societies (IFRC or "the Federation") is the world's largest...

  • BI Developer

    hace 2 semanas


    Panamá, Panamá, Panamá Edi Staffing A tiempo completo

    Overview This position requires both a technical acumen and an understanding of the business needs. Partnering and working closely with the business is key to delivering quality Business Intelligence solutions that will give the various business units the information they need to stay competitive. Responsibilities Work closely with business partners to...

  • Data Engineer

    hace 2 semanas


    Panamá, Panamá, Panamá The Aes Corporation A tiempo completo

    En AES, elevamos la calidad de vida en todo el mundo cambiando la forma en la que la energía funciona. Todos tienen un impacto cada día en nuestros equipos pequeños y globales. Postúlese aquí para iniciar una extraordinaria carrera hoy mismo. We are looking for a Data Engineer to join our Team at AES.Data engineers work in a variety of settings to build...


  • Panamá, Panamá, Panamá NGRS A tiempo completo

    The role is open in the international IT USA-based company. Sr FE Developer is responsible for design, development and maintenance of software products, while often taking on leader and mentor roles within the team. Remote work from any country. Salary $ gross.- Responsibilities_ Design, develop, and maintain highquality, scalable, and reliable software...

  • Data Engineer Ds-91

    hace 2 semanas


    Panamá, Panamá, Panamá Oceans Code Experts A tiempo completo

    Develop scalable and distributed systems in public or private clouds. Proficient in SQL and Python. Learn about and contribute to query engine internals, performance debugging, building highly scalable and maintainable systems, and more. Design and develop features, understand customer requirements, and meet business goals.Enhance the programmability surface...


  • Panamá, Panamá, Panamá Integconsult A tiempo completo

    Developing Custom components using Lightning Component Framework Both Aura and Lightning Web components5. Visual Force Page Development6. Should have written code in Visual Studio Code with Salesforce extensions7. Experience in writing SOQL and SOSL8.Handson experience in administration setup, e.g., managing users, security controls, and data as well as...