PROFESSIONAL SUMMARY:

• Over 10 years of IT experience with expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using ETL tools with RDBMS like Oracle, IDQ, MS SQL server, DB2, databases on Windows and UNIX platforms.
• 10+ years of IT industry with substantial experience in providing information management consulting services on Informatica Power Center, Informatica Master Data Management, Data Integration and
• Business Intelligence Applications.
• Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.
• Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Hands on experience on Salesforce Lightning for Customizing Reports and Dashboards for business use. Strong experience with Informatica tools using real - time CDC (change data capture) and MD5.
• Experience in integration of various data sources like Oracle, Teradata, Netezza, Mainframes, SQL server, XML, Flat files and extensive knowledge on Oracle, Teradata, Netezza and MS Access.
• Very strong in Data Warehousing Concepts like Dimensions Type I, II and III, Facts, Surrogate keys, ODS, Staging area, cube also well versed in Ralph Kimball and Bill Inmon Methodologies.
• Realistic understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Superior SQL Skills and ability to write and interpret complex SQL statements and also mentor developers on SQL Optimization.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server and Teradata. Good understanding of Views, Synonyms, Indexes, Partitioning, Database Joins, Stats and Optimization.
• Experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger projects. Heavily created mapplets, user defined functions, reusable transformations, look-ups.
• Expertise in SQL and PL/SQL programming and also excellent in Views, Analytical Functions, Stored
• Procedures, Functions and Triggers.
• Experience in designing and development of Variable Length EBCDIC VSAM Files, Cobol Copybooks using Informatica PowerExchange 9.6/9.1/8.6.
• Technical expertise in designing technical processes by using Internal Modeling & working with Analytical Teams to create design specifications; successfully defined & designed critical ETL processes,
• Extraction Logic, Job Control Audit Tables, Dynamic Generation of Session Parameter File, File Mover Process, etc.
• Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant.
• Deftly executed multi-resource projects following Onsite Offshore model while serving as a Mentor for the Junior Team Members.
• Developed applications to individual client standards.
• Submitted weekly status reports to Application Development Managers.
• Excellent communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.
• Exposure in Waterfall methodologies and Agile methodologies with Scum.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.1, Informatica PowerCenter 9.x/8.x, InformaticaPowerExchange 9.x/8.x, Informatica Cloud, Informatica DataQuality 9.x/8.x,Talend

Databases: Oracle 11g/10g, IBM UD2 DB2, MS SQL Server, MS Access 2000,Teradata 13/12/V2R5, Netezza 9

Programming Languages: C, C++, SQL, PL/SQL, UNIX, XML, Unix Shell Scripts

DB Tools: TOAD, SQL Navigator, SQL* Loader, SQL Management Studio, SQL Assistance,Cloud & SaaS Platforms: Amazon and Google Web Services, Salesforce.com

Mythologies: SDLC, Agile

Others: Salesforce.com, Control M, Erwin 5.1/4.1.2, OBIEE 10g, SQL Loader, MS Office,Smart FTP, Ultra Edit, Autosys, Control-M, HP Quality Center, MS Visio, Erwin9.3, Business Objects 6.0

Operating Systems: Sun Solaris 8.0/10.0, Windows XP/7, AIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Extensively used Informatica Power center, Power Exchange for extracting, transforming and loading data from relational sources and non-relational sources.Extracted data from different sources of databases. Created staging area to cleanse and validate the data.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router in Mappings.

Confidential

Informatica Developer

Responsibilities:

• Worked on complex ETL transformation and jobs including processing data from Salesforce web services.
• Developed Cloud Services tasks (Replication/Synchronization/Mapping Configuration) to load the data into Salesforce (SFDC) Objects.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Scheduled Sessions and Batches on the Informatica Server using Informatica workflow Manager.
• Migrate Informatica objects and Database objects to Integration Environment and schedule using the Control-M.
• Involved in doing Unit Testing, Integration Testing and System Testing.

Environment: Informatica Power Center 10.1, Unix, Oracle 10g/9i, SQL Server 2008, TOAD, Saleforce.com, Service Now, TIDAL

Confidential, San Antonio, TX

Informatica Developer

Responsibilities:

• Responsible for Internal Delivery of ETL code from Architecture /Design/ Development/ Testing and Implementation phases.Created Several Informatics Mappings to populate the data into dimensions and fact tables.
• Involved in the development of Informatica mappings and Mapplets and also tuned them for optimum performance, Dependencies and Batch Design.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Created and monitored workflows and task using Informatica Power Center Workflow Manager.
• Partitioned Informatica mappings using Hash value partition and Round robin partition to improve target load time.
• Uploaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Used Informatica designer for designing mappings and mapplets to extract data from Mainframes, SQL Server and Oracle sources.
• Used Various Transformations like Expression, Filter, Router, Joiner, Look Up, Update strategy, Source Qualifier in many mappings.

Confidential

Informatica Developer

Responsibilities:

• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.

Environment: Informatica PowerCenter 10.1, Business Objects 6.0, Oracle 10g, SQL Loader, PL/SQL, DB2, UNIX Shell Programming, Linux and Windows NT

Confidential, Omaha, NE

Informatica Developer

Responsibilities:

• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator etc.Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse. Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Teradata database
• Extracted the Salesforce CRM information into BI Data Warehouse using Force.com API/Informatica on Demand to provide integration with oracle financial information to perform advanced reporting and analysis.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into Data warehouse.
• Developed transformation logic as per the requirement, mappings and loaded data into respective targets. Used pmcmd command to run workflows from command line interface.
• Responsible for the data management and data cleansing activities using Informatica data quality (IDQ). Performed data quality analysis to validate the input data based on the cleansing rules.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning. Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Used the sandbox for testing to ensure minimum code coverage for the application to be migration.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production. Documented Data Mappings/ Transformations as per the business requirement.
• Created XML, Autosys JIL for the developed workflows.
• Extensively involved in code deployment from Dev to Testing.

Environment: Environment: Informatica PowerCenter 9.8, Informatica PowerExchange 9.84

Confidential, Fort Worth, TX

Informatica Developer

Responsibilities:

• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for the data management and data cleansing activities using Informatica data quality (IDQ). Collaborated with data management team and conducted large data management workshop
• Analyzed, modeled big-data sets and developed conceptual model to handle velocity and variety of big data.
• Developed Shell Scripts for automation, for file validation and for data loading procedures, designed re-usable component and exception handling techniques.
• Manage and address service requests in a timely manner using ITIL concepts around change, incident and problem management
• Actively involved in interacting with business users to record user requirements and Business Analysis. Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project. Worked with slowly changing dimension Type1, Type2, and Type3.
• Maintained Development, Test and Production Mappings, migration using Repository Manager. Involved in enhancements and Maintenance activities of the data warehouse.

Confidential

Informatica Developer

Responsibilities:

• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Utilized Informatica IDQ to complete the initial data profiling and matching/removing duplicate data for the process of data migration from the legacy systems to the target Oracle Database.

Environment: Informatica PowerCenter 9.6.1, Informatica PowerExchange 9.6.1, Informatica DataQuality 9.6.1, Cognos 9.0, AWS EC2, RDS, Amazon Redshift, Sun Solaris, SQL, PL/SQL, Oracle 11g, TOAD, SQL Server 2012, Data Masking option, Autosys, Shell Scripting, XML, SQL Loader

Confidential, Irving

Informatica Developer

Responsibilities:

• Involved in data masking project and developed Informatica mappings to mask production data using data masking transformation and other transformations.Responsible for design and development of Salesforce Data Warehouse migration project leveraging Informatica PowerCenter ETL tool.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator etc.Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse. Performed data integration and lead generation from Informatica cloud into Salesforce cloud.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Teradata database
• Extracted the Salesforce CRM information into BI Data Warehouse using Force.com API/Informatica on Demand to provide integration with oracle financial information to perform advanced reporting and analysis.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into Data warehouse.
• Developed transformation logic as per the requirement, mappings and loaded data into respective targets. Used pmcmd command to run workflows from command line interface.
• Worked with Informatica Cloud Data Loader for Salesforce, for reducing the time taken to import or export critical business information between Salesforce CRM, Force.com.
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Confidential

Informatica Developer

Responsibilities:

• Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
• Used the sandbox for testing to ensure minimum code coverage for the application to be migration.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Improved performance testing in Mapping and the session level.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Coordinated with Autosys team to run Informatica jobs for loading historical data in production. Documented Data Mappings/ Transformations as per the business requirement.
• Created XML, Autosys JIL for the developed workflows.

Environment: Informatica PowerCenter 8.6, Informatica, SQL Server 2008, Oracle 10g, Shell Scripts, Teradata 13, SQL, PL/SQL, UNIX, Toad, SQL Developer, HP Quality Center, Professional Sewxxw

Confidential, San Antonio, TX

Informatica Developer/ Data Analyst

Responsibilities:

• Interacted with business analyst to understand the business requirements. Involved in gathering requirements from business users.Extracted source data using Informatica tools and stored procedures from source systems. Developed transformation logic and designed various complex mappings and mapplets
• Designed various mappings using transformations like Look Up, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• Used Mapplets, parameters and variables to implement object orientation techniques and facilitate the re-usability of code.
• Used Workflow Manager to create and run batches for different applications.
• Developed UNIX scripts as pre/post-session commands to schedule loads, through SQL-loader utility.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping. Involved in Fine-tuning the Informatica code (mapping and sessions)
• Stored Procedures, SQL to obtain optimal performance and throughput.
• Used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.

Environment: Informatica PowerCenter 8.1, Business Objects 6.0, Oracle 10g, SQL Loader, PL/SQL, DB2, UNIX Shell Programming, Linux and Windows NT