Technical Lead

Tekskills; Bengaluru; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Tekskills in Bengaluru is hiring a Data Migration ETL specialist to understand migration requirements and Teamcenter data models. You will create data mappings and scripts for migration, perform unit tests, and execute rehearsals as part of the migration strategy.

The role requires deep SQL knowledge (MS SQL, Oracle PL/SQL), experience with data import/export, and the ability to guide developers and ensure coding standards. Strong communication skills are essential.

Qualifications

• In-depth understanding of Data Migration ETL methodologies.
• Ability to understand source DB systems, data models and business requirements.
• Proficient in extracting data from Teamcenter schema using SQL scripts.
• Strong knowledge of MS SQL and Oracle PL/SQL functions, procedures and queries.
• Experience in data import/export techniques and performance tuning.

Responsibilities

• Understand migration requirements and Teamcenter data model.
• Create data mappings and scripts for migration; perform unit tests.
• Execute rehearsals and implement the migration strategy.
• Guide developers on technical queries and coding standards.
• Communicate effectively with stakeholders and ensure quality.

Skills

Data Migration ETL

SQL

Teamcenter

Data Mapping

Scripting

Unit Testing

Performance Tuning

Leadership

Communication

Mentoring Developers

Tools

MS SQL

Oracle PL/SQL

Job description

Job Description:
1. Understand the Data Migration Requirements
2. Understand the Teamcenter Data model and solution
3. Create the data mapping
4.Create scripts for migration, Unit test
5. Understand the overall migration strategy and steps and execute the Rehearsals

Essential Skills:

Should have in-depth understanding of Data Migration ETL methodology.
Should be able to understand Source Database systems, Source data model, Business requirements for Data migration.
Should possess knowledge on extracting data from the team center schema using SQL script.
Should have good knowledge on MS SQL and Oracle PL/SQL functions, procedures, cursors, DML operations, collection, triggers, Index, Joins, CTE..Etc.
Should be able to write complex queries meeting the business requirement.
Should have very good knowledge on Data Import/Export techniques.
Should be able to tune the script respect to performance and should have deep knowledge on Query execution plan & optimization.
Should be able to guide the developers for any technical queries and practice coding standard.
Good verbal and written Communication skills.

Desirable Skills:
Worked with a Japanese customer for 1 PLM Data Migration (any PLM).
Basic knowledge of Japanese.
Experience in fast bulk loader utility- Knowledge on extracting data from Teamcenter database.
Basic Knowledge of Teamcenter PLM Data Model.
Knowledge of Database Performance Tuning Techniques.