SUMMARY

• 3 years of experience on database, ETL, which includes complete SDLC, Design, Development, and Development of Data warehousing environment, online Analytical Processing and ETL (Extraction, Transform, Load) solutions. Working closely with business users to get the requirements and prepare functional requirement specifications, Source and target mapping documents associated with development and implementation of data - marts, Operations Data Stores, and Enterprise Data Warehousing.
• Worked on installation, configuration and maintenance of MySQL and Ambari Hadoop (Hortonworks) using Linux.
• Experience in Data Extraction, Transforming and Loading (ETL) using Pentaho Data Integration and Informatica Power Center.
• Experience in creating Transformations and Mappings using Pentaho and Informatica Power center.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
• Good Knowledge in testing and debugging Java codes since I worked as a backend developer with Java terminologies.
• Experience in creating database objects such as tables, view in MySQL.
• Extensively used Informatica client tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager in creation in creating Source and target tables, designing transformation, and debugging.
• Creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Experience in designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key and Unique key) and Indexes.
• Performed tasks to gather database statistics, data analysis and monitored database audit log.
• Team player with the ability to communicate effectively at all levels of the development process.
• Experience in developing Linux shell scripts.

TECHNICAL SKILLS

Programming Languages: Java.

Relational Databases: MySQL

Software Applications: Microsoft Excel, Microsoft Word.

ETL: Pentaho Data Integration and Java as the ETL, Pentaho Report Designer, Informatica Power Centre.

Operating system: Windows 7, Windows 8 & 10, Linux.

IDEs: IntelliJ, Eclipse

PROFESSIONAL EXPERIENCE

Confidential, Mettawa, IL

Informatica Developer

Responsibilities:

• Extensively used Informatica client tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager in creation in creating Source and target tables, designing transformation, and debugging.
• Worked with Teradata and Oracle databases and backend as Unix to do the analytics on data.
• Understanding the Business and scope requirements from Customer and transforming the logic into Informatica power designer.
• Worked on code migration from Development, Q.A and production. As well as following up the code in production for better performance.
• Used different transformation tools in designer tool like Stored procedure, passive and Active transformations, tasks like Assignment, Commands, Sessions.
• Interacted with the clients both onsite and offshore on regular basis to understand and give better solutions to the Business requirements.
• Used Data Flow Tasks, and Informatica to load data to Teradata database, staging area, and data warehouse (DWH).
• Designed on creating complex drill down reports, parameterized reports, dropdowns and images, charts using Informatica, excel Reports for the analyzing data at an enterprise level.
• Reviewing the developed code to check for the errors if any, in the code, if there are errors or bugs in the developed code, then fixing them properly by taking assistance from the seniors.
• Participated in Test case building and execution for validating the ETL system.

Confidential

Data warehouse Developer and ETL Developer

Responsibilities:

• Strong problem-solving skills, good communication, interpersonal skills and a good team player and Interacted with the business teams to understand the requirements of the project.
• Implemented monitoring data systems using Linux scripts by sending Emails to outlook and Slack.
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software and performed the requirements walkthrough with business users for review and approval
• Designed and implemented new Java ETL, Pentaho ETL and proper database maintenance to maximize the database availability and high performance.
• Developing JAVA methods for proper working of the JDBC queries and ensure that proper error messages are generated upon errors.
• Enhanced Java JUnit Testing and Linux script testing Framework for performing Unit testing before moving data into production.
• To query database using the Java collection framework. Involved in batch processing using to extract data from database and load into corresponding MySQL Database tables.
• Defect to fix the code related issues after analyzing the code.
• Wrote prepared statement queries for creating, retrieving, updating and deleting data in database.
• Transformed data from one server to other servers using tools like Pentaho Data Integration. Tools that optimized component development by using historical data in databases to plan machine schedule and developed company’s databases.
• Prepare reports using Pentaho report designer and analyzed the logical model of the Pentaho report designer software with connection to MySQL databases.
• Designed on creating complex drill down reports, parameterized reports, dropdowns and images, charts using Pentaho Report Designer for analyzing data at an enterprise level.
• Used Pentaho Data Integration Flow Tasks, to load data to MySQL database, staging area, and data warehouse (DWH).
• Participated in Test case building and execution for validating the ETL system.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated meta data.
• Reviewing the Log files in Linux to check for the errors if any, in the code, if there are errors or bugs in the developed code, then fixing them properly by taking assistance from the seniors.

Confidential

MySQL Database Developer

Responsibilities:

• Assisted in day-to-day operations of the Data Warehouse and Reporting team.
• Create database objects such as tables, views, stored procedures, Triggers. Involved in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using MYSQL.
• Created SQL scripts, In MySQL queries for developer applications.
• Designed on creating complex drill down reports, parameterized reports, dropdowns and images, charts using Informatica, excel Reports for the analyzing data at an enterprise level.
• Involved in writing several Queries and Procedures. Used joins, indexes effectively in where clauses for Query optimization.
• Utilized strong understanding of Java object-oriented programming.
• Transformed data from one server to other servers using tools like Informatica workflows, using Informatica workflow Designer, Manager, and workflow Monitor.
• Reviewing the developed code to check for the errors if any, in the code, if there are errors or bugs in the developed code, then fixing them properly by taking assistance from the seniors.
• Monitored controls post authorization to ensure continuous compliance with the security requirements.