SUMMARY

• Data warehouse/Business Intelligence professional with 10 + years of experience; Worked in all phases of project like Business Requirements Gathering/Analysis, Development, Testing, Implementation, Deployment, Maintenance and Production Support.
• Extensive experience in Health Care, Banking, Insurance and Retail domains.
• Expertise in Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center 10.1/9.6/9.1/8.1/7.1 (Administrator activities, Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Worklet, Mapplets, Transformations, Partitions, version control and performance tuning).
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Sound knowledge on Data Warehouse concepts - Data Modeling using Star Schema/Snowflake Schema, Normalization, OLAP, ODS, EDW, Data Marts, Facts & Dimensions tables.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels. Also Involved in Performance tuning Oracle level using advance techniques for faster execution.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• 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 User defined functions, reusable transformation, Mapplets to use them in different mappings. Also created reusable task and worklets to use in different workflow.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• 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 SQL* loader to load data from flat files to the database tables in Oracle.
• 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.
• Expertise in scheduling BI/ETL jobs using Control-M, Cron, AutoSys jobs and Informatica Scheduler.
• Strong skills in Oracle Programming which includes SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers.
• Experience in visualization tools like Business Object and OBIEE.
• Basic Knowledge of Big Data technologies like Hadoop - Hadoop Architecture, JobTracker, TaskTracker, NameNode, Data Node, Map Reduce, manage and external tables.
• Basic Knowledge of Tableau.
• Experience in Production Support (rotational On-Call) for ETL and Reporting jobs - debugging issues and fixing within SLAs. Also involved in maintenance work, coordinating with other teams and managing services for all BI Servers.
• Experience in working closely with business product owners within the Agile/Scrum development process to deliver as per business requirements.
• Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.
• Quick learner and ability to work in a team as well as individually, who likes to work on cutting edge technologies, problems and leverage opportunity to enhance skills.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Worked with client directly. Almost 2 years of experience to work with client at onsite USA.

TECHNICAL SKILLS

ETL: Informatica 10.1, 9.x, 8.x, 7.x, SQL Loader, Informatica Cloud

Big Data: Hadoop, Hive, Sqoop, pig, Oozie

OLAP: OBIEE, Business Objects, Tableau

RDBMS: Oracle 9i/10g/11g/12c, Teradata, DB2, SQL Server

Languages: Shell Script, SQL, PL/SQL

Scheduling: Control-M, Cron, Autosys

Version control: GIT, Stash, Perforce, WinCVS

Other Tools: MS Office, TOAD, SQL Developer, IDQ, Rapid SQL, Jira, Splunk, HP Quality center, Visual Studio TFS ( Team Foundation Server), Jenkins

PROFESSIONAL EXPERIENCE

Confidential, Southborough, MA

Sr. ETL Lead

Responsibilities:

• To assist Client in providing support function for incident management and problem resolution. to their existing clients in the current platform.
• Working as ETL Technical lead using Informatica as ETL tool.
• Maintaining ETL support in defect management system for existing and new defects and SRs.
• Pro-active monitoring for issues. Monitor ETL process in production on daily basis.
• Coordinate call with customer and their vendors for data loads SQL Server, Oracle database and File Systems through ETL process.
• Triaging of ETL, Database Tickets/Issues.
• Provide ETL L1 Support and L2 Support within SLA.
• Working on ETL SRs and fixing production defect.
• Perform ETL QA testing, Link Testing and Regression Testing.
• Involved in Production Deployment and in Code Merge.
• Performance tuning of ETL code. Performance Testing for SR/Defect related work.
• Helping end user in UAT for defect fix and SRs.
• Automation & Performance Testing for ETL SR/Defect related work.
• Application Support where ETL tool is Informatica.
• Developed SQL script for one shot fix.
• Analysis of the problem statement and suggest solutions. Provide ETL Architectural solution for repeated defects.
• Communicate with all stakeholders on problem statement, possible solutions, intermediate issues and overall status of work assigned.
• Analysis and presentation of the issues and changes to the systems.
• Technical and functional ownership of the applications.
• Coordinate with Build teams for all changes, documentation and handover.
• Use JIRA as defect management/ issue tracking tools.
• Send Weekly, Monthly, Quarterly reports on ETL defects and SRs.
• Resolve defect related to Tableau reports.

Confidential

Sr. ETL Developer

Responsibilities:

• Worked as offshore ETL lead and handle team of five developer.
• Collaborated with Business Users for requirements gathering, business analysis, functional and technical design.
• Conducted meeting with onsite team and coordinated with offshore team to provide technical and functional direction to ensure quality deliverables.
• Extensively used Informatica (ETL) to load data from wide range of sources such as Oracle database and flat files (fixed-width or delimited).
• Developed Informatica mappings to process high volume of data and build a data warehouse from various sources like Oracle, SQL server, flat files and XML files.
• Responsible for Extracting and transforming data from different source systems and loading to staging area using Informatica and PL/SQL.
• Worked on Performance tuning and optimization using indexes, partitions, bulk collect, for all, explain plans, temporary tables, optimizer hints, SQL trace.
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Created packages and procedures to load the data from source to staging and same called in Informatica.
• Responsible for deploying the Informatica objects into another environment using deployment group.
• Responsible for creating and importing all the required sources and targets to the shared folder.
• Created Test Plan Document-UTC (Unit Test Cases) and executed them.
• Extensively used the mapping parameter and variables in simplifying the code during development phase
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Confidential, San Francisco, CA

ETL Consultant

Responsibilities:

• Worked as onsite Informatica Lead. Handled offshore team of three Informatica developer.
• Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI.
• Conduct meeting with client and vender for requirement gathering. Conducting impact analysis of requirement.
• Get knowledge on client’s business and requirement and provide technical solution to build datawarehouse and report generation.
• Prepare data field mapping document technical analysis and design document for deliverables.
• Technical design document review.
• Prepare ETL process design document.
• Informatica Coding for development /enhancement/modification of new/existing ETL process.
• Prepare test data for deliverables testing. Perform Unit testing and prepare unit testing related ocumentation.
• Perform code review and Prepare code review document.
• Mock runs and data file validations.
• Conduct JAD sessions for team deliverables.
• Coordinating quality assurance efforts and helping testing team to execute test validations for project changes in various Test phases i.e. SIT, UAT, Regression and Performance testing.
• Business approval of mapping and design documents for deliverables.
• Participating in all the release management activities and providing description of project, back out plans and implementation of enhancements in to real time environment.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Confidential

ETL Consultant

Responsibilities:

• Worked as offshore ETL lead and handle team of five developer.
• Collaborated with Business Users for requirements gathering, business analysis, functional and technical design.
• Conducted meeting with onsite team and coordinated with offshore team to provide technical and functional direction to ensure quality deliverables.
• Extensively used Informatica (ETL) to load data from wide range of sources such as Oracle database and flat files (fixed-width or delimited).
• Developed Informatica mappings to process high volume of data and build a data warehouse from various sources like Oracle, SQL server, flat files and XML files.
• Responsible for Extracting and transforming data from different source systems and loading to staging area using Informatica and PL/SQL.
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Created packages and procedures to load the data from source to staging and same called in Informatica.
• Responsible for deploying the Informatica objects into another environment using deployment group.
• Responsible for creating and importing all the required sources and targets to the shared folder.
• Created Test Plan Document-UTC (Unit Test Cases) and executed them.
• Extensively used the mapping parameter and variables in simplifying the code during development phase
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems. Also worked on performance tuning and optimization using indexes, partitions, bulk collect, for all, explain plans, temporary tables, optimizer hints, SQL trace
• Documented High Level Design, Low level Design, STM's, Unit test cases and Deployment documents etc.
• Provided Production Support for ETL and Reporting jobs.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Confidential, Louisville, KY

ETL Consultant

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• Worked as onsite ETL lead and worked with Offshore team. Code review of the ETL code developed by offshore and performed testing.
• Assisted with establishing and administering the Informatica and Unix environment.
• Used Informatica Power Center 9.5 to extract, transform and load data from multiple input sources like Oracle, flat files to target Oracle database using various transformation.
• Involved in Data Analysis, Data Validation and Data Cleansing.
• Created reusable transformations and mapplets.
• Created Sessions, reusable worklets and workflows in Workflow Manager.
• Implemented efficient and effective performance tuning procedures.
• Worked extensively on SQL, PL/SQL and UNIX shell scripting.
• Created and scheduled workflows using Workflow Manager at specified frequency to load the data into the Target Database.
• Documented High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents etc.
• Involved in Code migration to different Repositories (Test /Prod).
• Interacted with DBA’s, Informatica Admin team to resolve the issues.
• Used Informatica Cloud to replicate PDI’s Salesforce.com CRM data into the company’s reporting infrastructure where it can be shared across the enterprise. Similarly, Informatica cloud is used to upload oracle data in Salesforce.com CRM.
• Production Support & Maintenance.
• Worked on Pricing Estimated and SOW documentation and review.
• Prepared Project Plan, defined scope and worked for resource allocation.
• Stakeholder Management and Escalation support.

Confidential

ETL developer

Responsibilities:

• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (Oracle DB and Flat files).
• Designing the dimensional model and data load process using SCD Type II.
• Extensively used Transformations like Static/Dynamic Lookup, Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Interacted with client and gathered requirement for further enhancement of project.
• Deploying and monitoring the informatica workflows in UAT environment.
• Created IDQ mappings and profiles for Source Data profiling and produced scorecard, charts etc to view number of null values, wrong date formats etc
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by doing Performance tuning techniques like increasing block size, data cache size, sequence buffer length.
• Developed UNIX shell scripts to create parameter files, rename files and compress files.
• Developed low level Design, STM's, Code Review / Peer Review documents and Code migration documents.
• Developed the unit test cases (UTC) and test scenarios to test the reports according to the business requirement.
• Developed the various report with conditional formatting by using Presentation Services in OBIEE.
• Developed hierarchies to support drill down reports in OBIEE.