Responsibilities: Involved in the design, development, testing, implementation, and support of the ETL jobs. This includes designing, developing, testing, implementing and maintaining Teradata SQL server.
Performed data analysis and testing, created DDL scripts, wrote stored procedures, functions, and triggers for the entire project to use the Teradata database to support the quality assurance of the MicroStrategy reports.
O involved in data warehousing and ETL testing using Ab Initio and Netezza to create and debug the database and stored procedures, functions, Triggers, and views.
Informatica data quality, Oracle 10g, DB2, SQL Server, and Teradata, IT is a security tool, which is used for the production and use cases.
Performed data replication testing, wrote test plans, test scripts, and executed testing for the CICS application. Worked with offshore team to fix the issues.
Developed and implemented data modeling, DDL and DML scripts using Erwin tool. Used the security for creating users, roles, privileges, profiles, and roles.
Senior Software Engineer, I
Involved in the design, development, testing, maintenance, integration, and support of the ETL process for the data warehouse, EDW, and data migration.
Developed and implemented a HIPAA compliant EDI 834 system for the medical insurance portability and accountability Act (HIPAA) and a Sarbanes-Oxley (SOX) application.
Prepared the complete SDLC for the integration of the application, involved in coding, testing, documentation, and implementation of the reports and dashboards using SQL server.
Worked with the offshore team to develop the project for the integration of the data from the legacy system to the new CRM system.
The data integration testing was done in the ERP system. Developed the documentation for the user Acceptance testing (UAT) and clarify the business requirements.
Created and maintained the data warehouse and integration project for the WMS system. Developed the test cases for the POS application.