SUMMARY:

• Eight plus (6+) years of IT experience in the Analysis, Design, Development and Implementation of business application systems for Health care Sector.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, MS Access and Teradata.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience using SSIS ETL tool in various projects.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, csv files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Zeke scheduler.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

• Language
• SQL
• Tools
• SQL SERVER 2000/2005/2008/2012 , Informatica 8.6 and above, Tortoise SVN, BO, JIRA,
• Oracle,IBM DB2,Microstrategy
• Applications
• Microsoft Office, Excel
• OS
• Windows NT/95/98/2000/XP/Unix

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

• Interaction with the LOB owners on the requirement regarding their business flow.
• Understand the requirement from the business owners and provide them the solution so that they can achieve their future needs.
• Design document creation depending on the requirement basis.
• Communication with offshore team on the requirement and understand them requirement what is needed for the business.
• We used TFS (Team Foundation Server) for tracking of the task assign in the sprint.
• Various heterogeneous sources were used by LOB to store at central repository
• Understanding the mapping sheet provided by the data architect. Review them as per the business requirement. Communicate if any changes needed to achieve the goal.
• Extensively used transformation like Aggregator, Router, Filter, Normalizer, Stored Procedures, Sequence generator, Update Strategy and Lookup
• Review the mapping created by offshore to check as per the requirements.
• Migrate the mapping to QA after done with unit testing
• User Acceptance testing to be done, if any issues at that time .Analyze them and resolve the issue at point of time.
• Shell Scripting basically used for the parameterization purpose.
• Created many reusable components by using parameterizations.
• Analyzed the impact by certain change in the requirement and make sure that it doesn’t impact the other flows.
• Use of Source Control for the versioning of code on the SQL server side.

Environment: Informatica 9.6, Oracle 11g, SQL server 2008/2010/2012 , Teradata 14.0, IBM DB2 and Files, Business Objects, UNIX, Microstrategy,TFS

Confidential, TN 

Senior ETL Developer

Responsibilities:

• Interaction with the LOB owners on the requirement regarding their business flow.
• Understand the requirement from the business owners and provide them the solution so that they can achieve their future needs.
• Design document creation depending on the requirement basis.
• Communication with offshore team on the requirement and understand them requirement what is needed for the business.
• Various heterogeneous sources were used by LOB to store at central repository
• Understanding the mapping sheet provided by the data architect. Review them as per the business requirement. Communicate if any changes needed to achieve the goal.
• Extensively used transformation like Aggregator, Router, Filter, Normalizer, Stored Procedures, Sequence generator, Update Strategy and Lookup
• Review the mapping created by offshore to check as per the requirements.
• Migrate the mapping to QA after done with unit testing
• User Acceptance testing to be done, if any issues at that time .Analyze them and resolve the issue at point of time.
• Shell Scripting basically used for the parameterization purpose.
• Created many reusable components by using parameterizations.
• Analyzed the impact by certain change in the requirement and make sure that it doesn’t impact the other flows.
• Implemented SCD2 logic in many of the LOB as per the requirement needed.

Environment: Informatica 9.6, Oracle 11g, SQL server 2008/2010/2012 , Terdata 14.0, IBM DB2 and Files, Business Objects, UNIX, Microstrategy

Confidential

ETL Developer

Responsibilities:

• Involved in the requirement gathering phase on the Business needs.
• Design document to be prepared based on the business requirements.
• Document to be add in the confluence on the Jira site.
• Used to create stories and tasks on the based on the design document
• Mapping documents were used to be assigned to Jira ticket and from there we used to pick up the task for the Informatica mapping.
• Extensively used transformation like Router, Aggregator, Normalizer, Expressions and Lookup, Update Strategy and Sequence generator.
• Developed Complex mapping to load data from various source system.
• Parametrized the mapping and increased the reusability
• Prepared Unit Test Results (UTR) for the mappings developed by me.
• Performed Peer review and Peer Testing
• Analyzed the impact whenever there is change in the datatype of a column or some new columns are added in a table.

Environment: Informatica 9.0, Oracle, Jira Agile tool, Unix,Microstrategy .

Confidential

ETL Developer

Responsibilities:

• Understand the business requirement and as per that created the business document.
• Business signoff on the business document from the client.
• Creating the tasks and stories in the Jira as per the requirement document in Jira.
• Coordination with Onsite BA and client on the development task as part of the requirement phase.
• Developed the I nformatica mapping, sessions and workflows as per the requirement document .
• Extensively used transformation like Router, Aggregator, Normalizer, Expressions and Lookup, Update Strategy and Sequence generator.
• Developed Complex mapping to load data from various source system.
• Implemented performance tuning logic on targets, sources, mapping, sessions to provide maximum efficiency and performance.
• Parametrized the mapping and increased the reusability.
• Client Used versioning control tool like SVN for their code version.
• Extensively used informatica debugger to figure out the problems in mapping .Also involved in trouble shooting existing ETL bugs.
• Prepared Unit Test Results (UTR) for the mappings developed by me.
• Performed Peer review and Peer Testing
• Analyzed the impact whenever there is change in the datatype of a column or some new columns are added in a table.
• Created UNIX shell scripts to send an email to source team with the bad records attached in a file.

Environment: Informatica , Oracle,Unix, Agile Methdology (Jira),Files

Confidential

Software Engineer/Developer

Responsibilities:

• Understand the Business logic implemented in the SSIS packages.
• Creating the required document of the SSIS package so that the business logic is preserved
• Developing Informatica mapping as per the document provided.
• Unit Testing of the Informatica mapping then move the code for QA testing
• Created tables, views, triggers, stored procedures and indexes.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.

Environment: SQL server 2000, Teradata 12.0, IBM DB2, UNIX, Informatica. SSIS