SUMMARY

• 10 + Years of Professional experience in different areas of Data warehousing,RDBMS, Data modeling, Data extraction, Data acquisition, Analysis, Application design, Development and Implementation of data warehousing, business Intelligence system using InformaticaPower Center,Power Exchange, Data Conversion and various business applications in different platforms.
• Informatica Power Center9.X/8.X/7.X Oracle 11g/10g/9i(SQL/PL SQL).Extensive experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications
• Experience in Dimension Data Modeling concepts likeStar Join Schema Modeling, Snow - Flake Modeling, FACTandDimensionsTables,PhysicalandLogical Data Modeling.
• Worked in Data Conversion of various data sources like Oracle, MS SQL Server, Oracle Apps, MS Access, Fixed Width and Delimited Flat Files, COBOL files and XML Files.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using InformaticaPower Center(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger),Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Strong Experience onWorkflow Manager Tools - Task Developer, Workflows &Worklet Designer and Managing, Scheduling, and Monitoring of Informatica workflows.
• Worked on all thetransformationslikeConnectedandUnconnected - RemoteLookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and SequenceGenerator, Sorter.
• Created ETL mappings using InformaticaPower centerto move Data from multiple sources like Flat files, Oracle, DB2 & Teradata into a common target area such as Data Marts and Data Warehouse.
• Extensive knowledge with Teradata SQLAssistant.
• Developed Teradata BTEQscriptsto Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements.
• Experience inPL/SQL Programming(Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server andUNIX shell scriptingto perform job scheduling.
• Quick learner with Analytical and logical programming skills and possess excellent presentation and interpersonal skills.
• Good communication and interpersonal skills and Strong understanding of ETL best practices.
• Assigning work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

TECHNICAL SKILLS

Operating Systems: Linux,Windows 2008/2007/2005/ NT/XP,UNIX

Databases: MS SQL Server 2012/200r 2/2008/2005/2000 , Oracle 11i/10g/9i/8i, Teradata, DB2, SQL Server (DTS/SSIS/SSRS).

Programming Languages: UNIX Shell Scripting, Linux, C & C++.

Packages: MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint.

Scheduling Tools: Control-M & AUTOSYS.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr ETL/Informatica Developer

Responsibilities:

• Parsing high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involving in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.
• Remain calm under pressure and ensure IT management and business stakeholders are kept fully updated on progress of critical issues.
• Escalate issues and remediation steps effectively and in a timely manner.
• Perform troubleshooting analysis and resolution of critical applications and batch processes.
• Coordinating with vendors to troubleshoot and resolve issues.
• Supporting the Client Reporting Production Environment as a first priority.
• Involving in design, development and implementation of ETL process inpower center. Responsible for managing, scheduling and monitoring the workflow sessions
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in using Automation Scheduling through Control-M.
• Create change management strategy .Identify, analyze, prepare risk mitigation tactics identifying and manage anticipated resistance.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
• Participated in the full development lifecycle within the reporting framework, from developing business intelligence requirements to QA and production deployment & 24*7 Production support for data warehousing.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes.
• Created proper Teradata Primary Indexes taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.

Environment: InformaticaPower Center9.6,Teradata, DB2, Oracle 11g, Control-M, Obiee, PL/SQL, UNIX.

Confidential

Sr ETL/Informatica Developer

Responsibilities:

• Involved in design, development and implementation of ETL process inpower center. Responsible for managing, scheduling and monitoring the workflow sessions.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements
• Used Data Profiling to Minimize the risk of data quality problems proliferating throughout the organization.
• Worked Extensively on Siebel Answers to create reports as per the client requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Implemented ETL process to load data into target Oracle tables.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Responsible for Error handling, bug fixing, Session monitoring, log analysis Implemented various Data Transformations using Slowly Changing Dimensions.
• Worked on Power Mart client tools viz. Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developers.
• Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.
• Performed optimization of SQL queries in SQL Server.
• Installation and Configuration of ETL tool Informatica for creating Data ware housing Analyzed OLAP cubes data to compare actual results to budget results, to assess performance in Analysis studio.
• Collaborate with and mentor current development staff in the use of Business Intelligence (OBIEE), Informatica, and Oracle coding language based on numerous prior development activities in these environments
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.

Environment: InformaticaPower Center9.1.6,Oracle 11g, Tivoli, Unix.

Confidential

Sr ETL/Informatica Developer

Responsibilities:

• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using InformaticaPower Center.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Attended the QA Audit meetings and test artifacts review.
• Participated in the Integration testing and Unit Testing along with the Development team.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Provided production support to various manuals and deployment.
• Monitored functional requirements and mapped all documents.
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Preparing the documents for test data loading.

Environment: InformaticaPower Center9.5 .0., Oracle 11g, DB2, XML, TSQL, MS SQL Server, UNIX (AIX), UNIX Shell.

Confidential

Sr ETL/Informatica Developer

Responsibilities:

• Responsible Participated in design sessions where decisions are made involving the transformation from source to target.
• Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (pl and sql), packages, triggers.
• Managed and compile documentation for all ETL processes.
• Created detailed process flow designs and drafts high-level Standard Operation Procedures.
• Performed Informatica Administration tasks.
• Designed and implements the error handling strategy for ETL team.
• Monitored data warehouse month-end loads to ensure successful completion.
• Mappings, Mapplets and Sessions for data loads And data cleansing.
• Enhancing the existing mappings where changes are made to the existing mappingsusing InformaticaPower center.
• Gather and analyze business requirements.
• Design logical and physical data models and data processing infrastructure.
• Provide production database support, enhance existing system and design and develop new systems.
• Monitor the usage of database space and performance.
• Performance optimization of the database and applications.
• Involved in ETL process from development to testing and production environments.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.

Environment: InformaticaPower Center9.1Power Exchange,Erwin, Tivoli, Oracle 9i, DB2, XML, TSQL, MS SQL Server 2005, UNIX (AIX), UNIX Shell, SalesForce.

Confidential - Cincinnati,OH

ETL/Informatica Developer

Responsibilities:

• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.
• Maintained Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Developed complex Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data into Oracle.
• Performed Unit testing of the mappings developed.
• Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to model various standardized business processes.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily. Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Modified existing mappings for enhancements of new business requirements.
• Worked as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.
• Responsible for coordinating with the upstream teams to get the data into system.
• Loaded data into test databases by executing autosys box and validated the data.
• Created new Informatica mappings, sessions, Worklets and Workflows to in corporate the enhancements requirement.
• Giving KT to the new joiners and freshers in the team about project architecture, Loads and data issues.
• Responsible for validating the ETL transformation logic.
• Responisible for running autosys jobs.
• Helping to the team members in fixing the issues, developing the jobs and analyzing the code.
• Analyzing the data loads, identifying the dependency and changing the load sequence in busy schedules.
• Monitoring the daily, weekly and monthly data loads and fixing the load failures.
• Automated the jobs through scheduling using Built in informatica scheduler.
• Performance tuned and optimized various complex SQL queries.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.

Environment: Informatica Power Center 8.6.1, Teradata, Windows NT,Autosys,UNIX,Putty.

Confidential - Dearborn, MI

ETL/Informatica Developer

Responsibilities:

• Involved in understanding the Requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Configured the source and target database connections using .dbc files
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier,Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Developed reusable Mapplets and Transformations.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 7.0, MS SQL Server,Business Objects, Unix, Windows XP.