SUMMARY:

• Around 8 years of extensive experience in Information Technology with special emphasis on design and development of ETL Process, building Data Warehouse/EDW, performance on Data Integration Services, Database Testing.
• Expertise in SQL, PL/SQL, T - SQL, Procedures/Functions, Stored Procedures, Triggers, Packages, Index Design and Tuning.
• Experience with on Informatica Power Center 9.x/10.x, Power Exchange 9.x/10.x.& Tableau.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Schema Modeling, Fact and Dimension tables, Pivot Tables.
• Good experience and knowledge on SQL Queries for manipulation of data.
• Experience writing and modifying ETL Design Documentation, Test Results Documentation and Standard Operating Procedures (SOP) documentation.
• Expertise in Data Cleansing at staging level with utilization Informatica PowerCenter.
• Expertise in Performance Tuning, Indexing and Partitioning techniques on sources, targets, mappings and workflows.
• Expertise in defect tracking process, familiar with defect reporting and tracking using defect tracking tool like HP Quality Center 10.
• Implemented Slowly Changing Dimensions Type-1 & 2 Methodology for Accessing the full history of Accounts and Transaction information.
• Expertise on Implementing Complex Business Rules by creating Re-Usable Tasks (Mapplets, Session, Line, Command, and Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Proficient in using Informatica Workflow manager to create Schedule, Control Workflows, Tasks, and Sessions.
• Experience on Debugging of Informatica Mappings for Error Handling, Increasing Session Performance by Identifying and Resolving Bottlenecks at Read, Transformation and writer threads.
• Worked on various Scheduling Tools using Autosys, Control-M and Informatica Scheduler.
• Experience on Documenting Functional Specification Documents, Mapping Details, Data Validations, Test Cases, and Code Migration Reports.
• Hands-on experience in Developing and Supporting Metadata Application, IDQ (Data Quality), Power Exchange etc.
• Experience on Debugging and fixing errors in PL/SQL and T-SQL Stored Procedures, Indexes, Functions, Procedures, and Triggers and Cursors.
• Experience on using the Informatica command line utilities like PMCMD to Control Workflows.
• Involved in Migrating Informatica (Mappings, Workflows) to higher Environments Like Dev, SIT, UAT and Prod.
• Experience in developing Shell Scripts on UNIX and experience with UNIX command line.
• Experience in Scrum framework and its implementation in fast-paced Agile Development environment.
• Good experience in manual testing (Test case design, test data preparation, Test case writing).
• Having telecom domain experience
• Excellent communication, interpersonal skills, quick Learner, versatile, adaptable, team player and detail-oriented with professional work ethic.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter (10.1/9.6.1/9.1/8.6 ).

Database: Oracle 12c/11g/10g/9i/7i, MS SQL Server (2012,2014,2016).

BI/Reporting Tools: Tableau,Crystal Report.

Data Modeling Tools: ER/Studio, ERWIN, Power Designer

Languages: SQL, PL/SQL, UNIX Shell Scripts.

Operating Systems: UNIX/LINUX, Windows, MS Windows Server, MS DOS

Other Applications: Toad, SQL Developer, Control M, Autosys.

Protocol: ODBC, JDBC, OLE DB, TCP/IP

Server: MS SQL Server, LINUX Server

PROFESSIONAL EXPERIENCE:

Confidential, MI

ETL Informatica Developer

Responsibilities:

• Worked in Informatica 9.6/10.1 to perform ETL from various sources to the central data warehouse.
• Involved in gathering the requirements, Design and Development.
• Created high-level, low-level design documents, ETL specification documents, data model document and test document.
• Worked with connected and unconnected look-up and configured the same for implementing complex logic.
• To implement business rules created robust mapping, mapplets and reusable transformation using Informatica Power Center and its different transformation including Joiner, Look-up, Rank, Filter, Router, Expression, Aggregators, Sequence Generator, Sorter, Update Strategy.
• Extensively used ETL to load data from Flat files.
• Unit testing ETL code to ensure it can be delivered and run in a system testing environment.
• Object migration to different environments and managing the releases.
• Extensively usedReusable transformations and Mappletsare built wherever redundancy is needed.
• Help with the analysis of issues raised during QA/UAT/PROD phases and Data Reconciliation.
• Developed Unit test cases and involved in unit test to check for consistency.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion.
• Created Stored Procedures to transform the Data and worked extensively on PL/SQL for various needs of the transformations while loading the data.
• Extensively used dynamic parameters and created workflows, worklets.
• Coordination with project team in various levels of development and testing
• Ensure the ETL code delivered is running, conforms to specifications and design guidelines.
• Good working experience in Tableau Dashboard and extensive uses of Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.
• Build number of UNIX Shell scripts for PL/SQL programs to schedule them on Control M.

Environment: Informatica Power Center 9.x,Oracle, SQL server, XML files, Tableau, UNIX, SQL/PLSQ.

Confidential, Baltimore, MD

Informatica Developer

Responsibilities:

• Worked with the Business Analysts for requirements gathering, business analysis, testing, and project coordination.
• Worked on Data Warehouse concepts like Star-Schema, Snowflake Schema and Fact and Dimension tables.
• Extracted data from Flat files and RDBMS and loaded into TGT Databases by using Informatica Transformations.
• Worked on Informatica Data Quality (IDQ) toolkit, Analysis, Data cleansing, Data Matching, Data Conversion, Exception handling, and monitoring capabilities of IDQ.
• Used Informatica Data Quality (IDQ) to complete initial data profiling and matching/removing duplicate data.
• Implemented Slowly Changing DimensionType-1 andType-2Methodology’s for developing mappings to keep track the historical data.
• Used parallel processing capabilities, Session-partitioning techniques.
• Created Effective Unit Test Cases and Integration Testing to ensure the successful Execution of data loading process.
• Populated or Refreshed Teradata tables using Fast load, Multi load & Teradata Parallel Transporter utilities for loading history data.
• Worked on Teradata Utilities like Fast Load, T-pump, Multi Load and BTEQ.
• Creating Jobs and Job streams using with Autosys scheduling tool to schedule Informatica workflows.
• Involved in Performance tuning activities which includes identifying the potential bottle necks and thereby tuning ETL code for best performance.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development, and Scrum.
• Migrated Informatica Deployment Groups from Development to Test (SIT & UAT) and then to Production Environment.
• Created mappings using pushdown optimization to achieve good performance in loading data into RDBMS. And Used Hints and Indexes for query optimization.
• Extensively written Unix shell scripts for automation of the ETL Jobs using Autosys.

Environment: Informatica Power Center 9.5.1, Data Quality(IDQ), Oracle 11g/10g, Teradata, XML, SQL Server 2008, PL/SQL, and Autosys.

Confidential - GlendaleCA

ETL Informatica Developer

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Maintain Data Flow Diagrams (DFD's) and ETL Technical Specs or lower level design documents for all the source applications
• Worked with source databases like Oracle, SQL Server and Flat Files
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations
• Created complex mappings using Unconnected and Connected lookup Transformations
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts
• Worked with various Informatica PowerCenter objects like Mappings, transformations, Mapplet, Workflows and Session Tasks
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level
• Worked extensively with update strategy transformation for implementing inserts and updates
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre-session commands
• Extensively used debugger to test the logic implemented in the mappings
• Performed error handing using session logs
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if anything is abnormal
• Monitored workflows and session using PowerCenter workflows monitor
• Used Informatica Scheduler for scheduling the workflows

ENVIRONMENT: Informatica Power Center 8.5 / 8.6.1, Oracle 9i, Sql Server, Sybase, DB2, SQL, PL/SQL, Cognos, Cron Job, Unix windows.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Involved in designing the process for getting the data from all systems to Data Warehousing system.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 9.1.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Collection of data source information from all the legacy systems and existing data stores.
• Worked on large volumes of Mainframe data extraction.
• Involved in Data Extraction, Transformation and Loading from source systems to ODS.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used various transformations like Unconnected /Connected Lookup, Data Masking, Aggregator, Expression Joiner, Sequence Generator, Router etc.
• Responsible in the development of Informatica mappingsand also tuned for better performance.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Worked with Reporting team which utilizes Business Object tools for objects and to address their need from ETL point of view.
• Extensively used Dynamic lookup to implement the type 2 changes.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy using the concepts of Change Data Capture (CDC).
• Utilized Mload, Fast Load utility of the Teradata to load data in the Teradata Enterprise Data warehouse (EDW).
• Used PMCMD commands of Informatica in UNIX scripts to schedule workflows and jobs.

Environment: Informatica Power Center 9.1.1, IDQ 9.0.1, Teradata, Oracle 10g/11g, DB2, Toad, Erwin, Control M, Business Object 6.0, UNIX, Windows

Confidential, Cleveland, OH

ETLInformatica Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirement for database changes, ETL, Business Reports.
• Extracted Data from different source systems like Oracle, MySQL and Flat Files.
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO DATE, Decode, and IIF functions in Expression Transformation.
• Worked with various transformations in Informatica power centre like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Worked with PL/SQL to create complex queries, function, store procedures, trigger etc.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Performance tuning of SQL scripts using Oracle Explain Plan.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Reviewed and tested Informatica ETL code and wrote test plans.
• Responsible for 24/7 Informatica production support.
• Involved in various meetings, seminars, presentations and group discussions.

Environment: Informatica Power Center 8.6.1, Oracle 11g, MySQL, SQL, Pl/SQL, TOAD, Erwin, SQL SERVER,SSIS, Shell Scripts, Unix, Windows.

Confidential, Lake Forest - IL

Informatica consultant (ETL Developer)

Responsibilities:

• Led the Data Integration team to drive detailed ETL and data requirements to ensure accurate capturing of client's business requirements and deliverables.
• Involved in strategy development, project planning, and resource planning, allocation and budget management.
• Acted as the Subject Matter Expert for ETL and Sales Comp.
• Collaborated with IT and Business Teams to gather high-level Integration/Compensation requirements.
• Designed and built ETL solutions to automate the data feeds from client systems
• Go to guy on all data integration project related questions in Professional Services
• Took the lead on building custom Process Queuing system for the data Integration processes giving customers the visibility into the current of their processes.
• Worked with Cross Functional Teams on various initiatives.
• Involved in all phases of our company’s evolution from a Start Up to an Enterprise.
• Extensively worked on standardizing our methodologies to meet the industry standards with focus on quality, scalability and reusability.
• Always lived up to our Core values of CARE (Customer Focus, Accountability, Respect and Excellence).

Environment: Informatica Power Center 9.0, Oracle 10 g, Flat files, Git migration, STASH, UNIX, Shell Scripting, JIRA