Sr. Oracle Pl/sql Developers Talend Etl Developer Resume
New Haven, CT
PROFESSIONAL SUMMARY:
- Over 8+ years of experience as an Oracle PL/SQL developer with design, development, and testing of business applications such as OLTP, OLAP, Enterprise, web based, Client/Server architectures.
- 3+ years of experience using Talend Data Integration/Big Data Integration (7.1.1/6.1/5. x) / Talend Data Quality.
- 7 years of experience using Informatica PowerCenter 9.6.1/9.1/8.6 /8.5.
- 5+ years of experience using Greenplum.
- Worked on ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
- Worked on convert business logic into Greenplum functions for integrating source data into Data warehouses.
- Expert in writing SQL, PL/SQL modules like functions, stored procedures, cursors (Implicit, Explicit, REF), packages, triggers, indexes, collections (Nested tables and Varrays) and materialized views.
- Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer, SQL Navigator.
- Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL .
- Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
- Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
- Experienced in data analysis, data modeling, development, testing and documentation of projects.
- Carried out testing in test database for upgrading/migrating from Oracle 10g to Greenplum.
- Experience in developing logical and physical database design, data modeling using Erwin & Informatica (Power Center 6.1).
- Involved in creating mappings, transformations in Informatica, tuning & monitoring workflows.
- Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
- Experience with DBA activities like creating Tablespaces, granting and revoking privileges on database objects.
- Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
- Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER.
- Extensively worked in Client - Server application development using Oracle 11g/10g/9i FORMS 9i/6i, REPORTS 10g/6i, Oracle Import and Export Utilities.
- Created complex mappings in Talend using tHash, tDenormalize, tMap, tUniqueRow. tPivot To Columns Delimited as well as custom component such as tUnpivotRow.
- Created Talend jobs to load data into various Oracle tables. Utilized Oracle stored procedures and wrote fewJava code to capture global map variables and use them in the job.
- Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
- Experience in Installing Software’s and Configuring Databases.
- Experience in UNIX Shell Scripting for batch processing.
- Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
- Comfortable to work with a team or work individually.
- Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
TECHNICAL SKILLS:
Data Warehousing ETL: Talend 7.1.1./5.5/5.0 , Informatica PowerCenter 9.6.1/9.1/8.6 , (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server).
Databases: Oracle 11g/10g/9i/8.0, Greenplum PostgreSQL), MySQL, SQL Server 2005/ 2000/2008 Programming SQL, PL/SQL, Unix, Shell Scripting
Tools: TOAD, SQL Developer, Hive, Hbase, Pig, Sqoop, Map Reduce, pgAdmin, Aginity,A utosys, Team foundation Server, Jenkins, GIT, Banner, Talend Administrator Console, SVN
Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.
Environment: UNIX (IBM AIX,Sun solaris), Sun solaris
SKILL:
Oracle PL SQL (8+ years), informatica (7 years), Greenplum (5 years), Talend (3 years), Sql Server, TFS (6 years), DEV OPS (3 years)
PROFESSIONAL EXPERIENCE:
Confidential, New haven, CT
Sr. Oracle PL/SQL developers Talend ETL developer
Responsibilities:
- Support the Confidential ITS Student and Academic Support Systems (SASS), Campus Community Technologies.
- Implementation and support of Ellucian Banner modules, including Banner 9 Self-Service, and other custom applications.
- Worked with JEE Design patterns as well as their implementation in real world applications, Agile Methodology, XML/JSON and developing SOAP and REST web services, Maven, Jira, Confluence and Jenkin.
- Design and development of REST web services in Talend.
- Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 11g.
- Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
- JAD sessions with business users and SME's for better understanding of the reporting requirements.
- Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
- Analyzing the source data to know the quality of data by using Talend Data Quality.
- Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings.
- Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and target.
- Developed complex Talend ETL jobs to migrate the data from flat files to database. Implemented custom error handling in Talend jobs and also worked on different methods of logging. Created ETL/Talend jobs both design and code to process data to target databases.
- Troubleshot long running jobs and fixing the issues.
- Used Confidential, tDie, tLogRow to create a generic joblet to store processing stats.
- Solid experience in implementing complex business rules by creating re-usable transformations and robust mappings using Talend transformations like tConvertType, tSortRow, tReplace, tAggregateRow, tUnite etc.
- Developed Talend jobs to populate the claims data to data warehouse - star schema.
- Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
- Used Confidential, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history.
- Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and Routines.
- Experienced in using debug mode of talend to debug a job to fix errors. Created complex mappings using tHashOutput, tHashInput, tNormalize, tDenormalize, tMap, tUniqueRow. tPivotToColumnsDelimited, etc.
- Used tRunJob component to run child job from a parent job and to pass parameters from parent to child job.
- Created Context Variables and Groups to run Talend jobs against different environments.
- Used tParalleize component and multi thread execution option to run subjobs in parallel which increases the performance of a job.
- Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to FTP server using components like tFileCopy, TFileAcrchive, tFileDelete, tCreateTemporaryFile, tFTPDelete, tFTPCopy, tFTPRename, tFTPut, tFTPGet etc.
- Experienced in Building a Talend job outside of a Talend studio as well as on TAC server.
- Experienced in writing expressions with in tmap as per the business need. Handled insert and update Strategy using tmap. Used ETL methodologies and best practices to create Talend ETL jobs.
- Extracted data from flat files/ databases applied business logic to load them in the staging database as well as flat files.
- Design and implement innovative solutions, reusable components and patterns, frameworks and libraries to meet the needs of business.
- Review code and provide feedback relative to best practices and improving performance.
- Troubleshoot production support issues post-deployment, identify the root cause issue, and thrive to permanently solve the issue.
- Contribute to the design and architecture to enable secure, scalable, and maintainable software and should be able to clearly articulate the implications of design/architectural decisions, issues and plans to technology leadership.
- Developed programs or systems of moderate size and complexity. Modifies existing systems at all levels of difficulty.
- Provided informational input into decisions concerning the development and delivery of applications, programs and systems. Analyzes requirements to meet the expectations of stakeholders and intended end user needs, scheduled timeline, and budgetary targets.
- Responsible for the creation, definition, communication, and management of project plans which includes architectural design, technology selection and methodologies to apply.
- Troubleshoot problems, identify root cause and provide ongoing maintenance and support for applications and systems.
Environment: Oracle 11g, Talend 7.1.1/5.5/5.0 , Oracle 11g, MS SQL Server 2012/2008, PL/SQL, Agile Methodology, TOAD, Jenkins, GIT, Banner, Talend Administrator Console, AIX, Shell Scripts, AutoSys, SVN.
Confidential, Tampa, FL
Sr. Oracle PL/SQL developer, Talend ETL developer, Informatica and Greenplum developer
Responsibilities:
- Created Informatica mappings, workflows and application using Informatics BDE developer.
- Created Talend Mappings to populate the data into dimensions and fact tables. Frequently used Talend Administrative Console (TAC)
- Used Confidential, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history.
- Successfully Loaded Data into different targets from various source systems like Oracle Database, DB2, Flat files, XML files etc into the Staging table and then to the target database.
- Developed jobs, components and Joblet in Talend. Designed ETL Jobs/Packages using Talend Integration Suite (TIS).
- Implemented new users, projects, tasks within multiple different environments of TAC (Dev, Test, Prod, and DR).
- Created Infra commands to run workflows on UNIX server.
- Designed workflows with mappings, command task and decisions used.
- Monitored mappings, workflows and applications using Informatica BDE Monitor.
- Created and used reusable Mapplets and transformations using Informatica Power Center.
- Created data break points and error break points for debugging the mappings using Debugger Wizard.
- Created session and work flows to help schedule mighty loads and process data from all source.
- Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
- Performed Unit testing, Integration testing and System testing of Informatica mappings and applications.
- Implemented slowly changing dimension in various mappings.
- Created Test plans for unit-test, System Integration Test and UAT and tested code in all Development.
- Prepared ETL standards, Naming Conventions and wrote ETL flow documentation.
- Extensively worked with transformations like Lookup, Update Strategy, Expression, Filter, Router, Joiner, and Aggregate.
- Ported code from Oracle to Greenplum
- Reverse engineered data models to improve Green plum function queries.
- Loaded data into a Greenplum database instance using external tables, SQL copy and insert commands, and parallel load utilities.
- Worked on Greenplum features, benefits, and understanding architecture and how Greenplum supports redundancy and high availability.
- Designed and implemented table partitioning for handling very large tables.
- Improve query performance by following performance enhancement tips and database best practices.
- As part of the production support team, contributed to the effort to expand the number submitters by analyzing, and testing files, and setting up production Moveit jobs.
- Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
- Working on the ETL side of the process to load data into database from different servers.
- Created partitions for parallel processing of data.
- Developed UNIX Shell scripting for job automation and daily backup.
- Involved in performance tuning using with TKPROF.
- Documentation of the business process through Designer.
- Writing backend stored procedures, event driven triggers, functions, and packages as needed.
- Worked on production support, trouble reports which were received from clients.
- Expertise in debugging the code and creating the exceptions to handle bad data and send them to error log files.
- Error handling using system defined exceptions and user defined exceptions like
Confidential
Environment: Windows 7, Oracle 11g, Greenplum (PostgreSQL), Informatica, Oracle Application server 11g, Oracle Enterprise ManagerTools: PL/SQL Developer, Talend Administrator Console, Toad, SQL*Plus, Putty, WinSCP, HP Quality center version control, Work Load control Center.
Sr. Oracle PL/SQL developer, Informatica developer
Responsibilities:
- Database design and development including Tables, Primary and Foreign Keys, Indexes, Stored Procedures and Database access policies for the company’s education system.
- Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
- Maintained a series of UNIX shell scripts to manage batch order processing.
- Database performance monitoring and identifying bottlenecks hindering the performance of the database.
- Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
- Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and self-joins.
- Tuned SQL statements using hints for maximum efficiency and performance, created and Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
- Created complex Stored Procedures and Views to be used for the Reports.
- Manage existing data Sizing the database for future growth.
- Created database objects tables, indexes, views, synonyms.
- Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
- Created FORMS and REPORTS using Visual Basic.
- Developed PL/ SQL modules such as packages, triggers, procedures and functions.
- Heavily involved in Performance Tuning at the application level.
- Developed reports using Oracle reports.
- Developed UNIX Shell scripts that will interact with the PL/ SQL Objects.
- Documented and performed unit testing for all components prior to migrating them to production.
Environment: Oracle 11g/10g, Oracle REPORTS Developer (11g), UNIX Server 4.3, Rational Clear Quest, SQL NAVIGATOR. PL/SQL Developer, Toad, SQL*Plus, Putty, WinSCP, HP Quality center version control, Work Load control Center.