SUMMARY:

• A senior Informatica developer/lead with very strong professional background in Data warehouse domain and over 11+ years of industry experience in the software engineering, processes and methodologies, and management
• Expertise and working experience in establishing the process, methodology standards at all phases of an Enterprise Data warehouse.
• Extensive experience in the areas of Systems Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools, conducting testing and validations, conducting user, documentation and Production Support.
• Very strong analytical, technical and business skills in architecting and designing using ETL applications.
• Technical leadership, mentoring and managing designers, developers and development teams.
• Good exposure in Data Cleansing, Transformation, Data import, Data export and use of Teradata.
• Dimensional Data Modeling experience using Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling, ERWIN and SQL Power Architect.
• Experience in planning and executing Informatica upgrade process, designing and supporting mult - node/grid environment.

TECHNICAL EXPERTISE:

Data Warehousing Dimensional Data Modeling Reporting Tools UNIX Databases Domain Skills Scheduling Tool SSLM/ALM Tool : Informatica PowerCenter (7.1.2/1.3/1.4 , 8.0/8.1.0/8.1.1 , 9.0.1/9.5/9.6 ), Informatica WebServices, Informatica Data Quality (IDQ), Hadoop framework, HIVE, PIG, SQOOP : Dimensional Data Modeling experience using Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling, ERWIN and SQL Power Architect: QlikView, MS Excel: C Shell, K Shell, Bourne Shell, VI : Teradata, Teradata Loads (Fastload, Mload, TPump), Oracle 9i, 10i, 11i, PL/SQL, MS SQL Server 2008R2, Sybase, DB2, Informix: Pharma, Insurance, Finance

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Lead

Responsibilities:

• Introduced QC automation process to eliminate manual data QC. This reduced the 2 days QC effort to 4 hours and helped client utilize the resources in other analytical activities.
• Engagement with highly designated clients (Directors, Senior Managers).
• Designing the backend data model and frontend to improve the performance of the dashboard .
• Assessed requirement and prepared project timeline for enhancements to the dashboard.
• Consulting between Business and Technology teams from different vendors and fill the gaps.
• Conducted impact assessment and determine size of effort based on requirements.
• Helped team during design and code implementation for enhancements.
• Managed the monthly release cycle of the dashboard with zero data defect.

Environment: Informatica PowerCenter 9.6.0, Teradata, QlikView

Confidential

ETL Lead

Responsibilities:

• Worked closely with the PM to develop and update the task plan for ETL work, to keep the manager aware of any critical task issues and dependencies on other teams, and ensure that the end-to-end designs meet the business and data requirements
• Assessed requirements for completeness and accuracy and determine if requirements are actionable for ETL team.
• Identified, recommended and implemented ETL process and architecture improvements.
• Designed the data model for data mart.
• Conducted impact assessment and determine size of effort based on requirements.
• Established best practice and standard for ETL process documents.
• Designed ETL architecture and source to target documents.
• Defined and implemented ETL development standards and procedures.
• Designed deployment strategy and deployment template.
• Performance tuning and optimizing the mappings reading and writing huge data volume through Push Down Optimization .
• Implement automation, audit and alert strategies throughout ETL processes.
• Analyzed all errors generated by Informatica and fixed those errors in data collection.
• Reviewed ETL process detail design from ETL Developer.
• Performed code migration of mappings and workflows from Development to Test and Production Servers through deployment groups for DEV, TEST and PROD repositories in retaining shortcuts, dependencies with versioning.
• Effectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
• Precisely documented mappings to ETL Technical Specification document for all stages for future .
• Scheduled jobs for running weekly and monthly loads through Autosys.
• Involved in meeting minutes for status reports, updates, any issues for any change procedures to client.

Environment: Informatica PowerCenter 9.6.0, Teradata, UNIX, Autosys

Confidential, Greater Chicago Area, IL

ETL Lead

Responsibilities:

• Prepared the upgrade plan and timeline for product/repository upgrade .
• Performed technical analysis of all the Informatica projects in Dev, QA and PROD environments .
• Designed multi-node/grid environment.
• Worked in co-ordination with DBA and UNIX admin during the upgrade process.
• Performed the domain and repository backup as part of upgrade process.
• Validated all the environment variables before upgrade to 9.6.0.
• Took backup of nodemeta.xml and domains.infa
• Updated environment variables to 9.1 server path
• Performed post installation steps to validate the integration services and upgraded repository.
• Upgrade process was performed in DEV, QA and PROD environments in phased manner.

Confidential

ETL Lead and Senior Developer

Responsibilities:

• Responsible for analyzing the BRS and technology support processes.
• Worked closely with the Business Analyst, to ensure that the end to end designs meet the business and data requirements
• Performed as active, leading role in shaping and enhancing overall ETL Informatica architecture.
• Designed the data model as per the data oriented aspects of the project.
• Performed technical analysis and prepared recommended ETL design approach.
• Established best practice and standard for ETL process documents.
• Designed ETL process and prepare associated document.
• Identified, recommended and implemented ETL process and architecture improvements.
• Designed deployment strategy and deployment template.
• Created templates, ETL process and reusable components.
• Conducted performance tuning and optimized the mappings to reduce run time.
• Helped team to fix the defects rose during the testing phase.
• Used various transformations like Source Qualifier , Expression , Aggregator , Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor .
• Prepared SQL Queries to validate the data in both source and target databases.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.

Environment: Informatica PowerCenter 9.1.0, Teradata, UNIX, Autosys, QlikView

Confidential

ETL Lead and Developer

Responsibilities:

• Created ETL architecture design and documents.
• Created source to target mapping document.
• Coded ETL mapping, session and workflow.
• Imparted on Informatica.
• Performance tuned and optimized the mappings to reduce run time.
• Analyzed all errors generated by Informatica and fixed those errors in data collection.
• Prepared test data files, with both positive and negative testing scenarios.
• Supported UAT testing and defect fix .
• Designed deployment strategy and deployment template.
• Designed restart-ability, error handling and audit throughout ETL processes.
• Created and managed folders, groups and users and administered user and group privileges.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs .

Environment: Informatica PowerCenter 9.1.0, Teradata, UNIX, Java, Autosys, QlikView

Confidential, IOWA

Senior ETL Developer

Responsibilities:

• Providing Comprehensive solutions to Business Requirements by Analyzing requirements.
• Preparing ETL design specification.
• Build and Unit Test of deliverables with quality and without any scheduled variation.
• Coding in adherence to standards.
• Coding with zero defects.
• Implementing the business logic in the mappings and preparing workflows.
• Unit testing the code and documenting and validating the results.
• Performing IUT (Integration Unit Testing), System Testing & Post production activities .
• Providing Analysis & resolution to defects rose (if any) in system testing
• Analyze the system dependency.
• Root cause analysis of the defect.

Environment: Informatica PowerCenter 8.6.0, Teradata, UNIX, Maestro

Confidential

Senior ETL Developer

Responsibilities :

• Lead the Orchestration effort , which was an OEM product with Intalio.
• Also lead the of Informatica ODBC data services driver in 9.0 and 9.0.1.
• Installation and upgrade testing of the Informatica PowerCenter product.
• Applying hot fixes to Informatica PowerCenter during dot releases.
• Worked extensively on Informatica 9.0 Data Services Tool, created various scenarios for SQL data services involving several transformations, applications and performed execution through infacmd command line .
• Automated the Informatica ODBC driver for regression testing and also performed stress testing for the same in 9.0.1.
• Provided Integration test plan to Intalio QA team to improve their build quality before delivery.
• Stayed in constant touch with Intalio QA team to analyze and resolve issues upfront.
• Worked closely with PM on Orchestration integration with PowerCenter.
• Took feature ownership of few components in Web Services during 8.6.0 release:
• Provide performance tuning to ETL components
• Web Services regression run and analysis.
• Managed main releases and SP releases simultaneously.
• Worked in parallel across WS features and Orchestration maintaining timely execution.
• Involved in end user and support.
• Developed Mappings, Transformations and Workflows that address all the core functionalities of the PowerCenter Server 8.5 New features include pipeline lookup; push down optimization and web services.
• Single handedly done the compatibility test of PowerCenter 8.5.1 on Win IA 64 bit and Solaris x86 Systems.
• Responsible for the functional and regression testing of PowerCenter 8.5.
• Involved in the various other development of Testing Strategy and Test Plan.
• Unit Testing, Integration Testing, Performance and Stress Testing.
• Automation of workflow runs, batch and nightly runs using Perl and shell scripts.
• Bug logging and tracking them to closure.
• Responsible for addressing the customer issues and regression testing of the new fixes.
• Drawing data from disparate sources through external loaders and developing reusable transformations that load the data into multiple data warehouses and heterogeneous targets.

Environment: Informatica PowerCenter (9.0,8.x), Informatica Orchestration, WebServices, UNIX, Databases