SUMMARY

• Over 9.5 years of experience in IT Industry in Development, maintenance and enhancement projects in Data Warehousing and Client Server Architecture applications.
• Extensively worked on creating Mappings, Transformations, Sessions and Workflows to extract data from various sources and load into targets.
• Experienced in performance tuning of mappings, sessions and workflows including partitioning.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, XML Source Qualifier, External procedure.
• Involved in full life cycle development of Data Warehousing.
• Excellent understanding of Star Schema modeling, Snowflake modeling. Fact, Lookup and Dimensions Tables.
• Extensive knowledge on various performance tunings for mappings, sessions and stored procedures.
• Excellent skills in understanding business needs and converting them into technical solutions.
• Extensive experience in error handling and problem fixing in Informatica
• Strong technical, communication, time management and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCentre - 7x and 8x,9x Metadata Manager, Business Glossary, Data Analyzer, PowerExchange, PowerConnector

RDBMS: Oracle, DB2, SQL Server, MS-Access

Programming Languages: Shell Script, Batch Script

Scheduling Tools: WLM,CA7

Operating Systems: Windows NT/2000/XP, MS-DOS, UNIX

Data Modeling Tools: Erwin, Visio

PROFESSIONAL EXPERIENCE

Confidential, Plymouth MN

Sr. ETL Consultant

Environment: Informatica9.6/9.1,Oracle11i,Sqlserver 2012, CA7

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner,
• Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Deployed the Informatica code and worked on code merge between two difference development teams.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Created Informatica complex mappings with PL/SQL procedures/functions to build business rules to load data.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created automated scripts to perform data cleansing and data loading.
• Performed complex defect fixes in various environments like UAT, SIT etc. to ensure the proper delivery of the developed jobs into the production environment.
• Attended daily status call with internal team and weekly calls with client and updated the status report.
• Creating and deploying complex mappings, tasks, and workflows to higher environments
• Creating and scheduling windows scripts and stone branch jobs to run workflows
• Generating and submitting enrollment, commercial lending files to nCino server
• Supporting production issues by fixing the defects.

Confidential, Springfield MA

Senior ETL Developer

Environment: Informatica9.6/9.1,InformaticaILM,PowerExchange,PowerExchange Navigator,Oracle,DB2,Mainframe,Unix,Linux,CA7,OBIEE,SAPR/3,,SSIS,SSRS,ERWIN

Responsibilities:

• Involved in analysis, LLD, HLD and documentation of mapping specs as per business rules.
• Involve in understanding test requirements
• Prepare test strategy and Test Directories
• Participate in test case development and execution
• Participate in test results document preparation for the project
• Participate in bug reporting and tracking for the project
• Extensively used Power Exchange for getting Source from web services data.
• Extensively used Power Exchange for getting Source from Salesforce APEX data.
• Performed a data map and running row test in Power Exchange Navigator.
• Created data maps for oracle source from Power Exchange.
• Performed ETL data loading into OBIEE Environment.
• Familiar with the OBI data structures.
• Extensively used CDC on real time data.
• Extensively used SQL server Database from source and target.
• Participate in review of test document for the end-to-end testing
• Prepare project status reports for the work carried out
• Collect and reporting metrics on end-to-end testing.
• Hands on Experience in Erwin by creating logical and physical models.
• Experience in Reversed Engineering process by using Erwin
• Experience in Dimensional modeling by creating star and snow flake schemas
• Experience in 1&3NF by implementing into projects.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of INFORMATICA.
• Experienced in ETL auditing process.
• Used most of the transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression, Aggregator, Connected & Dynamic Lookup, Rank, Router, and Update Strategy, SQL Transformation, etc.
• Scheduled the Informatica Workflows as per user requirement by using AUTOSYS scheduling tool.
• Creating retention policy and assigning retention policy to entities
• Creating optimized file archive project with retention policy
• Running job for applying retention policy and viewing applied retention policy
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Experienced with Informatica connector to SAP
• Experience with SAP Account Payable.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
• Involved in unit testing to test the processed data and user acceptance testing.
• Experienced in troubleshooting and fix the different Development/Production environment issues.
• Involved in environment creation of metadata manager.
• Involved in recycle Repository, integration services and creation of automated scripts for deployment using pmrep command.
• Involved in Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories.
• Experienced in writing Uniting Test Cases with multiple scenarios.
• Generating the Reports in SSRS

Confidential

Analyst

Environment: Informatica9.1,InformaticaILM,OBIEE,Oracle,DB2,Mainframe,Unix,Linux,CA 7,SSRS,ERWIN,Power Exchange.

Responsibilities:

• Extracting the data from the Enterprise Memory Sources
• Transforming the data as specified in the Business Rules
• Loading the data into the Data Layer through DWS
• Identifying/Analyzing root-cause for the bugs/defects raised by Users and QA team in DWH model.
• Fixing bugs by modifying existing ETL code/logic or proposing new ETL design to meet user requirements.
• Performed ETL data loading into OBIEE Environment.
• Familiar with the OBI data structures.
• Expert in CDC real time data.
• Extensively used SQL server Database from source and target.
• Identifying the reason for rejection records in production during ETL data loads and fixing them by modifying/altering ETL code.
• Perform end-to-end impact analysis in case of any changes required in existing ETL code.
• Extensively used Power Exchange for getting Third party data as a source.
• Experienced in logical and physical models with Erwin.
• Experienced in Reverse Engineering concepts by using Erwin.
• Hand on Experience in Erwin tool.
• Communicating/Coordinating with DB admins and Informatica admins to resolve load issues.
• Creating retention policy and assigning retention policy to entities
• Creating optimized file archive project with retention policy
• Running job for applying retention policy and viewing applied retention policy
• Communicating with various source teams to understand business logic/purpose.
• Tuning long running sessions by changing ETL code and SQ/LKP queries.
• Involved in peer-code reviews.
• Monitoring Workflow Monitor, Workflow Manager, Designer.
• CA7 tool Monitoring.
• Created high, normal, low priority incidents and changes by using Smile (ticket raising tool).
• Experience reports performance turning in SSRS and MS SQL DB query optimization.
• Understanding the error and find a solution to complete batches which are daily, weekly, monthly, quarterly, yearly. checking files Unix directories which has been placed or not
• Handled Complexity mappings, issues and resolved them in time.
• Experience using MS SQL Server Reporting Services (SSRS).
• Communicate directly with clients and giving smooth supporting to the business.
• Handled Critical Supporting Activities which were in quarterly and yearly.
• Estimating efforts required to close defects.
• Perform Unit testing and Integration testing thoroughly to make sure no flaws in the code.

Confidential

Sr. Software Engineer

Environment: Informatica8.6, Oracle, Salesforce, Apex Explorer, Oracle, SQL Server 2008.

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Developed approach paper according to the business rules.
• Had a very good experience handling SAP Account Processing data structure.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Developed mappings with transformations confirming to the business rules.
• Preparing the Documentation for the mapping according to the designed logic used in the mapping
• Involve in understanding test requirements
• Prepare test strategy and Test Directories
• Participated in test case development and execution
• Participated in test results document preparation for the project
• Participated in bug reporting and tracking for the project
• Participated in review of test document for the end-to-end testing
• Prepared project status reports for the work carried out
• Collect and reporting metrics on end-to-end testing.
• Experience in Connecting the Informatica with SAP.
• Preparing Test Cases
• Processed session data using threads and various tasks (session, command etc.) and managed database connections
• Performance tuning of mappings, transformations and sessions to optimize session performance.

Confidential

ETL Developer

Environment: Informatica8.6, Oracle, SQL Server, Teradata, Erwin, Shell Scripts Windows NT, UNIX

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Developed approach paper according to the business rules.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Developed mappings with transformations and mapplets confirming to the business rules.
• Preparing the Documentation for the mapping according to the designed logic used in the mapping
• Optimizing performance tuning at mapping and Transformation level
• Interacting with Onshore people and Database team if any issues
• Preparing Test Cases
• Processed session data using threads and various tasks (session, command etc.) and managed database connections and scheduled workflows.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensively used stored procedures and also worked with parallel processing.
• Created shared folders, local and global shortcuts to reuse metadata.
• Worked on issues with migration from development to testing.
• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.

Confidential

ETL Developer

Environment: Informatica 8x, Oracle, Teradata, Windows XP, UNIX

Responsibilities:

• Involved in analysis and documentation of mapping specs as per business rules.
• Acted as a Administrator for this project.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of Informatica.
• Experienced in ETL auditing process.
• Used most of the transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression, Aggregator, Connected & Dynamic Lookup, Rank, Router, and Update Strategy.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Automated the jobs thru scheduling using Built in informatica scheduler, which runs every week by maintaining the data validations
• Experienced in batch scripting to archiving source files and mailing the status of workflow runs.
• Used Debugger to troubleshoot the mappings
• Experienced in unit testing and user acceptance testing.
• Experienced in documenting all the processes like deployment, coding standards, and UTP docs.
• Experienced in administering to maintain privileges of added users and taking repository backups on weekly and monthly basis.
• Experienced in Informatica software installation, configuration for the Informatica client and upgrades as needed.
• Create detailed project outlines and application design specifications.

Confidential, NA

ETL Developer

Environment: Informatica 7x, Cognos, Oracle 9i, WinNT4.0

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Designed and developed complex aggregate, joiner, lookup, transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions.
• Extracted, transformed data from various sources such as Flat files, MS SQL Server and transferred data to the target data warehouse Oracle9i database and Flat files
• Performed target load plan to load data into the targets.
• Conducted unit testing for Developed Mappings.
• Creating Transformations, mappings and mapplets as per specifications.
• Involved in ETL performance assessment and tuning.
• Involved in unit testing to check the data consistency.