PROFILE SUMMARY:

• Over 18 years of comprehensive experience in the Software industry as an ETL and Data warehouse architect/developer.
• Take pleasure in working in a team environment and play a key role by sharing technical knowledge and taking responsibilities to deliver quality work on time in analyzing problems and come up with creative solutions.
• Have developed strong business/functional knowledge Telecommunication and Banking industries.

• Proficient in ETL design and development using Informatica 10.1/9.5 products: Powercenter, Informatica Data Quality (IDQ), PowerExchange CDC and Master Data Management (MDM)
• Solid understating of Data warehouse, Database, Data Migration skill sets applied in industry.
• Worked as a Team Lead, Sr. ETL Architect/Developer/Admin for over 12 years.
• Strong skills in IDQ data profiling, MDM, Data warehouse and PLSQL/Packages
• Experience in working Agile/Scrum teams.
• Ability to working independently or in a team
• Skilled in working very large scale database environment and mission critical OLTP / OLAP systems.
• Experienced in creating client deliverables like Software Design Document (SDD), Data warehouse Architecture Plan document, programming standards document, Best practices document and .

CORE COMPETENCIES:

• Informatica ETL - Powercenter 10.1/9.6, PowerExchange CDC,
• Data Profiling and Master Data Management - Informatica Data Quality (IDQ), MDM
• Data warehousing, Relational databases, Data cleansing
• Optimizing database queries.

TECHNICAL PROFICIENCIES:

ETL Tools: Informatica 10.1/9.6, Powerexchange, Pentaho, Oracle Data Integrator 10g/11g

Database: Oracle 12c.x /11g.x /10g, Sybase, SQL server, PostgreSQL, Ms Access

Programming Languages: SQL, PL/SQL, Java, C, Cobol, Unix Shell script

SOFTWARE TOOLS: Informatica, SQLDeveloper, Jira, PL/SQL Developer, TOAD, OBIEE, Business Objects, Rational Rose. Powerbuilder, Erwin

Web: Java, JDBC, HTML, Java Script, Java Web Server 2.0, OBIEE

Data Modeling: Erwin, Designer 6i/2.1.2, Designer 2000

Operating Systems: Sun Solaris, Unix (Shell Script), AIX, LINUX, Windows.

Interfaces: JDBC, ODBC

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL /Data Quality (IDQ) Consultant

Environment: Informatica 10.1, Powerexchange CDC, IDQ, Agile/Scrum, AWS Oracle 12C/11G, Obiee 11G, Jira

Responsibilities:

• Developing new ETL workflows and also modifying the existing workflows to in corporate defect fixes and enhancements to accommodate data warehouse changes.
• Developed new CDC ETL to replace existing 116 Materialized views and Truncate/reload ETLs. This capability will bring data into ODS with 15 min frequency, which helped users with more current reports.
• Used IDQ toolkit (Informatica Analyst and Informatica Developer) to perform extensive Data profiling, Address doctor validation and testing on data related Applicants address, Service centers workload/performance etc.. Generated Data profiling results and scorecards.
• Took ownership of ETL code developed by IBM team, managed and deployed it successfully to production as per the schedule after performing the following tasks:
• Fixed performance issue from projected 20 days to under 4 hours by tuning session properties and implementing parallel processing.
• Fixed over 200 defects and enhancements brought data rejection count to an acceptable level set by client. migrated data to AWS environment by working closely with production DBAs.
• Earned ‘ of Appreciation’ from end client in March 2016.
• Worked with DBAs on tuning the queries for better performance.

Confidential

Sr. Informatica ETL /Data Quality (IDQ) Consultant

Environment: Informatica 9.5, Oracle 11g, Informatica Data Quality (IDQ 8.6.1), PL SQL

Responsibilities:

• Used IDQ toolkit (Informatica Analyst and Informatica Developer) to perform extensive Data profiling, validation and testing on data related to Reservation, Properties, Budget and Forecast. Generated Data profiling results and scorecards to help Business users to analyze data issues efficiently. Goal was to identify nature of data, issues with data like duplicate data, invalid/incomplete data, non-standard data and statistics.
• Developed ETL mappings to replace existing stored procedures and views used to populate a set of tables.
• Developed Test plans, Test cases and Test scripts using SQL and PL SQL routines to perform Unit testing.
• Conducted Performance testing of workflows and Boundary testing.
• Was part of team responsible for MDM tool set evaluation.

Confidential, Boston, MA

Informatica ETL Architect / Developer

Environment: Informatica 9.5, Oracle 11g, SQL Server- SSIS, Data Quality 8.6.1 (IDQ), MDM Hub console, PowerExchange, PL SQL, SQLDeveloper, DVO, Unix.

Responsibilities:

• Installed Address doctor and USPS data.
• Performed profiling using Address Validator on Data from US, non-US, MA etc..
• Develop profiling rules and implement them by coding mappings and mapplets.
• Performed comparison between IDQ profiling results and SAS DataFlux tool profiling results.
• Worked on prototype to show the client capabilities of MDM tool by consolidating data from three sources.

Confidential, VA

Lead Informatica ETL Architect / Developer/Admin

Environment: Informatica 9.5, Control-M, Oracle 11g, Data Quality 8.6.1 (IDQ) toolkitPowerExchange, PL SQL, SQLDeveloper, Unix, Primavera, JIRA.

Responsibilities:

• Successfully completed Data migration / Data conversion effort by leading the whole ETL effort including installation of Informatica products, Setting up ETL environment/ Coding guidelines, Data Analysis/Profiling, ETL development, QA test process, ETL code deployment process and deliverables (SDD, VDD, Architecture plan).
• Coordinated three major production releases.
• I have developed around 130 ETL mappings and 35 Oracle Stored procedures.
• The main goal of this effort was to migrate trusted data by performing data conversion and improve data quality with the help of new mapping rules and constraints on target tables to restrict bad data coming into the database thru’ new application.
• Work with Data Architect to discuss and analyze the Data model, data migration/conversion requirements, ETL mapping rules.
• Design, develop and Unit test Informatica Extract, Transform and Load (ETL) objects to perform Data migration for Full Load and/or Incremental Load (CDC).
• Design and implement error handling procedures. Made use of Informatica generated error handling system tables to analyze exceptions.
• Design and develop reusable transformations and mapplet.
• Generate Exception report on migrated data and discuss the results with Data Architect.
• Performed data profiling using PL SQL and IDQ. Presented results to Data Architect to help in Data model development/ modification effort and also to resolve data related issues.
• Suggest Data model changes, table structure changes and make changes to ETL code based on the initial unit test.
• Development of Oracle Stored procedures to handle complex data migration rules. Used them in ETL mappings and also to perform pre or post ETL data migration.
• Deployment of Informatica ETL objects to QA, Staging and Production environments.
• Participate in SEMS Data warehouse and Business Intelligence (BI) requirement analyses. Understand the existing Reports and new Reports requirement and scope for the future releases.
• Support production system by monitoring ETL tasks, analyze ETL performance, analyze data issues, develop emergency fixes to ETL code or prepare new Data correction script and deploy them.
• Evaluation of tools like Primavera, Oracle BI, Informatica Master Data Management (MDM) and BPM products.
• Prepare deliverables like Software Design Document (SDD) on ETL Data Migration for both ODS and DW and Data warehouse Architecture Plan document, Version Deployment Document (VDD) for a major production releases.

INFORMATICA ADMIN

Confidential

Responsibilities:

• Installation and Migration of Informatica from Version 8.6.1 to 9.5 on LINUX machine.
• Create new 9.5 Repository, Folders, Groups/Roles/Users and migrating code to new repository.
• Performed Repository Backup and Restore, Apply patches and hotfixes
• Experienced with Grid Architecture (Gateway node and worker nodes).