Technical Lead, Sr. Developer Resume
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.
