OBJECTIVE:

• A qualified professional involved in data migration and ETL projects. My passion for databases and desire to excel in every aspect of my professional career makes me stand out amongst the plethora of ETL developers out in the market.

PROFESSIONAL SUMMARY:

• 4 years of IT expertise in DWH/ETL Projects
• Proficient in RDBMS and ETL Process
• Having hands on experience in Informatica Power center
• Good knowledge in SDLC and all phases of application development
• Proficient in better understanding of the requirements documentation
• Have Good understanding ofETL/Informatica standards and best practices
• Having Good experience in writing simple to complex SQL queries
• Expertise in execution of transformation mappings in Prod/Dev/QA environments
• Involved in requirements review and development analysis
• Experience in integration of various data sources like SQL Server, Oracle and flat files into staging area
• Good knowledge in Dimensional Modeling, Star and Snowflake schemas
• Developed scripts as per ETL mapping documents
• Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations
• Extensive experience in developing the Workflows, Worklets, Sessions and Mappings
• Expertise in developing SQL queries to verify the data from Source to Target
• Expertise in unit testing the scripts to check field size validation, check constraints and cross verifying the field size defined
• Having good knowledge in debugging Prod issues
• Knowledge sharing & sessions for new team members
• Having hands on experience in ETL Data flux Tool
• Sending daily and weekly status reports to client
• Interaction with QA team to ensure QA issues are resolved on the basis of using defect reports
• Proficient in communicating with the client as well as team members
• Worked closely with testing teams to provide support and to participate in knowledge transfer to the client throughout software development life cycle.
• Extensively used tools likeInformatica, Teradata SQL AssistantandData fluxfor tracking issues.

TECHNICAL SKILLS:

Databases/ETL Tools/Operating Systems: Teradata, Oracle, SQL Server, MySQLInformatica, Pentaho DI, Data fluxWindows Family, Linux

Tool: s & IDE s: Informatica Power center, Teradata SQL Assistant, SQL Developer

Versioning Tools: SharePoint

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Environment: /Skill: Informatica, Teradata, Data flux

Responsibilities:

• Understanding the project functionality and scope
• Involved in requirements walkthrough to identify the Development and unit testing scope and feasibility
• Understand the data mapping from source to target tables and business logic used to populate target table
• Developing mappings for source to target based on ETL mappings documents(190/340)
• Create mappings using different sources of Flat file by using Expression, Aggregator, Sequence Generator, Look - up, Joiner, Filter and update strategy transformations are extensively used in the project.
• Created and configured Sessions in Informatica workflow Manager for loading data into Data Warehouse tables from various heterogeneous database sources like Flat files and CSV files
• Worked in Monitoring & Production Support Activities
• Involved in study of existing Operational Systems, Data Modeling and Analysis.
• Prepared unit testing documentation and Defects log sheets for developed mappings.
• Running the workflows and populating the date into the data mart..
• Resolve Bugs in mapping by debugging
• Designing unit test cases and test scripts as per ETL mappings
• Log the mismatches in bug tracking tool
• Able to work collaboratively with testers and business analysts in complex projects and maintain detail documentation
• Involved in Jr. Developers for effective use DWH/ETL Development and process

Confidential

ETL Testing

Environment: /Skill: Teradata, Data flux, Informatica

Responsibilities:

• Understanding the project functionality and scope
• Involved in requirements walkthrough to identify the Development and unit testing scope and feasibility
• Understand the data mapping from source to target tables and business logic used to populate target table
• Developing mappings from source to target based on ETL mappings documents(190/340)
• Developed scripts as per ETL mapping documents
• Worked in Monitoring & Production Support Activities
• Involved in study of existing Operational Systems, Data Modeling and Analysis.
• Prepared unit testing documentation and Defects log sheets for developed mappings.
• Running the workflows and populating the date into the data mart..
• Resolve Bugs in mapping by debugging
• Designing test cases and test scripts as per ETL mappings
• Log the mismatches in bug tracking tool
• Able to work collaboratively with testers and business analysts in complex projects and maintain detail documentation

Confidential

ETL Testing

Environment: /Skill: Teradata, Data flux

Responsibilities:

• Involved in data mapping from source to target tables and business logic used to populate target table
• Generating ER-Diagrams using data dictionary and understanding the hierarchy
• Perform basic DML, DDL Operations as per the Business requirement
• Migrated data from Heterogeneous Data Sources (Access, Excel, Flat File, Oracle) to centralized Teradata database
• Created objects as per the user requirement
• Involved in development and maintenance of database systems to extract, cleanse, transform, load and maintain data
• Worked on data analysis and Table level analysis
• Involved in debugging the scripts and performing root cause analysis on the issues
• Involved in Peer review and Unit testing
• Actively participated in Project Review Meetings
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements
• Adherence to the defined delivery process/guidelines