ETL-Talend Developer, ETL-Talend Developer

* Analyzed business requirements and developed corresponding technical solutions.
* Designed, developed, and executed test cases for unit and integration testing.
* Created Talend jobs for file transfers between servers, utilizing Talend FTP components.
* Developed end-to-end ETL processes, including data flow from various source systems to staging
areas and from staging to data marts.
* Responsible for writing SQL queries and using joins to access data from Redshift, Snowflake,
Hive, SQL Server, and Oracle.
* Created context variables and groups to manage Talend jobs across different environments.
* Configured the Repository Manager and created folders within Talend's repository
* Engaged in developing Talend mappings and fine-tuning them as needed
* Troubleshot and resolved issues with long-running jobs.
* Crafted Tmap expressions to meet business needs, managing insert and update strategies, and
applied ETL best practices.
* Extracted JSON data from APIs and loaded it into tables.
* Contributed to production and deployment activities, including creating deployment guides for
code migration.

* Efficiently extracted data from sources, transformed it, and loaded it into target systems.
* Designed, developed, and tested mappings using Talend.
* Developed and optimized Talend mappings as needed.
* Performed unit and system testing of mappings.
* Analyzed session error logs, utilized the debugger to test mappings, and resolved development bugs
while adhering to change procedures and validation processes
* Extensively used tMap components for joining data from different sources
* Managed data extraction, transformation, and loading from Oracle and flat files into the data
warehouse.
* Implemented Slowly Changing Dimensions (SCD) Type 1 and Type 2 mappings effectively.
* Configured the Repository Manager and created folders within Talend's repository.
* Provided support for testing and production issues.
* Utilized various methods and functions in tMap for implementing transformation logic.
* Participated in stand-up meetings, weekly status calls, and daily defect review sessions.

* Analyzed and understood source and target data models.
* Managed the execution flow for the entire workflow.
* Created mapping documents based on business rules.
* Prepared design documents, use case documents, and test case documents.
* Developed unit test plans, executed unit tests, and created checklists.
* Participated in business requirement analysis and understood functional specifications.
* Created metadata for Oracle and files for ETL jobs in Talend.
* Developed various Talend jobs to implement business logic.
* Worked with data from different sources, including Oracle and flat files.
* Developed scripts for database objects, including tables, procedures, and indexes.
* Created users and roles, and assigned appropriate permissions as part of security
implementation.
* Participated in patch meetings with clients, client coordinators, testing teams, and business
analysts.
* Collaborated with the team on analysis, design, and development of databases, including
normalization and relational database concepts.
* Prepared release notes documents outlining the deployment process.
* Contributed to the project by developing new stored procedures and modifying existing
procedures and functions based on requirements.