Job Search Status
Open to workDesired start date: 2 weeks notice
Open To Work
Roja Devasani
Hyderabad
Work Preference
Summary
Results-driven IT professional with over 5 years of experience in designing and implementing business applications across banking, finance, medical, and manufacturing sectors. Skilled in Talend Open Studio and Talend Enterprise Platform for data management and ETL processes. Expertise in database design and development with Oracle, SQL Server, MySQL, PostgreSQL, and AWS, including data warehousing, data modeling, and performance tuning.
Overview
5
5
years of professional experience
Work History
Specialist - Data Engineering
LTI Mindtree
Hyderabad
10.2023 - Current
- Developed ETL processes to extract, transform, and load data efficiently.
- Optimized existing ETL workflows for improved performance and reliability.
- Implemented data quality checks to ensure accuracy in reporting systems.
- Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
- Worked closely with Business Analysts, System Analysts, Data Architects in gathering requirements for developing ETL solutions.
- Created SQL Server Integration Services packages for incremental and full loads of data from various sources.
- Managed end-to-end operations of ETL data pipelines, maintaining uptime.
- Contributed innovative ideas and solutions to enhance team performance and outcomes.
- Developed and implemented data governance policies to ensure data accuracy and integrity.
- Established and enforced data governance policies and procedures to comply with regulatory requirements and ensure data privacy.
- Identified gaps in current Data Quality policies and processes and proposed solutions for improvement.
- Identified potential issues in data quality that could lead to inaccurate results from applied algorithms.
- Established standards for data quality control by creating automated rules to validate incoming source files against defined criteria.
- Conducted data migration from legacy systems to new databases with minimal disruption to operations.
- Develop detailed plans for data migration from legacy systems into new versions of SAP applications.
System Integration Senior Specialist - Talend
NTT Data
Hyderabad
01.2023 - 10.2023
- Designed and developed ETL processes using Talend for data extraction, transformation, and loading into data warehouses.
- Created and maintained Talend jobs, ensuring data accuracy, consistency, and reliability throughout workflows.
- Migrated SAP BODS jobs to Talend ETL, streamlining existing processes for improved efficiency.
- Implemented data cleansing and validation techniques to enhance data quality within ETL processes.
- Developed comprehensive testing plans, including unit, integration, and user acceptance testing for ETL accuracy.
- Established data governance standards, applying data masking and encryption techniques to ensure security.
- Collaborated with cross-functional teams to align ETL solutions with organizational goals and business needs.
- Maintained thorough documentation of ETL job designs, mappings, configurations, and processes.
Associate ETL Developer - Talend
Publicis Sapient
05.2022 - 01.2023
- Involved in requirement analysis and Design & development from scratch.
- Developed ETL jobs using Talend Cloud 7.3.1.
- Developing SQL Scripts (DDL & DML) in various environment.
- Using multiple components including tMap, tJoin, tJava, tJavaRow, tJavaFlex, tFlowtoIterate, tAggregateRow, tUniqRow, creating contexts, global variables & tContextLoad etc.
- Using Salesforce Components like tSalesforceInput, tSalesforceOutput, tSalesforceOutputBulkExec and etc.
- Performed exception handling using components like tDie, tLogCatcher, tStatCatcher and etc.
- Involved in UAT Testing & QA testing at the DEV & QA Environment.
- Worked with JIRA for tracking daily development active status.
- Worked with BitBucket for Creating branches for Pull and Push the branches.
- Worked with SourceTree for Check-In the changes made to the development.
- Worked with Jenkins to Build the job for updated parameters.
- Worked with UNIX for Data Load in different environments using shell script file.
- Worked with Salesforce for performing the Unit Testing.
- Used Talend Management Console-TMC to Deploy the job to QA and Prod Environments.
- Used Talend Management Console to schedule ETL Jobs on daily, weekly, monthly as per business requirements.
- Performance tuning – Data processed batch-wise and used the tMap cache properties and Parallelize components for better performance in case of huge source data. Tuning the SQL source queries to restrict unwanted data in the ETL process.
- Error Handling - Using tLogCatcher component, capturing every error and resolving it, performed exception handling using components like tDie, tLogCatcher, tstatcatcher and etc.
- Publicis Sapient is an American digital consulting company, founded as Sapient in Cambridge, Massachusetts in 1990. Sapient became a fully owned division of French advertising giant Publicis Groupe.
- Technical Environment: Talend Cloud, Talend Management Console – TMC, Microsoft SQL Server, SOQL, Salesforce, SourceTree, BitBucket, Jenkins, MTPuTTY, JIRA Tool, UNIX and DWH.
Associate ETL Developer - Talend
Jocata Financial Advisory & Technology
05.2021 - 05.2022
- Developed ETL jobs using Talend Cloud Data Management Tool 7.3.1 and SQL scripts (DDL & DML) for multiple environments, supporting data integration across Singapore, Indonesia, Vietnam, and Thailand.
- Using multiple components including tMap, tJoin, tJava, tJavaRow, tJavaFlex, tFlowtoIterate, tAggregateRow, tUniqRow, Created Joblets (re-usable components), creating contexts, global variables & tContextLoad etc…
- Configured Talend Management Console to automate ETL job scheduling, enhancing operational efficiency through daily, weekly, and monthly intervals.
- Used Talend Management Console to Deploy the job to QA and Prod Environments.
- Performed exception handling using components like tDie, tLogCatcher, tStatCatcher and etc...
- Conducted UAT testing and quality assurance testing in the DEV and QA environment.
- Prepared low-level design documentation (mapping sheet) to implement new data elements, ensuring alignment with user requirements.
- Understanding the product and the user requirements and system specifications. Involved in requirement analysis and Design and development from scratch.
- Developed structured tables in MySQL to meet client specifications.
- Performance tuning – Data processed batch-wise and used the tMap cache properties and Parallelize components for better performance in case of huge source data. Tuning the SQL source queries to restrict unwanted data in the ETL process.
Education
Post-Graduate Certificate -
Kakatiya University
08-2019
Skills
- Talend Data Integration
- Talend for Bigdata
- Talend Data Fabric
- DWH – Data Warehouse
- Snowflake
- Redshift
- Postgres
- RDBMS
- SAP BODS
- Talend Admin Console - TAC
- Talend Management Console – TMC
Foreign Language Skills - English
Proficient
Timeline
Specialist - Data Engineering
LTI Mindtree
10.2023 - Current
System Integration Senior Specialist - Talend
NTT Data
01.2023 - 10.2023
Associate ETL Developer - Talend
Publicis Sapient
05.2022 - 01.2023
Associate ETL Developer - Talend
Jocata Financial Advisory & Technology
05.2021 - 05.2022
Post-Graduate Certificate -
Kakatiya University