OBJECTIVE:

To enhance my analytical, technical and business skills while pursuing a career in data modeling, ETL development & Testing and advanced data warehousing tools and technologies and aspire to conceive, design and develop solutions for solving business problems.

PROFESSIONAL SUMMARY:

• Over 6 years of focused experience in Information Technology with a strong background in Data warehousing and predominantly into ETL using Teradata and Informatica PowerCenter .
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Expertise in Query Analyzing, performance tuning and testing.
• Experience in writing UNIX korn shell scripts to support and automate the ETL process.
• Very good understanding of SMP and MPP architectures.
• Technical expertise in ETL methodologies, Informatica 8.6 - Power Center,Client tools - Mapping Designer, Workflow Manager/Monitor .
• Developed complex Mappings, used transformations such as Lookup, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure and Update Strategy .
• Familiarity with Rally and Agile methodology.
• Underwent a on Foundation Level:101-Hadoop Developer and acquired on the same from my former employer, Confidential .
• Good Communication, interpersonal and problem solving skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills. Comprehensive technical, oral, written and communicational skills .
• Committed to quality work and deliverables.

TECHNICAL SUMMARY:

ETL Tools: Teradata SQL Assistant, BTEQ, FastLoad, MultiLoad, Informatica Power Center 8.6

Languages: SQLUNIX Shell Scripting

Databases: Oracle 8i/9i/10g, Teradata, MS SQL Server, Sybase, Flat Files, IBM Mainframe Systems

BI Tools: Business Objects-WEBI

PROFESSIONAL EXPERIENCE:

Confidential

Tools/Technologies: Teradata

ETL Developer

Responsibilities:

• Effective client communication and participation in the daily calls to gather the requirements from the client.
• Resolved various tickets that came as incidents relating to importing CSV files into Teradata tables and worked on inclusion and exclusion of payments relating to Confidential Healthcare.
• Responsible for preparing BTEQ scripts for populating the table relating to the SR (State Reporting) module and General and Research Template modules.
• Imported csv files into tables using Teradata SQL Assistant.
• Worked effectively on performance tuning of the queries running in production environment by using Global Temporary tables and other optimization techniques.
• Validation and unit testing and preparation of test cases for UAT as well.

Confidential

Tools: Informatica, Teradata

Senior ETL Developer

Responsibilities:

• Involved in the Analysis phase to elicit the requirements from the Functional Architect.
• Prepared standard interface document which would be the considered source for the respective source flat files.
• Worked on various Change Requests that came as a part of developmental activities in Teradata.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Validation and unit testing and preparation of test cases.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems encountered in the daily loads.
• Performed validations for BO reports.

Confidential

Tools/Technologies: Informatica 8.6, Oracle

Developer

Responsibilities:

• Worked with the concerned team in eliciting the requirements.
• Designed and developed Informatica Mappings and Sessions based on requirements and business rules to load data from source flat files.
• Effectively used Informatica parameter files for parameterizing mapping variables, workflow variables, and relational connections.
• Performed validations and unit testing and prepared test cases for the same.
• Worked collaboratively with the team to integrate the module with the existing modules.
• Delivered the required deliverables within the stipulated timeline.

Confidential

Tools/Technologies: Informatica, Oracle

Developer

Responsibilities:

• Requirement gathering
• GAP analysis for DWH
• Enhancement/Upgrade of the existing Informatica mappings.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Validation and unit testing for each of the modules.
• Documentation as per Confidential process

Confidential

Tools/Technologies: Teradata, Informatica,Cronacle

Developer

Responsibilities:

• Involved in the Analysis phase to elicit the requirements from the Functional Architect.
• Created the Mappings to load from Source table to source stage table.
• Creation of Bteq Scripts to load from source stage to Interface table.
• Creation of Job chains and executing it in Cronacle scheduling tool.
• Validation of Bteq Scripts and Job chains.
• Prepared test cases, ETL specs and other Project related documents
• Client Communication and Participate in the Scrum Calls.
• Interacted with clients in understanding the changing requirements.

Confidential

Tools/Technologies: Informatica 8.6, Unix, Teradata,Business Objects

Developer

Responsibilities:

• Involved in the Gathering of Requirements from the Functional Architect.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Creation of Bteq Scripts to load from source stage to Interface table and then to Global temporary table and finally to Fact/Dimension table.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Creation of Job chains and executing it in Cronacle scheduling tool.
• Validation of Informatica mappings,Bteq Scripts and Job chains
• Prepared test cases, ETL specs, MD120 and other Project related documents
• Client Communication and Participate in the Scrum Calls.
• Actively involved in the production move there by interacting with external Teams from Confidential Healthcare for a successful production migration.