PROFESSIONAL SUMMARY:

Strong focus on the Software Development Life Cycle (SDLC) utilizing both agile an waterfall methodologies with experience in functional and technical design, concept, architecture, planning, modeling, coding, development, testing, and implementation and support of Business Intelligence solutions using data warehouse/data mart design, ETL, OLAP, and BI. A team player with good communication skills and ability to work in groups as well as independently with minimum supervision. Skilled with enterprise data warehouse, data marts and operational data stores in major industry sectors using Informatica Power Center 9.x, 8.x and 7.x.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, LINUX, MS - DOS

Modeling: Dimensional data modeling, star schema modeling, snow - flake Schema modeling, E-R modeling, Visio

RDBMS: Oracle 12c/11g/10g/9i, Teradata 14/13/12, DB2, SQL Server 2000/2005/2008, DB2, MySQL, Sybase

ETL Tools: InformaticaPowerCenter 9.x/ 8.6.1/7.1.1

Reporting Tools: Cognos, Business Objects, Tableau

Languages: XML, UNIX Shell Scripting, SQL, PL/SQL, Python

PROFESSIONAL EXPERIENCE:

Confidential, CA

ETL Developer

Responsibilities:

• Worked closely with BA and business users during the requirements gathering stage of the engagements in order to publish functional specification documents detailing the application user requirements, system inputs/outputs, various module requirements and technical details.
• Designed, developed and maintained projects, ETL architecture from multiple environments by working with various source systems and fetched data via flat files, views, database connections in Teradata, Oracle, mainframe etc.
• Created mappings in informatica, SQL loader using UNIX scripting to stage/validate data before it is to be standardized as per the business requirements which will be leveraged to assemble contracts in later processes.
• Expert level skills on Source, mapping, device configuration, designer transformations, complex and simple mapplets, external call factor, lookups, UDF and several other power center designer objects.
• Created scheduler batches in autosys scheduler and automated jobs.
• Responsible for identifying tool limitations/bugs and worked with peer developers and in parallel designed work arounds till it is resolved in later builds/patches.
• Extensively created SQL, PL/SQL stored procedures to create tables, keys (unique and primary) and indexes in the database,complex source qualifier queries, pre and post SQL queries in the target.
• Analyzed source system’s live data to identify the design fallouts and worked with analysts to address them as change requests or enhancements based on LOE and SLA.
• Extensively used workflow variables, mapping parameters and mapping variables and slowly changing dimensions logics.
• Used ETL methodology for supporting Data Extraction, transformations and loading processing, using Informatica BDE to Hive target in Hadoop.
• Implemented performance tuning logic on targets, sources, mappings and sessions to provide maximum efficiency and performance also by analyzing HIVE scripts that are generated during session runs.
• Involved in unit, integration, system, and performance testing levels. Wrote test scripts in Teradata and oracle to validation and process audit.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (testing) and supported QA team and UAT (user) and maintained entire wireless solution.
• Created detailed unit test document with all possible test cases/scripts.

Confidential, Fremont, CA

ETL Developer

Responsibilities:

• Involved in discussion of user and business requirements with business team by attending meetings with business integrators to discuss in-depth analysis of design level issues, data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Developed SQL queries, PL/SQL procedures and functions to develop the interfaces to extract the data in regular intervals also using UNIX shell scripts to meet the business requirements and extensively used Teradata utilities like M - Load, F- Load, TPT, BTEQ and Fast Export, wrote and involved in change data capture (CDC) ETL process.
• Involved in informatica, Teradata and Oracle upgrade process and testing the environment while up gradation; invoiced in upgrade of informatica from 9.1 to 9.5.
• Worked with informatica version control excessively and experienced in using SVN as version control for migration.
• Managed enhancements and coordinated with every release within informatica objects by writing unit test scripts to test the developed interfaces.
• Creating a single, authoritative view of business-critical data from disparate, duplicate, and conflicting information using MDM to identify the relationships among the facts and dimensions thereby successfully completed customer and product centric master data management initiatives.
• Analyzed the business data and defined the match and merge rules and trust scores for INFA MDM hub; developed internal and external interfaces to send the data in regular intervals to data warehouse systems.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using parameter files and analyzing session log files in session failures to resolve errors in mapping or session configuration.
• Extensively used power center to design multiple mappings with embedded business logic; created complex mappings using unconnected lookup, sorter, aggregator and router and few other transformations for populating target tables in efficient manner by creating mapplets and using them in different mappings while working on flat files and XML, DB2, Oracle as sources.
• Provided support for the production department in handling the data warehouse.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Worked with Business Data Analysts (BDAs) to understand the requirements for MDW development.
• Implemented informatica procedures and standards while developing and testing the informatica objects extensively with different transformations such as expression, aggregator, sorter, joiner, router, lookup, filter and union in the mappings to migrate the data from source to target.
• Extracted data from various heterogeneous sources like Sybase, flat files and COBOL (VSAM) using informatica power center and loaded data in target databases in DB2, Oracle and Teradata.
• Developed complex SQL queries to develop the interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata utilities like M - load, F- load, TPT, BTEQ and Fast Export.
• Created UNIX shell scripts for various needs and used normalizer transformation for Cobol (VSAM) sources.
• Worked with the Control M scheduling team in scheduling informatica jobs as per the requirement and frequency.
• Involved in doing unit testing, integration testing and data validation which gave way to implement various performance tuning techniques by finding the bottle necks at source, target, mapping and session levels by deep diving into session and workflow logs for error handling and troubleshooting thereby achieving optimum results.
• Used FACETS in extracting the sample data and involved in DWH upgradation for source system changes.
• Worked with the Cognos team in generating various reports.
• Involved in preparing the migration documents and provided 24/7 on call-support.

Confidential

ETL Developer

Responsibilities:

• Involved in requirement analysis in support of data warehousing efforts to define both business and technical requirements.
• Owned and maintained data flow diagrams (DFD’s) and ETL Informatica technical specifications/lower level design documents for all the source applications.
• Provided source data analysis to be utilized during technical design such as Oracle, SQL server and flat files.
• Extensively worked with various active and passive transformations like filter, sorter, aggregator, router, joiner transformations, expression, unconnected and connected lookup, sequence generator transformations.
• Implemented slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like dynamic cache, static cache, persistent cache, re-cache from database and shared cache.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and target based commit interval.
• Performed error handing using session logs and extensively used debugger to test the logic implemented in the mappings.
• As per business we implemented auditing and balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to target tables.
• Used power center workflow monitor to monitor workflows and utilized Scheduler for scheduling those workflows.