Informatica Etl Developer

1 week ago

Singapore TECHNOALLY PTE. LTD. Full time

**Role: ETL Developer**
- Design and develop any/all necessary ETL processes
- Responsible for loading and validating data into the data warehouse
- Knowledge in Dimensions and Facts tables.
- Translated the business processes into Informatica mappings for building the Dimension tables.
- Worked on different tasks such as Event wait, Event Raise and Command.
- Created mappings to build business rules to load data.
- Implemented slowly changing strategy to manage the data in the dimension tables.
- Involved in Code review and manual testing such as Unit testing
- Involved in creating mapping variable, mapping parameter to make the mapping more flexible
- Knowledge in performance tuning to optimize session performance by eliminating performance bottlenecks.
- Prepared Functional spec, Migration document, Unit test case document and support manual.
- Hands on experience in writing UNIX commands and writing, editing Shell Scripts.
- Hands on experience in creating procedures and functions.
- Hands on working experience in SQL Server and Vertica Databases.
- Strong experience in Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger). Experience in SQL, PL/SQL and UNIX shell scripting.

Primary Skills
- ETL Tool - Informatica 9.x & above
- Oracle 10g & above.
- Unix Shell Scripting

Secondary Skills
- PLSQL
- CTRL-M
- JIRA
- Banking domain knowledge

  • Etl Informatica Developer

    2 weeks ago

    Singapore Infosight Consuting Full time

    Administrator experience on Informatica products - DEQ,/**PowerCentre**, Enterprise Data Catalog, - To perform administration and maintenance tasks of Informatica Data Governance Platform**:DQ, DEI, EDC and Axon**, - To design, develop and implement **ETL framework** and job using **Informatica DEI**: - To design, develop and implement **UNIX Shell and...

  • Etl Informatica

    2 weeks ago

    Singapore Infosight consulting Full time

    Administrator experience on Informatica products - DEQ,/PowerCentre, Enterprise Data Catalog, - To perform administration and maintenance tasks of Informatica Data Governance Platform**:DQ, DEI, EDC and Axon**, - To design, develop and implement **ETL framework** and job using **Informatica DEI**: - To design, develop and implement **UNIX Shell and Database...

  • Etl Informatica Developer

    1 week ago

    Singapore VUI SYSTEMS PTE. LTD. Full time

    ETL (Informatica), OBIEE Designer. To Perform ETL (Informatica),OBIEE Design & Development and data modelling capabilities to support EDW to deliver NHGPBI CR & Enhancements. **Role and Responsibilities**: **_Communication: _** - Build strong relationships with Business Intelligence Analysts to understand business requirements and use cases for data...

  • Informatica Developer

    1 week ago

    Singapore Unison Consulting Pte Ltd Full time

    Design, develop, and maintain robust **ETL workflows** using **Informatica IDMC**. - Work on data ingestion, transformation, and integration from various on-premise and cloud-based sources. - Develop and troubleshoot mappings, sessions, workflows, and data pipelines. - Collaborate with data architects, analysts, and business teams to translate business...

  • Etl/informatica Administrator

    1 week ago

    Singapore EXASOFT PTE. LTD. Full time

    **Responsibilities** To perform administration and maintenance tasks of Informatica Data Governance Platform: DQ, DEI, EDC and Axon To design, develop and implement ETL framework and job using Informatica DEI To design, develop and implement UNIX Shell and Database SQL script to support Application Administration & Development To design and administer ETL...

  • Informatica Etl Developer

    1 week ago

    Singapore FUTUREX TECHNOLOGIES PTE. LTD. Full time

    We are looking for a consultant which can execute the implementation data integration & management solution using ETL tool. The consultant will deliver value-added solutions to our banking client. The main tasks/responsibilities will include: Involve in full cycle of project implementation, from gathering requirement with users, design, architecting,...

  • Sr. Etl Informatica Developer

    3 days ago

    Singapore Horizon Corp Full time

    **Role - Sr. ETL Informatica Consultant** **Location - Singapore** **Duration - Long term contract(Payroll under R Systems)** **Job description** - Work with Biz Users and project Team and Perform A&D work for Credit Risk, Basel, iFRS9 & Customer Segmentation projects - Support and enhance existing Informatica environment and develops new, complex ETL...

  • Informatica Developer

    2 weeks ago

    Singapore SAVANT INFOTECH SOLUTIONS PTE. LTD. Full time

    **Job Scope** - Design Extract, Transform and Load (ETL) strategy across multiple data sources using Informatica PowerCenter. - Work with other team members to ensure that all system components in various environments are prepared for ETL activities. - Develop and execute ETL using Informatica PowerCenter 10.x or higher. - Responsible for ensuring the...

  • Hiring for Etl Informatica Developer

    7 days ago

    Singapore PATH INFOTECH PTE. LTD. Full time

    Degree/Diploma in Computer Science/ Engineering, Information Technology/ System or equivalent. - Minimum 8 years of experience in design, develop, deploy, and maintenance of BI solutions - Equipped with key SQL Skillsets on Oracle, Teradata and MS-SQL Server databases - Knowledge and relevant experience in one or more of the following areas: - ETL tools...

  • Informatica Developer

    2 days ago

    Singapore LMA Full time

    **Informatica developer** - 7+ years’ experience in designing and implementing the ETL based data solutions. Preferably on Informatica, Azure Platform. - Good working knowledge of Informatica PowerCenter, Azure Databricks and Azure Data Lake - good knowledge of Oracle, PostgreS database and of SQL is essential. - strong understanding of data warehousing...