PROFESSIONAL SUMMARY:

• 10 years of IT experience in development and maintenance of data - warehouse applications.
• Working experience in Informatica, Teradata, Snowflake, Oracle, UNIX, and SQL.
• Experience in implementing the projects in Hadoop Big Data using Hive, Sqoop and MapReduce.
• Experience in developing ETL’s using Informatica.
• Extensive knowledge in Teradata utilities like Mload, Tpump and Fload and have good command on SQL.
• Well aware of Support project methodologies.
• Domain expertise in Telecom.
• Experience in preparing estimations for the project.
• Worked in end to end life cycle of project implementation.
• Experience in design, development of reports according to specifications provided by the user.
• Quick learner and excellent team player having ability to meet tight deadlines.

SKILL:

Primary Skill: Hadoop (HDFS, Hive, Sqoop, Map-Reduce, Hbase)

Secondary skills: Informatica, Teradata, Snowflake

Sub skills: Oracle, UNIX

Project Acquired skills: TOAD, Kintana, PVCS, Artifactory, Dollar U, Control-M

WORK EXPERIENCE:

Confidential

TeamLead/Senior Developer

Software:

Languages: Hive QL, SQL

Database: Hive, Teradata, Oracle,Snowflake

Tools: Hadoop BigData, HDFS, Hive, Sqoop, Informatica Power Center, Teradata SQL Assistant, TOAD, Artifactory, Kintana, $U, Quality Center, SSH Tectia Client

O/s: Linux, Windows

Responsibilities:

• Source System Analysis: Understanding the scope of the Project and technical modeling, Analyzing the specifications and requirements provided by the clients, Analyzing new or additional requirements or business functionality that needs to be implemented and how, when and where these can be implemented.
• Involvement in the preparation of the Specifications by performing competitive analysis as per High level design methodology.
• Design and Development of Dataflow using MetaLoad using the Sqoop and Hive QL.
• Reviewing the Code to make sure it is developed according to the Specifications provided by the Client.
• Supporting the UAT, BAT and helping the testing teams in testing the application against the test cases.
• Bug Fixing.
• Preparing the code deployment plan and supporting the deployment activities.
• Documenting the High level design, low level design, technical design documents.
• Documenting the test plan and deployment plan.

Confidential

TeamLead

Software:

Languages: SQL

Database: Teradata, Oracle

Tools: Informatica Power Center, Teradata SQL Assistant, TOAD, Artifactory, Kintana, $U, Quality Center, SSH Tectia Client

O/s: Linux, Windows

Responsibilities:

• Source System Analysis: Understanding the scope of the Project and technical modeling,
• Analyzing the specifications and requirements provided by the clients
• Analyzing new or additional requirements or business functionality that needs to be implemented and how, when and where these can be implemented.
• Involvement in the preparation of the Specifications by performing competitive analysis as per High level design methodology.
• Design and Development of Dataflow and ETLs using Informatica.
• Coding based on the Specifications provided by the Client and Bug Fixing.
• Preparing Unit Test cases and integration test cases and testing the application against the test cases.
• Bug Fixing using HP QC Tool.
• Preparing the code deployment plan and deploying the code using Kintana tool.
• Documenting the High level design, low level design, technical design documents.
• Documenting the test plan and deployment plan.

Confidential

Team Lead

Software:

Languages: SQL

Database: Teradata, Oracle

Tools: Informatica Power Center, Teradata SQL Assistant, TOAD, Artifactory, Kintana, $U, Quality Center, SSH Tectia Client

O/s: Linux, Windows

Responsibilities:

• Source System Analysis: Understanding the scope of the Project and technical modeling, Analyzing the specifications and requirements provided by the clients, Analyzing new or additional requirements or business functionality that needs to be implemented and how, when and where these can be implemented.
• Involvement in the preparation of the Specifications by performing competitive analysis as per High level design methodology.
• Design and Development of Dataflow and ETLs using Informatica.
• Coding based on the Specifications provided by the Client and Bug Fixing. Code new programs and modules for the enhancement of the Data Capture process and automate various manual processes
• Preparing Unit Test cases and integration test cases and testing the application against the test cases.
• Bug Fixing using HP QC Tool.
• Preparing the code deployment plan and deploying the code using Kintana tool.
• Documenting the High level design, low level design, technical design documents.
• Documenting the test plan and deployment plan.

Confidential

Team Lead

Software:

Languages: SQL

Database: Teradata, Oracle

Tools: Informatica Power Center, Teradata SQL Assistant, TOAD, Artifactory, Kintana, $U, Quality Center, SSH Tectia Client

O/s: Linux, Windows

Responsibilities:

• Source System Analysis: Understanding the scope of the Project and technical modeling, Analyzing the specifications and requirements provided by the clients, Analyzing new or additional requirements or business functionality that needs to be implemented and how, when and where these can be implemented.
• Involvement in the preparation of the Specifications by performing competitive analysis as per High level design methodology.
• Design and Development of Dataflow and ETLs using Informatica.
• Coding based on the Specifications provided by the Client and Bug Fixing. Code new programs and modules for the enhancement of the Data Capture process and automate various manual processes
• Preparing Unit Test cases and integration test cases and testing the application against the test cases.
• Bug Fixing using HP QC Tool.
• Preparing the code deployment plan and deploying the code using Kintana tool.
• Documenting the High level design, low level design, technical design, test plan and deployment plan.

Confidential

Senior Developer

Software:

Languages: SQL

Database: Teradata, Oracle

Tools: Informatica Power Center, Teradata SQL Assistant, TOAD, Control-M, Quality Center, SSH Tectia Client

O/s: Linux, Windows

Responsibilities:

• Prepared ETL Mapping Document for Dimension, Fact and Aggregate tables.
• Coded Queries for Dimension, Fact and Aggregate population.
• Developed ETL mappings for Dimensions and Facts and Aggregates and Performed Unit Testing.
• Ensuring Data Quality in the newly Build Ware house Aggregate tables.
• Giving solution for the Data discrepancies in Fact and Aggregate tables.
• Identifying the root cause for the defect and suggest necessary changes.
• Testing and recording test results with strict adherence to Quality Procedure.