We provide IT Staff Augmentation Services!

Etl Tech Lead Resume

CA

EXPERIENCE SUMMARY:

  • Over 10 years of experience in Data Architecture, Analysis, ETL process design, ETL/SQL development, testing, implementation, maintenance and supporting of Enterprise level Data Integration, Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store(ODS)Data Warehouse (DW)/Data Mart (DM), ETL, OLAP Client/Server and Web applications on Windows and Unix platforms.
  • Over 7 years of experience in using Informatica Power Center 8.x/9.x Designer, SSIS, Repository Manager, Workflow Manager, Workflow Monitor and performance tuning of Informatica transformations/mappings/sessions/workflow's.
  • Over 3 years of Relational Modeling and Dimensional Data Modeling using Star & Snow Flake schema, De normalization, Normalization, and Aggregations. Designed Data bases.
  • Have Good understanding of ETL(SSIS/Informatica) standards and best practices, different types of Dimensions, Slowly Changing Dimensions (SCD1,SCD2,SCD3)
  • Over 2 Years of experience SSRS,SSAS and generating various complex reports, using Crystal Report, SSRS 2005, SSRS 2008.
  • Over 7 Years of experience in using SQL, Dynamic SQL, Stored procedures/functions, triggers and packages, complex joins, correlated sub - queries, aggregate functions analytic functions, materialized views, indexing, partitioning and performance tuning the same using explain plan.
  • Over 5 years of experience as ETL architect in large scale data warehouse using Databases like Oracle 11g/10g/9i, MS Access 2000/2002, SQL Server 2005, 2008, MS Excel and Flat files.
  • Worked as a Scrum master and well aware of Agile development methodologies and worked as ETL team lead to manage onsite/offshore and work with tech leads across multiple project streams for integrating the data.
  • Work with Business/Product owner to establish and clarify requirements and Prepares comprehensive documentation, and ensures timely completion of assigned work.
  • Working on Data Virtualization architecture on Informatica DV
TECHNICAL SKILLS

Databases: Oracle 9i/Oracle 10g/Oracle 11g, MS SQL Server 2000/2005/2008

ETL Tools: Informatica Power Centre 7.x/8.x/9.6, SSIS 2005/SSIS 2008

Reporting Tools: SSRS 2005, SSRS 2008, SSAS 2005, Crystal Report, Proclarity 6.1

Programming Languages: T-SQL, PL/SQL, Unix Shell Scripting, ASP.NET 2.0, C#, VB.NET

Configuration management: SVN, VSS,TFS, MKS

Environment: Windows 7, XP, UNIX

Other Tools: TOAD, SQL Developer, Peregrine, HP Service Center, Proclarity, Tidal, Autosys, ScrumPro, KANBAN

PROFESSIONAL SUMMARY:

Confidential, CA

ETL Tech lead

Responsibilities:

  • Work with Business/Product owner to establish and clarify requirements and Prepares comprehensive documentation, and ensures timely completion of assigned work.
  • Working on Data Virtualization architecture on Informatica DV
  • Involved in the ETL technical design discussions and prepared ETL high level technical design document., closely worked Architect team to decide on the solution.
  • Extracted data from excel files, high volume of data sets from data files, Oracle using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area
  • Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
  • Created re-usable transformations/mapplets and used across various mappings
  • Involved in performance tuning of the Mappings, SQL statements, Query optimization, and Explain Plan utilities for Optimum Performance and used Informatica Debugger.
  • Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
  • Created Autosys jobs to schedule Informatica Workflows using Unix Script
  • Prepared Unit Test Plans and performed Negative testing, Positive testing
  • Involved in performance tuning of Informatica code using standard informatica tuning steps
  • Working as single point of contact with Client and coordinating with offshore team to implement several projects.

Environments: Oracle 11g, Informatica Power Center 8.6, 9.5. Informatica Data Service, TOAD, HP service Centre. MKS (Version contron)

Confidential, TX

ETL/Database Consultant

Responsibilities:

  • Evaluated existing database performance, identify bottleneck, suggest solution to development team to improve performance.
  • Converted existing Crystal reports to SSRS 2008 reports.
  • Reading files from difference source, creating SSIS package to process these files and automating the file processing.
  • extensively worked on the performance tuning of existing Source qualifier queries, non-clustered indexes, and clustered indexes
  • Attending daily scrum, following an implementing agile development methodology.
  • Involved in the Analysis of Physical Data Model for ETL mapping and the process flow diagrams.
  • Created Mappings to extract data from data sources like Flat file, SQL Server.

Environments: SQL server 2008R2, SSIS 2008R2, SSRS 2008 R2, SVN (Source control), USD (ticket management) KANBAN

Confidential, MN

Senior Informatica Developer/ MSBI Consultant

Responsibilities:

  • Involved in meetings with the business users for gathering requirements and identifying the source data.
  • Worked extensively on different types of transformations like Expression, Filter, Aggregator, Lookup, Joiner, Sequence generator and Router.
  • Developed complex mappings using multiple sources and targets in different databases, Flat files.
  • Created stored procedures to generate the sequence numbers for Master data tables in landing area.
  • Involved in performance tuning at session level tuned the mapping by setting the buffer size, cache size, increasing commit intervals etc
  • Worked within a team to populate Type II slowly changing dimension customer tables from several mainframe flat files.
  • Troubleshooting and support 24/7 during operational cycles for historical load process.
  • Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
  • Analyzed current system and programs and prepared gap analysis documents.
  • Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered from Solution Business Proposal document.
  • Extensively used ETL to load data using Power Center from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle. Analyzed the existing systems and made a Feasibility Study.
  • Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
  • Prepared technical specification to load data into various tables in Data Marts.
  • Created ETL packages using SSIS, designed SSAS cube and generated report using SSRS.

Environment: Informatica 8.1, SQL server 2005, SSIS, SSAS,SSRS, Oracle 9i/10g.Proclarity ( BI Reporting tool), Peregrine(change management tool)

Confidential, MN

ETL Developer

Responsibilities:

  • Developed Informatica jobs for Conversions which involved loading the mainframe extract data into staging tables.
  • Troubleshoot the ETL process developed for Conversions and implemented various techniques for enhancing the performance.
  • Developed and maintained custom PL/SQL packages and procedures for analysis of source system data and also for data validation.
  • Extensively involved in creating design documents for loading data into Datawarehouse and worked with the data modeler to change/update the Datawarehouse model when needed.
  • Developed ETL processes to load data into dimensional model from various sources using Informatica Power Center.
  • Developed mapplets and reusable transformations that were used in different mappings and across different folders.
  • Designed and developed the error handling mechanism to be used for all the Informatica jobs, which load data into the data warehouse.
  • Extensively used warehouse designer of Informatica Powercenter Created different target definitions.
  • Created robust and complex workflows and worklets using Informatica workflow manager and Trouble-shooted data load problems

Environment: Informatica 8.0, Oracle 9i, SQL Server 2005, MS-VSS (for source code control)

Confidential, MN

Application Developer

Responsibilities:

  • Creating Stored procedure using SQL server 2005, Oracle 9i
  • Creating Database View, Materialized views, table and Oracle packages
  • Understanding business requirement and transforming them into Crystal reports,
  • Giving 24x7 production support, making sure application is up and running
  • Resolving users issue, deploying fixes in production environment
  • Creating test document, test cases and automating test cases using custom programming.

Environment: UNIFACE 6.0,Crystal Report 10.0,Oracle 9i, SQL server 2005

Confidential

Application Developer

Responsibilities:

  • establishing a detailed program specification through discussion with clients;
  • clarifying what actions the program is intended to perform;
  • breaking down program specification into its simplest elements and translating this logic into a programming language;
  • devising possible solutions to anticipated problems;
  • creating several database functions, procedure and tables;
  • Understanding existing database and writing SQL for front-end to consume data.
  • testing sample data-sets to check that output from the program works as intended;
  • conducting testing and installing the program into production;
  • conducting user acceptance testing to ensure the program can be used easily, quickly and accurately;
  • writing detailed documentation for the operation of the program by users and computer operators;

Environment: Windows XP, SQL Server 2000 database, ASP.NET

Confidential

Application Developer

Responsibilities:

  • Attending daily stand up meeting and gathering requirements and transforming the requirement to technical understanding document.
  • Writing DTX package and database objects such as table, views and stored procedures
  • breaking down program specification into its simplest elements and translating this logic into a programming language;
  • testing sample data-sets to check that output from the program works as intended;
  • conducting testing and installing the program into production;
  • reacting to problems and correcting the program as necessary;
  • adapting the program to new requirements, as necessary;
  • conducting user acceptance testing to ensure the program can be used easily, quickly and accurately;
  • writing detailed documentation for the operation of the program by users and computer operators;

Environment: Windows XP, SQL Server 2000 database, ASP.NET, VSS, MS Access

Hire Now