ETL Developer

Founded in 1994 and headquartered in Switzerland, ERNI is a leading Software Development company with over 800 employees worldwide. Specializing in IT and software engineering, we drive innovation in process and technology. Our first service center in Asia Pacific, located in Metro Manila (Mandaluyong), supports clients across Europe, APAC, the Philippines, and the USA. As we continue to grow, were looking for passionate and motivated individuals to join our team. 

Why ERNI is the Perfect Place for You: 🏡 

• International Exposure: Work with global clients on cutting-edge projects.
• Inclusive Culture: Thrive in a collaborative and diverse work environment.
• Career Development: Enjoy continuous learning and professional growth opportunities.


🤩Perks and Benefits: 
• Comprehensive Benefits: Government-mandated benefits including 13th-month pay.
• Skill Enhancement: Access free training and certifications.
• Baby Basket: To welcome your newborn to the ERNI family.
• Fruit Basket: Boost of vitamins during hospitalization.
• Office Perks: Enjoy free snacks and coffee.

🔐Growth and Opportunities: 
• Free Training: Advance your skills through technical and non-technical training.
• Challenging Projects: Engage in complex software projects across MedTech, Industry,
Finance, and Transportation.
• Supportive Environment: Benefit from a team dedicated to guiding and supporting your success.
• Recognition and Advancement: Receive acknowledgment for your efforts and
opportunities for promotion.
• Open Communication: Experience transparency and value your input in our culture.

⏱Flexibility: 
• Hybrid Work Setup: Balance remote and in-person work for better work-life integration.

🎉Events: 
• Connect and Celebrate: Participate in a variety of events including leisure, summer,
family, social, and year-end gatherings.


👋What are our wishes: 

Education and Work Experience

• Bachelor’s degree in computer science or equivalent experience required

• 8yrs to 10 years’ experience in managing data lineage and performing impact analysis

• 8yrs to 10 years’ 10 years’ experience with ETL tool development using Oracle PLSQL. • Knowledge in ADF (Azure Data Factory) is preferred

• 8yrs to 10 years’ 10 years’ experience with Oracle (10g, 11g and 12c)

• Expert ability in SQL and PL/SQL

• Excellent ETL design and documentation skills

• Understanding of advanced database concepts: e.g., instance, table, table space, data files, database structure, indexes to fine tune programs and solve program failures.

• Understanding of basic Unix Operation system concepts, programs, directory structure and basic commands (e.g., vi, sh)

• Familiarity with the technical aspects of Unix, the Oracle RDBMS, and tools

• Knowledge in Python language is an advantage

• Deep appreciation of Agile or rapid application development (RAD) method

• Ability to handle multiple tasks and adapt to a constantly changing environment

Reporting and Coordination

• For the provision of staff augmentation services, the Agency Personnel will take instructions from the Manager at the Information Technology Department at work closely with the project team, internal and external stakeholders.

• The Agency Personnel will provide any other services as required by the team and ITD supervisor or user unit.

💼How can you contribute to the team?

• The Senior ETL developer will be responsible for working with data owners, system owners, solutions, delivery team and managed services provider (MSP) in identifying solutions and process enhancements. Should work and collaborate with managed services provider (MSP) in ensuring smooth and undisruptive production processes. Should help Business Analysts to coordinate issues with infrastructure team, middleware team and managed services provider (MSP).

• The Senior ETL developer has a strong command of ETL (extract-transform-load) Oracle PLSQL development responsible for design, development, and delivery of data from operational systems and files into staging area, Data Warehouse, downstream Data Marts and files. The senior developer will implement quality logical and physical ETL designs that have been optimized to meet the operational performance requirements for our multiple solutions and products. This will include the implementation of sound architecture, design, and development standards. He/she has the experience to design the optimal performance strategy and manage the technical metadata across all ETL jobs.

• The Senior ETL developer has strong analytical skills and should recommend technical improvements to Business Analyst and help collaborate with Business Analysts for more efficient and effective system designs and processes. The Senior ETL developer should be able to adapt to new technologies.

Detailed Tasks and/or Expected Outputs:

• Perform systems and data management of TD systems, including the extraction-transformation-loading (ETL) components of the system, which includes but not limited to:

1. Spearheads development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.

2. Manages automation of file processing as well as all ETL processes within a job workflow.

3.Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.

4.Manage software upgrades, capacity planning and system optimization.

5.Perform the unit testing, system integration testing and assist with user acceptance testing

6.Adapt ETL code to accommodate changes in source data and new business requirements.

7.Document the ETL detailed design and test results.

8.Prioritize development and enhancement requests.

9.Ensures data quality throughout entire ETL process.

10.Understanding of Middleware Data Integration

11.Ensures compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation.

12.Designs Power BI Reports and Dashboard is an advantage.

13.Power BI Data Analysis and Modeling is an advantage.

14.Designs Datadog Dashboard is an advantage.

15.Configure Datadog Alerts using Datadog Logs and Events is an advantage.

16.Datadog Real User Monitoring Configuration is an advantage.