SUMMARY:

• 8 Years of IT experience in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing, Maintenance and testing and Data Warehousing implementations across various domains.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• 6+ years of Strong expertise in using ETL Tool Informatica Power Center 9.6.1/9.0.1/8. x (Designer, Workflow Manager, Repository Manager, Data Quality (IDQ 9.6.1/IDQ 8.x)
• Strong experience with Informatica tools for incremental load like Change Data Capture (CDC), MD5 etc.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked with Teradata utilities like Fast Load, Multi Load, Tpump, Teradata Parallel transporter and highly experienced in Teradata SQL Programming.
• Experienced in Teradata Parallel Transporter (TPT). Frequently used full PDO on Teradata and worked with different Teradata load operators.
• Designing and developing Informatica mappings including slowly changing dimensions (SCD) type 1 and Type 2.
• Validating data files against their control files and performing technical data quality checks to certify source file usage.
• Very good in data modeling knowledge in ER and Dimensional Data modeling, Star / Snow - flake Schema, Fact / Dimensions tables.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Package, Functions, Triggers, Views, and Materialized Views.
• Experienced in using advanced concepts of Informatica like push down optimization (PDO).
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from different data sources like Multiple Relational Databases (ORACLE 12c/11g/10g, Teradata 14/13, Netezza, DB2, SQL server 2012, Informix, MySQL, JSON, XML, Flat files
• Experience in using Automation Scheduling tools like Control-M and Autosys
• Worked with various transformations like Normalizer, expression, rank, filter, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, Union, CDC etc.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Experience in preparing different types of project related document like ETL Specification, Source to Target Mapping, Test Case, Design document, scheduling, deployment, training document etc.,
• Experience in working with Agile environment for many years using Rally, Icescrum, JIRA etc.
• Excellent domain knowledge of HealthCare, Retails and Telecommunication.
• Good skills in defining standards, methodologies and performing technical design reviews.
• Committed team player. Ability to adapt to changing professional work environment to implement software solutions in an efficient manner.

TECHNICAL SUMMARY:

ETL Tools: Informatica 9.6.1/9.1/8.6.1 ,Informatica Data Quality IDQ, SSIS

Data Modeling Tools / methodology: ERWIN 9.5.2/7.3/4.1 , MS - Visio. Ralph Kimball and Bill Inman Methodology

Databases: Oracle 11g/10g/9i, Teradata 14/13, MS SQL Server 2008/2005, DB2, MS Access 2008, Sybase

Environment: Windows family, UNIX

Job Scheduling: Control-M, Autosys

Reporting Tools: Tableau 10/9x, Excel

SDLC: Waterfall, Agile, TD

Others: Notepad++, Teradata SQL Assistant, Teradata view point MS office, T-SQL, TOAD, SQL Developer, XML Files, Rally Icescrum, JIRA, PL/SQL Developer, Bugzilla, Toad, SQL Navigator

PROFESSIONAL EXPERIENCE:

Confidential, Allen, TX

ETL Sr. Informatica Developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Designed and developed ETL Informatica mappings. Scheduled and Managed Informatica sessions.
• Extracted large volumes of data form Mainframes systems to target DB2 database.
• Extensively worked on Performance tuning of queries. Complex SQL queries are used for data retrieval.
• Designed, Developed and Deployed UNIX shell scripts.
• Development & Implementation of a data warehousing project and production support for enhancements and maintenance.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Coordinated and worked closely with architects, operations, and business units to build and deploy.
• Implementing data quality management solutions that manage millions of customer transactions.
• Configuration and Administration of Informatica Servers.
• Oversee the technical design of the data warehouse, optimizing for scale and performance.
• Performed systems, data quality assurance, system testing, ensuring that software and systems perform to specification
• Established test environments and test data and advocate the use of common re-usable functions, services and data
• Participated in quality assurance activities like reviews, walkthroughs etc.
• Performed extensive risk assessment prior to production implementations and carried out validations for post implementation to ensure successful execution monitoring performance.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica PowerCenter 9.6.1, IDQ 9.6.1, Tableau 10, Oracle 11g, Teradata 14.1.0, Teradata SQL Assistant, SQL Server 2012, DB2, Erwin 9.2, Control M, Putty, Shell Scripting, WinSCP, Notepad++, Rally, JIRA

Confidential, Tampa, FL

ETL Informatica Developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created mappings for initial load in PowerCenter Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, and Union.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Involving in extracting the data from Oracle and Flat Files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Experience in analyzing business specification documents, developing test plans defining test cases, developing and XML test scripts.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica PowerCenter 8.6.1, Tableau 9.2, Cognos 9, SQL Server 2008, IDQ 8.6.1, Oracle 11g, PL/SQL, TOAD, Putty, Autosys Scheduler, UNIX, Teradata 13, Erwin 7.5, WinSCP

Confidential, Dallas

ETL Informatica Developer

Responsibilities:

• Analysis, requirements gathering, functional/technical specification, development, deploying and testing.
• Significant Multi-dimensional and Relational data modeling experience with modeling tool like ERWIN with a strong emphasis on data Warehouse/data Marts analysis, design, and implementation.
• Extensive use of Informatica Tools like Designer, Workflow Manger and Workflow Monitor.
• Extensively used Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, and Informatica Server Manager.
• Extracted source data from Oracle, SQL Server, Flat files and XML using Informatica, and loaded into Oracle or flat file targets.
• Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, sequence Generator.
• Developed, tested stored procedures, functions in PL/SQL
• Created reusable transformations and mapplets to use in multiple mappings
• Used Workflow Manager/Monitor for creating and monitoring workflows and worklets.
• Improved the session performance by pipe line partitioning
• Extensively used mapping parameters, mapping variables and parameter files
• Analyzed the query performance and designed the loading process schedules
• Created sessions and batches for various mappings and automated using UNIX shell scripts.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading.
• Involved in troubleshooting the loading failure cases, including database problems.

Environment: Informatica Power Center 8.1, SQL, PL/SQL, UNIX, Shell Scripting, SQL Server 2008, Sybase, Oracle 11g, DB2, Control-M, MicroStrategy 9

Confidential, Schaumburg, IL

ETL Informatica Developer

Responsibilities:

• Understand the problem description stated in BRD and design and write ETL Specifications
• Designing the ETL jobs using Informatica tool to load data from ORACLE 9i to Netezza Database
• Designing and reviewing the ETL solutions in Informatica Power Center 8X
• Based on the requirements, created Functional design documents and Technical Design specification documents for ETL Process.
• Worked as ETL Developer involved in the development of ETL process using Informatica to load data from source oracle database into the target oracle database and flat files.
• Designing and optimizing the Mapping to load the data in Slowly Changing Dimensions.
• Involved in Performance Tuning at various levels including Target, Source and Mapping.
• Used Debugger to gain troubleshooting information from the mappings.
• Worked on Migration from Dev environment to Test Environment.
• Write Test Cases and perform integration testing
• Writing SQL queries to generate the data files for Testing/validation
• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed schema model for target database using Erwin Data modeling.
• Designed and developed Context for faster development, standardization and reusability purposes.
• Involved in pre and post session migration planning for optimizing data load performance.
• Understanding client process to work efficiently and deliver solutions in accordance with Confidential quality control standards and business practices and procedures.
• Have developed a level of competency, which helps to anticipate issues solve them in advance.
• Involved in analyzing, resolving and providing temporary fix for the Data Issues Also had to interact with the business users to intimate and do the recovery steps if there is any problem in the process
• Deployment to various servers & Migration activities.

Environment: Informatica Power Center 8.1, SQL, Windows 2008, UNIX, SQL Server 2000, Oracle 9i, Netezza, Flat files, SQL *Plus, Business Objects 5.1.6