SUMMARY:

• Over 7 Years of experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica Power Center v10.x/v9.x/v8.x Experienced in analysis of different systems for system study and data warehouse implementations.
• Extensively worked on Informatic PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations.
• Extensively Worked on Informatica Designer Components - Source Analyzer,Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Good experience in designing and developing complex mappings from varied transformation logic Using Informatica.
• Experienced in Dimensional modeling concepts star/snowflakes Schema, Fact and Dimension table and proficient in identification of Facts, Measures and Dimensions.
• Experience developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experienced in OLTP/OLAP Systems, Analysis, and Data model Schemas like Star schema, Snowflake schema and multidimensional modeling.
• Experienced in Data Analysis, Data modeling, ETL, Data Warehousing, Reporting, Development, Maintenance, Testing and Documentation.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Developed effective working relationships with client team to understand support requirements.
• Experienced in loading data, troubleshooting, Debugging, mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
• Knowledge on Informatica Data Quality (IDQ) for cleanup and massaging at staging area.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server, Teradata and formats like flat-files, XML, etc.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Data modeling experience in creating Conceptual, Logical and Physical Data Models using ERwin Data Modeler.
• Experienced in using Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Experience in Oracle and MS SQL Server environments using Triggers, functions, SQL, T-SQL and PL/SQL.
• Good experience in Scheduling ETL Jobs tool like Autosys, Cron tab and Control M.
• Experienced in working for the post development cycle and applications in Production Support.
• Expertise in SQL and PL/SQL programming to develop stored procedures, functions, packages and triggers.
• Knowledge on AWS EC2, Load balancing.
• Monitor AWS resources using Amazon Cloud Watch and track events using Cloud Trail.
• Configure the Elastic Load Balancers (ELB) for distributing incoming application traffic across multiple EC2 instances
• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Worked on Agile process for development and testing.
• Independently perform complex troubleshooting, root-cause analysis and solution development.

TECHNICAL SKILLS:

Agile, Water: Fall

Data Bases: Oracle,Teradata,Hana,DB2, MS-SQL Server 2005/2000

Operating Systems: Windows, Linux, Unix

Languages: SQL, PL/SQL, shell scripting, C and C++

ETL Tools: Informatica v10.x/v9.x/v8.x

PROFESSIONAL EXPERIENCE:

Confidential, Monroe, Louisiana

ETL/Informatica Developer

Responsibilities:

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Analysed the business requirements, designed and developed the ETL mappings involving complex business rules.
• Developed Dimensional data modeling of the data warehouse projects by using star schema also developed Data mapping and filtering procedures.
• Used Waterfall model to extract the data in sequential non-iterative way.
• ETL includes the selection criteria to extract data from source systems (Cloud), performing any necessary data transformations or derivations needed, data quality audits, and cleansing.
• Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Data warehouse.
• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.
• Gather Requirements from the source system and creating Process using Informatica cloud.
• Building Design Spec for the ETL Process flow based on the requirements using Informatica cloud.
• Design the ETL process and schedule the stage and mart loads for the data mart.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplets Designer and Transformation Developer for defining Source and Target, and coded the process from source system to data warehouse.
• Designed, Developed and Deployed UNIX shell scripts.
• Configured and managed Informatica servers and Implemented data quality management solutions that manage millions of customer transactions.
• Performed systems, data quality assurance, system testing, ensuring that software and systems perform to specification.
• Expertise in Designing and developing anonymous blocks, views, materialized view, stored procedures, functions, Ref & Traditional Cursors, and Dynamic SQL as part of Project/Application requirements.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Implemented and Maintained the Appropriate Informatica Best Practices
• Troubleshooting the production support issues and Keeping the triage of support tickets
• Extracted large volumes of data from Mainframes systems to target Oracle database.
• Executed, scheduled workflows using Informatica Cloud tool to load data from Source to Target.

Environment: : Power Center 10.1/9.6, Informatica Power Exchange, Informatica Cloud, Teradata, Oracle 12c/11g (SQL, PL/SQL), SQL plus, UNIX Shell Scripting, Teradata SQL Assistant, Toad and Windows.

Confidential, Sunnyvale, CA

ETL/Informatica Developer

Responsibilities:

• Created/Modified Informatica ETL, data stage mappings in various stages folders like Staging area and production area for development and production environment that transfers data from SQL Server, Oracle Source systems to Oracle Target system.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed 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.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Designed data model to meet the business requirements, created tables, views, anonymous blocks, materialized views, stored procedures, packages and functions.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Design the mapping to remove to duplicate source records.
• Responsible for Unit level testing and Application testing.
• Applied Slowly Changing Dimensions like Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Interact with technical and business analyst, operation analyst to resolve data issues
• Experience in partitioning tables to improve performance and scalability.
• Tuned database SQL statements and procedures by examining explain plans, monitoring run times and system statistics. Applied database hints, fine-tuned indexes and rewrote code to improve performance.
• Developed core PL/SQL Packages accounted for error handling and logging routines.
• Helped prepare the mapping document which details out the mapping of source to the target data model with application of business rules.

Environment: : Informatica Power Center 9.5.1/9.6.1 Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange 9.5.1/9.6.1 Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, UNIX Linux, Toad 9.0, Mainframe, Harvest, U-deploy.

Confidential, Pleasanton, CA

ETL/Informatica Developer

Responsibilities:

• Interact with business analysts, Analysed, inspected and translate business requirements into technical specifications.
• Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.
• Analysed the Requirement for ETL Design and Development for extracting the data which is stored in different sources like Oracle, SQL Server, Sybase, and DB2.
• Participated in designing and developing an environment that would facilitate the use of Informatica to transform data coming from oltp into data marts.
• Used Agile Methodology for SDLC and utilized scrum meetings for creative and productive work.
• Developed complex Informatica Mappings with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Worked with Informatica Cloud to create Source /Target connections, monitor, and synchronize the data in the data warehouse.
• Hands on experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center 8.x/9.x, Power Exchange.
• Using Informatica Power center 9.1 to make the changes to the existing ETL mappings in each of the environments.
• Involved in the migration of Informatica 8.6 workflows into Informatica 9.1 version.
• Wrote PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load, delete records based on a condition and rename the tables
• Interact with business analysts, Analysed, inspected and translate business requirements into technical specifications.
• Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.
• Involved Creating Fact and Dimension tables using Star schema.
• Extensively involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Design and developed complex Informatica mappings including SCD Type 2 (Slow Changing Dimension Type 2).
• Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Environment: Informatica PowerCenter v 9.6, SQL Server 2012, Power mart, PL/SQL, SAP BO, Oracle,Hana,Windows, Flat files (fixed width/delimited), Salesforce, XML, SharePoint, Quality Center.

Confidential

TL/Informatica Developer

Responsibilities:

• Worked with Business Analysts for requirements gathering, implementing designs process, development and preparing business rules.
• Worked in Software Development Life Cycle (SDLC) like in Agile Scrum methodologies.
• Actively performed in the meeting and providing comments for user story review meeting in Agile Scrum environment.
• Created Complex Mappings to load data using transformations like Source Qualifier, Expression, Aggregator, Dynamic Lookup, Connected and unconnected lookups, Joiner, Sorter, Filter, Stored Procedures, Sequence, Router and Update Strategy.
• Created Mappings using parameters, used Session parameters, Mapping variable/parameters and created Parameter files and runs of workflows based on changing variable values.
• Worked on complex mapping for the performance tuning to reduce the total ETL process time.
• Developed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle.
• Developed Informatica Workflows and sessions connected with the mappings using Workflow Manager. Implemented Slowly Changing Dimensions (SCD Type 1 & 2) in Mappings.
• Hands on experience using query tools like SQL Developer, PLSQL developer, Teradata SQL.
• Involved in creating new table structures and modifying existing tables discussing with Data Modeler.
• Experience in writing documentation like Micro documents from Macro documents, High level and low level design, analyzing Source to Target Mapping (STM's), Test cases and Code migration report.
• Developed Mapplets, Source and Target definitions, mappings, Reusable Transformations, using Informatica PowerCenter 9.6.1
• Update the tables as per the requirements by generating queries using SQL to check the data consistency in the table.
• Checked Sessions and error logs to troubleshoot problems and also used debugger.
• Created Unix Shell Scripts to automate pre-session and post-session processes.
• Created shortcuts for reusable transformation, source/target definitions, mapplets in Shared folder.

Environment: Informatica Powercenter 9.6.1, Oracle 11g/10g, OBIEE 11g, SQL, Flat files, Oracle SQL Developer, Toad, Unix, Shell scripts.

Confidential

SQL Server Consultant

Responsibilities:

• Involved in all phases of SDLC and follows Agile Methodology.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export.
• Designed DDL and DML for MS SQL Server 2000/2005.
• Created scripts to create custom Tables and Views.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Extensively used TSQL to manipulate and architect to produce results for users. Used multiple join statements to retrieve data from multiple tables.
• Extract Transform and Load source data into respective target tables to build the required data marts.
• Install and configure servers and clients using SQL Server 2005. Create and upgrade SQL databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Experience in Creating stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization Actively involved in Normalization & De-normalization of database.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Writing T- SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables. .
• Monitor production Server Activity
• Worked with DTS packages to load the massaged data into Data warehousing system
• Tuned the SQL queries using SQL profiler and involved in tuning the database
• Very pro-actively identifying the problems before user complaints

Environment: : Windows 2000 Advanced Server/Server 2003, SQL Server, MS Access, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL, MS SQL Server DTS, Upgrade Advisor, DTS Designer Tools .