PROFESSIONAL SUMMARY:

• Over 13 years of experience in Data Warehouse Design, Data modeling, Development, Testing, Production Support using ETL tools like Informatica Power Mart/Center 10.1, Actian Data Connect 9 and IBM Web Sphere DataStage 11.1.
• Ten plus years of technical hands - on experience in development of Data warehousing solutions using Informatica PowerCenter 10.1(Workflow Manager, Workflow Monitor, Repository Manager, Designer -- Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer).
• Six plus years of Extensive ETL tool experience using IBM Infosphere/Websphere DataStage, Ascential DataStage using DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator
• Five plus years of Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man), Teradata parallel support.
• Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
• Three years of Actian Data Connect tool using Process Designer, Mapping designer and source schema designer.
• Strong skills in coding and debugging Teradata utilities like Fast Load, Fast Export, MultiLoad and Tpump for Teradata ETL processing huge volumes of data throughput.
• Experience with IMPORT/EXPORT, Data-Pump, Sql-Loader and built-in packages in Oracle.
• One plus year experience with Big Data using Hadoop,Python and Spark technologies.
• Expertise in Python and usage of eclipse.
• Developed parallel jobs using different processing stages like Transformer, Aggregator, Lookup, Join, Sort, Copy, Merge, Funnel, CDC, Change Apply and Filter
• Familiar in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files
• Efficient in in corporation of various data sources such as Oracle, Teradata, MS SQL Server, and DB2, XML and Flat files into the staging area.
• Experience with both normalized and dimensional data models, hands-on knowledge of other data integration techniques such as database replication, change data capture (CDC).
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inman), Star and Snowflake schema design.
• Expertise in writing complex SQLs, Teradata Load utilities like Multi Load, Fast Load, BTEQ, Fast Export and Oracle utilities such as TOAD
• Proven track record in addressing production issues like performance tuning and enhancement.
• Excellent knowledge in creating and managing Conceptual, Logical and Physical Data Models using Erwin and Power Designer
• Complete Hands on with ETL testing.
• Usage of Eclipse and Python Sql, Razor Sql, GIT, Jira
• Experience in dimensional and relational database design.
• Strong in Data warehousing concepts, dimensional Star Schema, Extended Star Schema and Snowflakes Schema methodologies.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in different Scheduling tools like IBM ControlM Scheduler, Tivoli Work Load scheduler (TWS), Crontab for automating and scheduling jobs run.
• Excellent with PL/SQL, T-SQL, Stored Procedures, Database Triggers and SQL * Loader
• Proficient in UNIX Shell Scripting.
• Experience in analyzing the data generated by the business process, defining the granularity, source to Confidential mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development
• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling using Workflow Manager
• Excellent knowledge of operating systems Windows, UNIX, LINUX and databases including Oracle, Teradata, SQL Server, and DB2.
• Experience of End-To-End data warehouse project implementation
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

KEY TECHNICAL SKILLS:

Data Warehousing: Actian Pervasive, Confidential Connect Data Integrator, Ascential DataStage 9.1,8.5, 7.1 Enterprise Edition (Designer, Director, Manager, Parallel Extender), Informatica Power Center 9/8.X/ 7.1/7.0/6.1/5.1/4.7 , Power center 10.1 Administration, Informatica Power Mart 6.1/5.1.2/4.7.2

Database: Oracle 9i/8i/8.0/7.3, SQL*Loader, PL/SQL, SQL*Plus, Explain plan, Stored Procedures, triggers, Materialized Views and cursors), MS Access, DB2 UDB, SSIS packages, Teradata 13.x,14

Data Modeling: Power Designer, Erwin 4.0/3.5.5/3.5.2 (Dimensional data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling), Visio 6.0

Business Analysis: MS Project 2000, User Interviews, Business Requirements Gathering, Process flow diagrams, Microsoft Visio, Jira, GIT

Scheduling Tools: Ctrl-m Scheduler, Tivoli Work Load Scheduler, JAMS Scheduler, Crontab Scheduler

Programming: SQL, PL/SQL, Visual Basic 6.0/5.0/4.0, HTML, COBOL, Java, C, C++, SAS, UNIX, Shell Scripting,Teradata SQL

Teradata tools and load utilities: BTEQ, Multi Load, Fast Load, Fast Export, Tpump, Teradata Manager, SQL Assistant, Teradata Administrator, Index Wizard, Statistics Wizards.

PROJECT EXPERIENCE:

Confidential, GA

Sr Integration Consultant

Hardware/Software: Informatica PowerCenter 10.1, Informatica Cloud 10.1, Oracle 11g, SAP HANA, Unix, CA Scheduler, Eclipse, GIT

Responsibilities:

• Participated in the requirements gathering process, Data Analysis, High level (HLD) and Low level (LLD) design process, meetings with SME’s and stake holders. Created technical, AID (Application Information documents), LLD, HLD and Run-books documentation.
• Performed data analysis for both Source and Confidential tables/columns.
• Provided technical documentation of Source and Confidential mappings.
• Developed automated extraction, transformation, and load processes to migrate a subset of data from production applications, integration tools, operational data stores and data warehouses for the purpose of supporting development and testing requirements in the non-production environments
• Implemented the CDC replication (real-time data replication) process to replicate data to operational data store and historic data store from multiple applications to serve reporting needs.
• Automated the Installation and Configuration of Informatica Power center and Power Exchange services. Setup and configure PowerCenter domain, grid, repositories, folders and integration services. Implement LDAP authentication in Enterprise ETL, integrated the authentication process in ETL with Oncor active directory.
• Implemented High Availability process in Power Center services and workflows.
• Developed ETL processes for multiple interfaces to support data integration between different applications, following established development standards and processes.
• Developed Procedures/Functions, Triggers and ETL Packages using SQL, SQL*Plus, PL/SQL. Develop and perform test strategies and plans for Unit, Integration, System and User Acceptance Testing.
• Developed scripts to implement auto restart and audit processes in ETL jobs.
• Implement performance tuning in Informatica Mappings by identifying the bottlenecks and Implemented effective transformation Logic.
• Developed scheduling jobs using CAWA (CA Workload Automation) to implement batch schedules for multiple modules.
• Participated in DR (Disaster Recovery) solution, work with DR team in designing DR process for Enterprise ETL applications.
• Designed the ETL code repository structure in GIT (SVN to GIT migration) to support multiple ETL applications (Enterprise ETL, AMS ETL & CIS ETL).
• Closely worked and assist the QA team during the test cycles to resolve the issues and bug fixing.
• Performed production migrations.
• Worked closely with the Reporting team for their requirements, issues on the operational data.
• Created Project documents, ETL migration documents, Power center Installation documents, Source to Confidential mapping documents and operation manuals
• Extensively used JIRA for all the types of tickets during production support and for Project work.
• Ensured performance metrics are met and tracked.
• Experience with Kimball Dimensional Modeling, Bus Matrix and DW Lifecycle.

Confidential, CA

Sr Integration Consultant

Hardware/Software: Informatica PowerCenter 10.1, Confidential Connect Data Integration Tool, Actian Data Connector 11, Oracle 11g, Flat files, Unix, Cron Scheduler, Eclipse, GIT, SOQL, Force, Teradata14, SQL Assistant 14.0, BTEQ, FastLoad, FastExport, Multiload

Responsibilities:

• Used Confidential Connect Data Integrator to extract data from sources systems like Flat files, SFDC loaded the data into the ORACLE database with Incent as UI.
• Driven detailed ETL and data requirements to capture Customer Business Requirements and deliverables.
• Collaborated with IT and Business Teams to gather high level Integration and Compensation requirements.
• Worked on custom process queueing system for Data Integration Process to give customers the visibility of process runs.
• Created Teradata stored procedures and functions to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Automatically loading source system data such as Sales transactions and HR data. Leverage Connect Rest APIs to pull real time data into reporting dashboards.
• Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Coded individually and collaboratively in a team environment, adhering to coding standards and industry best practices.
• Troubleshoot and provide resolution of problems, test system and software performance throughout the completion of the development cycle.
• Complete Agile methodology.
• Active participation in decision making and Requirements, QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Created documentation of software, systems and solutions for multiple audiences (e.g., internal development engineers, testers, managers and end users)
• Working collaboratively with larger groups and diversified teams as necessary, extremely comfortable working in a large information technology environment, and be capable of independently building
• Experience in working with different types of sources like Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 10.1
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.

Confidential, MN

ETL Designer

Hardware/Software: DataStage 9.1, Oracle 11g, SQL Server 2008, Flat files, Unix, SAP Scheduler, MS ACCESS ( )

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using DataStage 9.1
• Prepared Data Mapping Documents and Design the ETL jobs
• Active participation in decision making and Requirements, QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database. Designed and Developed Data Stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes. Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Developed MS Access macros, queries and run them through windows scripts to generate source files for ETL jobs.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Creation of jobs sequences.
• Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables.
• Created windows batch scripts to run data stage jobs from UNIX and make them run through SAP BI scheduler.
• Coordinate with team members and administer all onsite work packages.
• Analyze performance and monitor work with capacity planning.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Participated in Daily status meetings.

Confidential, MN

ETL Designer

Hardware/Software: Informatica 10.1, Teradata 14.0, SQL Server 2008, Flat files, Linux, TWS Scheduler, SAS, Korn Shell, Oracle

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using Informatica 10.1 and Teradata.
• Prepared Data Mapping Documents and Design the ETL jobs
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Was an integral part of SAS to Teradata conversion.
• Used Teradata Data Mover for overall data management capabilities for copying indexes, global temporary tables.
• Wrote numerous BTEQ scripts to run complex queries on the Teradata database. Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process. Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created tables, views, Macros in Teradata, according to the requirements.
• Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to Teradata RDBMS using BTEQ, MultiLoad and Fast Load.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to Confidential mappings/source views, and to verify data in Confidential tables
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Creation of jobs sequences.
• Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling TWS tool.
• Coordinate with team members and administer all onsite and offshore work packages.
• Analyze performance and monitor work with capacity planning.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Participated in Daily status meetings.
• Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.

Confidential, MN

ETL, DW Designer

Hardware/Software: Informatica Power Center 9.1, SQL Server 2008, Flat files, Sequential files, Windows, JAMS Scheduler, CRM Application, Dot net Framework

Responsibilities:

• Implemented new billing module and sunset legacy billing systems
• Converted historical data into new Billing system
• Created multiple integrations in/from other applications
• Developed technical design and building components based on Use cases.
• Created new User Interfaces to view General Ledger and Record-keeper interfaces.
• Created Data models to generate flow into DW from different up streams
• Built ODS, Data Warehouse to create Reports
• Implemented archival strategy for the DW.
• Working collaboratively with larger groups and diversified teams as necessary, extremely comfortable working in a large information technology environment, and be capable of independently building
• Created stored procedures and SSIS packages to do conversion from old billing system to new billing system.
• Experience in working with different types of sources like Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.0.1
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.

Confidential, MN

ETL Designer, lead

Hardware/Software: Informatica Power Center 9.1, Oracle 10g, SQL Server 2008, DB2 UDB, Flat files, Sequential files, TWS, AIX UNIX

Responsibilities:

• Manage the as required by portfolio projects design and implementation of new Integration environments
• Working collaboratively with larger groups and diversified teams as necessary, extremely comfortable working in a large information technology environment, and be capable of independently building
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the Confidential Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Used Informatica PowerCenter 8.6.1/9.0.1 to migrate the data from OLTP to Data Warehouse.
• Experience in upgrading from Informatica version 8.6.1 to 9.0.1.
• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.0.1/8.6.1
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.

Confidential, MN

ETL Designer, lead, developer

Hardware/Software: IBM DataStage 8.0 (Designer, Director, Manager, Parallel Extender), Oracle 10g, SQL Server 2008, DB2 UDB, Flat files, Sequential files, TWS, AIX UNIX, Control M, Erwin

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Set job monitoring limits and other Director defaults, set user and group privileges, Enable or disable server-side tracing on the Tracing tab.
• Specify parallel job defaults on the Parallel tab, Specify Job Sequencer defaults on the Sequence tab. Studied the PL/SQL code developed to relate the source and Confidential mappings.
• Helped in preparing the mapping document for source to Confidential .
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the Confidential Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used IBM Control M job scheduler for automating the monthly regular run of DW cycle in both production and UAT environments.
• Wrote Configuration files for Performance in production environment.
• Partnerships with diversified business and technical teams
• Used Data stage routines to generate new keys.
• New data stage job designs introduced for new logic to be incorporated.
• Created UNIX scripts to run the jobs, load the logs into the table.
• Worked on Encryption Functions in Oracle for encrypting sensitive information in the applications.
• Resolved Production data quality issues for reporting.
• Developed C++/C custom routines.
• Complex SQL debugging to find out data quality issues.
• Develop and maintain reporting structures including Oracle tables and other structures, SQL queries and reports to support the needs of the project as well as on-going needs of business owners
• Monitor and manage production jobs using Control M scheduler/CA Scheduler.
• Prepared/ Performed Unit test cases, System test cases, Integration test cases.

Confidential

ETL Developer

Hardware/Software: I Informatica Power Center 8.X, IBM DataStage 7.X (Designer, Director, Manager, Parallel Extender), SQL 2005,2008, Oracle 10g, SQL Server 2008, DB2 UDB, Flat files, Sequential files, TWS, AIX UNIX, Control M, Erwin, Perl, Teradata

Responsibilities:

• Interacted with the client to understand the business requirements.
• Hands on experience in writing Technical Documents as per the requirements.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the Confidential Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Used Informatica PowerCenter 7.1.2/8.1 to migrate the data from OLTP to Data Warehouse.
• Experience in working with different types of sources like Oracle, Flat Files, XML, DB2 and SQL Server.
• Developed mappings using PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 9.0.1/8.6.1
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Handle slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Extensively used Mapping Variables & Parameters, Workflow Variables and Session Parameters.
• Extensively involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Involved in Performance tuning for sources, targets, mappings, and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Documents were prepared and the existing modified for future reference.