SUMMARY

• 5+ years of experience in Information Technology with a strong background in Data Warehousing.
• Worked extensively in Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor. Informatica, ETL, Data warehousing, Oracle, Shell Scripting
• Extensive experience in integrating disparate data sources (flat files, XML, CSV) with multiple relational databases
• Implemented complex business rules in Informatica by creating reusable transformations, robust mappings/mapplets, utilizing varied transformation logic like lookups, router, filter, expression, aggregator, joiner, update strategy, normalizer and more
• Exposure to Data modeling techniques like star and snowflake schemas using Erwin
• Expertise in designing and implementing SCD - slowly changing dimensions types (1, 2 and 3) and CDC - change data capture
• Performance tuning of the mappings, ETL Environments, procedures, queries and processes
• Expertise in handling and loading high volumes of data into data warehouse in a given load window
• Knowledge in design and development of BI reports using Tableau
• Proficient in implementing ETL QA procedures and Exposure to all stages of Software Development Life Cycle
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica PowerCenter.
• Proficiency in using Informatica Power Center tool to design data conversions from wide Variety of source system.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping conversion and loading.
• Strong in Data warehousing concepts, Dimensional Star Schema and Snowflakes Schema methodologies.
• Extensively used Flat files to load data from source systems to targets using direct and indirect methods.
• Proficient in understanding business processes / requirements and translating them into Technical requirements.
• Extensively worked on Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML files into the data warehouse.
• Extensively used SQL to write Stored Procedures, Functions, Packages and Triggers.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Well developed interpersonal and communication skills.
• Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.0/8.6/7.1 (Source AnalyzerData Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets).

Methodologies: Star Schema, SnowFlake Schema, FACT and Dimension Tables.

RDBMS: SQL Server 2005/2012,2014, DB2, MS Access 7.0/2000.

Operating System: Windows 7, Windows Vista/XP/2000, UNIX

Development tools: SQL Developer, SQL *PLUS.

Programming/Languages: SQL, UNIX shell scripting.

PROFESSIONAL EXPERIENCE

Confidential, Dallas,Tx

Informatica Consultant

Responsibilities:

• Extensively involved in requirements gathering, writing ETL Specs and preparing design documents
• Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies
• Fixed various performance bottlenecks involving huge data sets by utilizing Informatica’s partitioning, pushdown optimizations and SQL overrides
• Worked on parameters, variables, procedures, scheduling and pre/post session shell scripts
• Designed migration plan and cutover documents; created and monitored Informatica batches
• Worked on requirement traceability matrix, provided support for integration and user acceptance testing.

Confidential, OK

Informatica Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited and fixed width Flat files.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type I and II effectively to handle the Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy, Designing and optimizing the Mapping.
• 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, Timer and Event wait.
• Modified several of the 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 run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.

Environment: Informatica Power Center 8.6, MS-SQL Server, Windows XP, MS Office and Flat files.

Confidential

Database Administrator

Responsibilities:

• Perform coding migration, database change management & data management through the various stages of the development life cycle
• Assist System Development Manager in Microsoft SQL Server management and database maintenance
• Assist System Development Manager in performance tuning and database optimization
• Identifying performance improvements to database procedures and data structures and working with Development teams to deliver code changes
• Work with the development team to resolve bug-fixes and assist in relevant testing through various environments
• Conduct performance reviews and contribute to performance feedback for all levels of staff
• Monitor SQL server and database performance and proactively address potential performance issues
• Review, design, and develop data models in conjunction with application development teams
• Provide solutions for database issues including capacity, redundancy, replication, and performance