SUMMARY

• As a Business Oriented Professional eight years (8) years of total IT experience and strong background in Data Modeling, OLAP, ETL Design, Analysis, Development, Testing, Performance Tuning, Implementation, Troubleshooting and error handling in the field of Data Warehousing in ETL process using Informatica, ODI 12c/11g/ 10.1.3.4/10.1.3.5 , BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server/2008R2/2012 /2014 Well experienced in all phases of System Development Life Cycle (SDLC).
• Extensive development experience for the Extraction, Transformation and Loading of data from multiple sources such as Informatica, ODI, Oracle, MS SQL Server, DB2, Flat Files and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Extensive experience in writing stored procedures , functions and views.
• Extensive experience in writing and tuning complex sub queries, SQL , PL/SQL stored procedures , functions , and triggers.
• Experience in requirement analysis, coding and testing various modules in a software development life cycle.
• Expertise preparing report specifications and database designs to support reporting requirements.
• Good experience in PL/SQL and ETL scripting and query optimization.
• Extensive Data Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions table and Physical and Logical data modeling.
• Good knowledge of Data ware house concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in creating ODI Packages, Procedures, Triggers for Jobs of various complexities and automated process data flow.
• Testing and Implementation of the ETL/Data warehouse project.
• Experience in debugging Interfaces, identifying bugs in existing Interfaces.
• Worked on Manufacturing and Retail domain in ODI Projects.
• Handsome experience on dealing with ODI Knowledge Modules like, LKM, IKM and CKM .
• Good knowledge in different versions like ODI 11g and ODI 12c and their installation.
• Experience in SQL L oader (data conversion) and Toad.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
• Preparing the Document of Understanding of the Project Requirement and Specification.
• Incident Management, Change Requests handling and bug fixing for issues like Manual Data Extraction, Data Scrubbing, Job amends and fixing Configuration issues for Oracle and ODI 11g and OWB
• Good understanding of RDBMS and job scheduling, indexing, and ETL and OLAP processing, and Software Development Life Cycle (SDLC)
• Good motivation to take independent responsibility as well as ability to contribute and be a productive team member.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, Windows 98/XP, windows 7, windows 10

ETL Tools: ODI,10.1.3.6,/11g,/12c, OWB 11g/10g. SQL Server 2008R2/2012

Web Technologies: HTML, Java Script, XML, CSSLanguages SQL, PL/SQL, UNIX/Linux, Shell Scripting

Databases: Oracle 10g/11g, DB2 and MS SQL Server 2000/2005/2008.

Other tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader.

IDE: Visual Studio 2003/2005/2008 R2/2012

Reporting Tools: OBIEE 11.1.1.5/11.1.1.6. SSRS.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles

ETL Developer

Responsibilities:

• Design and build ETL processes (Star Schemas) and ETL for relational reporting.
• Interacted with the users for requirement analysis and to define business and functional specifications.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Responsible for developing PL/SQL Procedures/Functions and called from ODI.
• Worked with ODI Graphical (Designer, Topology Manager, Operator and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration, Service).
• Created and maintained Process Flows and schedules for loading data into the Data Warehouse using ODI, Used SQL*Loader to load flat files and created log tables containing data with discrepancies.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Involved in unit testing, integration testing and system Testing and maintain detailed project documentation.
• Utilized JIRA, BMC remedy and kept track of all the tickets assigned and cleared the tickets with in deadline.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• 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.
• Migrated OWB mappings to PLSQL and created procedures and packages.
• Design and build ETL processes (Star Schemas) and ETL for relational reporting.
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses using Erwin 7.2
• Upgrade of Oracle Data Integrator from 10.1.3.5 to ODI 11g.
• Wrote shell scripts in UNIX using PUTTY to load the data.
• Scheduled various jobs in Crontab to load the data in the SQL tables.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Performing advanced ETL development activities using SQL Server Confidential (SSIS), T-SQL, etc.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Environment: ODI 11g / 10.1.3.4,OBIEE, PL/SQL, SQL, SQL Loader, Toad, ETL, Erwin, Flat files, Oracle 12c/11g, Shell Programming, Toad, SQL Developer, Unix scripting, Windows XP. SQL Server 2012, 2012 R2, Visual Studio 2012, T-SQL, SQL Server Analysis Services, SQL Server

Confidential, Los Angeles

ETL Developer

Responsibilities:

• Creates test plans/cases in Rally.
• Involved in R&D, model, design and Develop the process to setup dependency between Informatica Power Center (In-house) and Informatica Cloud process.
• Design Mapping Specifications based on the Transformation rules to load the data from source to the Staging.
• Designed and developed Informatica Mappings/Sessions/Workflows to load data from Source systems to Staging DB.
• Executed the test cases and reports test results and project progress
• Defines, coordinates, supports and performs Functional, System, Integration, Regression and Performance Testing across all assigned integrations.
• Leads and assists in the ongoing development of repeatable processes for the QA approach, processes and methods
• Worked with software/systems personnel in application testing, such as system, unit, regression, load and acceptance testing methods.
• Provide guidance to the testing team for proper and efficient testing.
• Helped developers to ensure quick turnaround for defects.
• Worked in Informatics power center for incremental loads.
• Managed Rally and acted as a scrum master.

Environment: Informatica Power Center 9.6.1, Informatica cloud, files, Oracle 12c/11g, Shell Programming, Toad, SQL Developer, Unix scripting, Windows XP. SQL Server 2012, 2012 R2, Visual Studio 2012, T-SQL, SQL Server Analysis Services, SQL Server

Confidential, Plano, TX

ETL DEVELOPER

Responsibilities:

• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager/ SSMS in SQL Server 2008/2012 environment, and deploy the data. Scheduled the jobs to do these tasks periodically.
• Tuning and optimization of SQL/Teradata Queries, Change request management.
• Extensively writing Teradata Coding with multiple SQL statement scenarios in Dev and Prod Environment.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, databases using SSIS packages.
• Extensively used SQL Server tools like Query Analyzer, Enterprise Manager, Profiler and Management Studio Collaborate with data architects for data model management and version control.
• Create data objects (DDL).
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Enhancing and deploying the SSIS Packages from Development server to UAT and Production server.
• Responsible for designing and implementing efficient Stored Procedures and SSIS Packages.
• Creating SSIS package to load data from Flat file to data warehouse databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate and Pivot Transformation.
• Used Teradata utilities fastload, multiload to load data.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Performance tuned and optimized various complex SQL queries.
• Extensively used SQL Analyzer and wrote complex SQL Queries using joins, sub queries and correlated sub queries.
• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Created Logical & Physical Data Modes using Entity Relationship Diagrams.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2014. .
• Migrated data between different heterogeneous sources such as Flat file, Excel 2010 using SSIS.
• Created physical and logical models using Erwin to effectively translate conceptual model into logical and physical models conforming to the business and data requirements.
• Designed and developed Reports in SQL Server 2014 Reporting Services (SSRS).
• Developed cubes by defining data sources and data source views and using SQL server analysis services (SSAS).
• Created views, Tables, stored procedures.

Environment: Microsoft SQL Server 2012, 2012 R2, Visual Studio 2012, T-SQL, SQL Server Analysis Services, SQL Server Confidential, Business Intelligence Development Studio (BIDS),Power BI Pivot, SQL Server Reporting Services, Teradata SQL Assistant, SQL server profiler, Team Foundation Server, Erwin DATA MODELER.