Natraj D
Chennai
Summary
Having 6.5 Years of experience and 4.5 years of experience in IT industry as ETL Tester and i have performed ETL testing, Manual testing and database testing with skills of Oracle SQL, UNIX, SSIS and ETL concepts.
Analysed Requirements and Provide work effort estimates.Developed test cases and planning to complete unit testing.Remarkable experience in designing ETL processs and Developing Source to Target Mappings.
Familiaring with data warehouse solution in Oracle 11g environment.
Proficient in SQL queries and SSIS validation Proven experience in utilizing database such as Oracle and SQL.
Worked in 24/7 Rotational shifts for provided Testing support Excellent Analysis, Problem solving and communication skills Experience in Fact and Dimention table analysis. Create design specification and operational documentation.
Overview
16
16
years of professional experience
Work History
ETL Tester
Precision Infomatic (M) Pvt. Ltd
08.2022 - Current
- Create test cases by studying the mapping documents from Source and target Environment
- To create ETL test Scripts based on technical specification and source to target mapping.
- To create Test Scripts and Execute the Test Scripts.
- Tested SQL queries to validate the data and performance of the database.
- Tested SQL queries to validate the data and performance of the database.
- Involved in data quality validation includes row counts check,sample data validations and entire data reconciliation.
- Verified Column mapping between Source and Target environments.
- Strong Understanding in Software Testing Life Cycle processes.
- Create documents for Bug logging, Prioritizing, Tracking and reporting.
ETL Tester
DUCEN IT Private Limited.
03.2019 - 04.2022
- Analysed the Project and tested the source data, staging data and target data.
- Written SQL queries to execute the test cased using Sub-queries,Joins,Group and Analytical function.
- Testing the Record counts between Source and Target environments.
- Documentation & preparation of test reports, defect list, test results.
- Analyzed application data using the SQL to identify the ETL processes modifying and creating SQL queries and stored procedures for quality assurance and analysis.
- Defects identified in testing environment are communicated to the developers.
- Creating traceability relationship between requirements in the same module and also between different modules.
- Attended the Scrum meeting and update the status for Day to Day activities.
IT Jr. System Engineer
DUCEN IT Private Limited.
03.2017 - 07.2017
- Onsite L1 support for the end user for Canada clients
- Routine Backup task and restore on the quest backup Server
- Vendor co-ordination for End-user warranty support related issue
- New implementation tool comparison and manage the existing tools
- Compliance support and audit report preparation support
- VIP management support like conference support and to create bridge calls
IT Jr. System Administrator
Ninestars Information Technology Limited.
08.2009 - 03.2017
- Installing and Configuring Windows 2008 Active Directory, DHCP, DNS, Managing server related issues
- Performed user account creation, deletion, and configuration
- Configuring and troubleshooting desktops, laptops and servers
- Supported cross-platform software on Linux client platforms, including some Windows and MacOS X support under the direction of other systems administration staff
- Installed software, patching, upgrading and maintenance of operating system
- Assisted in hardware installation and maintenance of workstations, servers, networking equipment, and other supporting hardware
- Installing software in MAC
- Linux and Windows server support at minimum level
- Tape backup taking in LTO4 using Net vault application
Jr. System Administrator
Prasad Corporation Limited.
10.2008 - 04.2009
- Asset Management for all the hardware peripherals
- Antivirus console monitoring and problem resolving in client systems
- Calls handling as per priority and sending the consolidate reports
- Tape backup taking in LTO4 media
- Network planning as per requirement of the team
- Maintenance schedule conducting for thrice a month
- Inward and outward material tracking
- Configuring Mails and troubleshooting the errors
Education
B.E. - Electronics and Communication Engineering
01-2010
Diploma - Electronics and Communication Engineering
01.2004
HSC - Higher Secondary school
01.2001
SSC - Secondary School Certificate
01.1999
Skills
- Oracle database 12C
- SQL and UNIX
- SQL Developer
- SSIS
- JIRA
- Tidal enterprise Scheduler
- Big query
- Linux
- Teamwork and collaboration
Disclaimer
I hereby declare that the above information mentioned in the resume is correct and complete to the best of my knowledge and belief.
Languages
English
Upper intermediate (B2)
Tamil
Upper intermediate (B2)
Telugu
Upper intermediate (B2)
Timeline
ETL Tester
Precision Infomatic (M) Pvt. Ltd
08.2022 - Current
ETL Tester
DUCEN IT Private Limited.
03.2019 - 04.2022
IT Jr. System Engineer
DUCEN IT Private Limited.
03.2017 - 07.2017
IT Jr. System Administrator
Ninestars Information Technology Limited.
08.2009 - 03.2017
Jr. System Administrator
Prasad Corporation Limited.
10.2008 - 04.2009
Diploma - Electronics and Communication Engineering
HSC - Higher Secondary school
B.E. - Electronics and Communication Engineering
SSC - Secondary School Certificate
Similar Profiles
PremKumar P PremKumar P null
Network Support Engineer at Precision Infomatic (M) Pvt. LtdNetwork Support Engineer at Precision Infomatic (M) Pvt. Ltd
BALASUBRAMANIAN S BALASUBRAMANIAN S null
IT Hardware Technician at PRECISION INFOMATIC (M) PVT LTDIT Hardware Technician at PRECISION INFOMATIC (M) PVT LTD
MURALIDARAN KUBENDRANMURALIDARAN KUBENDRAN
Program Manager at Precision Infomatic (M) Pvt LtdProgram Manager at Precision Infomatic (M) Pvt Ltd
Monika KMonika K
Billing Operation at ToastBilling Operation at Toast
V Madhwaraj RaoV Madhwaraj Rao
Senior Consultant at Infosys LimitedSenior Consultant at Infosys Limited