We provide IT Staff Augmentation Services!

Technical Lead, Sr. Developer Resume

0/5 (Submit Your Rating)

New, YorK

SUMMARY

  • Having around 8 years of experience in Information Technology.
  • Extensively used ETL methodology for supporting Data Extraction, Transformations and Loading processes in corporate - wide ETL solutions using Talend Open Studio (TOS) and Talend Integration Suite (TIS).
  • Adept in Oracle PL/SQL programming like creation of stored procedures, functions, packages, triggers, performance tuning and Advance PL/SQL(collection framework), Oracle Virtual Private Database(VPD) etc.
  • Good knowledge in Talend and Big data Integration.
  • Worked on Talend Data Mapper (TDM) to process mainframe file.
  • Excellent understanding on Hadoop & Big Data core Technologies (HDFS, MapReduce, Pig, Hive, Sqoop, Spark, HBase etc).
  • Involved in analysis phase during requirement gathering, analysis of data models and preparation of Conceptual, Logical, and Physical data models.
  • Worked in multiple onshore-offshore model based and Client facing projects exhibiting proficient communication and co-ordination skills.
  • Experienced in creation of Business Documentation especially in the BFS, Financial and Service Industry.
  • Additionally engaged in team management activities like planning and scheduling tasks, mentoring new members, organizing knowledge transfer sessions.
  • Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and excellent presentation skills.
  • Worked with Business Analyst to understand the business requirements and translating them into technical and system specifications.
  • Played role as Technical Lead, Sr. Developer (Oracle PL/SQL) for e-2-e implementations and Solutions.
  • Developed Talend DI & BD jobs using various components like HDFS, Pig, Hive, HBase, Sqoop, database components, Processing components, File components, XML, JSON and Webservice components.

TECHNICAL SKILLS

ETL Tools: Talend 6.x

Hadoop / Big Data: HDFS, Sqoop, Pig, Hive, MR, HBase

Databases: Oracle, MYSQL, SQL Server

Utilities: Toad, PL SQL Developer, Talend Admin Console (TAC)

Scripting Languages: SQL, PL/SQL, Unix Shell Scripting, Java Scripts

Version Control Systems: MS Visual Source Safe (VSS), Subversion (SVN)

Domains: Banking and Insurance

Data Modeling: Star-Schema Modeling, Snowflake Modeling

PROFESSIONAL EXPERIENCE

Confidential - New York

Responsibilities:

  • Leading ETL Talend team with Onsite/Offshore.
  • Responsible for creating high level design of Talend jobs covering the interface requirements.
  • Worked on design and creation of Data Mapper jobs using Talend.
  • Handling EBCIDIC file by using TDM.
  • Prepared ETL mapping document.
  • Conduct Talend training on Talend DI and TDM to Onsite/Offshore team.
  • The responsibilities also include being guiding new team members through the business and technical knowledge of the project’s technology stack.
  • Directly communicating Client to gather requirements and prepare high level ETL job flow.

Tools: - Oracle 11g, SQL Developer, Client VDI with Windows 7, PUTTY to use UNIX shell scripting, and Talend DI ETL tool 6.3.

Confidential

Responsibilities:

  • Understanding business requirements and preparation of technical design build document based on business requirements.
  • Responsible for creating high level design of Talend jobs covering the interface requirements.
  • Worked on design and creation of Master mind jobs using Talend.
  • Developed Talend jobs using various components like database components, Processing components, File components, XML and Webservice components.
  • Responsible for creating high level design of the project.
  • Development of both minor and major enhancements and scratch development of PL/SQL code.
  • Responsibilities include support ticket resolution, requirement analysis, detailed design, code writing, unit testing and integration testing.
  • The responsibilities also include being guiding new team members through the business and technical knowledge of the project’s technology stack.
  • Unit testing, Unit test case document preparation.
  • Generated server side PL/SQL scripts for data manipulation and validation.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created scripts to create new tables, views, and queries for new enhancement in the application using toad and pl/sql developer.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Performed SQL and PL/SQL tuning and Application tuning using EXPLAIN PLAN.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files Using UTL FILE package.
  • Creation of database objects like tables, views, materialized views, procedures and packages using Oracle tools like SQL Developer, PL/SQL Developer and Toad.

Tools: - Oracle 11g, SQL Developer, Client VDI with Windows 7, PUTTY to use UNIX shell scripting, and Talend DI ETL tool 6.3.

Confidential

Responsibilities:

  • Worked as Oracle PL/SQL Developer, designing and managing all the deliverables from day to day perspective.
  • Responsible for all communications with client and internal stakeholders including preparation of reports (WSR, Project Plan, Release Note etc.) .
  • Unit testing, Unit test case document preparation.
  • Analysed the specification to suggest the right solutions based on client requirements.
  • Created the database objects like tables, views, procedures, packages, triggers, materialized views Using Oracle tools like Toad, Oracle PL/SQL Developer.
  • Created various SQL and PL/SQL scripts for the data conversion and applying various business rules to Make the data compatible and in sync with the requirement.
  • Created Records, Tables, Objects, Collections (Nested Tables and Varrays) and Error Handling.
  • Worked with XML generation with data population in xml tags.
  • Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins.

Tools: - Oracle 10g, SQL Developer and pl/sql developer with Windows XP. CVS for code deployment.

Confidential

Responsibilities:

  • Involved on creation of stored procedures, functions, packages, objects. Worked in requirement analysis, design, coding & deployment.
  • Review of code changes, documentation, Planning, allocation and monitoring of tasks of team members.
  • Unit testing, Unit test case document preparation.
  • Created new module for e waybill generation by pl/sql procedure and package, core Java.
  • Worked in MVC architecture and Jsp/Servlet.
  • Worked in Oracle forms and reports in government intranet system.
  • Experienced in giving demonstration front of commercial tax officers and head of the department.
  • Worked in enhancement part of other projects of java.
  • Worked in anonymous scripting, pl/sql types, Tables, objects.

Tools: - Oracle 9i, SQL Developer with Windows XP. Net beans and j developer java tool, Core Java.

Confidential

Responsibilities:

  • Worked as developer trainee, Oracle PL/SQL and core java Developer and handled all communications/risks with all stake holders on day to day operations.
  • Involved in development and testing of Oracle Stored Procedures, Functions and Packages.
  • Unit testing, Unit test case document preparation.
  • Created documentation like technical document, requirement analysis document.

Tools: - Oracle 9i, SQL Developer with Windows XP. Net beans and j developer java tool, Core Java.

We'd love your feedback!