Application Designer(S1100192)

Pontoon Solutions

Project Role : Application Designer

Project Role Description : Assist in defining requirements and designing applications to meet business process and application requirements.

Must have Skills : Informatica PowerCenter

Good to Have Skills : No Function Specialization

Key Responsibilities :

• Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications

• Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10x and prepare corresponding documentation

• Designs and builds integrations supporting standard data warehousing objects type-2 dimensions, aggregations, star schema, etc

• Performs source system analysis as required

Technical Experience:

• Implements versioning of the ETL repository and supporting code as necessary

• Develops stored procedures, database triggers and SQL queries where needed

• Implements best practices and tunes SQL code for optimization

• Loads data from SF Power Exchange to Relational database using Informatica

• Works with XMLs, XML parser, Java and HTTP transformation within Informatica

Professional Attributes :

• Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse

• Works with Informatica Data Quality Analyst and Developer

• Primary skill is Informatica PowerCenter

Educational Qualification:

• Minimum 15 years of full time education

Additional Info :

• Understand the business requirement or the downstream process requirement

• Experience

  8 - 12 Years

• No. of Openings

  1

• Education

  Any Bachelor Degree

• Role

  Application Designer

• Industry Type

  IT-Hardware & Networking / IT-Software / Software Services

• Gender

  [ Male / Female ]

• Job Country

  India

• Type of Job

  Full Time

• Work Location Type

  Work from Office