SUMMARY

• Skilled detailed oriented Informatica Data Warehouse Developer with comprehensive understanding of all aspects of data modeling, Informatica PowerCenter and Informatica Cloud.
• Results oriented team player with comprehensive technical, written, communicational and analytical skills, with critical industry knowledge and technical capabilities, ability to provide fast and efficient support where needed to ensure end users remain productive and operations run smoothly, with strong understanding of SDLC (Software Development Life Cycle).
• 12+ years of IT experience in analyzing, designing, developing, implementing, testing of data warehousing and data integration solutions using Informatica PowerCenter, Oracle, SQL Server, Netezza, and Sun Solaris.
• 5+ years of hands - on in developing ETL (Extract Transform Load) processes and performance tuning involving source level, target level and mapping level bottle necks in PowerCenter.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• 4+ years of extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Excellent Experience withdifferent indexes (PI, SI, JI, PPI and Collect Statistics.
• 2+ years of Data modeling experience to build Data Mart using Erwin.
• 10+ years of proficient experience in writing complex SQL, PL/SQL, store procedure and Unix shell scripting.
• 7+ years of progressive participation in job monitoring on call rotation scheduling of multiple technology integrated environments (Informatica, Oracle, Unix, Netezza), and using reporting tool Cognos.
• Deep understanding of relational database design and dimensional modeling concepts and their respective maintenance.
• Strong conceptual knowledge of Business Intelligence and Data Warehouse.
• Extensive work in monitoring production inquiries and issues to ensure efficient resolutions.
• Supervision of development teams to manage data resources and data storage options.
• Independently performed complex troubleshooting, root cause analysis and solution development.
• Managed a team in a high-pressure work environment.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Informatica ETL Developer (PowerCenter/Cloud)

Responsibilities:

• Involvement in all phases of SDLC, including requirements gathering, design, development, testing, user training, and support for production environment.
• Used Informatica PowerCenter and Informatica Cloud for extraction, transformation and loading data from heterogeneous source systems (Flat files, XML, Oracle, Teradata and Salesforce) into targets (Oracle, Teradata and Flat files ).
• Configured reusable transformations, mapplets, tasks, and worklets during mapping and workflow design.
• Used multiple PowerCenter transformations including source qualifier, expression, sorter, aggregator, joiner, filter, lookup, sequence generator, stored procedure, JAVA, transaction control, Target (table and flat file), Input and Output to accomplish teh mapping design process.
• Extensive use of connected and unconnected lookups using different types of caches to improve performance of lookup transformations.
• Designed mappings to implement business logic and capturing deleted and updated records in source systems by using router, MD5 function and update strategy transformations.
• UsedTeradata utilities fastload, multiload, tpumpto load data
• Wrote BTEQ scripts to transform data
• Worked on Fastexport scripts to export data WroteTeradata Macrosand used various Teradataanalytic functions.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle and migrated those toTeradata.
• Created Unix Shell scripts for automating Workflows, Worklets, batch processing, and sessions schedule using PMCMD.
• Performed sync processes at source systems (SIEBEL, TBS, SINGLEVIEW) and target (Instore) in mapping and database level.
• Building Data Marts for SIEBEL (Customer), TBS (Provisioning), and SINGLEVIEW (Billing) by using Erwin.
• Wrote complex SQL queries, DDL, DML scripts for data retrieval and analysis.
• Implemented tuning logic on targets, sources, mappings, and sessions to provide maximum efficiency and performance.
• Worked on call rotation schedule supporting production inquiries and issues to ensure efficient resolutions.
• Produced, updated, and maintained ETL technical and operational documentation.

Confidential, Plano, TX

Data Modeler

Responsibilities:

• Collaborate with data architect to Create a relational model and dimensional model for XO SALES Data Mart.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user.
• Collaborate with BI teams to create reporting data structures.
• Produce Technical documentation

Confidential, Plano, TX

Cognos Developer

Responsibilities:

• Accomplish migration of all Brio and Business Objects reports over to Cognos8 Report Studio.
• Proactively assist across data marts and EBI platforms as needed. Support EBI managers by providing timely status updates and constructive feedback.
• Moving Cognos Objects components from dev to test, and finally from test to prod.
• Work as a backup Cognos admin
• Produce, update, and maintain Cognos technical and operational documentation.

Confidential, Plano, TX

Informatica Production Support

Responsibilities:

• Support daily, weekly and monthly production data load into Enterprise Data Warehouse.
• Monitor/troubleshoot processing of all nightly Production Infostore load scripts and Informatica load sessions.
• Participate as an integral part of operation and development team to manage data resources and data storage options including tables, tablespace, partitions, materialized views, indexes, stored procedures, temp or staging tables for better system performance. Manage database security for dev and test environments by creating different users granting appropriate privileges and roles.
• Create Unix Shell scripts for automating Workflows, Worklets, batch processing, and sessions schedule using PMCMD.
• Perform sync processes at source systems and target systems in mapping and database level.
• Moving Informatica components from dev to test, and finally from test to prod.
• Convert some of teh Informatica load processes into Materialized Views.
• Write complex SQL queries, DDL, DML scripts for data retrieval and analysis.
• Develop Unix shell scripts to process teh files on daily basis, including renaming teh file, extracting data from teh file, unzipping and deleting files, and removing teh junk characters from teh file before loading into teh base tables.
• Managed database security for dev and test environments by creating different users granting appropriate privileges and roles.
• Participated as an integral part of development team to manage data resources and data storage options including tables, tablespace, partitions, materialized views, indexes, stored procedures, temp or staging tables for better system performance.
• Help in Implementing tuning logic on targets, sources, mappings, and sessions to provide maximum efficiency and performance for new contractors.
• Work on call rotation schedule supporting production inquiries and issues to ensure efficient resolutions.

Environment: Informatica (7.1.3/8.6.1/9.6.1/10.2 ), Informatica Cloud, Erwin R 8.0/7.3, Sun Solaris (10/11), Oracle (8/8i/9/10G/11), Cognos (8.4), SQL Server (9.0/10.25/10.50/11.0/12.0/13.0/14.0 ), Teradata (12, 13, 13.10, 14), Netezza (1/2).