SUMMARY:

• 9 years of Strong IT experience in Life cycle development of building a Data Warehouse for large technology projects including Planning, Designing, Data analytics, Development, Maintenance and Support.
• Development of Data Quality mappings and Building Data Warehouse using ETL - Informatica Power Center 9x& 10.1 for OLTP, OLAP and equivalent large systems.
• Expertise in IBM Infosphere Data stage 11.5/9.x/8.x/7.5.x Suite. (Data stage & Information Analyzer).
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0 and Teradata.
• Strong Database skills in writing advanced SQL and PL/SQL queries in Oracle.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Strong experience in developing complex mappings using varied transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Unstructured Data Option (UDO), Stored Procedure, Update Strategy and Re-usable transformations
• Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency
• Extensive experience in error handling and problem fixing in Informatica.
• Strong Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements
• Experience in integration of various data sources from Databases like Oracle, SQL Server and dealing source files like XML files and regular flat files (.dat, .csv)
• Worked extensively with different Job Schedulers like Autosys, Control-M and cron jobs in UNIX.
• Expertise in postproduction support, enhancements and performance tuning.
• Experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting.
• Strong experience in Version control, deployment process and implementation to different environments.
• Sound Knowledge of Data Warehousing concepts, Dimensional modeling (3NF) like Star Schema, Snowflake Schema and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Good knowledge in Agile Methodology and experience working in Scrum Teams.
• Experience in Incident Management, Change management process during and after implementation.
• Experience in Coordinating onsite - offshore interaction, contributed suggestions and valuable solutions during the on-going. Good communication skills, interpersonal skills, self-motivated, quick learner and valuable team player.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.1.1/9.6.1/9.1 /8. x/7.x, IBM Information Server(DataStage) 11.5/9.1/8.x/7.x, Pentaho 4.4.2

RDBMS: Oracle 12c Exadata/11g/10g/9i/8i, SQL Server 2000, Netezza, Teradata 14, IBM DB2 V9.2.

Data Modeling Tools: ERwin 4.0/3.5

OLAP Tools: Cognos 8, Business Objects XI/6.x

Programming Languages: SQL, PL/SQL, C, C++, COBOL, JCL, VB, UNIX Shell Scripting.

Operating Systems: Windows98/2000/NT/XP, UNIX AIX, Sun Solaris

Scheduling Tools: AutoSys 4.0, Control-M

Other Tools: Subversion, Clear Case, Clear Quest, TOAD, SQL*Loader, WinScp, Microsoft Visio Professional 5.0, Jira, QC ticket tracking tool

Big Data Ecosystems: HDFS, HIVE, PIG, SPARK

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA.

Sr. ETL Consultant

• Participated in analyzing user requirements, identifying data needed to deliver requirements, and developing data models using data warehousing concepts.
• Participated in design and development of Star schema database and mappings between sources and operational staging targets by identifying suitable Fact and Dimensional tables for the schema
• Creating various Documents such as Functional Specification Documents, Source-To-Target Data Mapping Documents, Unit Test Cases and Data Migration Check list Documents.
• Analyzed the Functional Specs provided by the Business Analyst.
• Developed ETL processes to extract data from source to staging and from staging to ODS
• Developed ETL processes to load various Dimensions and Facts.
• Developed Change detection capture (CDC) processes to identify new and changed loan related information.
• Worked on slowly changing dimensions based on the business requirements.
• Applied necessary transformation rules Performed Unit testing of developed components and promoted the code to testing environment.
• Involved in the error checking and testing of ETL Procedures using Informatica Session log and workflow logs.
• Coordinated with QA team for Bug fixes.
• Prepared the implementation plan and coordinated with Release management team for production deployment.
• Monitored the scheduled jobs using Informatica Monitor.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Worked closely with different teams to make sure that the dependency of data is being met and ensured that there are no hurdles.

Environment: Informatica Power Center 10.1/9.6/9.1, Oracle 12C/11g/10g, ERwin 4.5, PL/SQL, SQL, UNIX Shell Scripting, Autosys, Windows-7, Sub Version, Jira, QC, Pac2000

Confidential, Sunnyvale, CA

Sr. ETL/Data Stage Consultant

• Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data
• Prepared mapping documents for the source to stage extract and the stage to EDW ETL jobs.
• Participated in data model design and ETL design.
• Closely worked with the solution architecture team to resolve issues in the data model.
• Prepared ETL design documents and low-level design documents.
• Developed DataStage Parallel jobs for extracting data from heterogeneous sources.
• Conducted performance tests and resolved issues to ensure that the jobs can be completed within the SLA.
• Conducted code reviews for the jobs developed by the onsite and offshore teams.
• Worked on Dimensional modeling to design and develop STAR schemas, Identifying Fact and Dimension Tables.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
• Working in the Oracle PL/SQL procedures & packages to analyze and develop the new business requirements and enhancements in the existing functionalities.
• Good hands on experience in performance tuning and maintenance on ETL tool and Oracle Database.
• Closely worked with the testing team for data loads for the system acceptance testing.
• Provided assistance to the Business Analyst team regarding questions on the data model and data availability.
• Created implementation plans and migration checklists (ETL and DB objects) for production deployment.
• Worked with the Production Operations team to address any issues during the deployment process.
• Provided production support during the project go-live and the warranty phase.

Environment: WebSphere DataStage 11.5/9.1/8.5, Pentaho 4.4.2, HDFS, HIVE, Oracle 11g/10g, ODI, Netezza, SFDC, ERwin 4.5, PL/SQL, SQL, UNIX Shell Scripting, Sun Solaris, Windows

Confidential, MD

Sr. ETL Consultant

Roles & Responsibilities:

• Responsible for the Business Analysis and Requirements gathering, create a road map for the Data warehouse designing
• Translated user requirements into system solutions
• Involved in Data Analysis of the OLTP system to identify the source tables and their reference data tables for extraction of the data
• Worked with Oracle and SQL Server source systems
• Implementing Screen Door Process for Flat file sources for data validation and data cleansing
• Designing and developing Mappings using Mapping Designer to load the data from various sources using different transformations like Unconnected and Connected lookups, Router, Unstructured Data Option (UDO), Aggregator, Sorter, Ranker, Joiner, Stored Procedure, Update Strategy and Re-usable transformations
• Creating Sessions, Workflows and Worklets for data loads using Workflow Manager
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks
• Developed and implemented Error Handling Strategies
• Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
• Preparing and using test data/cases to verify accuracy and completeness of ETL process
• Maintaining issue log of the issues during the UAT phase for future reference
• Migrating Folders, Mappings across repositories and folders

Environment: Informatica Power Center 8.1, Power Exchange 8.1.1, Oracle 9i, SQL Server, VSAM Files, Flat files, Microsoft Excel 2000, Microsoft Visio, PL/SQL, SQL*Plus, TOAD 6.3.11.1g, Windows XP Professional, UNIX, Erwin