SUMMARY:

• Talend Certified Administrator with data warehousing experience spanning over 9 years in planning, analyzing, designing, coding, testing and implementing database structures with hands on exposure to database administration, PL/SQL development, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive experience with ETL tools in the areas of analysis, design, development and administration with focus on Talend Data Integration, Talend Big - data Real Time, Informatica power center and Apache tomcat with different databases.
• Proficient in planning, scheduling and implementing ETL application changes while ensuring no impact to users including data migration across the different OS versions
• Worked on implementing DWH solution on GreenPlum database (MPP architecture) hosted on VM’s
• Built Talend 4.x through 6.x and Informatica environments for high availability for DEV, QA and production environments including Installation, upgrade, migration, User management, back/restore, code promotion and OS Profiling in AWS, RHEL and Windows instances.
• Experience working in Agile environment and extensive Cloud Management skills.
• Extensive knowledge in the installation and administration of Oracle E-Business in production environments.
• Working experience with Very-Large databases (VLDB) up to 150 terabytes, data migration against different databases/warehouses
• Excellent experience in installation, setup/configuration and upgrades of all versions of Informatica and Talend in HP-UX, Sun Solaris, Master Veritas, Oracle Sun Fire, IBM AIX, Windows and UNIX/Linux Environment
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, tuning heavy data loads, Monitoring and Performance tuning
• 24*7 production ETL application support with Support to developers & end-users and a good experience in Data Migration using export/import
• Worked with heterogeneous data like Oracle, Greenplum, HAWQ, Casandra, Mongo-DB, Flat files and different Hadoop concepts.
• Excellent working knowledge of Systems Development Life Cycle-SDLC, Agile software development and Software Testing Life Cycle-STLC. Dimensional Modeling Dimensional Tables and Fact Tables and strong understanding of Star schema modeling, Snowflake modeling.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in all work environment
• ETL Automations Processes:
• Built UNIX shell scripts to automate certain process in the data warehouse environment.
• Used different schedulers like: Dollar$ Universe, maestro job scheduler, Oozie Workflow Scheduler, Bonita soft, Informatica scheduler and Talend scheduler.
• Extensive experience with Bigdata tools like Hadoop, Spark, NoSQL and Hive.
• Proof of Concepts (POC): Jenkins with Talend, Hortonworks Data Platform (HDP) for Apache- tomcat Talend streaming environment for AWS servers.
• Possess organizational development, team facilitation, group process, leadership development and ability to analyze situation and offer cost innovative effective solutions.

TECHNICAL SKILLS:

ETL Tools: Talend Big Data 4x/5.x/6.x, Talend Real-Time Big Data 6.x, Informatica power center 9.x/8.x/7.x and Apache tomcat

Languages: SQL/PLSQL, UNIX shell scripting and P-SQL

Concepts: Data warehousing, DBMS and SDLC

Databases: Oracle 9i/10g,11G, Hadoop, Greenplum and HAWQ

Repositories: SVN, GIT and Nexus

Tools: Maven, Jenkins, Hive, Oozie, Maestro, Toad 8.x, SQL developer and Putty.

RDBMS: Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams, and (Golden Gate).

Operating Systems: HP-UX 10.x, 11.x, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP

Languages: Java SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Bash and Perl Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, Ohio

Talend platform Architect/ETL Administrator

Responsibilities:

• Built the Talend version 6.1 and upgraded to a highly scalable, high available 6.3 in the Non-Prod, Prod and AWS environments while interacting with the Business users and documenting and implementing their queries, business analysis, reporting needs, data and business logics.
• Developed and tested ETL jobs in Datastage.
• Designed and implemented the ETL Data model and create staging, source and Target tables in Oracle, Hawq, Hadoop and Greenplum databases.
• Completed several complex Data Integration process using Talend ETL Tools
• Repository setup by configuring SVN, GitHub, Nexus and Jenkins for the Talend code to be managed.
• Implemented Talend automations to reduce time and man power, also automated ETL jobs and unit testing, reducing build time by 30%.
• Designed and Developed Interactive Dashboards using Business Insight.
• Managed Hadoop and Oracle databases by using SQL developer and Hive tools.
• Used Oozie and Talend schedulers to schedule the workflows and jobs.
• Maintaining the standards as the code is sync in all the three environments and handling outages like password changes, patch installations (Hot Fixes/Software’s), Bouncing activities and network changes.
• Suggest ways to improve functionalities, work-arounds and business process improvements to improve operational efficiency and controls
• Perform functional and integration testing and user acceptance testing.
• Administration of Talend Server, User Administration, Creation of Talend Folders and assigning privileges, Creation of UNIX Level folders.
• Built Apache Ni-Fi environment and AWS sever implementation for Talend environment.
• Implemented UNIX shell scripts and tuning of SQL queries for better performance to improve Talend functionalities.

Talend Support Engineer

Responsibilities:

• Customer support for the various Talend products through support portals OTRS/Salesforce.
• Timely tickets resolutions, reproducing test scenarios and reporting bug cases to JIRA extensively while documenting each user/customer incdents/resolutions
• Security configuration for users, projects, roles (SVN, TAC, working with security group)
• Talend administrator with hands on Big data (Hadoop) with Cloudera framework
• Installation, configuration, and upgrades of Talend applications on all existing and supported versions with continuous experience and skills working with and troubleshooting associated issues and keeping current with all related emerging software enhancements, security patches and bug fixes
• Proactive gathering of requirements from Customers to provide technical/functional support and resolution to incidents and service requests
• Modifies, installs, and prepares technical documentation for system software applications
• Troubleshooting, debugging & fixing Talend specific issues, while maintaining the health and performance of the ETL environment
• Monitors systems capacity and performance, plans and executes disaster recovery procedures, and provides Tier 2 technical support.
• Best practices for Application Server maintenance
• Document disaster recovery procedures and technical support
• Work with the development staff to determine project requirements for dev/test/pre-prod/production environments Linux
• Experience to work at the highest technical level of all phases of applications server activities

Talend Platform Architect/Admin

Responsibilities:

• Built Talend versions 5.x to 6.0, monitored and administer environment seamlessly
• Administration of Talend Servers, User Administration, Creation of Talend jobs and assigning privileges and roles
• Developed a 100+ test cases for individual Talend jobs while documenting all test cases and test lab in Quality Center using screenshots
• Document the Installation, Deployment, administration and operational processes of Talend MDM Platform (production, Pre-Prod, test30, test 90 and development) environments for ETL project
• Document Security configuration - SVN, GIT, TAC, Jenkins, Job Server, MDM Server
• High availability for QA and production environments including Installation, upgrade, migration, User management, back/restore, code promotion
• Validated data flow from source system to staging to dimensions and fact tables.
• Talend Code Automation from one environment to another environment by using UNIX scripting.
• Provide support to Application Tuning Team. Also designed, developed, administered, tested and deployed needed enhancements
• Gathered requirements from key business users thereby writing technical design documents for Talend and SSIS ETL jobs and developed and deployed SSIS packages through development, QA and production servers.
• Worked closely with clients and Business to ensure a detailed understanding of the requirements
• Trained teammates and application owners as per mandated KT sessions
• Managed migration process for three other developers by analyzing specifications to identify the source data that needed to be moved to data warehouse.
• Supporting reporting related issues raised by the End Users

Informatica/Talend ETL Consultant

Contribution

• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center 7.x to 8.x
• Created different target definitions using warehouse designer of Informatica Power Center.
• Created different transformations such as Look-Up transformations, rank transformations, expression transformations, Aggregator transformations and Sequence Generator.
• Analyzed specifications and identified the source data that needed to be moved to data warehouse using Talend ETL tool as POC
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center 8.6
• Created different target definitions using warehouse designer of Informatica Power Center.
• ETL architecture and full software life cycle development across numerous software and hardware platforms in a variety of industries as well as SAS ETL developer with expertise in design and development of Extract, Transform and Load processes for data
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1.0 as well as the new Data Integration Hub (DIH) installation, support and maintenance

Informatica/Talend/Oracle DBA Administrator

Responsibilities:

• Working closely with the ETL Team in the troubleshooting the data issues
• Created different transformations such as Look-Up transformations, rank transformations, Expression transformations, Aggregator transformations and Sequence Generator.
• Responsible for Extracting, Transforming and Loading data from Oracle, Flat files and placing it into Data warehouse.
• Introduction to Talend ETL, building test jobs via Talend Open studio and migratinf existing Informatica, Oracle ODI and Pentaho jobs to Talend
• Design of ETL processes using Informatica tool to transform data from source system to target database
• Designed and developed various Mappings using Transformations like aggregator, joiner, Lookup, Filter, Source Qualifier and Update Strategy, Stored Procedure
• Improving the performance of Mappings and sessions.
• Installing Oracle Database Software 10g/11g also cluster management and verifying cluster process to ensure smooth operations.
• Analyzing, designing, coding, testing and implementation of database structures such as Oracle 10g Database upgraded to Oracle 11g Database
• Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM (Oracle Enterprise Manager),
• Monitoring and maintaining 2/3 node RAC database. Providing support to the development team and handling release schedules. Data protection and availability with tools like Data Guard and Grid Control with a more flexible replication mechanism using Golden Gate.
• Creating clone databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Using SQL Loader extensively to extract data from flat files and loading into the new application.
• Performed SQL Queries/ Application and Database performance monitoring and tuning using various tools like ADDM, AWR.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab scheduler

Oracle Database/ETL Administrator

Responsibilities:

• Responsible for Database Growth and Space management, capacity planning, table partitioning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
• Involved in logical backup using and full/ partial export/import and Data Pump, Backup and recovery.
• Design and implanted several Data Marts
• Instrumental in building/implementing the Oracle Data Warehouse
• Design the backend ELT system for moving disparate data to Warehouse
• Completed several complex Data Integration process using Informatica, Pentaho and Talend ETL Tools
• Architect and design several business intelligence solutions
• Excellent experience of SQL and PL/SQL Developer and Unix Shell scripting also maintaining UNIX scripts for monitoring and backup.
• Maintaining 24 X 7uptime for the database while carrying out the activities.
• Performing tuning of PL/SQL Developer and SQL.
• Completed large complex Data Modeling using Erwin
• Responsible for large complex Data Modeling, conception, Relationship, Physical
• Responsible for architectural design and strategies
• Created Conceptual and Physical designs models
• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment
• Experience on Net-back up client with RMAN to automate the backups to tape as per company standards and completing Hot, Cold and Logical backups also performed backup validations using RMAN.
• Creating the database, tables, table spaces, and data objects, setting privileges, indexes, user names & passwords, management, Security administration.
• Upgraded Oracle binaries in the development environment and production environment.
• Creating Users and Roles with appropriate privileges and roles.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Trouble shooting with restoring and recovery (Instance, media).