SUMMARY

• 11+ years of strong experience as a Software Professional with hands - on experience in System Analysis, Design, Development, Implementation/ Support and Testing using ETL and BI Tools
• Extensively experienced in Informatica PowerCenter, Unix shell scripting and SQL
• Designing Data warehouses using with clear understanding of multi-dimensional data modeling, Power exchange, Shell scripting and SQL ( Confidential, Netezza, DB2 and Confidential databases)
• Extensive experience in Data warehousing development and maintenance projects using ETL technology, and Performed project management activities like Estimations, Project Planning, Scheduling, Deployment, Tracking, Resource Management, Coordination of Team in onsite and offshore and Building strong experience in client relationship
• Proficient in data warehousing concepts, data modeling, dimensional star schema and snowflakes schema methodologies, implementing slowly changing dimensions, converting legacy into enterprise environment
• Developed mappings, sessions, worklets and workflows by using the power center Informatica tool
• Developed the multiple shell scripts to automate the Informatica workflow jobs and files operations
• Good in troubleshooting Informatica jobs, enhancement of jobs and addressing production issues like performance tuning and enhancement
• Good at analyzing the Cobol copy books and developing the data maps by using the Power exchange
• Optimized Informatica jobs utilizing parallelism, partitioning concepts in Informatica
• Independent developer with excellent Technical, Analytical and Communicational skills
• Worked in Waterfall and Agile methodologies

TECHNICAL SKILLS

ETL Tools: Informatica power center 8.x, 9.x, 10.1, 10.2 and Informatica Power exchange

Reporting Tools: Tableau

Database: Confidential, Confidential, DB2, Netezza & Apache Hadoop

Version Control Tools: Confidential Rational Team Concert and Service now and Confidential ALM

Testing: Unit testing and Performance testing.

Scheduler tools: Control M and Tivoli scheduler tools for Informatica jobs

Languages: Python, Shell scripting and SQL

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Till DateInformatica senior developer

Responsibilities:

• Designed and Developed the applications using Informatica, Shell scripting, Confidential and Confidential .
• Designed and developed ETL jobs using Informatica Power center to extract the data from Confidential transformed based on business requirements and loaded to Data Warehouse.
• Designed and developed the Informatica jobs to read the data from flat files and loaded into data warehouse.
• Performed the unit testing, system testing and integration testing of the applications.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Normalizer transformations.
• Have experienced in troubleshooting Informatica jobs, enhancement of jobs and addressing production issues like performance tuning and enhancement
• Developed shell scripts to source file watch, parameter file creation and Informatica jobs completion notification mail with statistics
• Developed python script to call the URL (CMS website) and parsing the JSON response
• Involved in brainstorming, consultation and troubleshooting of several technical problems faced during the data migration and application development processes.
• Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production
• Involved code migration activities to higher environments

Environment: Informatica power center 9.x, 10.1, 10.2, Confidential, Shell script, Python, Service now, Confidential ALM, Confidential Rational Team Concert and Tivoli scheduler.

Confidential

Senior ETL Informatica Developer

Responsibilities:

• Involved in preparation of technical design build document based on business requirements, Development, Execution, Testing and Defect fix phase of the project
• Prepared the design documents High level Design and LLDs
• Actively participated in project groups and meetings to fully understand new business processes and identify any new data/reporting requirements resulting from these projects.
• Analyzed the COBOL programs and prepared the mapping documents with transformation rules and data flow rules.
• Developed the Informatica jobs to replace the mainframe jobs to load the data into Datawarehouse.
• Designed and developed ETL mappings using Informatica Power center to extract the data from multiple sources like Mainframe files transformed based on business requirements and loaded to Data Warehouse
• Developed the data maps in power exchange navigator by using the COBOL copy books to load the data from mainframe files
• Worked extensively with complex mappings using different transformations like Application Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Normalizer transformations
• Developed shell scripts to generate the parameter files for daily incremental loads.
• Developed a shell script to run the Informatica jobs from Control M job scheduler
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results
• Performed the unit testing and involved in code review activities

Environment: Informatica 9.1, Informatica power exchange, DB2, COBOL, shell scripts, Service now, bConfidential ALM and Control M.

Confidential

Informatica developer

Responsibilities:

• Performed the feasibility study, impact analysis, prepared the high and low-level design documents, and detailed technical design document
• Involved in collating and defining business requirements for the data warehouse and preparation of technical design build document based on business requirements, Development, Execution, Testing, Defect fix and CR implementation phase of the project
• Performed Data cleansing in the source and loaded into staging tables for each data conversion
• Participated in project groups and meetings to fully understand new business processes and identify any new data/reporting requirements resulting from these projects.
• Designed and developed ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Confidential, Mainframe, CSV, Delimited files transformed based on business requirements and loaded to Data Warehouse.
• Involved in Peer review of code and participated in the overall systems testing to support the implementation of the application into production environment.
• Developed the complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures, XML transformations, Normalizer transformations and Java transformation.
• Developed a reusable Google API package which will fetch latitude and longitude information for address record updates
• Validated legacy source files before Job execution by using Informatica Power Exchange
• Involved in code migration activities (Code migration to production and testing environments) and pre-production and post production go live activities.
• Performed impact analysis of change requests based on revised requirements and implemented the CR
• Have experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.
• Involved in tracking and implementation of defects and Change requests

Environment: Informatica 8.6, 9.01 and Confidential 11g, Informatica power exchange 9.1, Java and Shell script.

Confidential

Informatica Developer

Responsibilities:

• Involved in preparation of technical design build document based on business requirements, Development, Execution, Testing and Defect fix phase of the project.
• Prepared the design documents High level Design, LLDs, SAD, SID and actively participated in project groups and meetings to fully understand new business processes and identify any new data/reporting requirements resulting from these projects.
• Designed and developed ETL mappings using Informatica Power center to extract the data from multiple sources like Mainframe files transformed based on business requirements and loaded to Data Warehouse
• Developed the data maps to load the mainframe data(binary) by using the power exchange navigator
• Developed webservice consumer services Informatica jobs
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Normalizer transformations and Webservice consumer transformations
• Participated in the overall systems testing to support the implementation of the application into production environment
• Involved in tracking and implementation of defects and provided daily and weekly status reports to the onsite and client business teams

Environment: Informatica 8.6, Informatica power exchange, DB2, COBOL and WebServices