Pratap Tutika pratap.tutika@gmail.
com
Mobile: +91 9160463146
--------------------------------------------------------------------------------------
Summary:
A motivated and detail-oriented Talend Developer with expertise in data integration and
ETL processes. Skilled in using Talend's suite of tools to design, develop, and deploy
data integration workflows. Proficient in writing SQL queries and working with
databases using PL/SQL and SQL. Familiar with Python for scripting and basic
automation tasks. Adept at collaborating with cross-functional teams to deliver data
solutions that improve business processes.
Technical Skills:
Talend:
o Proficient in using Talend Open Studio for Data Integration (DI) and Talend
Cloud for deploying solutions.
o Expertise in creating complex ETL workflows using Talend Studio, including
transformation, data cleansing, and loading.
o Knowledge of Talend components such as tMap, tJoin, tInput, tOutput,
tFileInputDelimited, tFileOutputDelimited, etc.
o Experience integrating with various data sources like databases, cloud storage,
and web services.
SQL & PL/SQL:
o Advanced SQL skills for writing queries, creating stored procedures, triggers, and
optimizing database performance.
o Strong knowledge of PL/SQL for writing complex database logic, managing
transaction control, and handling error management.
o Expertise in working with relational databases like Oracle, MySQL, and SQL
Server.
Python (Basics):
o Basic knowledge of Python for writing scripts to automate tasks, process data,
and interact with APIs.
o Experience with Python libraries like pandas, numpy for basic data
manipulation and processing tasks.
o Ability to integrate Python scripts with Talend workflows to enhance data
transformation and automation.
Version Control & Collaboration:
o Familiar with Git for version control and collaborating with teams on projects.
o Experience using Rally, Confluence, and other project management tools.
Pratap Tutika
Core Competencies:
ETL Development: Designing and implementing efficient ETL processes to extract,
transform, and load data from diverse sources.
Data Integration: Integrating data from on-premise and cloud-based data sources such
as SQL databases, NoSQL databases, APIs, and flat files.
Data Modeling: Experience with data modeling concepts and ensuring optimal data
structures for reporting and analysis.
Data Transformation: Performing complex transformations on data to meet business
requirements, including data mapping, enrichment, and validation.
Troubleshooting and Optimization: Identifying and resolving performance
bottlenecks in ETL processes, optimizing SQL queries, and Talend jobs for scalability.
Professional Experience:
Talend Developer| [Wissen Infotech] | [June 2024- Present]
Designed and implemented ETL processes using Talend Open Studio to migrate data
from legacy systems to AWS Platform.
Developed reusable Talend components to streamline data transformation and integration
tasks, reducing project timelines like ingestion checker jobs, extraction and ingestion
tasks.
Wrote SQL queries and PL/SQL scripts for data extraction, reporting, and optimization
of ETL workflows.
Integrated Talend with various data sources like Oracle, Microsoft SQL, and flat files,
ensuring accurate data loading and transformation.
Collaborated with data engineers, Database administrators and business analysts to
ensure data flows met the requirements and business logic.
Data Engineer| [Techmahindra] | [May 2023- May 2024]
Worked as PLSQL Developer for Sales dashboard Project to get right outcome for BI
Activities.
Created complex data base objects like Procedures, Functions and Views.
Requirement gathering, designing, development, testing and documentation.
Translated business requirements into technical requirements, delivering an application
code that is fully tested, meets the business requirements, and 100% compliance.
Executed and tested procedures huge data.
Directly worked with client to ensure fast and accurate deliverables.
Designing logical and physical process flow diagrams and related data processing
documentation.
Involved in continuous enhancements and fixing of production problems.
Prod deployment and providing production support as needed.
Pratap Tutika
ETL Developer | [Techmahindra] | [Apr 2021- Apr 2023]
Worked as Sr. Data Engineer responsible for Data Ingestion from Multiple sources to
Redshift.
As a part of this project, we are extracting the data from Green plum DB, Flat files,
multiple sources and Data Lake tables then loading them to AWS S3 and finally to AWS
Redshift. We are creating tables and views on top of the final table.
Based on the Incremental column to load the data into the final tables.
Created or updated existing jobs to accommodate changes at source level.
Responsible for managing metadata.
Involved in creating non prod and prod job layers and test the data for prod activities.
Handled many data migration issues like code compatibility, DDL, column length and
many other code-pattern conversion issues.
Participated in Daily stand up and update individual tasks in Rally.
Worked with GIT for code repository.
Make sure the quality standards are defined and met.
Working in sprint environment with Rally tool.
Data Engineer | [CadVision Engineers Pvt Ltd] | [Aug 2019- Mar 2021]
Created Data migration job designs for various item structures in Talend as per client
requirement.
Enhance existing job designs according to Input template/schema changes from data
preparation team.
Based on the Incremental column, loading the data into the final tables.
Created or updated existing jobs to accommodate changes at source level.
Created Metadata and worked on TAC.
Processing the Data files in Talend Open Studio using different components like tMap,
tReplicate, tFilterRow and tLogRow etc.,
Working experience with files .xlsx, .CSV, .SQL and .XML in Talend.
PLM Data Engineer | [Tata Consultancy Services] | [Jan 2015- Apr 2017]
Created Data migration job designs for various item structures in Talend as per client
requirement.
Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Normalizer and
De-Normalizer, Maps Transformations.
Experienced on processing the data files through Talend Open Studio.
Exception Handling in Talend tDie, tlogcatcher.
Created and Tested various Job Designs in Talend Open Studio.
Experience in working on Context Group, tContextLoad and tContextDump components.
Pratap Tutika
Design Engineer | [Tata Consultancy Services] | [Dec 2011- Apr 2014]
Legacy conversion of Drawings.
Get 2 D Drawings from client.
Preparation of 3D Models in Solidworks.
Also prepare Detail drawings for parts and assemblies.
Update GD&T as per client specification.
Have Exposure to PLM-Teamcenter.
Employment Summary:
Company Details
Area of Expertise: ETL, Talend, AWS-Redshift
Wissen Infotech Shoreline
Duration of Service: NA (Jun 2024 to Till Date)
Designation: Sr. software Engineer
Area of Expertise: Plsql, ETL, Talend, AWS
Techmahindra Duration of Service: 2.11 years (Apr 2021 - May 2024)
Designation: Sr. software Engineer
Area of Expertise: ETL-Talend, Data migration
CADVision Engineers Pvt Ltd. Duration of Service: 1 Year (Aug 2019 - Mar 2021)
Designation: Software Engineer
Area of Expertise: Design Engineer, Talend
TATA Consultancy Services Duration of Service: 5.4 years (Dec 2011 - Apr 2017)
Designation: Systems Engineer
Academic Background:
Degree, Year of Institute Details Major and Specialization
Passed
M.Tech, 2011 JNTU, Kakinada, AP Mechanical with CAD/CAM
B. Tech, 2009 Aditya Institute of Mechanical Engineering
Technology and
Management, Tekkali,
AP.
Intermediate, 2005 SVS Jr. College, Kotturu, AP. Maths, Physics and Chemistry
SSC, 2003 RBP School, A. P General
Key Traits:
Problem-solving mindset with a strong attention to detail.
Strong analytical and troubleshooting skills.
Effective communicator with the ability to collaborate in cross-functional teams.
Eager to learn new technologies and improve technical expertise.
Pratap Tutika
