SUMMARY:

• To obtain a position as Informatica Developer with advancement potential in a progressive institution which will allow me to utilize my knowledge and skill to design, develop and deploy efficient ETL process to build powerful Data warehouse.
• 9+ 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.
• 7+ years of experience utilizing Informatica Power Center in all the phases of the Data Warehouse Life Cycle involving design, Development, Analysis.
• Expertise in SQL, PL/SQL, T - SQL, Procedures/Functions, Stored Procedures, Triggers, Packages, Index Design and Tuning.
• 2+ years of experience as QA Analyst/Test Engineer on Manual and Automation Testing using ALM, JIRA, Bugzilla, Quality Center, QTP, Selenium.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Schema Modeling, Fact and Dimension tables, Pivot Tables.
• Expertise in Data Cleansing at staging level with utilization Informatica Power Center.
• Extensive experience in Data warehousing tools Informatica Power Center using different modules like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience in integration of various data sources like Oracle, Teradata, Netezza, SQL server, SAP, Sybase, Informix, MQ series and XML, Flat files, Mainframes, XML files and Scheduling tools like Control-M, Autosys and Informatica Scheduler.
• Expertise in Performance Tuning, Indexing and Partitioning techniques on sources, targets, mappings and workflows
• Experience writing and modifying ETL Design Documentation, Test Results Documentation and Standard Operating Procedures (SOP) documentation.
• 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.
• Hands-on knowledge of Software Testing as Quality Assurance Analyst/Performance Test Engineer and related matters.
• Have good communications, management and problem solving skills with self-motivation, ability to working dependently or cooperatively in a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center (10.1/9.6.1/9.1/8.6 ), Informatica Power Exchange (10.1,10.0,9.6.1,9.5.1), SSIS (SQL Server 2012, 2014)

Database: Oracle 11g/10g/9i/7i, MS SQL Server (2012,2014,2016), Teradata, DB2-UDB, Informix, Netezza

BI/Reporting Tools: Tableau, SSRS, OBIEE, Pentaho, Business Objects, Crystal Report, Micro Strategy

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

SQL, PL/SQL, T: SQL, UNIX Shell Scripts, Java, VB Scripts

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

Other Applications: Toad, SQL Developer, Visual Studio, MS Visio, Control M, Autosys, JIRA,QC

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

Server: MS SQL Server, LINUX Server

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, San Antonio, TX

Responsibilities:

• Worked with business analyst to understand business requirement in order to transform business requirements into effective technology solutions. Also involved in robust teamwork with Managers, Architects and Data Modelers to understand the business process and functional requirements.
• Created high-level, low-level design documents, ETL specification documents, data model document and test document.
• 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.
• Improved and enhanced various jobs in different cycles by creating reusable and common job techniques, extensively used parameters at run time to push in job related parameters.
• Worked with connected and unconnected look-up and configured the same for implementing complex logic.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping. Enhanced Performance on Informatica sessions using large data files by using partitions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion
• Managed the authenticity of jobs by checking-in & checking-out code from Star Team code versioning tool.
• Worked in SSAS Packages (Cube) development, processing and validating the cubes.
• Developed business object reports like universe, crystal reports for business validation.
• Worked with Offshore team to oversee the development activity, reviewed code to make sure it confirms the standard programming practice at Confidential .
• 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 10.1/9.6, Power Exchange 10.1/9.6, Oracle 11g, Teradata 14SQL/PLSQL, IDQ, SQL Server 2014, UNIX/LINUX, Tableau, Control M, Putty, Rally.

Informatica Developer

Confidential, Baltimore, MD

Responsibilities:

• Developed Data Flow diagrams to create Mappings and Test plans from OLTP systems staging to Data warehouse.
• Designed and developed Mappings from OLTP to Stage and Stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Connected and Unconnected Lookup, Normalizer, Update Strategy etc.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, SQL Server, Flat files and loaded into target.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping. Enhanced Performance on Informatica sessions using large data files by using partitions.
• Worked with Static cache, Persistent cache, Dynamic cache, Index cache, Data cache.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Build number of Unix Shell scripts for PL/SQL programs to schedule them on Control M.
• Assisted the development team to design standards and codes for effective ETL procedure development and implementation.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Validate the data in source and target systems using PL/SQL queries.

Environment: Informatica Power Center 9.6, Power Exchange 9.6, Oracle 11g, Teradata 14, SQL/P SQL, IDQ, SQL Server 2012, AIX, Windows XP, LINUX, UNIX, Putty, Rally, Autosys.

Informatica Developer

Confidential, Minnesota, MN

Responsibilities:

• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensive use of ETL process to load data from different RDBMS, XML and flat files.
• Used Informatica Repository Manager to create repositories and users and set permissions.
• Experience in Performance tuning of SQL queries and mainframe applications.
• Involved in Data Extraction from Oracle, Flat files, Mainframe files using Informatica.
• Debugged the mappings extensively, hard coding the test data to test the logics going instance by instance.
• Handle the migration process from Development, Test and Production Environments.
• Implemented Type 2 slowly changing dimensions to maintain dimension history and tuned the mappings for Optimum Performance.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation
• Used Informatica Designer to design mappings and coded it using reusable mapplets.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Involved in unit testing and documenting the jobs and work flows.
• Set Standards for naming conventions and best practices for Informatica mapping development.
• Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
• Created various UNIX shell scripts for Job automation of data loads
• Created mappings which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs

Environment: Informatica Power Center 8.6/9.1, Oracle 11g, Oracle Data Integrator, SQL, PL/SQL, SQL Developer, IDQ, ERwin, MS VISIO, Autosys, QC, LINUX, UNIX.

Informatica Developer/ ETL Developer

Confidential, Cleveland, OH

Responsibilities:

• Extracted and transformed data from Flat Files and Oracle and then loaded into Oracle using Informatica Power Center.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool, which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplets Designer.
• Developed mappings for the Initial loads of the dimensions and incremental loads including Type1 and Type2.
• Utilized Slowly Changing Dimensions. Created corresponding workflows and sessions and various transformations like Source Qualifier, Expression, Filter, Joiner, Router, Lookup (Connected and Unconnected, Static and Dynamic cache) and Aggregator were used.
• Wrote SQL overrides in Source Qualifier and Lookups according to business requirements.
• Involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively
• Worked on performance tuning for ETL processes.
• Created mappings using Unconnected, Connected Lookup and Aggregate transformations for populating target table in efficient manner.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extracted data from different sources like Oracle and Flat files and loaded the data into DWH.

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.6, Oracle 10g, Oracle Data Integrator, SQL, PL/SQL, SQL Developer, Erwin, Oracle Designer, MS VISIO, Autosys, QC, LINUX, UNIX.

ETL Test Engineer

Confidential, Virginia Beach, VA

Responsibilities:

• Analyzed the Business Requirements Document, Functional Specifications documents to prepare Test Cases based on the Test Plans and Use Cases.
• Created and executed SQL queries to fetch data from database server to validate and compare expected results with those actually obtained.
• Write complex SQL queries to validate loaded data in the EWD according to the implemented logic.
• Tested data imported from various sources like Oracle, MS SQL Server, Teradata, XML files.
• Validate Data Warehouse schema, Informatica ETL and BI changes for Dish and Sling EDW
• Write complex Teradata SQL queries to validate data loaded in the Enterprise Data Warehouse against the logic implemented in Informatica mappings
• Work with data coming from various sources (Oracle, Teradata, Netezza, ASCII and XML files)
• Experience in creating Excel VB Macros and Pivot Tables for reporting and analysis
• Assist other analysts and developers by debugging defects and performing root cause analysis
• Used SQL queries and UNIX Shell scripts to check the database integrity.
• Performed report generation & defect tracking activities by using Quality Center.
• Used TOAD Software for Querying Oracle. And Used Teradata SQL Assistant for Querying Teradata.

Environment: SQL/PL SQL, Toad, SQL Developer, Oracle 10g, SQL Server 2008, Shell scripting, UNIX/LINUX, Quality Center.