SUMMARY:

• Around 6+ years of IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL Server databases, Informatica Power Center 10.x/9.x/8.x/7.x, Informatica Data Quality, etc.
• Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor
• Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, Stored Procedure, XML Parser, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.
• Extensively worked on Relational Databases Systems like Oracle11g/10g/9i/8i, MS SQL Server, Teradata and Source files like flat files, XML files and COBOL files
• Excellent background in implementation of business applications and in using RDBMS and OOPS concepts.
• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities using IDQ 9.6.1.
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis, and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional data modeling.
• Experienced in mapping techniques for Type 1, Type 2, and Type 3 Slowly Changing Dimensions
• Hands-on experience in Informatica upgrade from 8.6 to 10.2.0
• Extensive experience in debugging mappings, identifying bottlenecks/bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations
• Solid experience in implementing business requirements, error handling, job control & job auditing using Informatica Power Center tools
• Strong experience in SQL, PL/SQL, Tables, Database Links, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Joins, Unions, Cursors, Collections, and Indexes in Oracle
• Sound knowledge of Linux/UNIX, Shell scripting, experience in command line utilities like pmcmd to execute workflows in non-windows environments
• Proficiency in working with Teradata utilities like (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, PMON, Visual Explain).
• Implemented change data capture (CDC) using Informatica power exchange to load data from clarity DB to TERADATA warehouse.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server, MS Access, Teradata, Flat Files, XML files and other sources like Salesforce, etc.
• Experience in Migrating Data from Legacy systems to Oracle database using SQL*Loader
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts, Linux Scripts and scheduling tool (Control-M v7/v8), CA WA Workstation (ESP)
• Expert in analyzing Business & Functional Specifications, creating Technical Design Document and Unit Test cases
• Experience in Performance Tuning of targets, sources, mapping, workflow, and system.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Involved in SDLC- software development life cycle (Water, Scrum/Agile) of building a Data Warehouse on windows and Unix Platforms.
• Well versed with onsite/offshore project delivery model and experience in working with offshore teams
• Designed Applications according to the customer requirements and specifications.
• Excellent Interpersonal and Communication skills coupled with strong technical and problem-solving capabilities.
• Excellent analytical, problem solving, technical, project management,, and presentation skills.

TECHNICAL SKILLS:

Operating System: UNIX, Linux, Windows

Programming and Scripting: C, C++, Java, .Net, Perl Scripting, Shell Scripting VBA, PL/SQL, T-SQL.

Specialist Applications & Software: Informatica Power Center 10.2.0/10.1.1/9.5/9.1/8.6/8.1/7.1 , Informatica Power Exchange, Metadata Manager, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), SSIS, Salesforce, DataStage, etc.

Databases tools: SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6 (Oracle), Teradata, AQT v10 (Advanced query tool) (Oracle/Netezza), DB Artisan 9.0 (Sybase), SQL Browser (Oracle Sybase), Visio, ERWIN

Scheduling tools: Informatica Scheduler, CA Scheduler (Autosys), ESP Maestro, Control-M.

Conversion/Transformation tools: Informatica Data Transformation, Oxygen XML Editor (ver.9, ver.10)

Software Development Methodology: Agile, Waterfall.

Domain Expertise: Insurance/Finance

RDBMS: SQL, SQL*Plus, SQL*Loader, Oracle11g/10g/9i/8i, Teradata, IBM DB2, UDB 8.1/7.0, Sybase 12.5, Netezza v9, MS SQL Server 2000/2005/2008 , MS Access 7.0/2000.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Analyze functional, business requirements and in scrum meeting provide detail description about task.
• Talk about the milestones, issues and roadblocks faced during the development process.
• Attend’s daily scrum meetings and provide the status of the tasks that are assigned.
• Design, develop, configure, deploy, program and implement software applications, packages and components customized to meet specific needs and requirements.
• Focusing on ETL (Extract, Transform and Load) Processes.
• Develop multiple tables relevant to the project comes and useful when multiple requirements come off the same structure.
• Design a structure and schedule a job to load the data into table and virtual tables to test and analyze the structure and the data loaded into the table.
• Develop mappings, workflows and monitor the results using Informatica PowerCenter tool to meet the requirements.
• Converted the code in DJ/ Pervasive tool in to Informatica Mappings. Also, converted the VBA code in to Informatica.
• Write queries in the Advanced Query Tool to check the results of the data loaded into the table.
• Extensively worked with different transformations such as Expression, Aggregator, Sorter, Joiner, Router, Filter, and Union in developing the mappings to migrate the data from source to target.
• Used connected and Unconnected Lookup transformations and Lookup Caches in looking the data from relational and Flat Files. Used Update Strategy transformation extensively with DD INSERT, DD UPDATE, DD REJECT, and DD DELETE.
• Modify Business logic code to the changed requirement of the client.
• Modify existing mappings as per the updates.
• Modify design documents and update the share point document to reflect the changes.
• Perform test plan preparation, unit and system testing.
• Create the test data for the analyzed dataflow.
• Modify code where required, to perform actions faster.
• Debug each of the Unit tests to check if the modified code flows run as desired.
• Review, repair and modify programs to ensure technical accuracy, security and reliability of programs.
• Perform troubleshooting, code migration, code review and bug fixing.
• Provide quality documentation, status updates and support

Environment: Informatica Power Center 10.2.0, DB2, Advanced Query Tool V.10, Control-M

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Communicated with business customers to discuss the issues and requirements.
• Developed ETL programs using Informatica to implement the business requirements.
• Developed several IDQ complex mappings in Informatica a variety of Power Center, transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using Informatica Power Center.
• Used Informatica Power Center to load data from different data sources like xml, flat files and Oracle, Teradata, Salesforce.
• Imported the IDQ address standardized mappings into Informatica Designer as a Mapplets.
• Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in maintenance and enhancements activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions) Type 1 and Type 2
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, and Aggregator Transformation.
• Involved in creating UNIX shell scripts for Data stage job and Informatica workflow execution.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Used the Teradata fast load utilities to load data into tables
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Converted all the jobs scheduled in Maestro to Autosys scheduler as the per requirements
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (workflows)
• Performed tuning of queries, targets, sources, mappings, and sessions.
• Used Linux scripts and necessary Test Plans to ensure the successful execution of the data loading process
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Identified problems in existing production data and developed one-time scripts to correct them.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Provided 24x7 production supports for business users and documented problems and solutions for running the workflows.

Environment: Informatica Power Center 9.6.1, UNIX, SQL, IDQ, CDC, Linux, Perl, WINSCP, Shell, PL/SQL, Netezza, Maestro, Teradata, Salesforce, Microsoft SQL Server 2008, and Microsoft Visual studio

Confidential, Irving, TX

ETL / Informatica Developer

Responsibilities:

• Used Informatica Power Center v9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Productively used Informatica tools - Informatica Repository Manager, Informatica Power Center Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Using the concept of Slowly Changing Dimensions, complex mappings were created. Involved implementation of Business logic and capturing the deleted rows in the source origination.
• Worked extensively with the connected lookup transformations with the dynamic cache enabled.
• Developed several reusable transformations and Mapplets, which were used in other mappings.
• Created sessions and extracted data from various sources.
• Transformed the data according to the requirement and loading into the data warehouse.
• Involved in creating various mappings in the Informatica power center designer.
• Used Informatica Power Center for extractions, transformation, and loading data from heterogeneous sources into the target databases.
• Worked extensively on different complex mappings using transformations like Source qualifier, expression, Router, filter, update strategy, Connected and Un-connected lookup, Normalizer, joiner, Aggregator, Update strategy.
• Extracted Data from different Source Systems like Oracle, Teradata and Flat files.
• Experienced in optimizing the SQL queries to improve the performance.
• Experience on Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Dimensions, Facts and Star, Snowflake Schemas and ER modeling.
• Responsible for Unit testing, System and Integration testing.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data
• Identified and fixed performance bottlenecks and tuned the Informatica mappings for better Performance.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Analyzed Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.

Environment: Informatica Power 9.6 (Workflow Manager, Workflow Monitor, Mapplets), Oracle, Teradata, SQL.

Confidential

Informatica Developer

Responsibilities:

• Involved in analysis, design, development, test data preparation, unit and integration testing, Preparation of Test cases and Test Results
• Coordinating with client, Business and ETL team on development
• Developed Batch jobs using extraction programs using COBOL, JCL, VSAM, Datasets, FTP to Load Informatica tables
• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing logic, and transformation as per the requirement and creating mappings and loading the data into BI database.
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designing and developing ETL solutions in Informatica Power Center 8.1
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files.
• Developed Informatica mappings, enabling the ETL process for large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in each SLA.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Informatica scheduling tool.
• Expertise in creating control files to define job dependencies and for scheduling using Informatica.
• Provided effective support in delivering process and product change improvement solutions.
• Ensured acceptable performance of the data warehouse processes by monitoring, researching and identifying the root causes of bottlenecks.
• Acted as a liaison between the application testing team and development team in order to make timely fixes.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 8.1, ETL, Business Objects, Oracle 10g/9i/8i, HP - Unix, PL/SQL.