ETL Developer Resume Texas - Hire IT People

PROFESSIONAL SUMMARY:

Having 5+ years of experience in IT, with experience as Teradata Developer and ETL Designer.
Having hands on experience on technologies like Teradata 14, Informatica 9.5.1 and Unix Shell scripting.
Extensively Worked in Health Care Industry with strong knowledge on Pharmacy Benefit Management.
Experienced in Performance Tuning and Optimization of Teradata Large/Complex queries with the help of Teradata View Point.
Extensively worked with Teradata utilities like BTEQ, MULTILOAD, FAST EXPORT and FAST LOAD.
Well versed with all stages of Software Development Life Cycle from Requirement Gathering & analyzing, Design, Development, Implementation &Testing.
Experienced in implementing End to End solutions for several Major projects.
In - Depth hands on experience in Quality Process and Release management activities using Serena Dimensions.
Experienced in handling the customers queries globally and have good interaction with business users.
Have a high degree of positive attitude, communicative and extremely flexible to changing needs and environments.
Strong analytical and problem solving skills, handling of incidents and service requests.
Excellent self-motivated Team player with good communication, presentation and interpersonal skills and grooming junior resources for the project needs.
Experienced in managing medium sized team

TECHNICAL SKILLS:

ETL Tool: Informatica 9.5.1,8.6.1

Scripting: Unix Shell script.

Database: Teradata 14

Operating Systems: Microsoft windows 9X, 2000, XP,7.

PROFESSIONAL EXPERIENCE:

Confidential, Texas

ETL Developer

Technologies: Informatica 9.5.1, Teradata and Unix

Responsibilities:

Analyzed the existing Pharmacy advisor Program and captured all the business requirements.
Responsible in creating and presenting Design documents, Source to target mapping documents after understanding requirements and Source system analysis.
Lead a team of 15 resources in the development phase and was a key member in the development team for the Member Dimension.
Implemented Several Complex Business scenarios with ease.
Created Several BTEQ’s and Unix scripts for processing Data.
Supported the QAT and bug fix.
Part of the team driving the UAT and BAT and was the sole lead for Member Dimension and Gap prevalence.
Performed the Project deployment through Serena dimensions and supported the Post production deployment.

Confidential

ETL Developer

Technologies: Informatica 9.5.1, Teradata and Unix

Responsibilities:

Leading member of the offshore team for member module.
Responsible in creating and presenting Design documents, Source to target mapping documents after understanding requirements and Source system analysis.
Documented all the legacy system logics and identified the equivalent source in EDM model.
Created Several BTEQ’s and part of the code approving committee for Junior team members.
Supported the QAT and bug fix.
Part of the team driving the UAT and BAT and was the sole lead for Member Dimension.
Performed the Project deployment through Serena dimensions and supported the Post production deployment.

Confidential

ETL Developer

Technologies: Informatica 9.5.1, Teradata,Unix

Responsibilities:

Designed a Reusable template to extract data for every state.
Automated data extracts for many States.
Developed Bteq Scripts as part of the load strategy.
Followed all CVSC Coding standards and developed mapping to load the data from Flat Files.
Involved in Testing of data and UAT.

Confidential

ETL Developer

Technologies: Informatica 9.5.1, Teradata,Unix

Responsibilities:

Identified all the legacy components and documented.
Created Informatica mappings with sources pointing to new EDM sources.
Followed all CVSC Coding standards and developed mapping to load the data from Flat Files.
Involved in Testing of data and UAT.

Confidential

ETL Developer

Technologies: Informatica 9.5.1, Teradata,Unix

Responsibilities:

Understood and used the ABC(Audit Balance and Control) process while loading the MDI data.
Developed Unix scripts according to the existing ABC Process.
Developed Bteq Scripts as part of the load strategy.
Followed all CVSC Coding standards and developed mapping to load the data from Flat Files.
Involved in Testing of data and UAT.

Confidential

ETL Developer

Technologies: Informatica 8.5, Ms SQL Server 2005, Oracle 10g, OBIEE.

Responsibilities:

Involved in End to End Implementation.
Interaction with business for new requirements.
Created the mappings and corresponding sessions, workflows in Informatica.
Scheduled the jobs and automated the monitoring process using email tasks in Informatica.