Oracle PlSQL with Informatica

4 weeks 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)



  • Kuala Lumpur, Malaysia Amit Global Solutions Full time

    **Job Description**: **LOOKING FOR CANDIDATES WHO ARE LOCALLY AVAILABLE IN MALAYSIA** - Should have 5+ years of experience as ETL INFORMATICA Developer - Having experience in Informatica Development. - Good debugging and analysis knowledge in Informatica issues. - Having Oracle Plsql and Unix knowledge. - Work experience in Tech upgrade project will be...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Krisv Consulting Services Pte Ltd Full time

    Krisv Consulting Services Pte Ltd is seeking an experienced Informatica PowerCenter Developer to join our team.About the RoleThe successful candidate will be responsible for designing, developing and maintaining ETL processes using Informatica PowerCenter. This involves collaborating with business analysts and stakeholders to understand data requirements and...


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


  • Kuala Lumpur, Kuala Lumpur, Malaysia Krisv Consulting Services Pte Ltd Full time

    Krisv Consulting Services Pte Ltd is seeking an experienced Informatica MDM Solutions Expert to join our team.About the RoleThe successful candidate will be responsible for designing, developing and maintaining ETL processes using Informatica PowerCenter. This involves working with cross-functional teams to ensure data integration solutions meet business...


  • Kuala Lumpur, Malaysia HTC Global Services Full time

    Job Description (JD) Understand & Interpret upstream and downstream data flow, do data profiling, data mapping and Check Data Quality from Source to Target. Perform impact analysis of new systems, new interfaces & integration. Work on impact analysis to reference data (domain/dimension; data elements/properties; base members/data sets; hierarchies) to ensure...


  • Kuala Lumpur, Malaysia Vision Technology Consulting Sdn Bhd Full time

    **Responsibilities**: - Job Summary: - Primarily responsible for installing, maintaining & supporting technical environment for Oracle Siebel, OBIEE & Informatica PowerCenter solutions with integration with Active Directory in LINUX and/or UNIX server operating system platforms. - Key Responsibilities: - Install, configure, maintain & support Siebel...


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


  • Kuala Lumpur, Malaysia Abhidi Solution Full time

    **Hands-on experience on**: - Informatica PowerCenter 10.5.2 - SQL Query (Teradata / Haddoop) - Intermediate / Advance - Oracle - PL/SQL, SQL-Loader - Understand & Interpret upstream and downstream data flow, do data profiling, data mapping and check data quality from source to target. - Perform impact analysis of new systems, new interfaces & integration....

  • Data Developer

    4 weeks ago


    Kuala Lumpur, Malaysia YM Global Technologies Full time

    Job Information Work Experience - 3+ yearsIndustry - IT ServicesSalary - 8500 MYRCity - Kuala LumpurState/Province - Wilayah Persekutuan Kuala LumpurCountry - MalaysiaZip/Postal Code - 59200- SN 844- L2 (3-5 years)- Mandatory - Teradata & Informatica- Platform - Teradata, Informatica- Database:Teradata, Oracle, SQL server- Language:TD, MDM, FSLDM, SQL- OS:...

  • Junior Developer

    4 weeks 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:...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Avensys Consulting Full time

    Avensys Consulting is seeking a highly skilled Oracle Database Specialist to join our team. As an Oracle PL/SQL Developer, you will play a crucial role in designing, building, and configuring applications to meet business process requirements.This is an exciting opportunity to expand your skill set, achieve job satisfaction, and work-life balance in a fun...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Cognizant Full time

    About the Job:We are seeking an experienced Informatica ETL Developer to join our team at Cognizant. In this role, you will be responsible for designing, developing, and implementing ETL solutions using Informatica PowerCenter.Key Responsibilities:Design, develop, and implement ETL solutions using Informatica PowerCenter.Work with cross-functional teams to...


  • Kuala Lumpur, Malaysia Coforge Pte. Ltd Full time

    **Required**: - Working level professional knowledge of SQL and PL/SQL with Oracle database - Good knowledge on Unix Shell scripting - Working knowledge of core JAVA, JSP servlets - Understanding of development methodologies, phases and milestones. - Understanding of configuration management, production deployment processes, post production support...


  • Kuala Lumpur, Malaysia HTC Global Services Full time

    Around 9 to 10 years of overall experience in the industry. - Working experience in Banking is a must. - Good Technical knowledge on Oracle PL / SQL and MS SQL / Other databases. - Working experience on any automation skills will be an added advnatage - Usage of any reporting tools is good to have and is an advantage - Knowledge/experience in retail and...


  • Kuala Lumpur, Malaysia KellyOCG Full time

    **Responsibilities**: - Participate in the software development life-cycle - Perform system analysis, design, testing, development, project implementation and documentation. - Ensure timely delivery of assigned work. **Job Requirements** - Required Skill set: - SQL - ETL tool experience (eg: Informatica, ODI, SSIS) - MySQL, MsSQL, PostgreSQL, DB2, Oracle...


  • Kuala Lumpur, Malaysia Agensi Pekerjaan JP Caliber Full time

    Job detail - Design, analyse, and provide technical specifications and specialty guidance including review of codes / test contents and coding of complex programs for system development / enhancement in accordance to user specifications. - Support user testing including review of test plan and be responsive to user queries, request for assistance. - Assist...


  • Kuala Lumpur, Kuala Lumpur, Malaysia Cognizant Full time

    Cognizant engineers modern businesses to help our clients modernize technology, reimagine processes, and transform experiences.We're looking for a Data Integration and Analytics Professional to work in a 24x7 on-call support environment for Banking Finance, ETL, Data warehouse, and Finance knowledge for GL, MAS, GST, Regulatory and Reporting/business...

  • Data Integration

    3 weeks ago


    Kuala Lumpur, Malaysia Terrabit Consulting Sdn Bhd Full time

    Must have Informatica/data stage, Oracle Data Integrator Teradata,...


  • Kuala Lumpur, Malaysia Accenture Full time

    Type B WO2 Data S N248 Platform Cloudera Hadoop distributon 6.X, Teradata Inteliflex, AS400,Informatica Data Integration suite of tools,MS Business Intelligence, QlikSense Discovery, SAS, Microsoft R,Experian PowerCurve Server AS400 DB2, Teradata, Oracle, SQL Server, Postgress Language AS400, Teradata TD Studio, IFX, MDM, FSLDM GCFR, View Point, JIRA, Oracle...


  • Kuala Lumpur, Malaysia Accenture Full time

    Type B WO2 Data S N250 Platform Cloudera Hadoop distributon 6.X, Teradata Inteliflex, AS400,Informatica Data Integration suite of tools,MS Business Intelligence, QlikSense Discovery, SAS, Microsoft R,Experian PowerCurve Server AS400 DB2, Teradata, Oracle, SQL Server, Postgress Language AS400, Teradata TD Studio, IFX, MDM, FSLDM GCFR, View Point, JIRA, Oracle...