Around 6months of experience with design/developing ETL processes using BO Data Integrator. Experience in Design & Development of Enterprise Data Warehouse infrastructure processes for extracting, transforming and loading data Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems. Extensively used SQL and PL/SQL for development of Procedures, Functions, Packages and Triggers. Wide experience in reengineering concepts and tools along with End-to-End understanding of Business Concepts. Experience in developing Unix Shell Scripts for automation of ETL process. Experience in developing XML/XSD/XSLT as a part of Source XML files for Talend and also input XML for Webservice Call. Strong communication skills and demonstrated ability to work effectively with business users. Experience with shell scripting schedulers for scheduling nightly jobs. Experience with AGILE Methodologies.
Operating Systems * Windows, Linux
Databases * JAVA, Hibernate, J2EE, SQL and PL/SQL.
Oracle 10g/11g, MySQL, DB2, PostgreSQL.
IDE's & Tools * Apache Tomcat
Eclipse, NetBeans, Talend Open Studio for Integration and Talend for MDM
It deals with the data moving into our database from the client's old application.
For this we used Talend Open Studio (IDE) which is a java environment Oriented IDE.
I used to design talend jobs to complete migration of data (Extract transform, Load).Writing queries flat file loading into Database using sqlloader, Optimizing queries at developer's desk, developing talend jobs for a complex Financial System, scheduling jobs are my primary tasks.
Responsibilities: Develop Talend jobs migrate the data from flat file such as CSV, fixed length files etc.
to oracle tables.
Jobs are able to process large amount of data in quick time Performing logical operations in talend jobs to transform data into application understandable format Data first loaded into the staging tables and then into original tables.
Communicated with business customers to discuss the issues and requirements.
Troubleshooting issues in the production environment and help in resolving issues in the same.
Used debugging tools to debug the flow of data and found the exact issues where expected data was not populated correctly Designed custom components in talend to specific needs Created shell scripts to fine tune the ETL flow and execute them in a proper way Performed unit testing at various levels of the ETL and actively involved in team code reviews.
Worked with team to maintain version control of talend Jobs Able to write sub jobs and call them from a parent jobs Used to design job to perform data validations.
06/2013 to 06/2014
JAVA DeveloperVSOFT TECHNOLOGIES
Carter Bank & Trust Module : “Coresoft” Description: Coresoft is a typical Core banking application specially designed for the teller to make their task pretty much easy when compared to other applications with enhanced security.
I have been working with the Interface module and in specific I have been dealing with interface which handles client's teller machine requests and converts into product understandable format.
Responsibilities: Used to write java code to interpret 128 character length message coming from a third party and split it into parts so that useful information can be gathered then pass it to application for processing.
Used inheritance to comply with company standards.
Used single pattern to reduce the redundancy of objects Used log4j for errors Used hibernate one-to-many , many-to-many concepts for persistence.
Masters: Applied Computer ScienceNorthwest Missouri State University - Maryville, MOGPA: GPA: 3.8/4.0Applied Computer Science GPA: 3.8/4.0
3 Years of experience on a Data Integration/Data warehouse Projects using Talend ETL tool, OLAP Tools, Oracle, Web Designing, XML and Unix Scripting. Extensive experience with Talend (ETL Tool) for Data Extraction, Transformation and Loading. Extensive experience in building Data Warehouses/Data Marts using ETL tool Talend for Data Integration (5.x). Worked on Web services as a part of Talend and obtained the successful connection of the external Webservice call. Reporting experience with tools like Tableau.