SUMMARY

• 6+ years of IT experience in performing Software Analysis, Design, Development of ETL, Data Warehousing and Data Integration Solutions using Informatica Power Center and Teradata.
• Experience in implementing several ETL projects using waterfall and Agile/Scrum Methodologies.
• Well versed with Ralph Kimball and Bill Inmon methodologies. Hands on Experience in building effective Data warehouse and Data Marts.
• Extensive experience with ETL Informatica Power Center 9.x/8.x and Informatica Data Quality (IDQ). Experienced in ETL testing andTDM(Test Data Management) involvingInformatica,
• Utilized of InformaticaIDQ 9.xto complete initialData profiling and Matching/Removing duplicate data.
• Experience in creating Mapplets and Rules and using of rules in Profiling.
• Expertisein Data Quality validation, Data Profiling and Data analysis in Enterprise Data Warehouse environment.
• Expertise in using databases like Oracle 10g/11g, SQL Server and Teradata. Used various SQL tools like TOAD, Oracle SQL Developer, SQL*Plus, SQL Loader.
• Hands on experience in several business domains like Hospitality, Finance, and Logistics.
• Experienced in writing UNIX and Linux Shell Scripts and scheduled these Scripts using Scheduling tools like Crontab and Control - M.
• Experience in preparing Source-Target Mappings, Functional and Technical design documents.
• Knowledge in developing Star schema and Snowflake schema using Fact Tables, Dimension Tables.
• Excellent experience on implementing Change Data Capture(CDC)techniques and slowly changing Dimensions (SCD)-Type I, II & III.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, XML Files, Mainframe Files and RDBMS systems Oracle, Teradata, SQL Server into a common target area such as Staging, Data Warehouse and Data Marts.
• Performed Administrator roles like Installation, upgrade, User creation and Roles assignment, ETL code Backup, Version Control and Migration in various projects.
• Strong experience in complex PL/SQL procedures, packages, functions, cursors, triggers, views, materialized views.
• Experience in writing Teradata Fload, Mload scripts and automated using UNIX scripts.
• Good experience in using defect tracking tool like JIRA.
• Strong Knowledge in Data Modeling using ERWIN. Used Data Visualization and reporting tools like Tableau, Micro Strategy etc.
• Sound knowledge and understanding of OOP Languages like Java, C++. Worked with Eclipse IDE.
• Worked closely with internal and external customers to meet Development, Implementation and Production support objectives by explaining industry best planning practices and processes.
• Professionally considered to be extremely aggressive and result oriented.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center v9.x/8.x, Informatica Data Quality 9.x/8.x

RDBMS: Oracle 9i/10g/11g/12c, MS SQL Server 2008/2005, MS Access

Operating Systems: UNIX (HP, SUN, IBM), Linux, Windows XP, 2000,2003

Reporting and PM tools: HP ALM, JIRA, Tableau, Micro Strategy

Database Tools: Oracle SQL Developer, TOAD, SQL*Plus, SQL Tools1.6

Web Technologies: HTML, CSS, XML, Java Script

Programming Languages: R, Java, C, C++

Tools: Putty, WinScp, MS Visio, Erwin, MS Office, Visual Studio, Eclipse, SQL*Loader.

Scheduling Tools: Crontab, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

ETL Developer / Data Analyst

Responsibilities:

• Involved in full life cycle software development using Agile Methodology. Participated in client and development team Scrum meetings presiding over development tasks and open critical issues.
• Involved extensively during Business user/client interaction sessions to gather functional and technical requirements and Prepared HLD and LLD documents.
• Implemented Data Profiling and created score cards for the profiled data which need to be analyzed by the analysts.
• Experienced in using Address Doctor, Merge, Labeler, Standardizer, and Parser Transformations in IDQ.
• Created the test strategy document for theTDMprojects and packages. Planned for the required testing components and defined how the testing will be performed.
• Working with different strategies on removing duplicate data by using the Match, consolidated and key generator transformations.
• Responsible for analysis, design and develop of ETL strategies, resolve issues related to data warehouse.
• Executed Linux/UNIX shell scripts jobs as part of ETLTDMtesting. Validated and analyzed the logs of the jobs.
• Performed ETL testing usingTDM(Test Data Management) andInformaticain validating data mapping, data staging validation, data profiling validation, data scrubbing and validating data flow and processing.
• Extensively worked with Source Qualifier, Expression, Aggregator, Joiner, Lookups (Connected / Unconnected), Update Strategy, Union, Normalizer, SQL, Router and Filter Transformations
• Created Mapplets, Reusable Transformations, Reusable Session/Email/Command Tasks to increase the code reusability and maintenance
• Implemented SCD-Type1, Type2 to maintain current and history data in Dimension tables.
• Identifying performance issues in the code and tuning it to complete the jobs within the given SLA time.
• Performance tuning at Informatica and database levels depending on the bottlenecks identified with the jobs.
• Have developed PL/SQL procedures, views and Materialized views that are required for an application based on the Requirement.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Working with the testing team to resolve bugs related to day one ETL mappings before production.
• Written Fload, Mload Teradata scripts to load the data from Unix landing zone by creating jobs.
• Done Query optimization by creating stats and by checking the confidence levels in the Explain plan.
• Maintaining ETL release document for every release and migrating the code into higher environments through deployment groups.
• Creating change request before deploying the code into production to get required approvals from business.
• Creating weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Worked closely with production support team when failure occurs to rectify them.
• Documented test conditions and results from development instances in Unit Test Plan document.

Environment: Informatica Power Center 9.5.1/9.0.1 , IDQ, Informatica Administrator, Oracle 11g, PL/SQL, Toad for Oracle, Oracle SQL Developer, Putty, JIRA, Crontab scheduling, UNIX shell scripting.

Confidential, Boston, MA

Informatica ETL Developer/ Data Analyst

Responsibilities:

• Involved in requirements analysis, design and source system analysis to derive the business logic, validation of data mappings for enhancement releases.
• Responsible for designing the ETL Processes/reports and managing the ETL development efforts in the project. Data Extraction, Transformation and Loading from Source to Target using Informatica Power center.
• Extracted source definitions from databases like Oracle and Flat files into the Power Center Repository.
• Experienced in using Address Doctor, Merge, Labeler, Standardizer, and Parser Transformations in IDQ.
• Working with different strategies on removing of duplicate data by using the Match, consolidated and key generator transformations.
• Extracted data from various source systems like Oracle and flat files as per the requirements and loaded it to SQL Server. Consumed data from csv files and XML files.
• Implemented SCD-Type1, Type2 to maintain current and history data in Dimension tables.
• Involved in Unit, Functional, Integration and System testing and preparation of review documents.
• Extensively worked with Source Qualifier, Expression, Aggregator, Joiner, Lookups (Connected / Unconnected), Update Strategy, Union, Normalizer, SQL, Router and Filter Transformations.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Created Mapplets, Reusable Transformations, Reusable Session/Email/Command Tasks to increase the code reusability and maintenance
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Imported Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Tool set of Informatica.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Involved in the Performance Tuning & Preparation of unit test cases. Resolving if any issues in transformations and mappings.
• Estimating the time lines for implementing the enhancement. Defect fixes related to current/previous releases.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.

Environment: Informatica Power Center 9.5.1/8.6.1 , MS SQL Server 2008, Oracle, Putty, HP ALM, MS Office, UNIX Shell Scripting.

Confidential, Alpharetta, GA

Informatica Developer

Responsibilities:

• Analyzed business, functional and technical requirements to make sure project met expectations.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Created copy books and Data maps for mainframe sources using Power Exchange and imported them into Informatica designer.
• Designed the structure of new database tables incorporated for module enhancement using Entity Relationship Diagrams and Normalization concepts.
• Implemented SCD-Type1, Type2 to maintain current and history data in Dimension tables.
• Developed custom database objects like Tables, Materialized Views, Triggers, Indexes, and Cursors to implement efficient data management techniques.
• Designed and created ER and Data Modeling diagrams using MS VISIO 2008 software.
• Defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, and stored procedures.
• Working with the testing team to resolve bugs related to day one ETL mappings before production.
• Developed an Interface Program to transfer legacy data to the HR/payroll tables using SQL*Loader.
• Participated in performance tuning of existing SQL statements using Oracle cost-based SQL optimizer (CBO) and used Explain Plan for resolving bottlenecks.
• Developed Oracle packages involving cursors and composite data types for backend functionalities.
• Added extensive exception handling to the primitive packages to enhance error handling.
• Performed Physical and logical backup on a frequent basis using Recovery Manager (RMAN) and Oracle export and import utilities.
• Prepared Crystal Reports time estimates. Supported and maintained current Crystal Reports.
• Performed support DBA tasks for taking hot and cold backups. Performed DBA monitoring tasks with the help of various scripts for database monitoring.
• Loaded data in new tables using SQL*LOADER.
• Provided 24*7 supports to Production environment.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Working knowledge and understanding of developing Java web application.
• Developed UI screens using HTML, CSS and JavaScript.
• Connected to backend Oracle database using Java JDBC framework.
• Tuned stored procedures and triggers identified for better performance.
• Created custom table, triggers, stored procedures, functions, packages to modify the existing oracle database.
• Created a series of procedures and functions for loan and facilities transactions.
• Analyzed business functionalities related to back-end database interfaces and utilized PL/SQL developed tool to develop all back-end database interfaces.
• Developed triggers for error handling and to keep track of changes to the fields of tables when changes are made.
• Worked on the stored Procedures, Functions, and Constraints, Tables, Indexes and Tuned queries for performance.
• Created views which require complex joins and quick response time.
• Carried out technical specification documents for back-end and interface with front-end.
• Modified Stored Procedures and Packages using PL/SQL.
• Defined relationships using primary keys for the entities and normalized the entities.

Environment: Oracle 9i, PL/SQL, Toad 8.0, Windows NT, HTML, SQL *Plus, Crystal Reports, Test Advisor, Test Director.