Informatica Etl Developer

3 days 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

    7 days 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 Developer

    3 days 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 day 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...

  • Informatica Developer

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

  • Informatica Developer

    1 week ago

    Singapore Epergne Solutions Full time

    Epergne Solutions is looking for a informatica developer. **Duties and responsibilities** - Works with Solution Architect & BAs on end-to-end solution, evaluate and recommend suitable IDMC services. - Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work. - Works cooperatively with others to...

  • Informatica Developer

    1 week ago

    Singapore TECHCOM SOLUTIONS (SINGAPORE) PTE. LTD. Full time

    **Responsibilities**: - Design, develop, and maintain ETL processes using Informatica. - Collaborate with data analysts to gather requirements and optimize data flows. - Troubleshoot and resolve data integration issues. - Perform data validation and ensure data quality. - Optimize existing ETL jobs for performance improvements. - Document technical...

  • Hiring for Informatica Developer

    2 weeks ago

    Singapore PATH INFOTECH PTE. LTD. Full time

    Hands on in information IDMC cloud data pipelines creation, idmc data profiling and data quality, prior experience in migration from informatica DEI to informatica IDMC is highly preferred. Involve in various stages of the systems development life cycle; adopting waterfall, agile or hybrid development methodology. (b) Performs analysis, design and...

  • Etl Developer

    1 day ago

    Singapore U3 Infotech Pte Ltd. Full time

    Job - ETL Developer(Obiee) Informatica Power Centre Oracle Oracle PL/SQL Unix (Good to have) OBIEE (Good to have) Preferred Banking industry domain.

  • Informatica Admin

    1 day ago

    Singapore Quess Corp Limited Full time

    **Job Information**: Industry **IT Services** *** Salary **$8500 Max** *** Work Experience **6-8 Years** *** City **Singapore** *** State/Province **Singapore** *** Country **Singapore** *** Zip/Postal Code **079914** *** - Administrator experience on Informatica products - DEQ,/PowerCentre, Enterprise Data Catalog, - To perform administration...

  • Informatica Admin

    1 week ago

    Singapore CONSULGURU PTE. LTD. Full time

    **POSITION GENERAL DUTIES AND TASKS**: - 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...