Highlights:-

• Over 9 years of IT experiences in Data Warehousing ETL Requirements Gathering, Analysis, Design, Development, Implementation, Integration, Testing, Profiling, Cleansing and Validation of data using the Technology, Informatica PowerCenter/Data Quality IDQ from versions 7.1 to 9.6.1HF1 for Health Care, Insurance, Banking and Wireless Industries in different Methodologies.
• Experienced in Migration of codes from Repository to Repository, wrote up Technical/Functional Mapping specification Documents for each Mapping along with unit testing for future development.
• Proficient in Designing the Automation Process of Workflows and configuring/scheduling the Workflows for load frequencies. Skilled to Develop, Test, Tune and Debug the Mappings, Sessions and Monitor the system.
• Experienced to Profile, Analysis, Standardize, Clean, Integrate, Score Carding, Reference Data from various source systems using Informatica Data Quality IDQ Toolkit. Worked with Address Doctor, different algorithms, Biogram/Jaro/Edit/Hamming/Reverse distance in IDQ.
• Skilled to interact with business users. Pioneered in different load strategies from heterogeneous sources to target. Successfully implemented SCD Type1/Type2 load, Capture Data Changes to maintain the Data history.
• Experienced to identify the Bottlenecks of data load and Tuned the Bottlenecks for better performance.
• Extensive experiences to create Logical Physical Data Modeling on Relational OLTP , Dimensional Data Modeling OLAP on Star schema for Fact Dimension tables using CA ERwin.
• Experienced in Informatica Administration for installing and configuring Repository, Web Hub services for configuration of Domain/Gateway Services using the Administration Consol, Repository Manager tools.
• Excellent to write the Stored Procedures, Triggers, Indexes, Functions by PL/SQL, SQL Scripts. Developed various reports, dash board using MicroStrategy reporting tools.
• Experienced as Database Administration in Oracle 9i, Flashback, RMAN to Recover the data, Database Design, Enterprise level Backup/ Recovery procedure, Performance Tuning, Table Partitioning, Database Architecture, Monitoring, and Database Migration, SQL Developer.
• Excellent in communication and interpersonal skills vivid analytical ability to solve the problems.
• Team player, motivated and dynamic with excellent oral and written communication skills.

Technologies:-

Professional Experiences:-

Title: - Sr. Data Warehousing ETL /IDQ Developer- Informatica.

Confidential

Responsibilities: -

• Used the Address Doctor to validate the address and performed exception handling, reporting and monitoring the system. Created different rules as mapplets, Logical Data Objects LDO , workflows. Deployed the workflows as an application to run them. Tuned the mappings for better performance.
• Used different algorithms like Biogram Distance, Edit Distance, Jaro Distance, Reverse Distance, Hamming Distance to determine the threshold values to identify and eliminate the duplicate datasets and to validate, profile and cleanse the data. Created/modified reference tables for valid data using IDQ Analyst tools.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality IDQ 9.5.1 Developer to remove the noises of data using Parser, Labeler, Standardization, Merge, Match, Case Conversion, Consolidation, Address Validation, Key Generator, Lookup, Decision etc Transformations and performed the unit testing for accuracy of data.
• Tested mappings, workflows and sessions to figure out the bottleneck to tune them for better performance. Prepared effect Unit, Integration and System test cases for various stages to capture the data discrepancies/ inaccuracies to ensure the successful execution of accurate data loading.
• Designed and developed various complex SCD Type1/Type2 mappings in different layers, migrated the codes from Dev to Test to Prod environment. Wrote down the techno-functional documentations along with different test cases to smooth transfer of project and to maintain SDLC.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica PowerCenter/Data Quality IDQ , peer reviewed their development works and provided the technical solutions. Proposed ETL strategies based on requirements.
• Created Pre Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop re-create the indexes and to solve the complex calculations on data. Responsible to transform and load of large sets of structured, semi-structured and unstructured data from heterogeneous sources.

Environment:- Informatica PowerCenter 9.5.1 HF4, Informatica Data Quality IDQ , Oracle 11g/10g, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX Shell Scripting, MS-SQL Server 2008, SQL-Developer, JIRA.

Title: - Sr. ETL Developer-Informatica.

Confidential

Responsibilities:-

• Participated in daily/weekly meetings, monitored the work progresses of teams and proposed ETL strategies.
• Based on requirements designed and coded new/old Mappings and validated/debugged old Mappings, tested Workflows, Sessions and figured out the better technical solutions on old new Mappings for Source/Target compatibility. Identified the bottlenecks in old Mappings and tuned them for better Performance.
• Migrated the codes from Dev to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project. Prepared ETL technical Mapping documents along with test cases for each Mapping for future developments to maintain SDLC.
• Worked on various complex SCD Type1/Type 2 Mappings in different layers to maintain the data history. Used Mappings Sessions Variables/Parameters, Parameters files, Reusable Transformations Mapplets to maintain the life cycle development and fixed other's Mappings.
• For each Mapping prepared effective Unit, Integration and System test cases for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
• Worked on Informatica PowerCenter 9.5.1HF4 Tools- Repository Manager, Informatica Designer, Workflow Manager/Monitor and carefully monitored the system during data loading.
• Designed the automation process of Sessions, Workflows, scheduled the Workflows, created Worklets command, email, assignment, control, event wait/raise, conditional flows etc and configured them according to business logics requirements to load data from different Sources to Targets.
• Created Pre Post-Sessions UNIX Scripts to merge the flat files and to create, delete temporary files, change the file name to reflect the file generated date etc.
• Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings. Wrote various Functions, Triggers and Stored Procedures to drop, re-create the indexes and to solve the complex calculations.

Environment:- Informatica PowerCenter 9.5.1 HF4, Oracle 11g/10g, SQL, PL/SQL, TOAD 9.5, Putty, WinSCP, UNIX Shell Scripting, MS-SQL Server 2005, SharePoint, HIPPA, IIR, Web Services WSDL , MySQL.

Title: - Sr. ETL / IDQ Developer- Informatica.

Confidential

Responsibilities:-

• Coordinated in daily team meetings, technical code review meetings and interacted with business people for better technical solutions and proposed ETL strategy based on Agile Methodologies.
• Validated, debugged old Mappings, tested Workflows Sessions and figured out the better technical solutions. Identified the Bottlenecks in old/new Mappings and tuned them for better Performance.
• Developed various complex SCD Type1/Type2 Mappings to maintain the data history in different layers. Used Mapping Sessions Variables/Parameters, Parameters files, Reusable Transformations Mapplets to maintain the life cycle development. Designed and coded of major change requests as per new requirements.
• Worked on Automation process of Sessions, Workflows, scheduled the Workflows, created Worklets and configured them according to business logics requirements to load data from different Sources to Targets.
• Worked on Team Based development to migrate the codes from Dev to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project.
• Prepared effective Unit, Integration and System test cases of Mappings for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
• Created Pre Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop re-create the indexes and to solve the complex calculations on data. Transformed and loaded of large sets of structured, semi-structured and unstructured data coming from different sources like CSV, Flat file MS-SQL, Oracle etc.
• Worked with Informatica Data Quality IDQ 9.5.1 Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Created Reference tables using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data.
• Built the Logical Data Objects LDO and developed various mapping, mapplets/rules using the Informatica Data Quality IDQ based on requirements to profile, validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM.
• Worked on Web Services WSDL to extract data from different Web Links and created Mappings load the data into target tables. Used WSDL link to represent the data in MS-Word, MS-Excel in Ads-on menu.

Environments:-

Informatica Power Center 9.1.0-9.5.1HF2, Oracle 11g, PL/SQL, Toad 9.5, Dynamic SQL, UNIX Shell Scripting, SharePoint, HIPPA, Embercado, IIR, Web Services WSDL ,MDM, MySQL.

Title: - Sr. ETL / IDQ Developer- Informatica.

Confidential

Responsibilities:-

• Participated in team meetings and proposed ETL strategy based on Agile Methodology.
• Worked on Informatica PowerCenter 8.6.1-9.1.0.HF1 Tools- Repository Manager, Informatica Designer, Workflow Manager/ Monitor, Informatica Data Quality IDQ Developer and Analyst Toolkits.
• Based on Subject Areas, provided concrete solutions for complex/critical Mappings and created various complex Mappings in different layers. Successfully implemented SCD Type1/ Type 2 for insert capture data changes and delete operation to maintain the data history. Created Mapping Sessions Variables/Parameters, Parameters files, Mapplets Reusable Transformations to reuse during life cycle development.
• Created batches based on Subject Areas for different layers to run Workflows/Worklets and Sessions, scheduled the Workflows for load frequencies and configured them to load data.
• Involved in debugging the invalid Mappings. Tasted Mappings, Sessions, and Workflows to figure out the Bottlenecks and tuned them for better performance. Built Unit test queries to test data accuracy.
• Migrated the codes from Development to Test, Test to Production. Created effective Unit, System, Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading. Created technical documentations for each Mapping for future developments.
• Designed and coded change request as per the new requirements. Created Pre Post-Sessions UNIX Scripts, Stored Procedures to drop re-create the indexes and to solve the complex calculation.
• Worked with Informatica Data Quality IDQ 9.5.1 Developer/Analyst Tools to remove the noise of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Created Reference/Master data for profiling using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling, reporting and monitoring the data.
• Built the Physical Data Objects and developed various mapping, mapplets/rules using the Informatica Data Quality IDQ based on requirements to profile, validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for the MDM.

Environments:-

Informatica Power Center 9.1.0/8.6.1, Teradata, Oracle 11g, PL/SQL,UNIX, Toad 9.5, Dynamic SQL, Shell Scripting. Web Services WSDL , SQL Navigator ILM, IDQ 9.5.1, IIR, BTEQ, MDM, Hadoop.

Title: - Sr. ETL Developer- Informatica.

Confidential

Responsibilities:-

Worked on data Integration from different sources using Informatica PowerCenter/Power Exchange 8.6.1/9.1 Tools- Repository Manager, Informatica Designer, Workflow Manager/ Monitor and Upgraded the system from 8.6.1 to 9.1. Participated in team meetings and proposed ETL strategies.

• Developed various complex Mappings and successfully implemented SCD Type1/Type 2 to keep the data history changes. Designed and coded change request as per the new requirements.
• Migrated the codes from Repository to Repository. Used debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings. Tested the Mappings, Sessions, Workflows and Worklets. Wrote the test queries to check if the data was loading to dimension tables and fact tables properly.
• Created and reviewed the logical and physical data model for the fact and dimension tables according to business requirements to be used for EDW. Created DDL scripts to implement Data Model changes. Created ERwin reports in HTML, RTF format depending upon the requirements, published Data Model in Model Mart, co-coordinated with DBAs to apply the data model changes.
• Created effective Unit, System and Integration Test cases for various stages of ETL to capture the data discrepancies and inaccuracies to ensure the successful execution of accurate data loading.
• Wrote Functions, Stored Procedures to drop re-create the indexes and to solve the complex calculation as needed. Tested and maintained data integrity among various Sources and Targets. Worked on Performance Tuning to tune the data loading by identifying the Bottlenecks in Sources, Targets, Mappings, Transformations, Sessions, Database, Network then fixing them. Involved in providing Informatica Technical Support to the team members, as well as the business.

Environments:-

Informatica PowerCenter/Power Exchange 8.6.1/9.1, Teradata, Oracle 10g, MS-Server 2008, PL/SQL, ERwin 8.2, Toad 9.5, Putty, WinSCP, UNIX, SOAP, SAP, COBOL, Web Services WSDL , BTEQ, MySQL.

Title: - ETL Developer/ Informatica Data Modeler.

Confidential

Responsibility:-

• Used Informatica 8.6.1 to Extract, Transform and Load data from Oracle, MS-SQL Server 2000, CSV and flat files to Oracle Server and Migrated the Informatica from 7.1 to 8.6.1.
• Created several complex Mappings, Mapping Parameters/Variables, mapplets, Parameters files successfully implemented the SCD Type1/Type2 to load the data to maintain the history of data.
• Migrated the codes from Repository to Repository. Created and Monitored Workflows/Sessions using Informatica Workflow Manager/Monitor to load data from different Sources to Target.
• Tested all applications to smooth flow of data. Scheduled and ran the extraction load processes.
• Maintained Metadata, naming and Warehouse standards for future application development.
• Involved in writing Functions, Triggers, and Stored Procedures in PL/SQL as per the requirements.
• Extensively worked on Performance Tuning to tune the data load by identifying the Bottlenecks in Sources, Targets, Mappings, Transformations, Sessions, Database, and Network.
• Worked on data conversion, integration, load verification. Performed Unit, System, Integration. Tested Mappings in various stages of ETL to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading, and used debugger to troubleshoot logical errors.
• Created and reviewed the logical and physical model for the fact and dimension tables from the source systems according to business requirements to be used for EDW. Created DDL scripts for implementing Data Modeling changes. Created ERwin reports in HTML, RTF format depending upon the requirement, published Data model in model mart, co-coordinated with DBAs to apply the data model changes.
• Provided Informatica technical support to the team members, as well as the business.

Environments:-

Informatica Power Center 8.6.1, Oracle 9i, MS-SQL Server 2005, PL/SQL, UNIX, ERwin 7.2, Toad 9.5. MS-DOS, SIF, SQL Navigator, ILM, Putty, WinSCP, Unix Shell Scripting.

Title: - ETL Developer-Informatica.

Confidential

Responsibilities:-

• Participated in team meeting to design, develop implement the project proposed ETL strategies.
• Developed several complex Mappings and successfully implemented SCD Type1/Type 2 to keep the history changes. Worked with Variables/Parameters, Parameter Files, Workflows, Sessions and configured them for smooth transfer of data. Extensively worked on identifying the Bottlenecks and resolved them to accelerate the performance of loading the data. Performed tuning of SQL queries for speedy extraction of data and troubleshooted the long running Sessions and fixed the issues.
• Involved in the development of Stored Procedures, Functions, Views, Materialized Views, and Triggers, to drop re-create the indexes and to process business data according to requirements.
• Worked with the testing team to resolve bugs related to ETL Mappings, created effective Test Cases Unit, Coding, and Integration Testing for various stages of ETL to capture the data discrepancies and inaccuracies to ensure the successful execution of accurate data loading.
• Created Objects into repository by merging and importing into Micro Strategy Repositories.
• Reported to the senior Micro Strategy consultant about weekly and monthly project status.
• Designed and developed ad hoc queries, analytics and dashboards through Micro Strategy solutions.
• Created the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to deployment, maintenance, future enhancements, backup and crisis management of DW.

Environment:- Informatica Power Center 7.1, ERwin 4.0, CDC, Windows 2000, Oracle 9i/, PL/SQL, TOAD. Jaspersoft, Micro Strategy, Putty, WinSCP, UNIX Shell Scripting.