OBJECTIVE

Seeking a challenging position, utilizing my abilities developed through my experience and education with an opportunity for career growth based on my merit and to promote the growth of the organization.

PROFESSION

• 7 years of professional experience in warehouse project and ETL scripting.
• Extensive design, development and testing experience with Talend Open Studio and expertise in Performance Tuning of mappings.
• Hands on Experience with Talend Data Integration Etl Tool.
• Strong background in row and column oriented data bases and highly experienced in PL/SQL. performance tuning and debugging of existing ETL process
• Excellent knowledge of the design and implementation of the Data Warehouse life cycle and familiarity with entity-relationship/multidimensional modeling star schema, snowflake schema and strong knowledge on MDX and OLAP cubes.
• Experience in troubleshooting and handling production duties
• Experience in Data quality profiling.
• Experience on MySQL Database Administration on Linux and Windows.
• Experience on MSSQL Server Database Development and Administration
• Experience on Design, Installation, Creation, Maintenance of Databases, Performance Tuning, Backup and Recovery, Optimization and Database Security.
• I have good experience in Jquery and java development.
• Well versed and Hands-on with MySQL, Infobright, MS SQL server architectures. Solid work experience on UNIX, Linux platforms. Handled complex product installations rpm/tar ball independently.
• Experience working in an Agile/Scrum environment and ability to work well under pressure and meet deadlines.
• Implementation of ETL engine using Java to handle incremental loads.

SKILL SET

ETL Tools : Talend, Informatica,MDM

• Data Modeling : Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling
• Databases : MySQL, SQL Server 2008, Oracle, PL/SQL, MDM
• Operating Systems : Linux, Microsoft Windows
• IDE : Eclipse 3.x.
• Web Server : Apache2
• Application server : Tomcat 4.0/5.0,Blazeds
• Languages : C, C , java
• Tools : Schema work bench, Pentaho aggregate designer, DB Designer

Confidential

Role: ETL Developer

The client is into the Health and Medical care vertical. The prime responsibility of the team is to develop a Patient Care Data Warehouse PCDW .This data warehouse is used to access easily the detailed clinical data on a platform and also to facilitate the enterprise-wide data analysis within the health care environment.

Key Responsibilities

• Involved in the product performance Turing right from the inception to installation on production servers.
• Installation and configuration of MySQL database servers.
• Backup / Restore of databases.
• Installation and configuration of MySQL database servers.
• I have good experience in MDM for functionality integration.
• Extensively worked on Data Mart Schema Design.
• Backup / Restore of databases and Writing Complex Queries
• Used efficient optimization techniques to design ETL Scripts.
• Loaded data into Infobright using Talend, FastLoad, MultiLoad, and shell scripts.
• Worked closely with the source team and users to validate the accuracy of the mapped attributes.
• Troubleshoot and created automatic script/SQL generators. I have good experience in Jquery and java development.
• Worked of the design and implementation of the Data Warehouse life cycle and familiarity with entity-relationship/multidimensional modeling star schema, snowflake schema
• Checked the accuracy of data loaded into Infobright and assured the performance of system.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issue.
• Enhanced SQLs for performance tuning
• Rolled out documentation for the ETL Process, Early Data Inventory, and Data Profiling
• Confidential Role: ETL Developer Jun'12 May'13
• This project is for Comcast, which is mainly an Internet and Telephone service provider. As a part of the IT team I was responsible for Migration as well as Integration for few modules such as their Accounting and Internet division. I was involved very closely from gathering the requirement, developing, testing and providing the data to users.

Key Responsibilities

• Installation and configuration of MySQL database servers.
• Loaded data into Infobright using Talend, Fast Load, and Multi Load.
• Worked on Star Join Schema Modeling, Snow Flake Modeling
• Worked closely with the source team and users to validate the accuracy of the mapped attributes.
• Monitoring System Performance.
• Writing SQL code and code review for evaluating the data quality.I have good experience in Jquery and java development. Checked the accuracy of data loaded into Infobright and assured the performance of system. Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues
• Backup / Restore of databases and Monitoring System Performance
• Good working experience in MDM Developer and Rolled out documentation for the ETL Process, early Data Inventory, and Data Profiling

Confidential

Role: ETL Developer

• The client is into the Health and Medical care vertical. The prime responsibility of the team is to develop a Patient Care Data Warehouse PCDW .This data warehouse is used to access easily the detailed clinical data on a platform and also to facilitate the enterprise-wide data analysis within the health care environment. The PCDW is up and running with incremental growth starting from 20 Terabytes of data.
• Key Responsibilities
• Installation and configuration of MySQL database servers.
• Extensively worked on Data Mart Schema Design.
• Backup / Restore of databases and Writing Complex Queries. Used efficient optimization techniques to design ETL Scripts.
• Loaded data into Infobright using Talend, FastLoad, MultiLoad, and shell scripts Worked closely with the source team and users to validate the accuracy of the mapped attributes Troubleshoot and created automatic script/SQL generators. I have good experience in Jquery and java development. Checked the accuracy of data loaded into Infobright and assured the performance of system. Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues Enhanced SQLs for performance tuning Rolled out documentation for the ETL Process, Early Data Inventory, and Data Profiling
• Confidential Role: ETL Developer
• This project was to implement an Enterprise Data Warehouse EDW by means of integrating data from different feeder system situated across various locations into a central repository of business information. The EDW provides quick access to data to enable a more informative decision making process.

Key Responsibilities

• Installation and configuration of MySQL database servers.
• Monitoring System Performance and Backup / Restore of databases.
• Worked on ETL Design for developing optimized ETL scripts
• Loaded data into MySQL using Talend and shell scripts Worked closely with the source team and users to validate the accuracy of the mapped attributes Troubleshoot and created automatic script/SQL generators. Checked the quality of data loaded into MySQL and assured the performance of system. Unit tested the developed ETL scripts, created test SQLs, and handled UAT issues Enhanced SQLs for performance tuning Rolled out documentation for the ETL Process, Early Data Inventory, and Data Profiling.

Confidential Role: ETL Developer

• The system provides online banking to its customers like money withdrawal, fund transfers between accounts and loans etc. The system aims at integrating data scattered in many legacy systems and presenting a centralized data warehouse interface.
• Key Responsibilities
• Involved in the product performance Turing right from the inception to installation on production servers.
• Installation and configuration of MySQL database servers.
• Backup / Restore of databases.
• Involved in 64 bit environment compatibility verification
• The job requirements included installation of the product right from the OS to the product including Apache, Tomcat, and Databases.
• Was involved in smoke testing, integration testing, load tests, performance testing, writing and executing test cases, and preparing bug reports.