SUMMARY

• About 8+ years of total IT experience in Software Development Life Cycle (SDLC) with strong background in Database Development and ETL Data Warehousing usingInformaticaPower Center.
• Extensively worked inInformaticacloudusing CMD (cloudmapping Designer), DRT (data Replication Tasks) and DST (Data Synchronization Task)
• Experience in working with Data analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating and analyzing the Dimensional data modeling, Star/snowflake Schema modeling.
• Experience in deployment of Business Objects & Web Intelligence from Various Sources Oracle, Teradata, MS SQL Server, DB2 and Access.
• Extensive working experience in Data Analysis, Design, Development, implementation andTesting of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL) methodologies.
• Worked extensively onInformaticaCloudtool to pull the data fromcloudapplications.
• Extensively worked on development of complex mappings using various transformations like Expression, Connected/Unconnected Lookup, Filter, Router, Joiner, Union, Aggregator, Update Strategy, SQL, Transaction control etc.
• Expertise in the ETL Tool Informatica and have extensive experience in Power Center Client tools including Designer, Repository Manager, Workflow Manager/ Workflow Monitor.
• Experienced in mapping techniques for Type 1, Type 2, and Type 3 Slowly Changing Dimensions.
• 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.
• 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.
• Extensive experience using database tool such as SQL *Plus, SQL *Developer, Autosys and TOAD.
• Excellent analytical, problem solving, technical, project management, training, and presentation skills.
• Highly adaptive to new emerging technologies.

TECHNICAL SKILLS

ETL: Informatica Power Center, Informatica Cloud, Informatica Power Exchange, Power Analyzer, Informatica Power Connect and Master Data Management (MDM), Data Quality Tool (IDQ), Informatica Data Services(IDS), DataStage

Data Modeling: Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow flake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization.

Languages: C, Java, Python and Shell scripting

SQL Databases: Oracle 9i,10g,11g, Teradata, MySQL, DB2 and MS - SQL Server

Other ETL Tools: Erwin, Pentaho, Tableau

Operating Systems: Ubuntu, Windows, iOS, Unix

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Informatica Developer

Responsibilities:

• Coordinated with Business users & Business Analysts to understand the business requirements and Involved in reviewing technical documents for implementing solutions according to the needs.
• Extensively usedInformaticaClient tools likeInformaticaRepository Manager,InformaticaDesigner,InformaticaWorkflow Manager andInformaticaWorkflow Monitor.
• Involved in Modelling (Dimensional Modelling) review sessions.
• Participated in Data analysis and Data validation.
• Developed a Logical modelling using Erwin based on requirements analysis.
• Performed data migration from DB2 database to Teradata database.
• Worked closely with Business Analysis team and Reverse Engineering Team to gather the Analytics requirements and created the Business Model using Star schemas.
• Developed UNIX shell and SQL scripts for database monitoring and backups.
• Resolving the tickets raised by the customers and other team members regarding running applications.
• Fixing the bugs and making enhancements in the application whenever required.
• Working with team on ETL and dashboards and reports.
• Loaded staging database from source as Flat Files, XML, Oracle, and SQL Server & My SQL.
• Created different mappings for loading the data into targets using various transformations such as Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Expression, Aggregator, and Sequence generator.
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Developed and designed Informatica Workflows or sessions to load the data into target Data Mart.
• Involved in implementing CDC & SCD (Type 1 & Type2).
• Participated in Code migration to different Repositories.
• Coordinated with DBA's and Informatica Admin to fix the issues.
• Extensively used Teradata Utilities BTEQ, Fast Export, M-Load & F-Load to improve the Teradata Load Performance.
• Extract data from flat files, Oracle, DB2, Mainframe files, SQL Server 2008 and to load the data into the Enterprise Data warehouse.
• Extensively involved in doing SQL Tuning at DB level.
• Implemented Performance Tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Extensively used Informatica Debugger to analyze or resolve the data issues.
• Wrote UNIX shell scripts to Automate the process and schedule.
• Involved in production support and maintenance.
• Extensively worked on Kimball Methodology.

Environment: Informatica Power Center 9.6.1/9.5.1, Informatica Cloud, Oracle11g, DB2, Teradata 14.0, SQL Server 2005, PL/SQL, SQL Loader, putty, Erwin 4.1.2, Unix Shell Script.

Confidential, dallas, tx

Informatica Developer

Responsibilities:

• Documented high and low-level design document specifications for source-target mapping, based on the transformation rules.
• Documented technical requirements for ETL process and Design documents for each source. Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Extensively used PL/SQL programming procedures, packages to implement business rules.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Workflow Manager.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.
• Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Extensively dealt with the performance issues and made necessary coding changes for improving the system Performance.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Design and Developed pre-session, post-session routines and batch execution routines.
• Worked with XSD and XML files (sources & targets) to read & parse the data and load into the various target system.
• Created various Oracle objects (tables, views, synonyms, indexes, partitions, functions, triggers etc.).
• Developed various PL/SQL procedures using cursors, records, collections & dynamic SQL.

Environment: Informatica Power Center 9.1/9.5, IDQ, Oracle 10g, SQL server 2005/2000, SQR, XML, Windows, UNIX and PL/SQL

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
• Extensively usedInformaticaClient tools likeInformaticaRepository Manager,InformaticaDesigner,InformaticaWorkflow Manager andInformaticaWorkflow Monitor.
• Used Teradata utilities Fast Load, Multi Load, TPump to load data.
• Created Sources, Targets in shared folder and developed re-usable transformations, Mapplets and user defined function (UDF) to re-use these objects in mappings to save the development time.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Worked on high volume data sets from various sources like Oracle, Text Files and Teradata Tables.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Modified PL/SQL stored procedures forInformaticamappings.
• Created Sessions and Workflows to load data from the SQL server, flat file and Oracle sources that exist on servers located at various locations all over the country.
• Configured the session properties i.e. high value for commit intervals to increase the performance.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures usingInformaticasession logs.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Environment: InformaticaPower Center 9.1.1/8.6.1, Flat Files, Oracle, Teradata 12/13, SQL, PL/SQL, TOAD, SQL Assistant, Windows XP

Confidential

Informatica Developer

Responsibilities:

• Worked with the business team to gather requirements for projects and created strategies to handle the requirements.
• Worked on project documentation which included the Functional, Technical and ETL Specification documents.
• Experienced in usingInformaticafor data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems.
• Designed and implemented ETL mappings and processes as per the company standards, usingInformaticaPowerCenter.
• Extensively worked on complex mappings which involved slowly changing dimensions.
• Developed several complex mappings inInformaticaa variety of PowerCenter transformations, Mapping, Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both theInformaticaPowerCenter and IDQ.
• Worked extensively onInformaticatransformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.
• Debugged mappings by creating a logic that assigns a severity level to each error and sent the error rows to error table so that they can be corrected and re-loaded into a target system.
• Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.
• Worked on developing Change Data Capture (CDC) mechanism usingInformaticaPower Exchange for some of the interfaces based on the requirements and limitations of the Project.
• Implemented performance and query tuning on all the objects ofInformaticausing SQL Developer.
• Created the design and technical specifications for the ETL process of the project.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked with SQL*Loader to load data from flat files obtained from various facilities.
• Worked on loading of data from several flat files to Staging using Teradata MLOAD, FLOAD and BTEQ.
• Worked with the Release Management Team for the approvals of the Change requests, Incidents using BMC Remedy Incident tool.
• Worked with the infrastructure team to make sure that the deployment is up-to-date.
• Provided 24x7 production support when necessary. Involved in various phases of Software Development Life Cycle (SDLC) as design development and unit testing.

Environment: InformaticaPowerCenter 8.6,InformaticaIDQ 8.6,InformaticaPower Exchange 8.6, Oracle, SQL, Erwin 5, UNIX CRONTAB, Control-M, Remedy Incident Tool, Teradata.

Confidential

ETL Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Designed and developedInformaticaMappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used PowerCenter to design multiple mappings with embedded business logic.
• Created database objects like stored procedures, function.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations, Mapplet for populating target table in efficient manner.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Created and maintained several custom reports for the client using Business Objects and SSRS.
• Performance tuning of theInformaticamappings using various components like Parameter files, Variables and Dynamic Cache.

Environment: InformaticaPowerCenter 8.6, Oracle, SQL Server, PL/SQL, TOAD, SQL*Plus, Windows, SSRS ESP.