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