BI Consultant-informatica Etl

20 hours ago


Singapore IntersoftKK Full time

Singapore

**Experience**:
**Skills**:
Mandatory Skills

Informatica ETL

Preferred Skills

Brief Job Description

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
- Technical design, development, testing, documentation of Data Warehouse / ETL projects
- Perform data profiling and logical / physical data modelling to build new ETL designs and solutions
- Develop, implement and deploy ETL solutions to update data warehouse and datamarts
- Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data
- Troubleshoot, debug and diagnose ETL issues
- Have the ability to work with users, BI and Application teams to get ETL solutions developed and implemented
- Performance tuning and enhancement of SQL and ETL processes and prepare related technical documentation
- Meet with functional analysts and /or end users to gather/ clarify requirements as needed to complete BI/ DW projects
- Develop and enhance BI reports, models and Cubes and provide support as needed
- Keep abreast of latest ETL technologies and plan effective use
- Help build solutions pertaining to Predictive analytics and/or Big data
- Communicate very clearly and professionally with users, peers, and all levels of management. The communication forms include written and verbal methods
- Lead the team members to work with end users to resolve data refresh issues
- Provide ETL components for standard bid proposals and justify functional components in the proposed solution.

**Basic Qualifications**
- More than 7 years in ETL:

- Expert knowledge of data warehouse architecture
- Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
- Advanced experience in SQL, writing Stored procedures and tuning SQL
- Strong experience with Informatica Powercenter.
- Experience in trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
- Independent problems solving skills.
- Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management.
- Open to learn and acquire new skills.
- Working knowledge in Informatica TDM and DQ

**Preferred Qualifications**
- Preferred experience with other ETL tools, like Talend
- Preferred with experience in Big Data projects



  • Singapore IntersoftKK Full time

    Singapore **Experience**: **Skills**: - Technical design, development, testing, documentation of Data Warehouse / ETL projects - Perform data profiling and logical / physical data modelling to build new ETL designs and solutions - Develop, implement and deploy ETL solutions to update data warehouse and datamarts - Maintain quality control, document...


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


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


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


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


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


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


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


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

  • Data Engineer(Etl)

    2 days ago


    Singapore NodeFlair Full time

    **Job Summary**: **Salary** S$5,000 - S$6,500 / Monthly **Job Type** **Seniority** Senior **Years of Experience** At least 7 years **Tech Stacks** ETL Informatica Oracle play Teradata SSIS SAP Java MSSQL SQL C# Python **Job Responsiblities**: Position Summary: - ETL (Informatica), OAS Designer - Responsible for ETL (Informatica), OAS Design,...