Senior Talend Data Integration & Snowflake Architect

.

.

Upender Babu Sarala

Phone +1-470-***-****

E-mail ***********@*****.***

www.linkedin.com/in/upender-sarala-929b61143/

14+ years of experience in full life cycle of software product development in various areas like design, applications development of Enterprise Data Warehouse on large scale development efforts leveraging industry standard using Talend.

10+ years of experience using Talend Data Integration/Big Data Integration (5.x, 6.x, 7.x). Extensive knowledge of business process and functioning of Health Care, Manufacturing, Financial, Retail and Insurance Sectors.

Extensive experience in ETL Methodology for performing Data Profiling, Data Migration, Extraction, Transformation, Loading using Talend and designed data conversions from wide variety of source systems including Netezza, Oracle, DB2, SQL Server, Teradata, Hive and non-relational sources like flat files, XML files, and Mainframe file.

Expertise in creating mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tConvertType, tflowtoiterate, tAggregate, tSortRow, tFlowMeter, tLogCatcher, tRowGenerator, tNormalize, tDenormalize, tHashInput, tHashOutput, tJava, tJavarow, tJavaflex, tAggregateRow, tWarn, tFilter, tDie, etc.

Deep understanding and experience with integrating Snowflake with various cloud platforms (AWS S3, Azure Blob Storage, Google Cloud Storage) for data ingestion and external staging. Knowledge of cloud-native services that complement Talend and Snowflake (e.g., AWS Glue, Azure Data Factory, GCP Dataflow)

Contribute to the overall data strategy and roadmap, identifying opportunities for leveraging Talend and Snowflake to drive business value.

Drive innovation by exploring and implementing new features of Talend and Snowflake, as well as emerging data technologies

Expertise in Data Modeling techniques like Data Modelling -Dimensional /Star Schema and Snowflake modeling, Slowly Changing Dimensions (SCD Type1, Type2, and Type3) Well versed with Talend Big Data, Hadoop, Hive and used Talend Big Data Components like tHDFSInput, tHDFSOutput, tPigload, tPigfilterRow, tPigFilterColumn, tHiveLoad, tHiveInput, tHiveOutput, tHBaseInput, tHBaseOutput etc.

Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing in a corporate wide ETL solution using Talend and other tools.

Created mappings using lookup, Aggregator, Joiner, Expression, Filter, Router, Update Strategy and Normalizer Transformations. Developed reusable transformations and mapplets. Strong Experience with Shell scripting, understanding approaches for business intelligence and data warehouse.

Self-starter and Team Player with excellent communication, organizational and interpersonal skills with the ability to grasp things quickly.

.

.

Technical skills:

• Cloud Systems: Azure, AWS, GCP, Snowflake, Azure Data Factory, Azure DevOps, Data Catalog, Azure Data Lake, Azure Analysis Services.

• Databases: MS SQL Server (2019/2017/2016/2014/2012/2008R2/2008/2005/2000), PostgreSQL 13/10/9, Oracle (12c/11g/10g/9i/8i), NoSQL (MongoDB 3.4/3.2), Windows Azure Cloud, AWS Cloud. IBM DB2 9.5/9.1, My SQL

• Database Tools: SQL Data Tools, SQL Server Management Studio (SSMS), SQL Server Configuration Manager (SSCM),SQL Server Analysis Services (SSAS), Power BI, ApexSQL, MongoChef, SQL Server Migration Assistant (SSMA), DMA, DMS, Facets, Visual Studio, SQL Profiler.

• Software Application and ETL Tools: Talend Data Integration v5.x/ v6.x / v7.x/ v8.x, Talend Big Data v5.x/ v6.x / v7.x/ v8.x, Talend Administration Console, Microsoft Visual Studio, Oracle SQL Developer, Oracle Applications, HP Quality Center, Eclipse, MS Office, Microsoft SQL Server Management Studio. AWS Architecture for Cloud.

• Programming languages: C, C#, Java, PostgreSQL, Pl/SQL, Python, VB.NET.

• Applications: Microsoft Office (Excel, CSV) and Web Services. Skills

Data Warehousing

Excellent

Product Life Cycle Management

Excellent

Project Management

Excellent

ETL Talend

Excellent

Databases

Excellent

Work History

August 2025 – Consultant – Talend Developer

Current Compunnel Inc – Thomasville, GA

• Designing and building data pipelines and jobs using Talend Studio to extract data from various sources (databases, flat files, APIs, etc.), transform it according to business rules, and load it into target systems (data warehouses, data lakes, etc.)

• Collaborating with business analysts and data architects to understand data requirements and translate them into effective data integration solutions.

• Implementing data quality checks, validation, and cleansing routines to ensure data accuracy, consistency, and integrity.

• Optimizing ETL jobs for performance, including fine-tuning SQL queries, managing data volumes, and leveraging parallel processing.

• Creating and maintaining detailed documentation of ETL processes, data lineage, and technical architectures.

.

.

• Monitoring ETL processes and troubleshooting issues that arise, such as job failures or data inconsistencies.

• Working with other teams, such as data engineers, data scientists, and business intelligence analysts, to ensure data accessibility and support business objectives.

• Providing ongoing maintenance and support for existing ETL workflows, including bug fixes and enhancements.

• Specific Responsibilities and Skills in an AWS Workspace Environment as an AWS Workspace, responsibilities often expand to include knowledge and collaboration with AWS-specific services and practices.

• Utilizing the AWS Workspace as a secure, pre-configured development environment.

• Working within the constraints and configurations of the virtual desktop. Leveraging pre-installed software and tools.

• Using the Workspace for secure access to other AWS resources without a direct connection from a local machine.

• Integration with AWS Services in developing Talend jobs that seamlessly connect with and utilize various AWS services. This is a crucial aspect of the role.

• Amazon S3: Reading data from and writing data to S3 buckets for data lakes and temporary storage.

• Amazon Redshift: Loading transformed data into Redshift, a petabyte-scale data warehouse.

• AWS Glue: Working with Glue Data Catalog to manage metadata and connect to data sources.

• Amazon RDS: Connecting to various relational databases hosted on RDS.

• AWS Lambda: Potentially triggering or being triggered by Lambda functions for serverless data processing.

• Adhering to the security protocols enabled by the AWS Workspace, which is designed to prevent sensitive data and intellectual property from leaving the controlled environment.

• Using a version control system like Git (often hosted on AWS CodeCommit or other platforms) from within the AWS Workspace to manage and collaborate on Talend code.

• Deploying Talend jobs from the development Workspace to production environments. This often involves using the Talend Administration Center (TAC).

• Scheduling and monitoring jobs in production, which might involve using AWS services like AWS Lambda, AWS Step Functions, or Amazon Managed Workflows for Apache Airflow (MWAA).

• Performance Optimization for Cloud like tuning Talend jobs specifically for performance in the AWS cloud. Optimizing data transfer between AWS services. Leveraging AWS-specific components in Talend.

• Managing compute and memory resources on the Workspace and target AWS services to handle large datasets efficiently.

Technical Skills Used: AWS Workspace, Talend Bigdata Integration v7.x,/ v6.x/ v5.x, Talend Data Integration v8.x,/ v7.x,/ v6.x, /v5.x, Oracle, MySQL, Linux/UNIX

.

.

March 2025

– Aug 2025

Senior ETL Talend Developer

Comsense Technologies LLC – Alpharetta, GA

• Deep understanding and experience with integrating Snowflake with various cloud platforms (AWS S3, Azure Blob Storage, Google Cloud Storage) for data ingestion and external staging.

• Knowledge of cloud-native services that complement Talend and Snowflake (e.g., AWS Glue, Azure Data Factory, GCP Dataflow)

• Contribute to the overall data strategy and roadmap, identifying opportunities for leveraging Talend and Snowflake to drive business value.

• Design, develop, test, and deploy robust ETL/ELT jobs using Talend Studio to extract data from diverse source systems (databases, APIs, files, etc.), transform it according to business rules, and load it into Snowflake.

• Drive innovation by exploring and implementing new features of Talend as well as emerging data technologies.

• Understanding Business Needs and Data Requirements in a core function to work with stakeholders to understand their business questions and translate them into data requirements using Talend.

• Identifying relevant data sources (databases, APIs, flat files, etc.) and determining the best methods for collecting this data using Talend.

• Data Cleaning and Preprocessing involves identifying and handling missing values, outliers, inconsistencies, and errors to ensure data quality using Talend.

• Transforming raw data into a usable format for analysis. This might involve aggregating, joining, filtering, and creating new calculated fields using Talend.

• Investigating the data to uncover patterns, trends, and insights using statistical techniques and visualization.

• Developing and Maintaining Reports and Dashboards in creating clear and concise visualizations and reports to communicate findings to stakeholders.

• Performing Statistical Analysis and Hypothesis Testing in applying statistical methods to answer specific business questions and draw meaningful conclusions.

• Data Quality Monitoring and participating in efforts to ensure ongoing data accuracy and integrity and working closely with data engineers, business users, and other stakeholders.

• Building ETL Pipelines often the primary responsibility of Data Engineers, a Data Analyst by using Talend in designing and building basic ETL pipelines to extract data from different sources and configuring connectors, defining data transformations, and scheduling jobs in Talend Data integration and in TAC.

• Using Talend to create specific data marts or aggregated tables tailored for their analytical needs, making the data easier and faster to query.

• Leveraging Talend to automate repetitive data preparation tasks, freeing up more time for actual analysis and insight generation. Technical Skills Used: Talend Bigdata Integration v7.x,/ v6.x/ v5.x, Talend Data Integration v8.x,/ v7.x,/ v6.x, /v5.x, Netezza, Oracle, Sail fish, MySQL, Sql Workbench, FTP, Putty, Linux/UNIX.

.

.

April 2022 –

March 2025

Talend Developer

AlticeUSA (Telecommunication) -New York, NY

• Analyzed problematic areas to provide recommendations and solutions.

• Collaborated with teams to define, strategize, and implement marketing and web strategies.

• Proficiency in managing and optimizing Talend Data Integration environments including job design, routine maintenance, and troubleshooting

• Experience in TAC and TDC

• Proficiency in administering Linux servers, managing user accounts, system updates, monitoring performance and troubleshooting issues.

• Experience managing and maintaining Windows servers, applying updates/patches, handling Active Directory, resolving issues.

• Ability to manage and track SSL certificates, ensure they are up to date and handle any related issues or errors.

• Knowledge of scripting languages such as UNIX, Linux and ability to automate routine tasks and troubleshoot.

• Experience with managing and configuring cloud services like AWS, Azure, or Google Cloud

• Familiar with network architecture and principles, including routers, switches, and firewall configurations.

• Understanding of other database systems like MySQL, PostgreSQL, and principles of database management

• Work with department managers to implement new and improved processes and operations.

• Constructing components, subunits, or simple models or adapts standard equipment; may troubleshoot and correct malfunctions.

• Following specific layout and scientific diagrams to construct and package simple devices and subunits of equipment.

• Conducting various tests or experiments which may require minor modifications in test setups or procedures as well as subjective judgments in measurement, selecting, preparing, and operating standard test equipment and recording test data.

• Extracting and compiling a variety of engineering data from field notes, manuals, lab reports, etc., processing data, identifying errors or inconsistencies, selecting methods of data presentation.

• Assisting in design modification by compiling data related to design, specifications, and materials that are pertinent to specific items of equipment or component parts; developing information concerning previous operational failures and modifications and using judgment and initiative to recognize inconsistencies or gaps in data and seek sources to clarify information.

Technical Skills Used: Talend Bigdata Integration v7.x,/ v6.x/ v5.x, Talend Data Integration v8.x,/ v7.x,/ v6.x, /v5.x, Netezza, Oracle, Sail fish, MySQL, Sql Workbench, FTP, Putty, Linux/UNIX.

.

.

Sep 2021 -

Feb 2022

Talend Developer

Verizon (Telecommunication) –Dallas, TX

• Work closely with enterprise and application architects to align the data engineering team to the overall company SDLC standards, practices, and data access patterns.

• Worked with project managers, developers, quality assurance and customers to resolve technical issues.

• Design, develop, test, and deploy robust ETL/ELT jobs using Talend Studio to extract data from diverse source systems (databases, APIs, files, etc.), transform it according to business rules, and load it into Snowflake.

• Utilize various Talend components (e.g., tSnowflakeInput, tSnowflakeOutput, tMap, tFilterRow, tJoin) for efficient data manipulation and integration.

• Implement data quality checks and error handling mechanisms within Talend jobs to ensure data integrity.

• Trained and mentored junior developers and engineers, teaching skills in ETL and working to improve overall team performance.

• Lead and/or assist in designing and developing cloud-based data systems, tailoring solutions to meet business requirements.

• Develop comprehensive architecture solution roadmaps seamlessly integrating business processes and technologies.

• Design, develop and enforce standards for data storage, processing, and governance across all environments.

• Develop, document, and maintain overall view of data platform architecture, data acquisition, data quality, and data retention.

• Provide guidance in administration of ETL jobs including developing best practices

• Provide formal and informal training for data engineers, platform engineers and ETL developers.

• Maintain knowledge of emerging technologies and architectures.

• Worked with development teams to correct problems and run test scenarios.

• Provided technical support using knowledge of complex technology to solve problems and support new projects.

• Adjusted design parameters to incorporate new features.

• Managed development and database technological issues for assigned projects, increasing customer satisfaction ratings.

• Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.

• Updated old code bases to modern development standards, improving functionality.

• Review and debug code

• Perform validation and verification testing

• Collaborate with internal teams and vendors to fix and improve products

• Document development phases and monitor systems

• Ensure software is up-to-date with latest technologies Technical Skills Used: Talend Bigdata Integration v7.x,/ v6.x/ v5.x, Talend Data Integration v7.x,/ v6.x, /v5.x, Netezza, Oracle, MySQL, SQL Workbench, FTP.

.

.

Dec 2019 -

Aug 2021

Lead Programmer

CITI Bank – Dallas, TX

• Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.

• Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.

• Updated old code bases to modern development standards, improving functionality.

• Integrated third-party tools and components into applications.

• Developed clear specifications for project plans using customer requirements.

• Work closely with product owners to understand business needs and conceptualize solutions to meet the needs.

• Leading a team of engineers to define activities, sequence of events, and dependencies required to complete the project and communicate effectively to IT and business stakeholders

• Develop platform applications using Kafka, Java, Microservices, AWS technologies, Kubernetes, automated test cases, code coverage and deploy using automated CI/CD pipeline (CircleCI, Jenkins)

• Design the high-level architecture and collaborate with enterprise architects on design reviews and ensure it meets the required architecture and security standards.

• Support organizational changes regarding capability development, restructuring toward product-centric team models and transitioning to modern agile SDLC practices.

• Own key relationships both up and downstream of the platform teams to ensure delivery.

• Conducting system analysis and recommending changes in technical processes to improve software operations

• Recruiting and interviewing junior software engineers to grow the software engineering team

• Staying up to date with the software development industry and studying the latest trends and programming techniques

• Training junior software engineers to ensure they understand the organizational processes and technologies

• Collaborating in close partnership with cross-functional and management teams

• Sustaining a clear understanding of the company's software development policies and culture among employers

• Compiling, analyzing and summarizing information regarding development and service issues

• Taking ownership of developed applications and systems

• Engaging in product development and brainstorming with team members

• Developing and designing an existing portfolio of applications and services

Technical Skills Used: Talend Bigdata Integration v7.x, / v6.x/ v5.x, Talend Data Integration v7.x, / v6.x, /v5.x, Oracle, MySQL Workbench, FTP, Cloudera ETL tool, Power BI Dashboards.

.

.

Mar 2016 -

Nov 2019

Senior Consultant

Eneco (Dutch Integrated Energy)-London, UK

• Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.

• Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.

• Participate in code reviews and agile team ceremonies to help plan and execute work.

• Help identify and remove technical obstacles and assist in completing the team’s commitments on a sprint and quarterly basis.

• Considers all aspects of design and development, including but not limited to, usability, simplicity, reliability, uptime, performance, scalability, maintainability, and testing.

• Good technical communication and troubleshooting skills.

• Ability to implement new features without fully detailed technical specifications.

• Comfortable with developing new features from scratch.

• Self-directed team member, highly collaborative with team and comfortable working with product management, stakeholders, and other end users.

• Ability to develop high quality, testable and maintainable code with unit tests.

• Delivered unit-tested systems within customer-prescribed timeframes.

• Tested methodology with writing and execution of test plans, debugging and testing scripts and tools.

• Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.

• Adjusted design parameters to incorporate new features.

• Collaborated with fellow engineers to evaluate software and hardware interfaces.

• Worked with customers for needs analysis and to determine vendor costs. Technical Skills Used: Talend Data Integration v5.x, v6.x, Oracle, MySQL, SQL server.

Dec 2010 -

Mar 2016

Software Engineer

SellerCloud - Cranbury, NJ

• Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.

• Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.

• Updated old code bases to modern development standards, improving functionality.

• Develop high-quality software design and architecture

• Identify, prioritize, and execute tasks in the software development life cycle.

• Develop tools and applications by producing clean, efficient code

.

.

• Automate tasks through appropriate tools and scripting

• Review and debug code

• Perform validation and verification testing

• Develop the software architecture based on the requirements of the client or the company.

• Create required codes using the most effective tools, applications, and other resources and keep them confidential.

• Stay updated with the prevalent technologies and trends.

• Complete documentation of the developed software and run significant tests while adhering to the project's timelines.

• Collaborate with internal teams and vendors to fix and improve products

• Document development phases and monitor systems

• Ensure software is up-to-date with latest technologies

• Integrated third-party tools and components into applications.

• Collaborated with clients to define solution requirements.

• Analyzed proposed technical solutions based on customer requirements. Technical Skills Used: Talend Data Integration v5.x, v6.x, Oracle, MySQL, SQL server, FTP.

Education

Aug 2006 -

Jun 2010

Bachelor of Technology: Information Technology

Sri Venkateshwara College of Engineering and Technology–JNTU Hyderabad Interests

Cooking

Certifications

Oct 2019 Talend Data Integration v7 Certified Developer Jun 2020 Talend Big Data Integration

Contact this candidate