Informatica Expert

Found in: Talent SG 2A C2 - 2 weeks ago

Singapore MINDTECK SINGAPORE PTE LTD Full time
Roles & Responsibilities

Informatica Expert 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 with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people.
  • Works cooperatively with others to resolve data and process issues.
  • Plans & develops ETL, Data preparation/aggregation processes from various sources to MSSQL database/PostgreSQL DB
  • Create, maintain, and optimize ETL and other informatica processes to adapt to changes in needs and requirements.
  • Responsible for developing and managing informatica configurable artifacts (code, environment, configuration files, documentation).
  • Plans Informatica ETL unit, SIT and UAT tests.
  • Familiar with stored procedures, functions, inline SQL, database structures
  • Provide post-production application support as required.
  • Follow established standards and best practices and provide input for improvement of those processes.

Informatica ETL Developer qualifications

  • BS/MS degree in Computer Science, Engineering, or a related subject.
  • Must have 5 to 8 years of Informatica development experience.
  • Current experience with Informatica PowerCenter v10.5+.
  • Experience with migration of Informatica PowerCenter to IDMC.
  • Experience with performance tuning of sources, mappings, targets, and sessions.
  • Experience with Data Architecture and Data Modeling concepts is a plus.
  • Familiarity with Microsoft SQL Server/PostgreSQL DB.
  • Excellent understanding of T-SQL programming.
  • Ability to work with development and operations teams to tune production queries for optimal performance.
  • Knowledge of git Source Control. and Knowledge of CI/CD pipelines or deployment automation tools.
  • Critical thinker and problem-solving skills.
  • Team player.
  • Good time management skills.
  • Great interpersonal and communication skills.

Tell employers what skills you have

Informatica PowerCenter
Data Modeling
ETL Tools
ETL specification
Informatica
ETL
Data Architecture
Informatica Power
Informatica Power Center
data warehouse solution
Data Warehousing

  • Informatica Consultant

    Found in: Talent SG 2A C2 - 2 weeks ago

    Singapore MINDTECK SINGAPORE PTE LTD Full time

    Roles & ResponsibilitiesDuties 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 with non-technical, subject matter experts to understand underlying...

  • Informatica Consultant

    1 week ago

    Singapore Mindteck Singapore Pte Ltd Full time

    Duties and responsibilitiesWorks 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 with non-technical, subject matter experts to understand underlying data behavior and...

  • Data Engineer

    1 week ago

    Singapore Collabera Technologies Private Limited Inc Full time

    Role: Work closely with business analysts and solution architects to develop and implement end-to-end data solutions.You will perform data analysis, collaborate with non-technical stakeholders to understand data behavior, and assess and provide recommendations for IDMC services. Responsibilities:Work with Solution Architects and Business Analysts to assess...

  • Teradata Developer #SGUnitedJobs

    Found in: Talent SG 2A C2 - 1 week ago

    Singapore VUI SYSTEMS PTE. LTD. Full time

    Roles & ResponsibilitiesWe are hiring for our project requirement in singapore- Developement and user support in Teradata, DWH projects- Should have thorough Hands on 3-5 years of work experience in Unix and writing in Teradata SQL. · Must have work with any ETL look like Datastage , Informatica or ODI· Experience in dealing multiple file extractions and...

  • Teradata Developer #SGUnitedJobs

    1 week ago

    Singapore Vui Systems Pte. Ltd. Full time

    We are hiring for our project requirement in singapore - Developement and user support in Teradata, DWH projects - Should have thorough Hands on 3-5 years of work experience in Unix and writing in Teradata SQL. . Must have work with any ETL look like Datastage , Informatica or ODI . Experience in dealing multiple file extractions and creating mappings ....

  • Manager, Data Engineering

    Found in: Talent SG 2A C2 - 1 week ago

    Singapore TEMUS PTE. LTD. Full time

    Roles & ResponsibilitiesOur Background:Founded by Temasek & UST, Temus is a start-up aspiring to be Singapore's Digital Transformation champion, with a mission to empower Singapore’s Smart Nation across public and private sectors and enhance the lives of citizens.Our services span from strategic advisory through to digital, data and AI delivery. Our focus...

  • VP - BSA (AML/Payments)

    Found in: Talent SG 2A C2 - 23 hours ago

    Singapore THE TORONTO-DOMINION BANK Full time

    Roles & ResponsibilitiesTD Bank GroupHeadquartered in Toronto, Canada, with ~95,000 employees around the world, the Toronto-Dominion Bank and its subsidiaries are collectively known as TD Bank Group (TD). TD offers a full range of financial products and services to over 27.5 million customers worldwide through four key business lines: Canadian Personal and...