PROFESSIONAL SUMMARY:

• Over 11 years of focused IT industry experience in Data Modeling, Database Development and Data Warehousing, including development, implementation and testing database and data warehouse applications.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Proficient in all phases of the Software development lifecycle, including requirements definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse.
• Experience in Informatica Power Center 10.4/10.1/9.6/9.1/8.6 .1 - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Experience wif Relational and Dimensional Modeling. Created Star and snow flake models for Data warehousing application.
• Experience wif development and maintenance of Informatica mappings, workflows and other tasks, experience in creating reusable objects.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Excellent capabilities in integration mappings including dynamic cache lookup, shared, and persistence mappings for Type I, Type II, Type III slowly changing dimensions.
• Experience in implementing update strategies, incremental loads and change Data capture.
• Experience in using SQL, PL/SQL and TOAD.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in different databases.
• Experience in database development skills using Oracle PL/SQL to write stored procedures and functions.
• Expertise in implementation of MD5 functionality.
• Experience in OLAP tools such as Business Objects, Crystal Reports, Oracle Business Intelligence (Designer and Reporter).
• Experience in designing data model for fulfilling the business requirement in the best manner.
• Experience in analyzing the business requirement and suggesting best possible solutions for give constraints.
• Experience in performance tuning for give scenario.
• Worked wifin SLA and 24/7 environments, excellent communication skills and capable of working in a group or at an individual capacity, hardworking and very fast learner.
• Having excellent customer service skills. Interactive wif various vendors for support and troubleshooting.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.4/10.1/9.6/9.1/8.6

Data Modeling: Erwin 7.2, ER Model, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Logical and Physical Modeling

Databases: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2005/2000, XML, flat files

Data Replication Tools: Informatica Data Replication Tool 9.1/9.5

Operating Systems: Solaris 9, 10, Red hat Linux 8, 9, Windows NT / XP/ 2000/2003/7/8/10

Programming Languages: Shell Scripting, SQL, PL/SQL

DB Tools: SQL plus, TOAD, Autosys, CRONTAB

Defect Tracking Tool: Test director, Helpzilla, HP Quality Centre

Designing tools: Visio, Microsoft PowerPoint

Agile Methodologies: Rally, Jira

Scheduler: Tidal Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Team Lead/Sr. Informatica Developer

Responsibilities:

• Analyzing business requirements, specifications and functional requirements.
• Understand the business needs and accommodate the requests wif the existing functionality.
• Design ETL architecture to make sure, it fits well wif the existing system for better improved process.
• Extracted data from Kafka platform as source and loaded data into database using Informatica.
• Preparing Functional documents based on all the metrics/measurements.
• Preparing technical documents corresponds to functional documents for all metrics.
• Work wif business users and business analysts to design, develop, deploy and validate the proposed plan.
• List out the identified issues wif the existing architecture, and provide suggestions to improve the process wif future enhancements.
• Always improve the process to improve the performance and improve the productivity of the tool.
• Perform the data modelling to adopt the enhancements as per the needs from business.
• Plan list of requirements part of monthly release based on criticality for IT team.
• Always plan on improving the process to optimize the quality output of the team.
• Revise functional documents in case of new requirement comes in between the development.
• Review and guide team to cover all the scenarios required to test the functionality of the code.
• Improvising the code by rewriting the existing code in much simpler way.
• Work wif business users to resolve the issues identified in production.
• Performed job scheduling for required jobs.
• Work closely wif users for any adhoc issue/challenges encountered in the tool and to have a fix in-place.
• Analyze the root cause of the issues and work wif teams to achieve the solution as per user expectations.
• Support team members internally as required to resolve any critical/complicated issues identified.
• Review and perform tasks related to both development and operational tasks in the project.
• Operation support to submit the metrics to Quest Forum for continuity

Environment: Informatica Power Center 10.2/10.1/9.6.1, Flat File, Oracle 12c/11g, Kafka, SQL*Loader, AIX UNIX 5.3, MS Office, Toad, SQL developer, OBIEE 11g/12c, Control-M, Test Scheduler

Confidential

Informatica CDC consultant

Responsibilities:

• Understand the business and functional requirements for the issue raised according to EDW Standards.
• Involved in all phases of software development lifecycle including requirements definition, Analysis, design, implementation, performance tuning, testing and support.
• Created Technical and Functional design documents for all development activities to follow the EDW Standards and follow Business Standards.
• Developed the execution steps to implement in prod env for client.
• Created/fixed mappings and transformations according to specifications using Informatica.
• Involved in performance tuning for the mappings in existing mappings and newly developed Mapping before moving to Production.
• Worked wif Mapplets, Reusable transformations and Worklets.
• Configured registration and extraction data maps in informatica Power Exchange and used them as part of informatica power Centre mappings for data extractions.
• Created data flow from source oracle database to target sql server database using Power exchange and informatica Power Centre tools.
• Involved in identifying the root cause of the issues and fixing them wif most appropriate methodologies.
• Involved in deployment of code and preparing the documentation for identified issues.
• Design the unit test script documents and perform unit testing on the mappings after development.
• Validating the developed code for bug free release.

Environment: Informatica Power Center 9.6.1, Informatica Power Exchange for Oracle CDC, Flat File, Oracle 12g/11g, SQL*Loader, AIX UNIX 5.3, MS Office, Toad, SQL developer, Tablue 9.3.

Confidential, Owings Mills, MD

Sr. ETL Developer

Responsibilities:

• Gather business requirements and prepare functional specifications.
• Engage in all phases of software development lifecycle including requirements definition, analysis, design, implementation, performance tuning, testing and support;
• Design mapping documents for Dimensions and Fact tables;
• Create mappings and transformations according to specifications using Informatica;
• Engage in performance tuning on sources, targets, mappings, sessions and SQL queries in the transformations to improve the daily load performance;
• Work wif Mapplets, Reusable transformations and Worklets;
• Design and develop complex Aggregate, Join, Router, look up and update strategy transformation based on business rules;
• Design the unit test script documents and perform unit testing on the mappings after development.
• Create View and Image tables.
• Use the Toad application to validate queries and test the data.
• Work wif the Cognos team to implement the changes and fix any bugs in the system.

Environment: Informatica 9.5, Oracle 11g, Sql Developer, MS Office, WinSCP.

Confidential

Sr. ETL Developer

Responsibilities:

• Obtained list of mappings/sessions dat need to be implemented for new MD50s (Business requirement documents).
• Modified existing mappings to enhance the design logic as per new MD50s.
• Updated MD70 to add new features for existing design documents.
• Validated the logics and implemented the logics as per business requirement documents.
• Tuned mappings for improving the performance because of additional code changes.
• Updated the testing results to testing team and got approvals to migrate to prod for migration.
• Supported for code migration and production support for the new code release.

Environment: Informatica 9.5, Oracle 11g, Sql Developer, MS Office, WinSCP.

Confidential, Carlsbad, CA

Sr. ETL Developer

Responsibilities:

• Obtained list of mappings/sessions dat need to be implemented for incremental/MD5/truncate-reload tables on daily basis.
• Fixed the mappings/sessions to accommodate logic for incremental/truncate-reload tables.
• Modified table definitions to capture the incremental data based on insert date and update date.
• For the tables wif very high volume of records and wif no update date from source system, implemented MD5 functionality.
• Created stored procedures to load data from staging tables to target tables for tables wif MD5 functionality.
• Defined parameter variables to control the load volume from source data.
• Modified session properties to accommodate various load types: insert and update/only insert/only update for target tables.
• Validated the session level dependencies for all Worklets and workflows across all the layers to make sure it does not impact the existing data flow and have better sequence to reduce the load time.
• Involved in scheduling workflow and defining workflow dependencies across all the layers.
• Fixed the mapping logic to update the existing business logic to accommodate appropriate logic.
• Involved in unit testing for all the mapping those have been created/altered as part of development.

Environment: Informatica 9.5, Oracle 11g, Sql Developer, MS Office, WinSCP.

Confidential, Palo Alto CA

Sr. ETL Developer/IDR Developer

Responsibilities:

• Identify list of tables to consider for Data replication.
• Identify list of workflows corresponding to the list of tables.
• Highlight list of tables dat can be drop from production.
• Categorize list of table under incremental vs truncate/reload vs drop/create.
• Address the change in code required from source teams for IDR implementation and also the explanation of impact analysis.
• Understand the business requirement and suggest the best approach for IDR implementation to have the best performance of the tool.
• Built the configurations for incremental vs truncate reloads.
• Created sessions in power center to start jobs related to IDR.
• Validate the data for all the tables end to end.
• Responsible to validate the test results fix the failures.
• Production support for the code.
• Integrated IDR application in Informatica Power Centre to control the jobs directly through scheduling tool.
• Checked wif Informatica support team for best performance.
• Addressed the improvement in performance by using IDR vs Data Pump.
• Implemented IDR successfully by improving the performance by two-thirds of Data Pump.
• Upgraded IDR servers from 9.1 to 9.5 and the EBFs dat were required to improve the tool productivity.

Environment: Informatica 8.6/9.1, Oracle 10g/11g, SQL*Loader, TOAD, MS Office, Informatica Data Replication 9.1/9.5

Confidential, San Jose CA

Analyst/Sr. ETL Developer

Responsibilities:

• Responsible to understand the business requirement and to develop the required metrics at the fact layer.
• Responsible to understand the source data and to add the mandatory attributes for metrics calculation.
• Introduced new dimension tables dat are required for the metrics calculations.
• Responsible in creating Functional specification document to project the high level data mapping to the project.
• Responsible to implement the logic for the existing fact wifout impacting the exiting data flow.
• Responsible to give permissions to business to alter the values for a set of attributes using Excel utility tool.
• Responsible for building a complex ETL logic using informatica to populate the results of the products performance at its lowest grain.
• Responsible for testing and regression testing to identify and resolve any issues in the data load.
• Responsible to migrate the code from dev to stage.
• Responsible for getting approvals for the complete development and to migrate the code from stage to production.
• Involved in team meetings wif business to give demo on the results of the development.
• Involved in team meeting to understand the process to migrate the code from stage to production for the project release.
• Responsible to migrate the code from stage to prod using the Kintana migration tool.
• Responsible to create a task dat includes the required session and dependent uproc for the newly created job.
• Responsible to complete the technical design document for the complete project and to responsible for the transition to the support team.
• Responsible for setting the dependencies for newly created jobs at session level in $Universe Tool.
• Responsible for automating the jobs to run at scheduled intervals using Reflection-X tool.
• Involved in weekly meeting wif offshore to discuss the traceability of the project status.
• Involved in production support to ensure, the results are populated as expected and to get signoff for the project completion.

Environment: Informatica 8.6, Oracle 10g, SQL*Loader, TOAD, MS Office HP Quality Centre, Oracle Business Intelligence.

Responsibilities:

• Involved in team meeting to have better understanding on both the source tables and the target tables.
• Identified all the mandatory attributes dat need to be populated in the QDI target tables.
• Identified the attributes from source system dat can be mapped to the mandatory attributes.
• Scheduled meetings wif the source team to understand the relation between the tables.
• Wif the help of source SAP team, was able to identify the appropriate attributes dat can be mapped to the tables from QDI.
• Identified and highlighted the gaps between the two systems.
• Updated the impact analysis for the identified gaps.
• Created mapping document wif the identified mandatory attributes for the required tables from QDI.

Environment: Informatica 8.6, Oracle 10g, SQL*Loader, TOAD, MS Office HP Quality Centre, Oracle Business Intelligence.

Confidential, Reston, VA

Sr. ETL Developer

Responsibilities:

• Responsible in loading sample data from various source systems to oracle DB. dat includes flat files, and xml files.
• Responsible to update the issues wif the sample data to HP to have the vendor fix.
• Implemented change data capture dimensions for various subject area files using reusable Mapplets.
• Involved in defect calls to analyze and assign the defects to appropriate teams.
• Involved in implementing shell scripting to improve the performance of the workflow.
• Responsible for end to end execution in stream 4 in dev and SIT.
• Responsible for implementing the code fixes in dev and migrating the code to SIT and re-execution to close the defect.
• Created Reusable Transformations and Mapplets in the designer using transformation developer and Mapplets designer according to the business requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Responsible for code migration from Dev to Sit and responsible in executing the workflows in resolve the identified issues.
• Responsible for auditing the source files been used in various levels of execution.
• Responsible for unit testing before testing wif actual data.
• Involved in onshore offshore calls to have end to end traceability of the given tasks.
• Responsible in implementing end to end execution wif offshore team.
• Responsible to interact wif vendor to analyze the source files and request for the required fix.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
• Used extensively in Functionality and Logic testing for all Mappings used in populating the Data Layer.

Environment: Informatica 9.1, Flat Files, Oracle 11g, XML files, SQL*Loader, TOAD, AIX UNIX 5.3, MS Office HP Quality Centre, Micro strategy

Confidential, Santa Clara, CA

ETL Developer/Computer programmer

Responsibilities:

• Worked wif Business Analyst to gather business requirements and involved in weekly team meetings.
• Data Quality Analysis to determine cleansing requirements. Responsible for the data cleansing of the source data.
• Responsible for solving complex data design and data retrieval/integration issues. Analyzing the data model and Identification of heterogeneous data sources.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Involved in gathering data using power exchange.
• Created Reusable Transformations and Mapplets in the designer using transformation developer and mapplet designer according to the business requirements.
• Improved Performance by tuning SQL Queries at mapping levels. Tuned performance by changing index and data cache sizes, DTM buffer size and target based commit intervals.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• As per the requirement of the business users to manage change data capture, implemented Slowly Changing Dimensions type I and type II.
• Designed and created test cases for Unit testing for job validations. Also was in support team for the UAT and soft launch phases.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers using FTP.

Environment: Informatica Power Center 8.6, Flat File, Oracle 10g, SQL, SQL*Loader, TOAD, AIX UNIX 5.3, XML, Autosys, MS Office.

Confidential, Springfield, MA

ETL Developer/Production (Support) Engineer

Responsibilities:

• Involved in Dimensional modeling of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed number of complex Informatica mappings, Mapplets, and reusable transformations to implement the business logic and to load the data incrementally.
• Worked on performance tuning of SQL and mappings by usage of SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations.
• As per the requirement of the business users to manage change data capture, implemented Slowly Changing Dimensions type I and type II.
• Worked wif Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed the bugs.
• Used Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run.
• Troubleshoot workflows and sessions for daily and monthly extracts from various data sources across all platforms to the target database.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Wrote various shell scripts for pre-processing of data and scheduling of jobs.
• Worked on Test Director for Unit and Integration testing.

Environment: Informatica Power Center 8.0/7.1.1, ERwin 7.2, Oracle 10g, SQL, TOAD, AIX UNIX 5.1, Autosys, Test Director 7.2, MS Office.

Confidential, Austin TX

Business Analyst/ ETL Developer

Responsibilities:

• Involved in various meetings wif business clients and DBA(s) for better understanding of business requirements.
• Designed and developed Informatica mappings for data loads using various transformations like Aggregator, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables, Session Partitioning and lookup Cache size.
• Performed change data capture process using Type I and Type II implementations.
• Developed Mapplets and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Studied Session Log files to find errors in mappings and sessions.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data
• Worked on Balance and Control mechanism as a part of error handling and data validation processes.
• Developed PL/SQL procedures to implement business logic, involved in query performance tuning and Informatica ETL tuning.
• Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
• Performed code reviews and handled change request.

Environment: Informatica Power Center 8.6, Oracle10g, SQL Server 2000, AIX UNIX 5.1, Business Objects 6.5.