SUMMARY:

• Over 8+ years of experience in ETL, Design, Development and Implementation of Data Warehouse systems.
• Designed and Build ETL batch architecture to load data from Source System to Staging and Staging to Core Confidential tables.
• Strong experience in performance tuning of Confidential SQL.
• Designed, Documented, Developed and Build Informatica Power Center Mappings and workflows using Confidential External Loaders.
• Extensively worked on Various Informatica transformations.
• Expertise in Collecting and Analyzing statistics for newly created tables and periodically colleting of existing table.
• Extensively used Confidential loader scripts (UNIX) for bulk load utilities like FastLoad, MLoad, BTEQ, TPT and performance tuning of scripts.
• Extensively worked on developing complex SQL queries for source system analysis, data analysis & data validation.
• Experience in Shell Scripting (KSh, Bourne Shell) and scheduling using Control - M and $Universe
• Expertise in understanding of Star Schema & Snowflake Schema, Fact & Dimension Tables, Physical & Logical data modeling.
• Involved in full life cycle development of Data Warehousing projects.
• Strong leadership qualities in mentoring and guiding team with Best Practices and make sure of on time delivery of project
• Superior communication, inter personal, presentation, strong analytical and trouble shooting skills. Great leadership quality and a versatile team player.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.x, DataStage PX

Operating Systems: Windows, Solaris, UNIX

OLAP Tool: Business Objects, MicroStrategy, Hyperion

Databases: Confidential, Oracle, Sybase, DB2, SQL Server

Confidential Utilities: BTEQ, SQL Assistant, FastLoad, MultiLoad, TPT, TDCH

Confidential tools: Confidential Administrator, Confidential SQL Assistant, ViewPoint

Scheduling tool: Control-M, $Universe

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Developer/Lead

Responsibilities:

• Responsible in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems.
• Used Tardis framework to generate Confidential database objects and TPT scripts.
• Replicated DB2 Confidential (DM) data to Confidential using TPT scripts.
• Analyzed existing stored procedure in DB2 and translate to Confidential Stored Procedures and BTEQ scripts.
• Developed Informatica Mappings, Sessions, Workflows by analysing existing components.
• Developed TDCH jobs to move data from HIVE to Confidential .
• Did data analysis and data validation for source and target data.
• Developed Control-M jobs to schedule data plumbing from source to target.
• Performed Unit Testing & System Testing for Source to Landing Zone (LZ) to Atomic Data Store (ADS) to Data Mart (DM).
• Created ad-hoc reports using the Business Objects suite applications.
• Deployed all the objects to different environments using Stash, Source Tree, Jenkins, Perforce.
• Participated daily standup meetings with onsite managers.
• Coordinating and mentoring offshore team with daily status calls.

Confidential, Colorado Springs, CO

Informatica Technical Lead

Responsibilities:

• Prepared detailed technical design document with regards to the business requirement.
• Involved in activities like design of high-level components, onsite & offshore team management, estimation, progress monitoring, resource planning and conducting quality reviews.
• Working as development lead in migrating from Sybase to Confidential, and involved with the team members in
• Developing efficient code
• Ensuring that the coding standards and the best practices are followed uniformly
• Performing code reviews
• Delivering of quality code
• Troubleshooting and optimizing ETL query performances
• Meeting timelines of the deliverables
• Performing end-to-end testing
• Prepared design documents, test plans and documented test results.
• Developing Confidential scripts for the migration by using Confidential Utilities like Fastload, BTEQ, and TPT, by analyzing existing Sybase scripts.
• Enhancing and developing stored procedures.
• Working on Informatica Power center in creating source to target mapping and workflows using Informatica designer and workflow manager.
• Developing Informatica scripts on UNIX servers, to schedule the jobs through $Universe-Scheduling tool.
• Participating in weekly status meetings and presenting the status report to the client.
• Coordinating and mentoring the offshore team.

Confidential, Plano, TX

Sr. ETL Informatica/ Confidential Developer

Responsibilities:

• Created detailed technical design documents from business requirements.
• Develop Confidential SQL queries to generate ad-hoc reports for the business analysts of to implement complex business rules.
• Worked as Development Lead and is responsible for preparing ETL Design (source to target mapping documents), helping developers in developing efficient code, ensure coding standards are followed, perform code reviews, delivery of quality code, meeting the timelines for development, perform end-to-end testing and provide weekly status on projects to management.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Design, Developed scripts for loading data to target data Warehouse for BTEQ, FastLoad, and MultiLoad.
• Created Informatica mappings using Source Analyzer, Target Designer, Transformation Developer, and Mapping Designer to implement business logic from the various data source systems.
• Extensively worked on Informatica tool to integrate data using Mload connections.
• Worked on data analysis and data validation for source and target data.
• Implemented migrations and version controlling using Star Team revision control tool.
• Managed onsite- offshore teams and coordinated test execution across locations.
• Extensively worked on creating Migration documents and involved in migrating ETL code between different environments.

Confidential, Mountain View, CA

Sr. ETL Developer

Responsibilities:

• Interfaced with SMEs to prepare BRD documents for projects.
• Provided support to the testing and development team in innumerable issues which required lot of understanding of the EO data. Resolved many data issues that came up in the UAT and SIT and fixed the design as necessarily
• Created Adhoc reports using Confidential SQL
• Did error handling and performance tuning in Confidential queries and utilities.
• Did data reconciliation in various source systems and in Confidential .
• Designed and build Informatica Mappings, Sessions & workflows with various types of transformations like Lookup, Update Strategy, Stored Procedure, Normalizer etc to in corporate business rules \ mapping rules with batch based and Time stamp loads
• Designed, Developed, Documented and Build Confidential UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Confidential tables.
• Completed market basket analysis for major retailers to determine what products are purchased together - in support of promotion strategies.
• Defining and implementing Standard Operating Procedures at departmental level
• Involved in coding, Unit testing, System integration testing & UAT.
• Writing & executing test cases
• Involved in functional testing
• Involved in peer to peer-to-peer reviews and mentoring offshore team.

Confidential, Hoffman Estates, IL

Developer

Responsibilities:

• Transformed businesses and Modeling rules in ETL - Specification documents with respective to subject area like Camp Confidential n, Opportunity and Leads.
• Done performance tuning of Confidential SQL.
• Design, Developing ETL technical Architecture involving process checks and error handling at various levels.
• Done data profiling of the source system to in corporate business rule and validation of data.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Prepared the best practices, conventions and standards documents that are used by the team during their development.
• Designed, Developed, Documented and Build Confidential UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Confidential tables.
• Designed the High Level ETL technical process to build Confidential scripts, Informatica mappings and Data Validation process that implement the Business logic and SLAs.
• Responsible for Code review of peers and Making sure of In corporation Best and Standard practices.
• Create data movement packages with the DTS Export Wizard to export into Flat Files.
• Designed, Documented and developed Low level Design, Requirement Tractability Matrix, and Unit Test Plans.
• Designed, Documented, Developed and Build Informatica Power center Mappings and workflows using Confidential External Loaders.
• Designed and developed batch loads Jobs using Tivoli Maestro Workload Scheduler based on Holiday calendar and Business calendar.

Confidential, Louisville, KY

Consultant

Responsibilities:

• Was involved right from the requirements gathering stage and helped out the KFC, Pizza Hut Taco Bell and Yum BA’s both in etching out the requirements technically.
• Conducted and participated in brainstorming sessions to finalize the design strategies for ADW and Confidential .
• Prepared the source to target mapping documents design approach transformation rules documents and finally handed over the DDL to the Development team.
• Designed, Developed, Documented and Build Confidential UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Confidential tables.
• Provided support to the testing and development team in innumerable issues, which required lot of understanding of the EO data. Resolved many data issues that came up in the UAT and SIT and fixed the design as necessarily.
• Involved in data model reviews with internal data architect, business analysts and business users with explanation of the data model in depth to make sure it is in line with business requirements.
• Designed, Developed, Documented and Build Confidential UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Confidential tables.
• Transformed businesses and Modeling rules in ETL - Specification documents with respective to subject areas
• Created source to target mapping rules with table/column metadata and transformation rules.
• Done data profiling of the source system to in corporate business rule and validation of data.
• Create and implement procedures, and standards for the corporate data asset.
• Collected and Analyzed statistics for newly created tables and periodically colleted statistics for existing table.
• Performed Performance tuning of Confidential SQL.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Prepared the best practices, conventions and standards documents that are used by the team during their development.