| PROFESSIONAL SUMMARY - Over 7+ years of overall IT exposure with system design, development, testing support and production support Data Warehousing which involves ETL, Teradata V2R5, Reporting and Data modeling experience.
- Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center8
- Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, _expression_, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
- Highly creative designer, and excellent problem solving ability.
- Innovative approach to branding, development, and identifying and utilising brand touch points.
- Fresh and intelligent image composition, visual language and interpretation skills.
- Extensive experience in interactive, digital and emerging technologies.
- Practical experience in social networking tools and integration, facebook, twitter, digg, youtube etc.
- Extensive branding and development experience across a wide range of international market sectors.
- knowledge and experience of strategic and operational planning in a business environment.
- Good knowledge in OLAP and OLTP process.
- Proficiency in using Informatica PowerCenter tool to design data conversions from wide variety of sources
- Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
- Extensively worked with large Databases in Production environments.
- Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
- Involved in Performance tuning of the Informatica and oracle.
- Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
- Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, DB2 and Teradata
- Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
- Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
- Extensively worked with sql loader for bulk loading into the oracle database.
- Experience in UNIX Operating System and Shell scripting.
- Proficient in understanding business processes / requirements and translating them into technical requirements.
- Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment.
- Good Knowledge in Data Modeling.
- Familiar with programming language such as C and JAVA.
- Expertise working with PHP, Java, HTML, _javascript_, MySQL, Perl and Joomla.
- Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.
Technical Skills :
Data Warehousing ETL | Informatica PowerCenter 8.x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Datastage ,Repository, Metadata, DataMart, FACT & Dimensions tables. | Data Modeling | Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams | Databases | Oracle 10g/9i/8.0, MySQL 5.4, DB2,OLTP, SQL Server | Programming | SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, C, Java, HTML, Perl, PHP, _javascript_ | Tools | TOAD, SQL*Plus, Dream weaver | Environment | UNIX, Windows XP/Vista, Linux |
|
