SUMMARY

• 8years of professional I.T experience in the space of Data Warehousing.
• Worked on end - to-end projects including analysis, design, development, ETL system testing.
• St rong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center tool
• Strong expertise in using ETL Tools Informatica Power Center 9.6 (Repository Manager, Designer,Workflow Manager, Workflow Monitor) and ETL concepts.
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookup, joiner, sequence generator, sorter, SQL, stored procedure, Update strategy, Source Qualifier.
• Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snowflake Schema, FACT and Dimensions tables.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Coordinating with Business Users, BI teams, functional Design team and testing team during the different phases of project development and resolving the issues.
• Have a good experience in AGILE methodology such as Story-based development, Conflict Resolution, WorkEstimation; Iteration/Sprint planning meetings and Daily stand up meetings etc.
• Committed, adaptive and accountable towards goals and objectives.
• Good analytical and problem solving skills with good communication and presentation skills­.
• Good Knowledge in Insurance and Retail Domain.
• Experience in preparing Technical Solution Design Document.
• Good interaction with team and technical support to team to complete the task on time.
• Ability to work well in both a team environment and individual environment

TECHNICAL SKILLS:

Tools: Informatica 9.x, Business Object,Putty,Winscp

Database: Oracle, MSSQL,Teradata

Languages: SQL, HTML

Domain Knowledge: Data Warehouse, Retail and Insurance

Version Control Tool: SVN

Change Management Tool: Service NOW

Clients Worked: Confidential (NOKIA)& Confidential

Operating System: Windows 7, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Database: Teradata

Informatica Developer

Tools: Informatica Power Center 9.1 & 9.6, Teradata Sql assistant

Responsibilities:

• Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Requirement Analysis from High Level Design document provided by the solution team.
• Preparing Estimation of tasks and Task distribution and management within the team.
• Coordinating with offshore team and providing the inputs and technical guidance.
• Coordinating the onsite and offshore teams on a daily basis.
• Participated proactively in developing and maintaining team standards, tools and best practices reducing development time
• Creation of ETL mapping, sessions, worklets and workflows using Informatica
• Worked on the Mapping specification documents and provided SQL queries to QA team which helps in testing data.
• Monitoring the loads, analyse and apply relevant fixes to scheduling issues.
• Technical as well as Functional Code Review of Informatica/DDL
• Built Low Level Design documents, Implementation Plans, Traceability Matrix.
• Documented Informatica mappings in Functional specification document
• Handled status calls between onsite/offshore teams
• Protect team from over-commitment, prioritize resolution of defects/bugs as evidenced by the on-time delivery
• Timely Defect analysis and resolution in the testing phase

Confidential, Redmond, WA

Database: MSSQL

Informatica Developer

Tools: Informatica Power Center 9.6, SSMS 2014

Responsibilities:

• Requirement Analysis from High Level Design document provided by the solution team.
• Preparing Estimation of tasks and Task distribution and management within the team.
• Participated proactively in developing and maintaining team standards, tools and best practices reducing development time
• Creation of ETL mapping, sessions, worklets and workflows using Informatica
• Work with various transformations like Normalizer,expression,rank, filter, group, aggregator, Lookup, joiner, sequence generator, sorter, SQL, stored procedure, Update strategy, Source Qualifier.
• Involved in designing the Mapplet and reusable transformation according to the business needs.
• Monitoring the loads, analyse and apply relevant fixes to scheduling issues.
• Technical as well as Functional Code Review of Informatica/DDL
• Built Low Level Design documents, Implementation Plans, Traceability Matrix.
• Documented Informatica mappings in Functional specification document
• Handled status calls between onsite/offshore teams
• Protect team from over-commitment, prioritize resolution of defects/bugs as evidenced by the on-time delivery
• Supported and worked with QA to test the stories in QA environment.
• Timely Defect analysis and resolution in the testing phase

Confidential, Redmond, WA

Database: Teradata

Informatica Developer

Tools: Informatica Power Center 9.1 & 9.6, Teradata Sql assistant

Responsibilities:

• Estimate volume of work and deriving delivery plans to fit into overall planning
• Requirement Analysis from High Level Design document provided by the solution team.
• Preparing Estimation of tasks and Task distribution and management within the team.
• Participated proactively in developing and maintaining team standards, tools and best practices reducing development time
• Involved in designing the tables structure and relations based on the requirements and helped to the new tables based on the design.
• Creation of ETL mapping, sessions, work lets and workflows using Informatica
• Work with various transformations like Normalizer,expression,rank, filter, group, aggregator,
• Lookup, joiner, sequence generator, sorter, SQL, stored procedure, Update strategy, Source Qualifier.
• Design and develop Informatica mappings including Type-I, Type-II, and Type-III slowly changing dimensions.
• Monitoring the loads, analyse and apply relevant fixes to scheduling issues.
• Built Low Level Design documents, ImplementationPlans, Traceability Matrix.
• Documented Informatica mappings in Functional specification document
• Timely Defect analysis and resolution in the testing phase

Confidential

Database : Oracle

Informatica Developer

Tools: Informatica 9.6.1, Toad

Responsibilities:

• As a Developer, I'm responsible for development, support, maintenance and implementation of Complex components of a project module.
• Design and Development of ETL mappings using Informatica.
• Work with various transformations like Normalizer,expression,rank, filter, group, aggregator, Lookup, joiner, sequence generator, sorter, SQL, stored procedure, Update strategy, Source Qualifier.
• Worked as an independent team member, capable of applying my own judgment in the areas ofSoftware development
• Involved in UNIT TESTING of mapping
• Attend Technical meetings & discussions.
• Created Informatica mappings and workflows with respect to the technical and functional Documents provided in sync with the customer requirements and the service requests.

Confidential

Database: Oracle

InformaticaDeveloper

Tools: Informatica Power Center 8.6, Toad, OBIEE

Responsibilities:

• It is a historical load and the tables are loaded on weekly basis. OBIEE Reports out of the data from the data warehouse and create reports, which helps them to see all the week from the time loaded.