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

hace 15 horas


Panama 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. -Hands-on development (estimated 75%) and data architecture-related work (estimated 25%). Specific Duties: 1.DW/BI projects and initiatives, including business analysis, independent technical design, and development.

2.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.

6.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.

9.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 1.Required: 10+ years of IT experience. 2.Required: 7+ years of data warehouse development with 1 year or more of team lead experience. 3.Required: 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. 5.Required: 1+ years of data modeling experience with at least 6 months of doing dimensional modeling. 6.Required: 3+ years: Data analysis and requirements gathering and testing. 7.Required: Strong oral and written communication skills.

**8.Desired**: 2+ years of Azure data development/engineering experience. 9.Desired: 3+ years of MS SQL Server and/or DB2 experience. 10.Desired: 6+ months of IICS (Informatica Intelligent Cloud Services) experience. 11.Desired: 6+ months of experience using Erwin data modeling tool.


  • BI Architect/developer

    hace 3 días


    Panama 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...

  • Remote .NET Developer

    hace 15 horas


    Panama Edi Staffing A tiempo completo

    Perform post-production support, user support and cross team support activities as assigned. Work independently or as a member on a project team. Mentor other developers on the team. Performs other duties as assigned. Proven understanding of API design and API security including current versions of OpenAPI specifications, OAuth specifications and experience...

  • BI Developer

    hace 7 meses


    Panama 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...

  • Senior Data Engineer

    hace 15 horas


    Panama Liberty Latin America A tiempo completo

    Job Description What's The Role?The main role of the Senior Data Engineer is to translate customer requirements and develop and deliver an optimal solution that fits industry standards and best practices.Management of the IT infrastructure including all internal IT and End User Technology & Software Support (Enterprise solutions, Corporate, BI for IT,...

  • Senior Data Engineer

    hace 7 meses


    Panama Gi Group Holding A tiempo completo

    WE TRANSFORM THE FUTURE OF PEOPLE! The Bridge is the global network of talent experts in digital and technological profiles. We are part of the largest ecosystem and global leader of integrated human capital solutions, Gi Group Holding. We create value by connecting leading companies with the best talents in the market around the world. Our purpose is to...


  • Panama 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...

  • React Native Developer

    hace 7 meses


    Panama Zarego A tiempo completo

    **Role: React Native Developer** **Seniority: Ssr. Adv - Sr** **Location: Latam** **Key Requirements**: - +4 years experience as a Developer, with a focus on React Native, and preferably EXPO. - Strong proficiency in React Native programming, Redux, Javascript, and TypeScript. - Experience in interacting with HTTP APIs. - Familiarity with native build...


  • Panama 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...

  • Sr. Data Modeler

    hace 15 horas


    Panama Millicom A tiempo completo

    Data ModelerRole.Understand and translate information into data model that conforms architectural standards and guideline-Creates 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...

  • Backend Developer

    hace 6 meses


    Panama Zarego A tiempo completo

    **Role**:Backend Developer **Seniority**:Senior **Location**:Latam We are currently seeking a skilled **Backend Developer** to join our team and contribute to the development of a modern enterprise platform for visualizing, managing, and operating energy data and hardware at critical sites **Requirements**: - Over 5 years of experience in the industry,...


  • Panama Estée Lauder Companies Singapore A tiempo completo

    **Sr Analyst FP&A Regions, Data Engineer**: - Panamá, Panama - Finance & Accounting - 2223985 - Estée Lauder Companies **Job 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...


  • Panama 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 $4500-5500 gross. - **Responsibilities**_ - Design, develop, and maintain high-quality, scalable, and...


  • Panama Estée Lauder Companies Gmbh A tiempo completo

    Sr Analyst FP&A Regions, Data EngineerDescriptionGrow 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...


  • Panama 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...

  • Lead Data Engineer

    hace 15 horas


    Panama Mod Op A tiempo completo

    **Essential Functions**: - Define, lead, and collaborate with UX/UI, front-end development, and IT on projects. - Use or design API’s, data architecture, data strategy, database design, data analysis, workflow or ETL processes for data warehouses and dashboards. **Who Are We Looking For?**: - Someone who is creative, collaborative, constantly learning...

  • BI Developer

    hace 3 días


    Panama 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...


  • Panama Adidas A tiempo completo

    Purpose & Overall Relevance for the Organization: - As Senior Manager aDCE Continuous Improvement, you will be responsible for guiding and mentoring adidas operations teams in Lean thinking and Continuous Improvement activities. You will ensure adidas operational basics are in place across all warehouses of our own and sub-contracted network within Latin...

  • Data Engineer

    hace 7 meses


    Panama ALSTOM A tiempo completo

    Req ID:439882 At Alstom, we understand transport networks and what moves people. From high-speed trains, metros, monorails, and trams, to turnkey systems, services, infrastructure, signalling and digital mobility, we offer our diverse customers the broadest portfolio in the industry. Every day, more than 80 000 colleagues lead the way to greener and smarter...

  • Data Engineer Ds-91

    hace 7 meses


    Panama 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...

  • Data Engineer Leader

    hace 7 meses


    Panama 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:...