Oracle PlSQL with Informatica

1 day ago

Kuala Lumpur, Malaysia amIT Global Solutions Sdn Bhd Full time

**Skill**:
**SQL, Informatica PowerCenter, Oracle PL/SQL, Stored Procedure, ANSI SQL, Linux shell scripting.**

**Responsibilities**:

- Years of experience: above 5 years.
- Perform requirement gathering and analysis with business stakeholders
- Perform hands-on ETL solution design, development, test execution and production deployment.
- Provide BAU support for existing and new data platforms
- Collect multiple streams of data and decompose them into concise specifications.
- Ensure that final product meets requirement specifications.
- Follow company and industry defined best practices to ensure smooth and continuous product development operations.
- Develop process improvements that ensure product quality and productivity.
- Communicate product efficiency or enhancement ideas and concepts to Manager.
- Analyse and troubleshoot product issues in a timely fashion.
- Understand and evaluate existing SQL
- Design and develop queries for a high-performance environment.
- Design, develop and implement complete solutions throughout the product life cycles.
- Maintain and manage revisions of code in production, testing and development environments.
- Accountable to development and delivery of solutions that meets and exceeds quality standards
- Deliver multiple projects on-time, on-budget and with targeted zero defects
- Provide support for Quality Assurance testing
- Provide estimation and coordination of technical activities related to system development
- Ensure solutions alignment to Enterprise Architecture policies and best practices; ensure that process methodologies are followed in system development
- Create technical documentation including the Technical Design document
- Manage day to day technical challenges and communicate to project manager any risks or issues associated with the development activities
- Identify opportunities for system reuse and system simplification
- Collaborate with IT partners to devise capacity plan and ensure appropriate infrastructure for the end to end system delivery
- Production support required on rotation basis.

**Key Points**:

- Oracle database
- Building datamarts for different tiers
- Consumer mobile app
- Plsql stored procedure
- Production support
- Small enhancements
- BAU
- ROTATION BASIS monthly 1 week mobile on call night support
- BA team separate interacting business users
- Users are claim related
- Job not running
- Data mart not refreshed
- Business rule or query related
- Individual contributor
- Reporting to team lead AIA

**Job Type**: Contract
Contract length: 12 months

Pay: RM12,000.00 - RM13,000.00 per month

**Benefits**:

- Dental insurance
- Health insurance
- Opportunities for promotion
- Professional development
- Vision insurance

Schedule:

- Day shift

**Experience**:

- Informatica: 3 years (required)
- Oracle PL/SQL: 5 years (required)
- Stored Procedure: 2 years (required)
- Linux Shell Scripting: 1 year (required)

  • Informatica Developer

    5 days ago

    Kuala Lumpur, Malaysia Cognizant Full time

    Cognizant is looking for a **Informatica Developer** in developing customized product for our clients. The role is expected to drive technology discussions and analyze the current landscape for gaps in addressing business needs. Cognizant needs a motivated individual to challenge the status quo and provide thought leadership/best practices to enhance our...

  • Informatica Developer

    5 days ago

    Kuala Lumpur, Malaysia Cognizant Full time

    Cognizant is looking for a **Informatica Developer** in developing customized product for our clients. The role is expected to drive technology discussions and analyze the current landscape for gaps in addressing business needs. Cognizant needs a motivated individual to challenge the status quo and provide thought leadership/best practices to enhance our...

  • Oracle Plsql Developer

    1 day ago

    Kuala Lumpur, Kuala Lumpur, Malaysia Unison Group Full time 60,000 - 120,000 per year

    About Unisontech  Headquartered in Singapore, Unison Consulting was founded in September 2012 with the core motive to provide cutting-edge solutions and services in a variety of areas. At Unison Consulting, our mission is to empower businesses with our financial and insurance services.Skill Oracle Plsql DeveloperWork Location Malaysia, KLClient BankingExp...

  • Mdm Informatica Specialist

    1 day ago

    Kuala Lumpur, Malaysia AMK TECHNOLOGY SDN BHD Full time

    Job Description - The role shall have a strong background and experience on Oracle DB, configuration on Informatica MDM Hub Console, Informatica Provisioning and Informatica C360 and able to effectively perform knowledge transfer for the on the job learning program. - Requires to work on Financial Performance Analytics Dashboard, Master Data Readiness for...

  • Junior Developer- Informatica

    2 weeks ago

    Kuala Lumpur, Malaysia SKILL QUOTIENT RESOURCES SDN BHD Full time

    **JOB DESCRIPTION**: - Minimum 2-3 years’ experience in Software Engineering/Software Programming/ Software Development - Platform : Informatica - Certified, TD or HD & Orcl any one Mandatory - Experience with any of these Server/Database: Teradata or Hadoop and Informatica - Must-Have - ETL or Informatica certification - Must-Have - Conceptual knowledge...

  • Developer (Informatica)

    5 days ago

    Kuala Lumpur, Malaysia Luxoft Full time

    **Project** Description**: Our Client a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe and North America are looking for Consultants to be part of the project The Technology and Operations function is comprised of five teams of specialists with distinct capabilities:...

  • Developer (Informatica)

    5 days ago

    Kuala Lumpur, Malaysia Luxoft Full time

    **Project** Description**: Our Client a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe and North America are looking for Consultants to be part of the project The Technology and Operations function is comprised of five teams of specialists with distinct capabilities:...

  • Etl Developer

    1 week ago

    Kuala Lumpur, Malaysia AMK Technology Sdn Bhd Full time

    *Design, develop, and implement ETL processes using Informatica PowerCenter. *Ensure accurate extraction, transformation, and loading of data from various source systems into target databases. *Develop and optimize SQL queries and stored procedures in Oracle. *Perform data modeling and database design to support ETL processes. *Create and maintain Unix shell...

  • Junior Cpm Developer

    3 days ago

    Kuala Lumpur, Malaysia Tentacle Infotech Full time

    **Job Title**: Junior CPM Developer **Job Summary**: **Key Responsibilities**: - Develop and maintain data integration and transformation pipelines using **Informatica Data Integration suite**. - Work with **Cloudera Hadoop 6.X** distribution for big data ingestion, processing, and storage. - Manage data modeling and transformation tasks on **Teradata...

  • Oracle Pl SQL Informatica

    1 day ago

    Kuala Lumpur, Malaysia amIT Global Solutions Sdn Bhd Full time

    Years of experience: above 5 years. - Perform requirement gathering and analysis with business stakeholders - Perform hands-on ETL solution design, development, test execution and production deployment. - Provide BAU support for existing and new data platforms - Collect multiple streams of data and decompose them into concise specifications. - Ensure that...