Janani L
Chennai
Summary
Senior consultant with 8+ years of experience in Talend ETL and data integration. Migrated complex data workflows to improve operational efficiency. Optimized data pipelines and strengthened team collaboration to support successful project delivery and client satisfaction.
Overview
1
1
Certification
9
9
years of professional experience
Work History
Senior Consultant 2
Ernst & Young GDS
11.2022 - Current
- Migrated SSIS data workflows to Talend, ensuring accuracy of business rules and transformation results.
- Built Talend jobs to process JSON from web services and update JDE systems in real time.
- Created Talend integration jobs to load records into Salesforce.
- Conducted unit tests, resolved issues, and facilitated deployment across development and production environments.
- Project: SSIS to Talend migration for US-based aluminum cans manufacturer.
- Technologies: Talend, SSIS, REST API, web services, Salesforce.
Data Analyst
Fractal Analytics
11.2021 - 11.2022
- Analyzed data to support decision-making for an Australian telecom company.
- Reviewed large Redshift datasets and shared clear insights with the client.
- Updated data models and queries to reflect changing business needs and client feedback.
- Enhanced reporting and decision-making by optimizing QuickSight dashboards based on user feedback and business requirements.
- Verified broadband speed results against customer plans to identify discrepancies and recommendations for refunds.
- Technologies used: Amazon Redshift, Amazon QuickSight.
Technology Analyst
Infosys
01.2018 - 11.2021
- Facilitated etl pipeline migrations from Pig scripts and DataStage to Talend across 20+ source systems, integrating AWS services and Snowflake.
- Reviewed and reproduced DataStage workflows in Talend without changing business logic, handling data transfers between web services, DB2, Oracle, flat files, and Snowflake.
- Built reusable Talend frameworks for web service data retrieval and added job automation with logging and error handling.
- Collaborated with a team of 4 on Talend development for multiple client applications using Bladebridge software, enhancing the efficiency of the DataStage to Talend migration.
- Developed SSIS pipelines for data staging and dimensional modeling, and created Power BI reports to ensure data accuracy and freshness.
- Conducted unit testing, debugged issues, and deployed applications in development and QA environments.
- Project Experience – Technology Analyst – (Infosys) - 2018 –2021
- Clients: US-based Financial Services Firm, Microsoft
- Technologies: Talend, Pig Scripts, AWS (S3, Glue, EC2, Athena), PySpark, HDFS, Shell Scripting, DataStage, Snowflake, DB2, Oracle, Web Services, SSIS, MS SQL, Power BI, Autosys.
Education
Bachelor of Civil Engineering -
R. M. K Engineering College
04-2018
Skills
- Talend ETL tools
- Talend development
- Data pipeline optimization
- Data integration
- REST API integration
- AWS services
- SQL querying
- Data migration
- Python programming
- Database management
- Automation tool: Autosys
- Version control: Bitbucket and GitHub
Certification
- Completed Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional
- Microsoft Azure Data Fundamentals
- Microsoft Azure Fundamentals
- Infosys Agile methodology certification
- Databricks Generative AI Fundamentals
- Databricks Fundamentals
- Building Batch Data Pipelines on GCP
Timeline
Senior Consultant 2
Ernst & Young GDS
11.2022 - Current
Data Analyst
Fractal Analytics
11.2021 - 11.2022
Technology Analyst
Infosys
01.2018 - 11.2021
Bachelor of Civil Engineering -
R. M. K Engineering College