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