SUMMARY

• 7 years of IT experience as an ETL Developer/Program analyst, which includes Data Warehouse/Database Developer experience using Informatica Power Center 9.x/8.x
• 2 years of experience in Informatica Data Migration Project from Legacy system to Global system.
• 2 years of Development and Testing experience in Datastage ETL tool.
• 2 years of Production Support and enhancement experience with Informatica tool.
• 2 years of experience in Data Reconciliation.
• Hands on experience in the Application Design, Business Requirements Analysis, Data Modeling, Development, IVI execution, Implementations and Testing of Database Business Systems and Data Warehousing using Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, Fact and Dimension tables.
• Proven experience in writing and modifying ETL design documentation, technical requirements analysis, test results documentation and standard operating procedures SOP documentation.
• Expertise in ETL designs, including process flow, data flow, source-to-target Mappings, physical database designs and data models.
• Experience in developing Shell scripts on UNIX and experience with UNIX command line.
• Excellent communication and writing skills and capable of working successfully both in teams and independently.
• Ability to self-manage time and task priorities to meet project timelines, and identify potential project risks.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and effectively manage client expectations.

Confidential

Sr. Software Engineer

I am part of the Global Engineering Platform Services team testing the NZ to ExaData conversion along with validating the impact of the conversion to existing applications.

Responsibilities:

• Involved in Migration from Netezza to Exadata, conduct end to end testing from backend and UI perspective.
• Knowledge of SAAS model web based applications and n-tier architectures.
• Involved in ETL process of loading data from Sql server to Exadata and Netezza both and perform end to end testing. Compared results between both the systems and make sure nothing broke.
• Design, develop and execute test plans and test cases, enter defects into Jira found during testing
• Writing queries in MS SQL 2008, 2010 , Netezza and Exadata, having good understanding of NZ, Exadata and data warehousing projects.

Environment: Marketing Cloud, Netezza, Exadata, Data Factory Utility ExactTarget in-house ETL tool , JIRA, MS SQL server

Confidential

Sr. BI Developer

Confidential based Pharmaceutical Company. The IDM is a batch number centric i.e. most data describes a manufacturing batch data mart containing a subset of data from systems such as GLIMS, GMARS, SAP, Process Automation OSIPI , Syncade, Admin LIMS and Bolder.I have been involved in various assignments as ETL development, Data reconciliation, Production Support and minor enhancement work.

Responsibilities:

• Understanding of Business requirements as part of new release of IDM.
• Based on Business requirements update the design document and incorporate the changes in Code. As Developing or Updating Informatica mapping ETL Coding .
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the Power Center.
• Implemented various identifying Bottleneck Performance Tuning technique on Source, Targets, Mapping, and Workflows.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts, Wrote PL/SQL scripts for dropping, rebuilding indexes.
• Performed Configuration Management to Migrate Informatica mappings/ sessions/ workflows from Development to Test to production environment.
• Using Oracle as database and running basic SQL queries.
• Performed Code review, Documents Technical Specification review.
• Prepared Test Cases for project related applications.
• Involved in Unit Testing and System Testing
• Deployed code in production environment.
• Along with development, worked on Enhancement CRs and Trouble Tickets. Have Production Support experience.

Environment: Informatica Power Center 9.1, Power Exchange 9.1, Oracle10g, Sql server 2007, HP Quality Center 10.0 , TFS version control library, Regulas, Windows XP, Microsoft office 2007, MS Visio 2007, Linux.

Confidential

S r. ETL Developer

Confidential is responsible for building, maintaining and operating the Tele2 IT and billing systems and environments. The organization is represented in most of the countries: Sweden, Russia, Estonia, Latvia, Lithuania, Germany, Croatia, and Norway where Tele2 operates. Tele2 has chosen IBM Infosphere platform with Cognos as BI tool for the future Tele2's Enterprise Data Warehouse EDW .

Responsibilities:

• Identified/documented data sources and transformation rules required populating and maintaining Enterprise data warehouse content
• Used Infosphere Datastage 8.1 EE as ETL tool to extract data from source systems such as DB2, Flat file to target database system
• Prepare High Level Design and Detailed Level Design documents ETL coding mapping and UNIX shell scripting.
• Developing complex ETL jobs involving multiple data sources including several RDBMS tables and flat files
• Used different transformations called stages in Datastage such as Merge, Join, Filter, Look-up, Aggregator, CDC, SCD1, SCD2 and SCD3 to transform the data
• Designed and implemented Type1 and Type2 Slowly changing dimensions
• Used Parameter files and variables in mappings and sessions
• Created reusable objects such as containers, routines to handle the reusability of the code
• Developed Jobs Dimension, Fact and Aggregator tables and loaded in sequence.
• Created Sequences to load data parallel and sequentially.
• Performed peer review and got appreciation for best performance
• Perform Unit testing and End to End testing in Dev environment.
• Coordinated with Testing and production support team during System testing and prod deployment.

Environment: Datastage, DB2, SQL, Flat File, Linux.

Confidential

ETL Developer,

• Confidential is basically migrating data from Confidential to Darwin System.
• Confidential based Laboratory Information Management System.
• Confidential is Confidential based Laboratory Information Management System.
• Laboratory Information Management System has the Information about the Samples to be tested

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• 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
• Involved in building Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling Star Schema of the Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used Toad for running the SQL Queries to check the data loaded to the Target Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts PMCMD commands for FTP of files from remote server and backup of repository and folder.
• 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 8.6.1, Workflow Manager, Workflow Monitor, Oracle 10g/9i, SQL, Toad, Windows XP, UNIX Shell Script.