PROFESSIONAL SUMMARY:

• 4.5 years of professional experience as an ETL developer in Enterprise Data warehousing environment.
• Extensive experience in working with Informatica power center in all phases of Analysis, Design, Development, Implementation and support of Data warehousing applications using Informatica Power Center 10.1/9.x/8.x
• 3years of experience in Teradata database using Teradata SQL Assistant
• Work closely with the business leads to understand and finalize the requirements
• Ensure all metrics data is collected for all critical processes during the Design and the Development phases of the SDLC lifecycle.
• Proficient in Full Life Cycle of Software Development (SDLC) including Business Requirements gathering and Data Analysis, Application Design, Development, Testing, Implementation and Documentation
• Parameterized the mappings and increased the reusability
• Experienced in writing SQL queries in Teradata
• Knowledge on Teradata utilities like Fast Load, Multi Load for loading data into multiple tables at a time or to load empty tables at high speed
• Expertise in working with Slowly Changing Dimensions (SCD1 & SCD2) in informatica
• Proficient in implementing complex business rules through different kinds of Informatica Transformations, Workflows/Worklet and mappings/mapplets
• Extensively used pmcmd commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files
• Expertise in using different source files like flat files, relational tables to extract data and to load to respected target
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance and dealing with huge volume of data
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, router, Expression, Lookup, Aggregator, Sorter, Update Strategy, and Sequence Generator etc
• Worked in Healthcare domain, so have good ability to handle huge and confidential data
• Good knowledge in UNIX shell scripts which is used in informatica for automation of ETL
• Involved in problem solving, fixing the bugs, and also connecting with the onsite coordinators and ability to meet deadlines, handle multiple tasks
• Received appreciation mails from client and manger for timely delivery of project at peak times
• Worked in Agile methodology and have constant interaction with the scrum master and the business users
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities, motivated and adaptive with ability to grasp things quickly and to take new roles

SKILL:

ETL Tools: Informatica Power Center 10.1/9.5/9.1/8.6.1

Databases: Teradata, MS - SQL Server 2000/2005/2008 , MySQL, and MS-Access

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling

OS/Environment: Windows, UNIX

Programming: SQL, HTML

Other Tools: SQL Developer, Microsoft word, Excel VBA.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Lead the team for successful delivery of the project on time
• Worked on Agile methodology which helped to understand the requirements very clearly and the progress of the project was good
• Responsible for Business analysis and Requirement collection and helping the development team to understand them
• Involved in building the ETL architecture and source to target mapping to load data into Data warehouse
• Used debugger to test the mappings and fixed the bugs
• Reviewed and analyzed functional requirements, mapping documents, problem solving ad trouble shooting
• Extensively worked on building the SQL’s in Teradata and performance tuning the queries
• Effectively worked on onsite offshore model
• Manage the successful delivery of development projects across the full application lifecycle
• Scheduling the workflows using AutoSys to run the jobs as per the business requirements
• Modified several existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Constant interaction with DBA and ETL admins for successful installation of the changes in the Production environment

Confidential

Informatica (DDH) and Teradata Developer

Responsibilities:

• As a part of team, I involved with the business in gathering the requirements to the technical designing and Functional mapping documents
• Worked on the Functional Design documents and was one of the key members for the ATP approvals taken from the business team
• Data Integration Hub (DIH) application is used as per the business requirements which is an integration solution used to share and synchronize data between applications in a n organization
• Worked on DDH to create subscriptions and auto mapping options
• Worked on developing the mappings in informatica using various transformations like source qualifier, aggregator, router, lookup, joiner, filters, and update strategy
• Implemented SCD slowly changing dimensions type I and II for data load.
• Developed Teradata queries as a part of my project.
• Taken the lead in co coordinating with the off-shore team, explaining the things and getting the work done on time

Confidential

Informatica and Teradata Developer

Responsibilities:

• Involved in all phases of SDLC from requirements gathering, design, development and testing.
• Analyzed the business requirements and functional specifications.
• Extracted data from flat file and staged into a single place and applied business logic to load them in the Teradata database.
• Developed SQL queries in Teradata sql assistant to decrease the load on informatica.
• Extensively worked with Transformations like Router, Aggregator, Expression, Normalizer, Lookup, Update Strategy, joiner and sequence generator.
• Parameterized the mappings and increased the reusability.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Partially involved in writing Unix shell scripts.
• Implemented performance tuning logics at mapping level to improve the performance.
• Extensively used informatica debugger to figure out the problems in mapping. Also involved in trouble shooting existing ETL bugs.
• Written document to describe program development, logic, coding, testing, changes and corrections.
• Implemented SCD slowly changing dimensions type I and II for data load.
• Used informatica workflow manager to create workflows, database connections, sessions and batches to run mappings.
• Scheduling the workflows and loading the files on daily basis.
• Monitoring the workflows very frequently to ensure data loading is done accordingly without any errors.
• Used deployment groups to move informatica objects from Dev to Test to Prod environment
• Responsible for code migration, code review, test plans, test cases as part of unit testing.
• Modified several existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

Environment: Informatica Power center, Teradata Sql Assistant, Unix.

Confidential

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like delimited flat file and Teradata.
• Applied slowly changing dimensions like Type1 and Type2 effectively to handle the delta loads.
• Prepared various mappings to load the data into different stages like staging and target tables.
• Developed workflows using task developer, worklet designer, and workflow designer in workflow manager and monitored the results using workflow monitor.
• Created various tasks like session, Command, email etc.
• Modified several existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following informatica best practices and also applied several methods to get best performance by decreasing the runtime of the workflows.
• Prepared SQL queries to validate the data in both source and target databases.
• Setting up sessions to schedule the loads at required frequency using power center workflow manager PMCMD.
• Performance tuning of Informatica Mappings using various components like Parameter Files, Variables, Dynamic Cache.
• Automated the informatica jobs using UNIX shell scripting.
• Once the development is done, code review is done in order to ensure it does not load the erroneous data
• Involve in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from Unix.
• Interaction with the onsite team on a daily basis on the development activities.
• Involved in error handling, performance tuning of mappings, testing of informatica sessions and the target data.

Environment: Informatica Power center, Teradata Sql Assistant, Unix.

Confidential

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Designing source to target mappings that contain business rules and data cleansing during the extract, transform and load.
• Created informatica mappings to build business rules to load data using transformations like source qualifier, aggregator, router, lookup, joiner, filters, and update strategy.
• Extensively worked on mapping variables, mapping parameters and session parameters.
• Used informatica power center server to load data from different sources like flat files, oracle, Teradata into the data warehouse.
• Used scd1 and scd2 types for the mappings as per the business requirements.
• Scheduling the workflows and Loading the files and Monitoring the workflows very frequently to ensure data loading is done accordingly
• Used deployment group to move informatica objects from Dev to Test and from Test to Prod.
• Created Unit test case document.