Radhika Duraisamy
Coimbatore
Summary
Enthusiastic and highly experienced ETL developer with 15 years of experience in developing Informatica based applications with Teradata, DB2, Oracle as databases and Hive file system. Supportive and enthusiastic team player, dedicated to streamlining processes and efficiently resolving project issues.
Overview
19
19
years of professional experience
Work History
Business Analyst & ETL Developer
NSW Department of Education
10.2016
- Responsible for requirement gathering and preparing the design documents required for development
- Responsible for analyzing and interpreting the requirements and source data
- Defining the ETL development standards required, effort estimation and performing Informatica Admin tasks
- Responsible for ETL development processes using Informatica power center adhering to the standards
- Data analysis, data profiling and data transformations using IDQ
- Experience in ETL Performance Tuning and handled complex scenarios and acted as a primary contact point with the client.
Tech Lead/PM
Wipro
06.2021 - Current
- Responsible for working on Enterprise landing zone which covers storing HDFS files from heterogeneous sources like mainframe, Database, text files etc
- Develop, configure, deploy and load disparate data into HDFS using Hive process
- Monitor Hadoop log files to fine-tune the performance of applications, capture datasets loaded through batch processing standards
- Developed ETL workflows using Informatica to incorporate business requirements, and executed UNIX Shell Scripts to invoke ETL jobs
- Collaborated with cross-functional teams in an onsite/offshore model to identify, prioritize, analyse, and resolve production issues
- Mentored and guided team on technical and business perspective
- Project Management activities including resource management and client invoicing.
- Optimized resource allocation by effectively prioritizing tasks based on business needs and project timelines.
- Developed comprehensive documentation to facilitate knowledge sharing among team members and support long-term maintenance efforts.
- Established coding standards to ensure consistent quality across the development team''s output.
- Built strong relationships with stakeholders, ensuring clear communication channels for project updates and progress reports.
ETL Developer
ING Australia
04.2018 - 02.2019
- Responsible for requirement gathering and preparing the design documents required for development
- Responsible for analyzing and interpreting the requirements and source data
- Defining the ETL development standards required, effort estimation and performing Informatica Admin tasks
- Responsible for ETL development processes using Informatica power center adhering to the standards
- Experience in ETL Performance Tuning and handled complex scenarios and acted as a primary contact point with the client.
Senior BI Developer
Insurance Australia Group
11.2014 - 06.2016
- Responsible for requirement gathering and preparing the design documents required for development
- Responsible for development of the ETL (Extract, Transform and Load) processes using Informatica power center
- Developing ETL code based on Data vault model and Agile Methodology
- Debugging and trouble shooting of complex data issues
- Identified areas of application that required improvement and implemented the ideas that helps the team and the client
- Organized and held meetings with stakeholders, contractor product teams and customers.
BI Developer
Cognizant Technology Solutions
09.2010 - 04.2014
- Responsible for requirement gathering, preparing the design documents required for development and development using Informatica PowerCenter
- Led the team in improving the code to effectively manage the data and to present to the user
- Instrumented and modified unit and integration tests to improve software quality and reliability
- Organized and held meetings with stakeholders, contractor product teams and customers
- Resolved customer issues by establishing workarounds and solutions and by debugging and creating defect fixes
- Trained 3 other team members on the business and the Informatica tool
- Drafted technical documents and provided guidance to the team members on Tool usage and business requirement.
BI Developer
IGATE Global Solutions
02.2006 - 12.2009
- Extensively developed using Informatica Power center, instrumented unit testing and system testing on the application deliverables and drafted test cases and review checklist
- Coordinating with client, on site team members and team members to implement new business requirements and to enhance the existing application
- Trained 5 other team members on the business and the Informatica tool
- Drafted technical documents and provided guidance to the team members on Tool usage and business requirement
- Development of Cognos Report Studio Reports from Framework Manager, testing Reports and preparing test cases for the deliverables.
Education
M.Sc. Computer Science -
Navarasam Arts and Science College for Women
Erode, Tamil Nadu04.2005
B.Sc. Computer Science -
Vellalar College for Women
Erode, Tamil Nadu04.2003
Skills
- Extensive knowledge in Informatica as ETL tool and Cognos as reporting tool
- 15 years of experience with application development using Informatica as an ETL tool
- Extensive knowledge in relational databases such as Teradata, DB2, SQL Server Oracle and Hive file system
- Extensive experience in Data analysis, preparing design documents
- Understanding & working knowledge of Informatica CDC (Change Data Capture)
- Experience as Reviewer and tester, involving in reviewing of Informatica objects, providing approvals and migrating an objects across development, QA and Production environments
- Strong understanding of Dimensional Data modelling, Star Schema/Snowflakes Schema, Fact and Dimension tables and data vault modelling
- Trained in Spark and Azure fundamentals
- Completed Wipro PMP certification
- Good communication skills, interpersonal skills, Analytical and problem solving skills, team player and enthusiastic in learning new tools and business environment
Accomplishments
- Obtained Gold medal in Master of Computer Science in Bharathiar University
- Provided innovative ideas to improve workaround for News America Marketing‘s ETL development and maintenance
- Single handedly managed the development process for cross sell percentage and trend for IAG.
- Obtained Advanced Teradata certified professional V2R5 certificate.
Languages
English
Tamil
Personal Information
- Nationality: Australian
- Marital Status: Married
- Visa Status: OCI holder
Technicalexperience
Teradata, Oracle, DB2, Hive file system, Informatica PowerCenter, Informatica Developer, SSH Secure File Transfer Client, Power Shell, Cognos ReportNet
Timeline
Tech Lead/PM
Wipro
06.2021 - Current
ETL Developer
ING Australia
04.2018 - 02.2019
Business Analyst & ETL Developer
NSW Department of Education
10.2016
Senior BI Developer
Insurance Australia Group
11.2014 - 06.2016
BI Developer
Cognizant Technology Solutions
09.2010 - 04.2014
BI Developer
IGATE Global Solutions
02.2006 - 12.2009
B.Sc. Computer Science -
Vellalar College for Women
M.Sc. Computer Science -
Navarasam Arts and Science College for Women
Similar Profiles
Kate HuntKate Hunt
PDHPE Teacher & Year Coordinator at NSW Department of EducationPDHPE Teacher & Year Coordinator at NSW Department of Education
Nathan Frederick MarksNathan Frederick Marks
High School Casual Teaching at NSW Department Of EducationHigh School Casual Teaching at NSW Department Of Education
Tanya Tanya null
HR Customer Service Support Officer at NSW Department of EducationHR Customer Service Support Officer at NSW Department of Education