Summary:

• Around 8 Years of IT Experience in analysis, design, development, implementation and troubleshooting of Data Mart Data Warehouse applications using ETL tools like Informatica power center 9.5/9.1/8.6/7.1/6.1 and power exchange 8.6.
• Strong experience in Data Warehousing ETL OLAP environment and acquired excellent analytical, co-ordination, interpersonal skills, have immense leadership potential.
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.
• Expertise in Data Flow Diagrams, Process Models and ER diagrams with modeling tools like ERWIN r 7/4/3.5 MS VISIO 2007/2010
• Adept at understanding Agile software development methodologies and framework.
• Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse using Informatica Power Center 9.5/9.1/8.6 and 7.1.
• Good Understanding of relational database management systems, experience in integrating data from various data source like Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008/2012, Teradata 13/12/V2R5, Flat files and XML into staging area
• Experienced in Administration setup like manage Users, Security Controls and Data Management Proficient in server side programming like stored procedures, stored functions, database triggers, packages using SQL
• Experience in implementing Slowly Changing dimension methodology SCD for accessing the full history of accounts and transaction information.
• Experience in implementing complex business rules by creating transformation, re-usable transformations Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy , and developing complex Mapplets, Mappings, and Triggers
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Experienced with Teradata utilities BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, PMON, and Visual Explain .
• Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experienced in creating mappings, task flow using Informatica On Demand tool IOD . Worked on Data synchronization tasks.
• Erudite in writing SQL quires and developing view and stored procedures in Teradata.
• Extensive knowledge with Teradata SQL Assistant, PUMP, Fast Export, Fast Load, Multiload, BTEQ, Coded complex scripts for the Teradata Utilities and finely tuned the queries to enhance performance.
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server
• Experience in data integration, cleansing and massaging.
• Extensively used Repository Manager, Designer, workflow manager, workflow monitor Client tools of Informatica
• Experience in UNIX shell and batch scripting, Perl, FTP and file management in various UNIX/Windows environments.
• Performed unit testing at various levels of the ETL.
• Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident.
• Proficiency in writing technical documentation to describe program development, logic, coding, testing, changes and corrections.

Technical Knowledge:

Professional Experience:

Confidential

Senior ETL Developer

Confidential is one of the world's leading medical technology companies. The company offers a diverse array of innovative medical technologies, including reconstructive, medical and surgical, and neuro technology and spine products to lead people more active and more satisfying lives

Roles Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures, Involved in the complete life cycle of the project
• Developed FRD Functional requirement Document and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis
• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin
• Extracted data from various data sources such as Oracle 11g, Flat files, DB2 10.5 and transformed and loaded into targets using Informatica
• Created users, groups and gave read/write permissions on the respective Folders of repository.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Application Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Used mapping parameters and variables
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Performed the data validations and control checks to ensure the data integrity and consistency
• Used debugger to trace errors in the mapping
• Created deployment groups in one environment for the Workflows, Worklets, Sessions, Mappings, Source definitions, Target definitions and imported them to other environments
• Performed Upgrading Informatica Power center Version 8.6 to Informatica Power center 9.0
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Involved in migration of ETL code from development repository to testing repository and then to production repository
• Created and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer
• Queried against the Oracle Database to retrieve Millions of records using PL/SQL
• Development of PL/SQL blocks and multi-thread Pro C programs for ETL purposes
• Used PL/SQL programming in backend and front-end functions, procedures, packages Used set explain utility for collecting detailed SQL query plans and execution statistics using Informix
• Developed UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency
• Worked on SQL optimization. Identified bottlenecks and performance tuned the Informatica mappings/sessions
• Created various documents including high-level design documents, mapping documents and knowledge transfer documents
• Prepared Run book for the daily batch loads giving the job dependencies and how to restart a job when it fails for ease of handling job failures during loads
• Reviewed the Testing progress and issues to be resolved by conducting walkthroughs
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis
• Responsible for regression testing ETL jobs before test to production migration
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle

Environment: Informatica Power Center 9.0/8.6, WINSCP, HPQC, Oracle 11i/10g, DB2 10.5, Flat Files, Autosys, TOAD, SQL, PL/SQL, Windows XP, UNIX.

Confidential

Senior Informatica Developer

Confidential Company, it is a leader in delivering broadband and other wire line and wireless communication innovations to mass market, business, government and wholesale customers.

Roles Responsibilities:

• Co-ordinated Joint Application Development JAD sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Scrutinize functional requirements, specifications and source to target mapping documents, identifying underspecified requirements and other design challenges
• Prepared the required application design documents based on functionality required.
• Created logical and physical data models using Erwin and created Entity Relationship ER diagrams based on requirements.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems SQL server, Oracle, Flat files
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Involved in migration of Informatica from 7.1 to 8.6
• Used BTEQ, SQL Assistant Query man front-end tool to issue SQL commands matching the business requirement to Teradata RDBMS
• Created Scripts using Teradata utilities Fast load, Multi load, Fast export
• Performed data validation, reconciliation and error handling in the load process
• Used Fast Load for loading the data into the empty tables.
• Coded Multi Load scripts to load the data into different tables.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Designed and developed UNIX Shell scripts for creating, dropping tables which are used for scheduling the jobs.
• Manage and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Use the SQL query against database to test and validate informatica mappings.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Involved in manual testing of Informatica mappings.
• Involved in reviewing the informatica mappings and documented any flaws
• Scheduled various daily and monthly ETL loads using Control-M
• Member of On call team for providing support for daily and weekly batch loads
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica Power Center 8.6/7.1, Erwin r4 , Teradata 12, Teradata SQL Assistant, BTEQ, TPUMP, PL/SQL, SQL Server 2008, DB2, Control M, UNIX Sun Solaris 2.8 , XML, MS-Visio, MS-Project, Clear Case, TOAD.

Confidential

Informatica Developer

Confidential is a leading provider of communications services connecting individuals through cloud-connected devices worldwide. It provide feature-rich, affordable communication solutions that offer flexibility, portability and ease-of-use for both landline and mobile phones

Roles Responsibilities:

• Worked closely with Business Analysis team, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files and Relational Database.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, and Sequence generator, Sorter, Joiner and Update Strategy.
• Used Parameter files to define values for parameters and variables used in the mappings and sessions.
• Dropping and re-creating Indexes on the database Target table using pre-Sql and post-Sql techniques while loading huge tables.
• Created Sessions and Worklets in Workflow manager having event tasks like e-mails.
• Worked on performance tuning by finding out the bottlenecks in various mappings.
• Unit testing self and other mappings before deploying the code for QA testing by creating scenarios based on the business requirement
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Designed new Informatica mappings which extract data from PDM system and load into DSS systems.
• Involved in creating Autosys Jobs which call Informatica Workflows, which run in the supply chain environment.
• Worked with Informatica Power Exchange DB2 version .
• Played a key role in day to day production support of the Informatica batch.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 8.6/8.1, Power Exchange 8.1, Toad 9.1, Oracle 10g / 9i, PL/SQL, Autosys Scheduler, SQL LOADER and Unix Script.

Bernhardt Furniture Company, Lenoir, NC Oct 10-Jan 12

ETL Developer

Confidential needs with a diverse product line that provides a wide range for Traditional and Contemporary styles. This project majorly includes maintaining the web pages and controlling of payment and creating of Hyperlinks using .net technologies

Roles Responsibilities:

• Analyzed various schemas for implementation and modeled the Data Warehousing Data marts using Star Schema.
• Created mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data from flat files and oracle database, applied business logic to load them into the central oracle database.
• Developed complex mappings mapplets in Informatica to load the data using different transformations.
• Created and monitored Sessions and Batches using Server Manager.
• Used various performance tuning techniques to improve the session performance Partitioning etc .
• Successfully moved the Sessions and Batches from the development to production environment.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Generated completion messages and status reports using Workflow manager.
• Created workflows and worklets for designed mappings.
• Developed mappings and loaded data into relational database. Worked on Dimension as well as Fact tables.
• Extensively used PL/SQL procedures and functions to build business rules.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better performance.
• Scheduled the batches using UNIX.
• Worked to parameterize all variables, connections at all levels in UNIX.

Environment: Informatica Power Center 7.1.4, Cognos, Oracle9i, Toad 8.6, UNIX, HP-UX 11i, Sun Solaris 5.4, SQL, FACETS 4.X, MS Office Visio 2003.

Confidential

Senior Programmer Analysts

Confidential is an IT services and software development company. It provides quality information technology services to our clients with a blend and breadth of industry experience and talent available at our offshore delivery center

Roles Responsibilities:

• Studied data sources by interviewing users.
• Worked with software engineers and database engineers to ensure the overall application design is optimal.
• Wrote database scripts for user management and roles.
• Created, monitored and maintained Oracle databases.
• Created Table spaces for Data and Indexes.
• Used data base objects like materialized view, sequence generators, parallel partitioning and stored procedures for accomplishing the complex logical situations
• Configured ODBC connectivity for new instances and clients.
• Formulated optimization strategies based on performance cost and rules.
• Built database tools and scripts that enable automation of tasks.
• Developed, managed and tested back-up and recovery plans

Environment: Visual Basic 6.0, Oracle 8i, PL/SQL, Crystal Report 6, Erwin, Windows NT

Confidential

Programmer Analyst

Confidential is a global diversified outsourced IT services company which brings offshore outsourcing to clients' doorstep. VESTIACO has extensive experience in providing outsourcing non-core business processes - IT functions software development, product development, SharePoint consulting and development, mobile app development, software testing, managed IT services, cloud computing solutions

Roles Responsibilities:

• As a part of 3-member team was involved in discussing Functional Requirement Document FRD .
• Created Tables, Indexes, Sequences, Clusters, Triggers, Procedures, Functions and Packages.
• Re-organization of databases and managing the databases for optimum performance levels.
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned for better performance
• Performing SQL query optimization using hints, Indexes and Explain plan.
• Effectively used views to prevent unauthorized access.
• Used Ref Cursors for faster retrieval of information.
• Involved in writing Functional and Technical documents.
• Created some Custom reports and forms for the end users to check the details and errors.

Environment: Oracle 9i, PL SQL, SQL server, MS Excel, MS Access, Windows XP.