BI Consultant-informatica Etl

1 day ago


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 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**: 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,...


  • 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 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 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 IKIGAI ENABLERS Full time

    **10 years + Experience Informatica Good hands on exposure on.Net Compliance / Banking experience mandatory Transformations experience immediate joiner Base location Singapore Travel to PH and other places required

  • Etl Developer

    3 days ago


    Singapore EVO OUTSOURCING SOLUTIONS PTE. LTD. Full time

    **Responsibilities**: - Analyzing data source, designing, testing and implementing analytic reports and dashboards. Skills/Requirement - A graduate of bachelor’s degree in computer science and/or equivalent - At least 3 years of ETL and BI experience - Experienced in Informatica, Oracle, Oracle PL/SQL, Unix and OBIEE - Strong working knowledge in ETL...

  • Bis Developer

    6 days ago


    Singapore ADOMITA TECHNOLOGIES PTE. LTD. Full time

    **Key Skills**: SQL Server, Informatica, Windows Scripting, Windows Server 2012/2016, SQL Server 2016, PowerShell Scripting, Power BI, SSIS, SSRS, IIS, Networking, Connect Direct, SFTP, Control M, Aldon, SQL Server Performance tuning, Citrix, WebS phere, Tomcat **Detailed JD**: - Good knowledge in Reg Reporting Domain - Experience in Moody’s RAY...

  • Informatica Admin

    1 week 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...

  • Data Engineer

    3 days ago


    Singapore Synapxe Full time

    Position Overview Do you love Healthtech and Singapore put together? Then you just might love Synapxe. Synapxe is a multiple award-winning Healthcare IT Leader that digitises, connects, and analyses Singapore's health ecosystem. Its ultimate aim is to improve the Singapore population's health and health administrations by integrating intelligent, highly...

  • BI Analyst

    5 days ago


    Singapore ANTAS PTE. LTD. Full time

    POSITION GENERAL DUTIES AND TASKS: Key Skills: Databricks Oracle or SQL Server BI: OAS, Tableau ETL: IDMC, Informatica Powercenter; Oracle PL/SQL scripting or SQL scripting or UNIX scripting or Python scripting **Requirements**: At least 5 - 6 years’ experience in developing, implementing and maintaining IT systems Has at least 3 - 4 years experience in...