PROFILE:

• 7+ Years of IT Experience.
• 7+ Years of ETL Experience.
• 7+ Years of Informatica Experience.
• 3+ Years of Tableau Experience

SUMMARY:

• 7 years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data Warehousing and Reporting with business knowledge of Healthcare, Financial, Insurance and Automobile domains
• Experience in interacting with business users to gather Business Requirement Specifications Document and prepare System Requirement Specifications document
• Experience in design and development of Extraction, Transformation and Loading (ETL) methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica PowerCenter 10.1/9.x/8.6 and SSIS
• Expertise in RDBMS concepts with hands on exposure in the development of relational database environment using SQL, PL/SQL
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files
• Experienced in ETL from disparate Data Source databases like Oracle, SQL Server, flat files, CSV files, XSD and XML files and loaded into target warehouse by using various transformations in Informatica
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used email task for capturing issues via email along with the Session logs
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing mappings and implementing complex business rules by creating reusable transformations and Mapplet
• Used SVN to check in and check out the code to maintain version history
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, Slowly Changing Dimension
• Extensively worked on Extraction/Data Migration/Transformation/Loading from various heterogeneous sources, Data warehouse staging and loading into various destinations using SSIS of MS SQL Server 2016/2014/2012/2008/ R2/2008
• Extensively worked on creating Jobs, alerts, SQL Mail Agent, and scheduling packages
• Experience in Tableau 10.3/10.1/9.2/8. x (Desktop & Server) and SSRS, creating various Reports and Dashboards using different visualizations like Bars, Lines, Pies, Maps, Scatter plots, Bubbles & Highlight tables
• Flexible, enthusiastic and project oriented team player with excellent oral and written communication and leadership skills to develop creative solution for challenging client needs

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 10.1/9.5/9.1/8.6.1 , SSIS, Clover

Reporting Tools: SSRS, Tableau

Utilities: Power Exchange

Data Modeling: Dimensional Data Modeling, using Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Databases: Oracle 11g/10g, SQL Server

Scripting: UNIX Shell scripting, SQL stored procedures

Control: M,Autosys

DB tools: SQL / PL SQL, TOAD, Oracle Developer

Operating System: UNIX (AIX, Sun), Windows

Agile Tools: JIRA

EXPERIENCE:

Confidential, New York, NY

ETL Informatica Developer

Responsibilities:

• Extensively used Informatica power Centre for loading the data from sources like Oracle, Sql server, Sybase and Flat file
• Created ETL mappings for various layer of data loads like Staging and Landing
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads
• Created mappings using Unconnected Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner
• Developed and scheduled Workflows using task developer and workflow designer in Workflow manager and monitored the results in Workflow monitor
• Reviewed the mappings, mapplets, sessions, workflows and workletes for ETL standards
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows
• Involved in development and review of HLD, LLD, Data mapping sheet and Unit Testing of Code
• Prepared unit test cases and executed unit test scripts successfully
• Involved in code reviews as per ETL/Informatica standards and best practices
• Scheduled and lead daily status and weekly status meetings with offshore and client
• Created complex dashboard using multiple data sources like Oracle, SQL and Excel to meet the Business requirement in Tableau
• Created Star schemas, Snowflake schema, fact and dimension tables, logical and physical modeling
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server

Environment: MS SQL Server 2016, Informatica power center 10.1, Oracle11g, Sybase, UNIX (AIX), SQL.Oracle Developer, Rapid SQL, MS Excel, MS Visio, Visual studio 2015, Tableau desktop 10.2, Tableau Server 10.2, MS Access

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Interacted with business users for requirement gathering and experience in translating business requirements to technical requirements
• Developed complex mappings using different transformations like source qualifier, connected lookup, unconnected lookup, expression, aggregator, joiner, filter, normalize, sequence generator and router transformations
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr and IIF function
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic
• Developed SCD Type 1 and SCD Type 2 to capture new changes while maintaining the historic information
• Experience with high volume datasets from various sources like Oracle, Text Files, Relational Tables
• Used Unix scripts for scheduling, executing informatica workflows and handle pre and post session processes
• Worked extensively on Unit Testing and preparing efficient unit test documentation for the developed code to make sure the test results match with the business requirements
• Experience in scheduling using Autosys
• Worked in Tableau environment to create dashboards like daily, weekly and monthly reports using Tableau Desktop & publish them to Tableau Server
• Developed various dashboards, used context filters, action filters, parameters and calculated sets for preparing dashboards and worksheets dealing with huge volume of data
• Blended data from multiple databases into one report by selecting primary key from each database for data validation

Environment: Informatica power center 9.1/ 8.6,Tableau desktop 10.0, Tableau Server 10.0 version, PL/SQL, UNIX, Windows 7, SQL Developer 2014

Confidential, Dallas, TX

ETL Informatica and Reporting Developer

Responsibilities:

• Involved in understanding Data Model, Preparing table scripts, ETL technical design documentation, preparation of field Mapping Specification documents and High level design documents
• Creating mappings using Informatica PowerCenter designer 9.1, as per ETL specification document & creating the jobs for the mappings
• Worked with Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence generator, Router, Update Strategy, Lookup and Normalizer transformations
• Created complex joiners, transformations of all types as needed to pass smoothly data through ETL maps
• Implemented Type 1/2/3 slowly changing dimensions (SCD) logic
• Loading the data from flat files to oracle tables using Informatica mappings
• Preparing the UNIX scripts for SFTP to transfer source data files to Informatica servers
• Involved in Performance tuning activities like remodeling the existing load plan of warehouse, tuning the long running jobs etc
• Created parameter files with Global, mapping, session and workflow variables using UNIX scripts
• Schedule the job using Informatica scheduler
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server
• Create dashboards like quarterly, monthly, weekly, daily reports and schedule the dashboards to requested users and prepared user stories to create compelling dashboards to deliver actionable insights
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications

Environment: - Informatica 9.1, Tableau desktop 9.2, Tableau Server 9.2 Oracle 9i, Windows XP & UNIX

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• As an ETL developer, was involved in understanding Data Model, ETL technical design documentation, preparation of field Mapping Specification documents and High level design documents.
• Involved in the development of mapplets, mappings, worklets, workflows.
• Preparation of ETL High level design document and publish and review the same with various teams like Modelling, testing and the End Users.
• Created mappings using Informatica PowerCenter Designer 8.6, as per ETL specification document & Implemented Reject report for finding the reject records along with the reason for rejecting those in ETL.
• Developed Informatica mappings for SCD type 1, 2, 3
• Worked specifically with the Normalizer Transformation to normalize the data.
• Unit testing and System Integration Testing.
• Designed complex mappings involving target load order and constraint based loading.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Extensively used various performance tuning techniques like pipeline partitioning to improve the session performance.
• Created parameter files with Global, mapping, session and workflow variables using UNIX scripts.

Environment: Informatica 8.6, Oracle 9i, Windows XP & UNIX.

Confidential, Los Angeles, CA

ETL Developer

Responsibilities:

• Interaction with client for status updates on tasks and requirements gathering for new requirements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Extensively used Informatica power Centre loading the data from sources involving sources like Oracle, Sql server, flat files, XML and loaded into DWH.
• Created ETL mappings for various layer of data loads like Staging and DWH.
• Developed and scheduled Workflows using task developer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Reviewed the mappings, mapplets, sessions and workflows for ETL standards.
• Involved in review of detailed Design document, Data Element sheet, UTC & Unit Testing of Code.
• Prepared Unit Test/ Assembly Test cases and executed unit test scripts successfully
• Created the Sample Files for SIT and Tested in SIT(System integration testing) Environment.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Involved in code Reviews as per ETL/Informatica standards and best practices.
• Resolved process abends, change orders, Incidents.
• Maintained the Defect Tracking and fixed the Defects.
• Assigned tasks to the offshore team.
• Setting up and coordinating meeting with Offshore and business users.
• Provide end to end Knowledge Transfer to Offshore team. scheduled daily status and weekly status meetings with offshore and client.

Environment: Informatica power Center 8.6, Flat files, XML, UNIX (AIX), SQL, PL/SQL Oracle 11g, Toad

Confidential

Jr. BI Developer

Responsibilities:

• Actively participated in the requirements gathering sessions and created low level, high level technical design documents as required by SDLC, including the data mapping documents
• Developed SSIS packages for the ETL process; loaded and transformed data from multiple sources like purchasing systems, warehousing systems and Accounts payable systems into the data mart
• Utilized multiple transformations for data cleansing in SSIS data flow, control flow using for loop containers and fuzzy lookups etc
• Implemented data cleansing operation with different transformations such as data conversion, derived column, fuzzy lookup and conditional split
• Implemented error handling in SSIS packages with event handlers, row redirects, and checkpoints
• Optimized the SSIS package performance by modifying the control flow and data flow such as avoiding blocking transformations and increasing the buffer size
• Extended support and maintenance for the project and handled problem management, change management and resolved several incident tickets

Environment: MS SQL Server 2008R2, Windows Server, SSMS, BIDS, SSIS, T-SQL, SSRS, Access, Excel, SharePoint and ITSM (Service Desk Tool)