SUMMARY:

• Overall 8 years of IT experience in analysis, design, development and implementation of Data warehouses, data marts and using Informatica Power Center with Oracle, MS SQL server, DB2 databases.
• Strong data processing experience in designing and implementing Data Warehouse and Data Mart applications, mainly Transformation processes using ETL tool INFORMATICA POWER CENTER, and UNIX Shell Scripting
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and technologies such as Ab Initio, ODI and Erwin.
• Proficient in Dimensional Data modeling and Relational Star Join Schema/ Snowflake models, FACT & Dimensions tables, Physical & logical data modeling and Ralph Kimball Methodologies
• Proficient level working with Informatica PowerCenter. Hands on experience identifying the most critical information within organization and creation of a single source of its truth to power business processes.
• Strong database experience using Oracle, SQL Server, SQL, PL/SQL, SQL*Loader, Stored Procedures, TOAD, MS Access and UNIX scripting.
• Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Proficiency in data warehousing techniques for data cleansing, slowly changing dimensions types (1, 2 and 3).
• Expertise in SQL/PLSQL in developing & executing Stored Procedures, Functions, Triggers and tuning on queries while extracting and loading data.
• Monitoring actively Informatica job runs.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities.
• Experience in UNIX shell scripting and configuring Cron jobs for Informatica job scheduling, backup of repository and folder
• Extensive experience and knowledge of the project lifecycle, including requirements gathering, development and execution.
• Coordinated offshore efforts and day - to-day activities,

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Data Stage 8.5.

Power Exchange for Datacom(CDC), Informatica Data Quality

DBMS: Oracle 11g/10g/9i/8i,Netezza, SQL Server 12

Data Modeling: Erwin Tool

Software Tools: Toad, SQL developer, SQL *Plus, MS Office, MS Visio, IBM Rational Clear Quest, File Zilla, SQL Loader, ER Studio 10.0, PG Admin 1.22

Operating System: Windows, UNIX, and Linux.

Languages: SQL, PL/SQL, Python 3.4.2

BigData Technologies: Sqoop, Hive

Reporting Tools: COGNOS 8, OBIEE 11g

PROFESSIONAL EXPERIENCE:

Confidential - LA, CA

Informatica Developer

Responsibilities:

• As a consultant studied the existing DataMarts to understand and integrate the new source of data.
• Managing the off shore support group in India for support issue as well as small enhancements for data warehouse.
• Preparing the weekly status report and coordinating weekly status calls with technology lead/business
• Designed and created new Informatica jobs to implement new business logic into the existing process.
• Data Migration from Legacy Servers which run on Oracle ETL and PLSQL code to run on new servers with Oracle and ETL Informatica Power Center 9.6.
• Installed Informatica Power Center on New servers and migrated data from Legacy Servers by troubleshooting all the performance issues.
• Created Data Maps using Power Exchange Navigator as per request from the Developers.
• Using Informatica modules (Repository Manager, Designer, Workflow Manager and Workflow Monitor) to accomplish end to end ETL process.
• Performed data profiling with Sources to analyse the content, quality and structure of source data
• Created required scripts/transformations to extract the source data from various sources such as Oracle, Flat Files etc.
• Used all the complex functionality of informatica (Mapplets, Stored Procedures, Normalizer,update strategy, Router, Joiner, Java, SQL Transformation Etc...) to interpret the business logic into the ETL mappings.
• Designed and developed complex aggregate, joiner, lookup transformations to implement the business rules in the ETL mappings to load the target Facts and Dimensions.
• Defined Target Load Order Plan for loading data into Target Tables
• Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability.
• Used Informatica’s features to implement Type 1, 2, 3changes in slowly changing dimension Change Data Capture (CDC)
• Different database triggers Created and configured workflows, worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
• Fine-tuned the session performance using Session partitioning for long running sessions.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Used Versioning, Labels and Deployment group in the production move process.
• Automation of Workflow using UNIX scripts using PMCMD, PMserver commands.
• Setup Permissions for Groups and Users in all Environments (Dev, UAT and Prod).
• Createdtables, views, primary keys, indexes, constraints, sequences, grants and synonym.
• Used debugger to test the mapping and fixed the bugs.
• Conducted Design and Code reviews and extensive documentation of standards, best practices and ETL Procedures.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Developed Oracle Stored Procedures, Packages and Functions and utilized in ETL Process.
• Handled the performance tuning of Informatica Mappings at various level to accomplish the established standard throughput.
• Analysed the Target Data mart for accuracy of data for the pre-defined reporting needs.

Environment : Informatica Power Center 9.5, Erwin, MS Visio, Oracle 11g, SQL, PL/SQL, Oracle Sql Developer Tool, SQL Server 2008, Flat Files, XML, Mainframe, Cobol Files, Autosys, UNIX Shell Scripting, Subversion.

Confidential, Plantation, FL

ETL Informatica Developer

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Working as an Informatica developer for loading Mortgage data to the target SQL Server.
• Define solution and features and worked in the agile environment.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc to extract data from SQL server and load into SQL Server and generate FlatFiles.
• Used shared folders for having shared mappings, shared transformations, shared sources and shared targets.
• Worked on Agile Methodology and Involved in installing Informatica and adding users and creating folders and giving permissions to users.
• Developed mapplets and worklets for reusability.
• Created post-session and pre-session shell scripts and mail-notifications.
• Scheduled workflows and shell scripts using Autosys.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Designed and Implemented the ETL code for Address verification, Identity checking by working with IDQ.
• Designed mappings which is used as Maplets in Power center.
• Developed numerous mappings using the various transformations including Address Validator, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge.
• Involved in Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Involved in creating shell scripts and involved in production support.
• Involved in Performance tuning of Informatica mappings, workflows and SQL queries/procedures.
• Worked with testing team in tracking and resolving the defects/Bug fixing and executing Ad-hoc Requests.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 9.5, Informatica IDQ 9.5,Informatica DVO 9.5, Oracle 11g, SQL Server 2010 PL/SQL, Cognos Report Studio, Cognos framework manager, Linux server, Unix shell scripting, Assembla, Service Now, Skybot, Putty

Confidential - Cincinnati, OH

Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• C reated reference tables in Oracle 11g and used it as database dictionaries
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensive work experience with Database programming in Oracle 12c/11g using PL/SQL
• Migration of data from Oracle 11g to Oracle Exadata
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.
• Used Hierarchy tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles.
• Created roles, users for roles, and assigned privileges to roles using Security Access Manager.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Deployment Group using Repository Manager.
• Using the RDBMS concepts on the data for different user specified functions.
• Worked on different data sources such as Oracle, SQL Server, Flat files, XML files etc.
• Performed import and export of metadata and promote incremental changes between environments from development to testing phase.
• Handled very complex requirements and scenarios subjected to the XSD with repeated
• Performed single/cross table structure profiling and drill down the data with IDE.
• Created rules with Informatica Analyst and generated score cards.
• Maintained data matching logic and Address Doctor dictionaries.
• Created Rules on profiled data and used the same to data quality mappings.
• Provided reports for data matching on pattern analysis and provide insight to data quality errors.

Environment: Informatica Power Center 9.6/9.5, Informatica Developer 9.6/9.5,Oracle 11g, Oracle 12c, DB2,Business Objects, DB2, SQL, Hadoop, Erwin 4.0, UNIX-AIX, XML, Web Services, UNIX shell programming.

Confidential

Informatica Developer

Responsibilities:

• Involved in analyzing and development of the Client Data Warehouse
• Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer
• Created various mappings using Aggregate, Filter, Join, Expression, Lookup, Update Strategy and Router.
• Extensively used ETL to load data from different databases and flat files to Oracle
• Involved in the development of Informatica mappings and tuned them for better performance.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Worked with sessions and batches using Server Manager to load data into the target database.
• Testing for Data Integrity and Consistency post load

Environment: Informatica Power Center 8.1, Oracle 8i, SQL, Windows 98/2000, Shell scripts