SUMMARY

• 11+ years of IT experience in the designing and implementing of Data Warehousing and Data Integration including Requirement Gathering, Data Analysis, Design, Development, Testing and implementation using Informatica PowerCenter for Healthcare, Insurance domains.
• Experience in data warehousing, Data Profiling using Informatica PowerCenter 10x/9x/8x in building Enterprise Data warehouse/Data Marts.
• Understand the business rules based on high level document specification and implement the data transformation methodologies.
• Extensively used ETL processes to load data from various source systems such as Oracle, Teradata, Flat Files, XML files into target system by applying business logic on transformation mapping.
• Extensively worked with mappings using different transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Update Strategy, Unconnected / Connected Lookup, Aggregator, SCD Type - 1 and SCD Type-2.
• Experience in identifying bottlenecks in ETL processes and Performance tuning of applications using Database tuning, Partitioning, Index usage, Informatica source level, target level and mapping level.
• Experience in problem solving and troubleshooting for the applications implemented with Informatica.
• Extensive experience in Dimensional Modelling using Star & Snow flake schema, Identifying Facts and Dimensions using Erwin.
• Flexible and versatile to adapt any new environment and work under pressure.
• Zeal to learn new technologies, undertake challenging tasks.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.

TECHNICAL SKILLS

ETL Tools: Informatica 8x/9x/10x, Informatica B2B DT Studio, Informatica Power Exchange

BI Tool: Business Objects XI R2

Databases: Oracle, Teradata, DB2, Netezza, SQL Server

OS: Windows XP/Vista /7/8/10

Scripting: SQL, PL/SQL, UNIX Shell Scripting, XML

Others: Stans tool, Data Flux Profiling tool, GitHub, CA Workstation Scheduler

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

Developer

Tools: & Environment: Windows, Informatica Power Center 9x/10x, Toad, Oracle SQL Developer, SQL, PL/SQL, XML, CA Workstation scheduling tool.

Responsibilities:

• Development of ETL mappings using Informatica Power Center as per the Business Requirements.
• Develop industry-specific solutions based on client needs and manage and upgrade existing applications.
• Carry out detailed analysis to understand requirements and create code and/or build solutions as per requirements in development/maintenance projects in accordance with coding standards.
• Creating and Updating of mapping documents, Design Documents and UTCs.
• Preparation of high-level, detailed-level design documents based on the business/functional Requirements (BR/FR).
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Integration of various data sources like Fixed Width and Delimited Flat Files, DB2, COBOL files, XML Files.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), SQL to obtain optimal performance and throughput.
• Used Unix shell scripting to kick-off the workflows to load the data from source to staging and then to target tables.
• Conduct module level work effort estimations and integrate for the whole system.
• Design and implement automated unit testing framework as required.
• Use best practices and coding standards.
• Clarify all unknown areas, which are communicated by the functional, from the customer.
• Develop, maintain, troubleshoot, enhance and document components develop by self and others as per the requirements and detailed design.
• Effectively worked on Onsite and Offshore work model.
• Execution of test cases and Unit testing.

Confidential - Columbus, OH.

Developer.

Tools: & Environment Windows, Informatica Power Center 9.6.1, Toad, Teradata, PL/SQL.

Responsibilities:

• Develop industry-specific solutions based on client needs and manage and upgrade existing applications Scheduling the jobs
• Carry out detailed analysis to understand requirements and create code and/or build solutions as per requirements in development/maintenance projects in accordance with coding standards
• Execution of test cases and Unit testing
• Developed slowly changed dimensions SCD Type 2 for loading data into Dimensions and Facts.
• Creating and Updating of mapping documents, BRD, Design Documents and UTCs
• Conduct system wide requirement analysis.
• Conduct module level work effort estimations and integrate for the whole system.
• Optimizing performance tuning at source, target, mapping and session level.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Design and implement automated unit testing framework as required.
• Use best practices and coding standards.
• Clarify all unknown areas, which are communicated by the functional, from the customer.
• Develop, maintain, troubleshoot, enhance and document components develop by self and others as per the requirements and detailed design.
• Have used BTEQ, FLOAD, MLOAD, TPUMP Teradata utilities to export and load data to/from Flat files.

Confidential - Columbus, OH.

Developer.

Tools: & Environment Windows, Informatica Power Center 9.6.1, Toad, Netezza, Oracle, PL/SQL.

Responsibilities:

• Develop industry-specific solutions based on client needs and manage and upgrade existing applications and scheduling the jobs
• Carry out detailed analysis to understand requirements and create code and/or build solutions as per requirements in development/maintenance projects in accordance with coding standards
• Execution of test cases and Unit testing
• Creating and Updating of mapping documents, BRD, Design Documents and UTCs
• Conduct module level work effort estimations and integrate for the whole system.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), SQL to obtain optimal performance and throughput.
• Developed slowly changed dimensions SCD Type 1 and SCD Type 2 for loading data into Dimensions and Facts.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Design and implement automated unit testing framework as required.
• Use best practices and coding standards.
• Clarify all unknown areas, which are communicated by the functional, from the customer.
• Develop, maintain, troubleshoot, enhance and document components develop by self and others as per the requirements and detailed design.

Confidential - Indianapolis.

Developer.

Tools: & Environment Windows, Informatica Power Center 9.5.1, B2B DT Studio, IBM DB2, UNIX.

Responsibilities:

• Understanding client requirements and Impact analysis.
• Understanding the Business requirements and flow.
• Code development, Walk through and Testing.
• Understanding Job flow and providing permanent fixes to the bugs.
• Fixing the identified bugs, by finding the root cause.
• Implementation plan and executing the same with version maintenance.
• Technical documentation /User Manual preparation.
• Interaction with onsite for requirement gathering.
• Ensure the overall quality of the project.
• Training and Mentoring of the team members.
• Establish “Best Practices” and plan for continuous improvement of processes.