OBJECTIVE

A professional management consultant with an excellent track record of providing value to clients through technology enabled business transformation. Experienced in BI Tools Informatica, Data Stage and Knowledge in Reporting Tools Micro Strategy and Business Objects.

SUMMARY

• Over 12 years experience in the software application industry.
• Certified Informatica Developer having 12+ years of experience in Informatica 10.1.2/9.5.1/9.1/8.6/8.1.1/7.1.1/6.1 and knowledge in OLAP tools like Micro strategy and Business Objects.
• Extensively used ETL methodology for 12+ years for designing and supporting Data Extraction, transformation and loading processes, in a corporate - wide-ETL Solution using Informatica (Power Mart/ Center 10.1.2/9.5.1/9.1/8.6/8.1.1/7.1.1/6.1- Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Extensive experience in Requirement Analysis, Requirement gathering, Functional Analysis, System Design, Process flow, Workflow, Software Development Life Cycle(SDLC), System Testing, Agile development, Bug fixing, Documentation, Implementation, Production Support and Maintenance.
• Experienced in developing complex business rules through Informatica transformations, Workflows/Worklets, Mappings/Mapplets, Test Plans, Test Strategies and Test Cases for Data Warehousing projects.
• Expertise in Data Warehouse Architecture, Technology and Dimensional Data Modeling.
• Extensively worked with Informatica Developer IDQ in cleaning and formatting customer master data.
• Experience in migration of code from different Environment: Dev to UAT/QA for testing. Comfortable in writing complex ETL code.
• Extensively worked with Informatica objects using Push down Optimization.
• Involved in Unit testing, System testing while moving the code from development to production.
• Experience in debugging mappings, Identification of bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Strong knowledge in understanding of Session logs to identify the performance bottlenecks and errors.
• Excellent performance tuning, troubleshooting, impact analysis and research skills.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 10.1.2/9.5.1/9.1/8.6/8.5/8.11/7.1.1/6.2/6.1, Informatica IDQ

Modeling Tools: Erwin/Oracle Data modeler

Operating systems: Windows 7/98/ NT / 2000, UNIX (Solaris, HP-UX, AIX)

Programming: PL/SQL, Visual Basic, HTML, DHTML, XML, C, C++

Scripting Languages: Linux/UNIX scripting

RDBMS: Oracle 12C/11g/10g/9i/8i, MS SQL Server 2005 / 2000

Testing Tools: QTP, Win runner.

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead

Environment: Informatica Power Center 10.1.2/9.6(Repository Manger, Designer, Workflow Manager, Workflow Monitor), Oracle SQL Developer, Flat files, Jira, SQL, XML files, Toad, onsite offshore model, Agile methodology.

Responsibilities:

• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Actively engage in building robust ETL solution using Informatica to harness the best practices in a typical Oracle/Unix environment in conjunction with Autosys scheduler.
• Perform problem assessment, resolution and documentation in existing Informatica mapping and workflows in production and Autosys jobs.
• Performance tuning of the ETL process and SQL queries, and recommended ETL and query tuning techniques
• Managing offshore team and responsible for completion of all development work.
• Involved in Unit testing, Integration testing, and code reviews.
• Involved in recovery of critical job failures in production environment. Coordinated with DBA's, analysts, external clients and business users in the process of recovery.
• Modified existing mappings and wrote new programs as needed.
• Performed Unit Testing and Integration Testing for Data Warehousing Applications and tuned for better performance
• Experienced in providing production and post-production support for ETL life cycle such as change enhancements, error handling, load failures, performance improvements and version control.

Confidential, Minneapolis, MN

Sr. Informatica developer

Environment: Informatica Power Center 10.1.2/9.6(Repository Manger, Designer, Workflow Manager, Workflow Monitor), SQL Server 2008, Flat files, Jira, SQL, XML files, Toad, Oracle SQL Developer, onsite offshore model, Agile methodology.

Responsibilities:

• Understand and Gather requirements from BRD and prepare Technical design Documents. Designed mapping template for common business rules.
• Analyzed business requirements, created ETL mapping specs and provided task duration estimates
• Develop ETL mappings, sessions and workflows to implement business requirements using Informatica Power Center 9.6
• Roles and responsibilities involved in creating mappings using Informatica ETL tool and debugging mappings, Identification of bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Strong knowledge in understanding of Session logs to identify the performance bottlenecks and errors.
• Develop, test and promote all of the code changes to QA and Production environment

Confidential, Plano, TX

Sr.ETL/ Informatica Developer

Environment: Informatica Power Center 10.1.2/9.6(Repository Manger, Designer, Workflow Manager, Workflow Monitor), SQL Server 2008, onsite offshore model, Toad, Oracle SQL Developer, Agile methodology, Flat files, SQL, XML files, SQL/PLSQL, Autosys, Windows NT

Responsibilities:

• Develop ETL mappings, sessions and workflows to implement business requirements using Informatica Power Center 9.6
• Communicate with business to discuss the issues and gather requirements
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Worked with mapping parameters, variables and parameter files
• Pre-and post-session assignment variables were used to pass the variable values from one session to other.
• Involved in translating the functional requirements into technical mapping specifications and leveraged Power Center 8.6.1 to extract the data from Oracle tables, XML and flat files to populate billing, service order and plant interface files, which are then loaded into the DPI Billing system.
• Design and development of complex ETL mappings making use of Connected/Unconnected Lookups, Normalizer, Stored Procedures, SQL & Custom Transformations.
• Implementation of successful strategies in loading feeds to the Frontier Data Warehouse.
• Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
• Development of PL/SQL Stored Procedures to implement complex business logic and integrate them with the ETL process as pre/post Stored Procedures.
• Performed Unit Testing on the developed Mappings and was also involves in the documentation of Test Plans and testing with the Users (UAT).
• Created detailed unit test document
• Designed workflows with many sessions with decision, assignment task and control task
• Experience with Autosys scheduling in Scheduling tools.
• Develop, test and promote all of the code changes to QA and Production environment

Confidential

Informatica Sr. Developer

Environment: Informatica Power center 8.6/9.5.1, Informatica IDQ, Oracle 11g, TOAD, MS Visio, Unix, Autosys scheduling Tool, Unix Shell script

Responsibilities:

• Worked on migration of the informatica code from versions 8.6 to version 9.5.1.
• Designed, developed and tested Informatica mappings/workflows for multiple sources and data warehouse target systems as part of new Informatica development.
• Understand and Gather requirements from BRD and prepare Technical design Documents. Designed mapping template for common business rules.
• Created IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center .
• Defined and implemented ETL development standards and procedures.
• Created source to target mapping document, external/internal design documents for the Informatica components
• Roles and responsibilities involved in creating mappings using Informatica ETL tool and debugging mappings, Identification of bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Strong knowledge in understanding of Session logs to identify the performance bottlenecks and errors.
• Conducted code reviews and tested ETL components in DIT, SIT, UAT environment. Responsible for best practices like naming Conventions, Performance tuning, and Error Handling.
• Developed, tested and migrated ETL/Informatica components through DIT, SIT, UAT, Break Fix and Production environment.
• Support UAT and SIT testing and troubleshooting production issues.

Confidential

ETL Developer

Environment: Informatica Power Center 9.5/9.1, Oracle 11g, Unix, Toad, SQL Developer, Mingle, Oracle Data Modeler, MS Visio, Jira

Responsibilities:

• Analyzed business requirements and converted complex hierarchical queries to ETL mappings.
• Developed Informatica ETL mappings, sessions and workflows, and scheduled the workflows as per business process. Provided task duration estimates and conducted code reviews.
• Analyzed code reusability across the project and developed reusable objects (mapplets, worklets, sessions...) where redundant logic was identified, enhancing ease of maintenance by minimizing object library.
• Implemented best practices as per Informatica Velocity methodology and optimized the code for performance.
• Involved in Performance tuning and bug fixing in Informatica interfaces and SQL scripts.
• Analyzed impacts of changes on current ETL mappings and developed mitigation strategies.
• Designed, developed and tested Informatica mappings/workflows for multiple sources and data warehouse target systems as part of new Informatica development
• Enhanced several mappings, sessions and workflows to meet new requirements and change requests.
• Unit tested the code and deployed them to QA environments, fixed defects and clarified functionality to test team when needed.
• Attended internal training sessions on business analysis, solution architecture development, project costing and estimation, and quality process implementation.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.0.1, Oracle 10g, Unix, Toad, Visio, Toad, Unix Shell script.

Responsibilities:

• Analyzed business requirements, created ETL mapping specs and provided task duration estimates.
• Created IDQ Mappings and Mapplets by using developer transformations like Merge, Address validator, Standardizer, Case convertor etc., Used DQ rules and developer mapplets with Informatica Power Center.
• Data analysis, data profiling and data cleansing using IDQ .
• Designed, developed and tested Informatica mappings/workflows for multiple sources and data warehouse target systems as part of new Informatica development as well as fixed variances.
• Involved in Performance Tuning of Informatica Jobs and finding out the bottlenecks and fixing them using various tuning methods like session partitioning, reducing the lookup sizes, using persistent caches etc.
• Created source to target mapping document, external/internal design documents for the Informatica components.
• Conducted code reviews with team as well as with business users and tested ETL components in SIT, UAT environment.
• Enhanced several mappings, sessions and workflows to meet new requirements and change requests.
• Involved in Performance tuning and bug fixing in Informatica interfaces and SQL scripts.
• Unit tested the code and deployed them to TQA environment, and provided support.

Confidential

Informatica Consultant

Responsibilities:

• Designed, developed and performed unit-testing on Informatica mapping, session and workflows based on ETL standard and specifications.
• Experienced in handling flat files and XML Sources
• Experienced in working with Type1, Type2 mappings
• Worked closely with business analysts to design, code, test, document and implement the data extraction, transformation and loading of source data into the data warehouse.
• Involved in Performance tuning and bug fixing in Informatica interfaces and SQL scripts.
• Worked with all the Informatica tools like Repository manager, Designer, Workflow manager and Workflow monitor.
• Unit tested the code and deployed them to QA environments, fixed defects and clarified functionality to test team when needed.
• Developed ETL deployment plan for the production environment.
• Participated in project design and code walkthroughs

Confidential

Informatica Sr. Developer

Environment: Informatica 8.5, Db2, AIX

Responsibilities:

• Participated with the Data Warehouse team in technical planning regarding data needs
• Worked with flat files, XML, other RDBMS databases to load data.
• Worked with Informatica tools to create mappings, mapplets and Reusable Transformations to load data from various sources to target.
• Responsible for the data management and data cleansing activities using Informatica data quality( IDQ )
• Created IDQ Mappings and Mapplets by using developer transformations like Merge, Address validator, Standardizer, Case convertor etc., Used DQ rules and developer mapplets with Informatica Power Center. Data analysis, data profiling and data cleansing using IDQ .
• Worked closely with business analysts to design, code, test, document and implement the data extraction, transformation and loading of source data into the data warehouse
• Prepare, maintain and publish ETL documentation, including source-to-target mappings and business-driven transformation rules
• Analyzed the business requirements to design, architect, develop and implement highly efficient, highly scalable ETL processes. Developed the sessions and workflows to accomplish the task
• Participated in the SIT testing and support the System Acceptance and User Acceptance testing
• Worked with all the Informatica tools like Repository manager, Designer, Workflow manager and Workflow monitor
• Participated in project design and code walkthroughs

Confidential

Informatica Sr.Developer

Environment : Informatica PowerCenter 8.5.1, Informatica PowerCenter 8.1.1, Informatica powercenter7.1.1, Informatica PowerCenter 6.1

Responsibilities:

• Designed, developed and performed unit-testing on Informatica mapping, session and workflows based on ETL standard and specifications
• Participated in data analysis and ETL requirements gathering.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Look up (connected and unconnected) Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Designed, developed and tested Informatica mappings/workflows for multiple sources and data warehouse target systems as part of new Informatica development as well as fixed variances.
• Involved in writing stored procedures and SQL scripts to add additional functionality to the target database.
• Designed and Developed the Informatica workflows/sessions to extract transform and load the data into Target.
• Worked with system architects to improve existing OLTP model, increase data quality and improve ETL performance
• Participated in the SIT testing and support the System Acceptance and User Acceptance testing
• Involved in Performance tuning and bug fixing in Informatica interfaces and SQL scripts.