SUMMARY

• 11+ years of experience in Information Technology with a strong background in Analyzing, Designing, Developing, Testing and Implementation of Database development in various verticals such as Financial, Automobiles, Sales and Retail.
• Extensive years of experience in design, development and implementation of ETL using Informatica Power Center 9.6.1/9.0.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Data Validation and Administration Console).
• Solid experience in implementing complex business rules by creating re - usable transformations and robust mappings/mapplets using various transformations like Source Qualifier, Filter, Expression, Aggregator, Joiner, Http, XML Generator etc.
• Expertise in Data Warehousing, ETL design and development process using Informatica Power Mart and Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Transformations).
• Strong Data modeling experience using Star/Snowflake schemas, Reengineering, Dimensional Data modeling, Fact & Dimension tables, and Physical & Logical data modeling.
• Experience with Data Extraction, Transformation and Loading (ETL) from different data sources like DB2, Oracle, MS SQL Server, Teradata etc. into a common analytical data model using Informatica Power Center 9.6.1/9.0.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Data Validation and Administration Console).
• Extensive experience with Oracle 11g/10g/9i, DB 2 10.0/8.0/7.0 , SQL Server 2008 and Teradata 13.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, and Transformations & Sessions, developed batch processes and ETL tools to update the accounts.
• Experienced knowledge in STERLING 8.5/9.4 databases.
• Experience in Jenkins/DSL to automate parameterized workflow execution.
• Experienced in using parameter files, mapping parameters, mapping variables and session variables.
• Extensive experience in Creating and maintaining Database Objects like Tables, Views, Indexes, Constraints, Sequence and Synonyms.
• Creating Data Structures i.e. Tables & Views and applying the referential Integrity.
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts and necessary Test plans to ensure the successful execution of the data loading processes.
• Thorough experience in integration of various data sources like Oracle, DB2, SQL Server and MS Access and worked on integrating data from flat files and XML files.
• Expertise in ILM (Data Masking, Data Subset and Data Archive).
• Strong experience in Oracle database Performance Tuning and extensive experience in SQL * Loader Imports/Exports.
• Extensively worked on UNIX shell scripts that are used in scheduling Informatica pre/post session operations, increasing cache size, database administrations and database connections.
• Expertise in error handling, debugging and problem fixing in Informatica.
• Experience in Production Support and Knowledge transfer to the users.
• Experience in loading data, troubleshooting, debugging mappings, tuning mappings, etc.
• Experience with Mainframe Technologies COBOL, PL1, JCL, VSAM, DB2, IMS-DB, Changeman, Xpediter, MQ.
• Experienced with Languages C, COBOL and PL/SQL.
• Strong understanding of Performance tuning in Informatica and Databases. Worked with Oracle and SQL Server Indexes, and experienced in loading data into Data Warehouse/Data Marts using Informatica.

TECHNICAL SKILLSData Warehousing:  Informatica Power Center 9.x (Designer, Workflow Manager, Workflow, Monitor, Administration Console)

Languages:  SQL, JCL, COBOL, PL/I, EasyTrieve, UNIX Shell Scripting, C

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, DB2, Flat Files, Teradata

DB Tools; Oracle SQL Developer, Teradata SQL Assistant, AQT (Advanced Query Tool v10), SQL Station:

Other Tools; Jenkins/DSL, WinSCP, ILM (Data Masking, Data Subset and Data Archive):

Operating Systems; Windows 7/Vista/Server 2003/XP/2000/9x/NT/DOS, UNIX:

Applications:  MS Project, Word, Excel, PowerPoint, VisioPROFESSIONAL EXPERIENCE

Sr. TDM/ ETL Informatica Developer/Lead

• Data compare utility to mine data scenarios across multiple systems/database as DB2 (zOS and UDB), Oracle and Sybase.
• Create Gold Copy for Sterling, Genesis, Siebel, DMS, Lowes.com using Informatica ILM/TDM 9.6 and PC 9.6.1
• Identifying possible items for usage and reporting their condition in all required systems for end to end testing.
• Enhance previously created Sterling ROM (masked/sub-set data copy) to add capability to save.
• Inject test store and test location setups for Sterling using Informatica HTTP call to API Tester.
• Build ROM sub-setting based on synchronized data captured from Mainframe/DB2 and Genesis store test systems.
• Enable ability to keep ROM healthy by providing ability to incrementally update as required.
• Help automate and streamline test data provisioning using Jenkins/Unix Scripting.
• Orchestrate between QA Automation, Engineering, Development, etc.
• Working closely with other functional team to provide test data as per requirements/scenarios.
• Triage trouble and incident tickets and track them to closure on JIRA.

Environment: STERLING/YANTRA (IBM Product for Retail Order Management), Databases (DB2/zOS, DB2/UDB and Oracle), Informatica PowerCenter/ETL, ILM-TDM (PII/PCI Data Masking and Data Subset), Others (COBOL, JCL, VSAM, MQ, FileAid, C, Unix, Jenkins/DSL, PuTTY, WinSCP etc.)

Sr. ETL Informatica Developer

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Coordinated offshore and onsite team with a total of 10 ETL developers.
• Developed technical specifications of the ETL process flow.
• Designed the Source - Target mappings and design the Selection Criteria document.
• Extensively used ETL to load data from Flat files, SQL Server and Teradata.
• Used Informatica Power Center 9x to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (Oracle, DB2, Teradata, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Http, and XML Generator.
• Upgrade Informatica from version 9.1 to 9.6.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Performance/Query tuning.
• Generation/interpretation of explain plans and tuning SQL to improve performance.
• Scheduled various daily and monthly ETL loads using Mainframe ESP.
• Write UNIX shell scripts and Jenkins/DSL to run and schedule batch jobs.
• Data Masking and Data Subset using Informatica ILM-TDM.
• Unit testing and documentation of the ETL process.

Environment: Informatica Power Center 9.x, ILM-TDM, Oracle, Teradata, DB2, UNIX, Windows, UNIX Shell

ETL Informatica Analyst/Developer

Roles and Responsibilities:

• Design mapping documents, which include details of field-to-field mapping between sources and target, Business (Transformation) Rules, Processing flow and details of sessions, pre-dependencies, post-dependencies, and exception error processing methodology.
• Designed and developed complex mappings to load the Historical and Weekly data from different source systems.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Maintained existing mappings by resolving performance issues.
• Used Informatica Repository Manager to maintain all the repositories of various applications.
• Used slowly changing dimensions.
• Imported and Created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Created Mapplets using Mapplet Designer to reuse Mapplets in the mappings; Mapping Parameters and Mapping Variables to use globally.
• Fine-tuned Transformations and mappings for better performance.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, lookup, stored procedure, sequence generator and joiner.
• Monitoring the Data Quality, Integrated Data Quality (IDQ) routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Administrated Informatica server ran Sessions and Batches.
• Developed shell scripts for automation of Informatica session loads.
• Performance tuning of Informatica servers.
• Created Data Flow Diagrams using Microsoft Visio to depict the flow of the Mappings.
• Developing Mappings as per the design document with proper naming conventions for transformations and Mapping variables.
• Handling CA-7 job scheduling.
• Migrating from development to QA and then to production.

Environment: Informatica Power Center 9.x, Oracle 10g, UNIX, CA-7(Scheduler)

Informatica Developer

Roles and Responsibilities:

• Met with business/user/developer groups to understand the business/data needs and gather requirements.
• Extracted and analyzed the sample data from source systems to validate the user requirements. Created high level design documents and process flow document.
• Participated in data model (Logical/Physical) discussions with Data Modelers.
• Did data profiling and analyzed data from vantage side.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked expensively on Conditional components and project parameters.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Sorter and Sequence Generator transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Created Indexes, Partitioned the tables better query performance.
• Developed Various Procedures, Functions & Packages in PL/SQL.
• Prepared Unit and Integration testing plans. Unit and Integration testing using the testing plans. UAT with user groups.
• After implementation support, user training and data models walkthroughs with developer/user groups.

Environment: Informatica Power Center 9.0.1, Oracle 10g, UNIX, CA-7(Scheduler)

Confidential

Informatica Developer

Roles and Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Developed Source to Target Mappings using Informatica Power Center Designer to load data from various source systems like Oracle and Flat files to target database, implementing the business rules.
• Extensively used stored procedures and also worked with parallel processing.
• Created shared folders, local and global shortcuts to reuse metadata.
• Designed and developed UNIX scripts to load tables and also for scheduling the jobs.
• Data Quality Analysis to determine cleansing requirements.
• Designed and developed Informatica mappings for data loads.
• Code review and Unit testing of Jobs.
• Strictly followed the change control methodologies while deploying the code from DEV to QA and Production.
• Using CA7 Scheduler to Schedule the Jobs.

Environment: Informatica Power Center 9.0.1, Oracle 10g, UNIX.

Sr. Mainframe Developer/Lead

Roles and Responsibilities:

• Requirement Analysis, Review, Planning and Effort Estimation.
• Preparing Technical Designs.
• Worked expensively on Conditional components and project parameters.
• Implementation through Programs using JCL, PROC, COBOL, DB2 SQL, IMS-DB, VSAM etc.
• Application Maintenance and Support tasks for Mainframe Applications.
• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Key team member in planning and coordinating the development and testing of the product, development on COBOL, IMS-DB.
• Very complex application, delivered most responsibly on time even with new developers.
• Implemented the plan for the rollover of this project to production.
• Providing the level-3 Production Support by recreating and debugging the prod issues
• Analyzing the issues that arises in the Production Environment
• Reporting metrics and participation in status meetings within the Team and with the Customer
• Carrying out preventive and scheduled maintenance activities pro-actively to ensure high availability.
• Recommending solutions and document findings.
• Change request estimation preparation, deployment and post deployment support
• Performance tuning of programs and SQL queries. Scheduling of jobs using ESP.
• Addressing calls related to Problems / Abends in Production jobs.
• Analyzing the programs of the System/Sub-system in order to answer the queries raised by the Business community.
• Communicating with Business Partners for understanding the problem and clarifying their queries.
• Conducting technical training on JCL, COBOL, DB2, VSAM, etc.
• Providing engagement overview to the new joiners with a training plan.
• SCM-coordinator - As an SCM coordinator was responsible for all project quality management and facing internal quality audits
• Has expertise in mainframe tools like File Aid, Changeman, Xpediter, Comparex

Environment: IBM Mainframe, COBOL, PL1, EasyTrieve, FOCUS, DB2, IMS-DB, JCL, VSAM, FileAid, OPC, Changeman, Xpeditor, MQ, FileAid, Spufi