SUMMARY:

• Seeking a challenging position in an organization, where I can utilize my skills in providing solutions for DWH Using Informatica.
• Over 8 years of IT experience in Analysis, Design, Development, Testing, and Implementation of business application systems for various Financial (Mortgage Banking, Telecommunication, Farming and Healthcare based clients.
• Extensive experience of more than 7 years in data extraction, transformation and loading data using Informatica PowerCenter9.x,8.x, 7.x (Designer, Workflow Manager, Workflow Monitor), and Data Warehousing.
• Strong understanding of Dimensional Modeling, Star and Snowflake Schemas and Data Warehousing.
• Startling experience in RDBMS databases like Oracle, MS SQL Server and Teradata.
• Strong experience in Unix Shell scripting.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Tuning of SQL Queries, Database leading to significant improvement in system response time and efficiency using Execution and Query plans.
• Emphasized on Performance of Mapping Optimizations in Informatica.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experienced in data profiling, validations, mapping, analysis, testing of data quality using IDQ
• Involved in data profiling using data quality tool IDQ and developed the frame work in IDQ environment.
• Have work experience in using Informatica data quality for Labeler, Standardizer and Address doctor transformations.
• Worked in different phases of software development lifecycle across various projects.
• Experienced in MicroStrategy reporting tool.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Involved in multi - dimensional data model and enhanced them to meet growing requirements.
• Sound Knowledge in Enterprise Data Warehouse, Data Integration, Data Marts and Data Migration projects.
• Experience in integration of various data source definitions like Teradata, Oracle, Flat Files, SQL Server and XML
• Developed Complex mappings from varied transformation logics like Unconnected/Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy, SQL, Transactional Control and more.
• Experience in ER modeling and Dimensional Data Modeling using Star and Snowflake schema with Power Designer.
• Created high level and low-level design documents and provide solutions for the requirements.
• Involved in code reviews, architectural reviews and peer reviews of project and maintained documentation as per client standards.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and
• High adaptability to new technologies and tools
• Strong Team working spirit and relationship management skills
• Good knowledge in Core Java concepts.
• Knowledge on SSIS.
• Strong understanding ofBig Data concepts, Hadoop architecture, HIVE, SQOOP technologies.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.x/8.x, OLAP, OLTP

Data Governance: IDQ

Data Modeling: Informatica Power designer

Databases: Oracle 11g/10g/9i, Teradata, SQL Server

Business Intelligence: MicroStrategy

Languages: SQL, PL/SQL

Load Utilities: MLoad, Fast Export, BTEQ, Fast load, SQL Loader

Tools: Toad 9.1, Quality Center, SQL Developer

Version Control: SVN, Tortoise

Operating System: Windows 2000/2003/XP/7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Sr. Informatica Developer

Responsibilities:

• Gathered requirements and data elements crucial for decision making for approach and analysis.
• Worked with the Business Analysts, technical analysts and the business users to understand the data, the expected formats, data hierarchies
• Worked on functional hierarchies of various datasets and Participated in Data model reviews.
• Developed various mappings and workflows using various transformations like Sorter transformation, Aggregator transformation, Union, Router and Joiner transformation to meet the requisites.
• Created various database objects like Tables, Views, Indexes, functions to handle intermediate staging data.
• Wrote shell scripts to as part of the job scheduling, by defining the ‘wait’ logic for triggering jobs in the batch.
• Performed major role in understanding business requirements and designing and loading data into data warehouse (ETL).
• Used Informatica Power Center to load data from various source systems to Data warehouse.
• Implemented Performance Tuning of ETL maps at mapping, session, source and target level as well as writing complex SQL Queries from Abstract data models.
• Used Informatica client tools like source Analyzer, Target designer, mapping designer, Mapplet designer and transformation developer for defining source and target definitions and coded the process of data flow from source systems to data warehouse.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre- Prod and Prod Environments.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Used Informatica workflow manager and Informatica workflow monitor to schedule and monitor session status.
• Worked with Informatica Data Quality(IDQ) 9.1 for data cleansing, data matching and data conversion
• Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them
• Extensively used different transformations such as Source qualifier, look up (connected and unconnected), Expression, Aggregator, Update strategy, Sequence generator, Joiner, Filter, Rank, Normalizer and Router transformations.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Extracted data from diverse sources like Oracle, SQL Server, COBOL files and Flat Files.
• Used BTEQ, FLOAD, MLOAD, TPT Teradata utilities to export and load data.
• Created a BTEQ script for pre-population of the work tables prior to the main load process.
• Used version mapping to update the Slowly Changing Dimensions to keep full history to the target database.
• Converted workflows with Relational connections to MLOAD connections to connect to Teradata to reduce overall workflow run-time and to improve the performance.
• Used Unix Shell scripting for automation of the process, invoking PL/SQL procedures and Informatica session.
• Imported data using source analyzer and exported data using Target analyzer designed and developed Oracle PL/SQL procedures.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in unit testing and identified requirements, scheduling and rerunning failed jobs as required.

Environment: Informatica 9.6 (Power Center), Oracle, SQL Server, Shelling Scripting, Flat Files, UNIX.

Confidential, St louis Mo

Sr. Informatica Developer

Responsibilities:

• Worked with Business and IT teams in educating Data Quality process and showcasing IDQ Capabilities in developing Enterprise wide Data Quality Solution.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications.
• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
• Configured Metadata Repository to create the lineage for Erwin data models, Databases consisting of Teradata, Oracle, Sql Server, Power center objects and Business Objects reports.
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
• Planned, created and executed SSIS packages to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Performed data profiling based on the functional specifications provided business team.
• Worked with data quality plans, components, uses the data quality report viewer to get reports, dash boards.
• Worked on IDQ parsing, IDQ Standardization, matching, IDQ web services.
• Imported the mappings developed in data quality (IDQ) to Informatica designer.
• Worked on Informatica Analyst Tool IDQ, to get score cards report for data issues.
• Worked with Informatica data quality core components like Informatica Analyst (web based) and Informatica developer
• Worked extensively with address validate to cleanse the address elements. Created input and output templates.
• Created Metadata Manager Service, Reporting Service and Reference Table Manager Service in ISP Admin Console to effectively use Metadata Manager.
• Customization of standard Informatica Meta Model to accommodate a full range of metadata as defined for the collection and storage of Enterprise Metadata.
• Integrate the address doctor with address validation transformation to cleanse the address.
• Develop Cleansing Services to remove noise words, standardize data, Validate Addresses, Parse data.
• Develop Matching Services for de-duplication as well dual-source matching.
• Extracted data from Oracle and Teradata then used SQL Server for data warehousing.
• Write Shell script running workflows in UNIX environment.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: IDQ, Informatica 9.6, Oracle 11g, TOAD, Unix Shell scripting, Power Designer, Quality center

Confidential, St louis MO

Informatica Developer

Responsibilities:

• Implemented the data marts to support the customers Home Security measures and handle better response to protect their properties and automated signal system to communicate with safety and recovery mechanism.
• Electronic Signatures will be required to support contracts for the Cox Home Security, Easy Pay Recurring Method of Payment Verifications, and Price Lock Guarantee Service Agreements.
• Implemented SCD Type 1 and Type 2 methodologies to load and maintain data in the Data warehouse.
• Extracted data from different sources, aggregated and implemented various calculation measures to aid the data analysis.
• Involved with Informatica team members in Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Created pre-session and post session tasks for exception and error handling. Created reusable email tasks for job completion notifications.
• Involved in the post production support. Analyzed and resolved all the data related production issues.
• Created ETL Spec documents for ETL mappings development.
• Created parameter files in order to pull data from Oracle Source environment.
• Incorporated ETL logic to process the input records only once in a day.
• Responsible for reference tables creation.
• Responsible for creating Informatica mappings, sessions, workflows.
• Built Unit Test Cases while testing data in DEV environment and involved in SIT & UAT Testing

Environment: - Informatica 9.5, Oracle 11g, Teradata, SQL Developer, Unix Shell scripting, Quality center

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Extensively used Source qualifier, Aggregator, Filter, Joiner, Expression, lookup, Router, Sequence Generator, Update Strategy, Union and SQL transformations to create mappings
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and from the relational database.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Extensively worked on tuning and improving the load time as well query processing time.
• Improved the Informatica Mappings and Session performance by eliminating extensive cache usage transformations, modifying session properties and partitioning the mapping.
• Used Error Handling Mapplet to capture error data into PMERR tables for handling nulls, analysis and error remediation Process.
• Documented the workflow dependencies and ordering for Autosys job scheduling process.
• Responsible for writing/documenting the unit test cases.
• Adhere to the quality code standards described by the client.
• Worked on UNIX scripts to troubleshoot QA and production issues.
• Responsible for deployment activities.

Environment: Informatica 9.5, Oracle 11g, Unix Shell scripting, SQL Developer.

Confidential

ETL Developer/Support

Responsibilities:

• Actively participating in agile process development process.
• Prepared technical Specification document and Migration document.
• Coordinate with onsite coordinator in understanding requirements.
• Sourced data from Oracle, flat file environment.
• Worked on Extraction, Transformation and Loading of data using Informatica.
• Develop Informatica Mappings, Sessions and Workflows.
• Wrote TD Bteq scripts to move data between stages, intermediate, Inc, base, package tables.
• Prepared test plans and test scripts.
• Involved in code migration and production implementations.
• Worked on reporting views creation.
• Responsible for scheduling and tracking of work assigned to the team members.
• Ensure project and process quality metrics achieved.
• Prepared SRS, TDS, MD 120, Code review, Peer review documents.
• Maintained all the documents in clear case with Version control in CVS.
• Prepared migration, job chains, production support documents.

Environment: - Informatica 8.6, Oracle 9i/10g, TOAD, Teradata, FTP.