BI Consultant-informatica Etl

2 weeks 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

  • ETL Informatica Developer

    2 weeks ago

    Singapore VUI SYSTEMS PTE. LTD. Full time

    Roles & ResponsibilitiesJob Description: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...

  • ETL Informatica Consultant

    2 weeks ago

    Singapore LMA Full time

    ETL Informatica ConsultantLMA Singapore Posted 18 hours ago Contract S$6k - S$7k As an ETL Informatica Developer, you will be responsible for designing, developing, and maintaining Informatica-based data integration solutions specifically tailored to the banking domain. You will work closely with our team of developers and business analysts to understand...

  • ETL Informatica Developer

    4 weeks ago

    Singapore VUI SYSTEMS PTE. LTD. Full time

    Roles & ResponsibilitiesJob Description: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...

  • ETL Informatica Developer

    3 months ago

    Singapore VUI SYSTEMS PTE. LTD. Full time

    Roles & ResponsibilitiesJob Description: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...

  • Hiring for ETL Informatica Developer

    2 months ago

    Singapore PATH INFOTECH PTE. LTD. Full time

    Roles & Responsibilities Minimum 5 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: Data visualisation tools such as Tableau,...

  • Hiring for ETL Informatica Developer

    4 weeks ago

    Singapore PATH INFOTECH PTE. LTD. Full time

    Roles & Responsibilities Minimum 5 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: Data visualisation tools such as Tableau,...

  • Etl Developer Informatica

    1 month ago

    Singapore TechBridge Market Full time

    : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future through innovation, technology, and collective knowledge, we want to hear from you! Our client is a : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful...

  • Etl Developer Informatica

    4 weeks ago

    Singapore TechBridge Market Full time

    : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future through innovation, technology, and collective knowledge, we want to hear from you! Our client is a : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful...

  • Etl Developer Informatica

    2 months ago

    Singapore TechBridge Market Full time

    : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future through innovation, technology, and collective knowledge, we want to hear from you Our client is a : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future...

  • Etl Developer Informatica

    4 weeks ago

    Singapore TechBridge Market Full time

    : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future through innovation, technology, and collective knowledge, we want to hear from you Our client is a : If you are passionate about playing a key role in the success of a purpose-led organization that is building a meaningful future...

  • Data Engineer(ETL)

    4 weeks ago

    Singapore SOFTENGER (SINGAPORE) PTE. LTD. Full time

    Roles & ResponsibilitiesJob Responsiblities:Position Summary: * ETL (Informatica), OAS Designer * Responsible for ETL (Informatica), OAS Design, Development and data modelling capabilities to support EDW projects & CRDesired Skill:Functional & Technical Expertise: * Regular use of leveraging common data management tools, such as Informatica, SAP BODS, MS-SQL...

  • Data Engineer(ETL)

    2 months ago

    Singapore SOFTENGER (SINGAPORE) PTE. LTD. Full time

    Roles & ResponsibilitiesJob Responsiblities:Position Summary: * ETL (Informatica), OAS Designer * Responsible for ETL (Informatica), OAS Design, Development and data modelling capabilities to support EDW projects & CRDesired Skill:Functional & Technical Expertise: * Regular use of leveraging common data management tools, such as Informatica, SAP BODS, MS-SQL...

  • Data Engineer(Etl)

    2 weeks ago

    Singapore NodeFlair Full time

    Job Summary:SalaryS$5,000 - S$6,500 / MonthlyJob TypeSenioritySeniorYears of ExperienceAt least 7 yearsTech StacksETL Informatica Oracle play Teradata SSIS SAP Java MSSQL SQL C# PythonJob Responsiblities:Position Summary: ETL (Informatica), OAS Designer Responsible for ETL (Informatica), OAS Design, Development and data modelling capabilities to support EDW...

  • Data Engineer(Bi, Tableau, Obiee, SQL, Etl, Data

    2 weeks ago

    Singapore NodeFlair Full time

    Job Summary:SalaryS$4,000 - S$8,500 / MonthlyJob TypeSeniorityMidYears of ExperienceAt least 3 yearsTech StacksETL Informatica Oracle Teradata SSIS SAP MSSQL SQLPOSITION GENERAL DUTIES AND TASKS:Minimum 3 years of experience in design, develop, deploy, and maintenance of BI solutionsEquipped with key SQL Skillsets on Oracle, Teradata and MS-SQL Server...

  • Data Engineer

    1 month ago

    Singapore SOFTENGER (SINGAPORE) PTE. LTD. Full time

    Roles & ResponsibilitiesPOSITION GENERAL DUTIES AND TASKS : Minimum 5 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: Data visualisation tools such as Tableau, OBIEE ETL...

  • Data Engineer

    4 weeks ago

    Singapore SOFTENGER (SINGAPORE) PTE. LTD. Full time

    Roles & ResponsibilitiesPOSITION GENERAL DUTIES AND TASKS : Minimum 5 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: Data visualisation tools such as Tableau, OBIEE ETL...

  • Data Platform Administrator

    1 month ago

    Singapore ALPHAEUS PTE. LTD. Full time

    Roles & ResponsibilitiesResponsibilities: Perform platform admin support for Power BI as well as Informatica Admin includes deployment of objects, security setup, server management, creation/maintenance of cronjobs to schedule Informatica jobs etc. on Linux platform Set up and maintain best practice for Informatica Familiar with PBI Fabric – Create...

  • Data Platform Administrator

    4 weeks ago

    Singapore ALPHAEUS PTE. LTD. Full time

    Roles & ResponsibilitiesResponsibilities: Perform platform admin support for Power BI as well as Informatica Admin includes deployment of objects, security setup, server management, creation/maintenance of cronjobs to schedule Informatica jobs etc. on Linux platform Set up and maintain best practice for Informatica Familiar with PBI Fabric – Create...

  • Informatica Admin

    2 weeks ago

    Singapore ANTAS PTE. LTD. Full time

    POSITION GENERAL DUTIES AND TASKS:To perform administration and maintenance tasks of Informatica Data Governance Platform: DQ, DEI, EDC and AxonTo design, develop and implement ETL framework and job using Informatica DEITo design, develop and implement UNIX Shell and Database SQL script to support Application Administration & DevelopmentTo design and...

  • Senior Engineer, Informatica

    4 weeks ago

    Singapore AVENSYS CONSULTING PTE. LTD. Full time

    Roles & ResponsibilitiesAvensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation, and managed services. Given our decade of success, we have evolved to become one of the top trusted providers in Singapore and...