Teamlead/senior Developer Resume
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.