• Strong analytical, problem-solving and conceptual skills; assisting team in developing clear solutions to complex problems, often where no current answer exists.• Effective interpersonal skills to consistently demonstrate expertise, business knowledge, team cohesiveness, respect and patience while interacting during crisis management or meeting deadlines.• Ability to communicate recommendations and solution effectively in written and spoken word to all levels of an organization.• Closely worked with the business users to capture the business requirements and with the Data Architects and DBA’s to come up with the logical and physical model.• Worked with client manager and business teams to develop, review, finalize and document Business Intelligence, including reporting and dashboard requirements based on the identified key performance metrics.• Architecting, designing and delivering ETL interfaces using Informatica tools including Mapping Designer Workflow Manager, Mapplets, Data Connections, Reusable Sessions, Command Tasks, WF Scheduler Workflow Monitor, Repository Manager and Repository Server Administration Console.

• Responsible for Requirement Gathering and Analysis of Business requirements• Extensively participated in the requirement gathering meetings with the end users.• Scrum/Agile Methodology• Responsible for mentoring and assigning tasks to other developers.• Responsible for high level ETL Process for the entire project.• Involved in discussions of Data modeling for datawarehouse & creation of data marts.• Associated with Physical and Logical Data Modeling using Sybase Power Designer.• Responsible for conversion of Business requirements into ETL Informatica technical specifications• Leading the technical design reviews, assisted with database design and architecture.• Formulating the ETL mappings to implement the business logic using transformations like lookup, update strategy, expression, filter, router, aggregate, Sorter, Rank, Joiner, Source Qualifier, XML Generator, Unstructured Data transformation, Stored Procedure, Normalizer.• Capturing requirements from the Business Analysis Team, designing Test Plan, Test Strategy, Test scenarios and executing SIT test cases, reporting defects and performing regression testing to ensure minimal UAT/post-production defects.• Creating B2B Mapper & serializer to convert the data from XML to X12 (Healthcare Proprietary format) using Informatica Data transformation Studio.• Handling project management activities like Requirement Gathering, Preparation of estimates and schedules, Training Developers, Setting up Environments.• Working with tracing levels for performance tuning of the mappings-Terse, Normal, Verbose Initialization, and Verbose Data.

• Client interaction on a daily basis for the requirements gathering and status updates.• Based on the client requirements identifying the appropriate data sources for loading Datawarehouse. Creating detailed design documents based on mapping sheet.• Ensuring the strategy and execution of ETLs are consistent with defined controls and procedures established by global data standards.• Developed, maintained and enhanced PL/SQL packages, procedures and functions utilized by ETL processes.• Populating slowly changing dimensions tables using type 2-dimension changing and maintaining the full history of the data.• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.• Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type1, Type 2 and for loading historical data and current data into EDW.• Write complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy. • Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.• Worked in creation of multiple universe and document domains for Development, QA and Production Environments.