ETL Developer Sn -  (Spring batch, Java, SQL, ETL)

TCS has always been in the spotlight for being adept in the next big technologies. What we can offer you is a space to explore varied technologies and quench your techie soul.

Role: ETL Developer

Experience: 3 -10 Yrs

Key Skills: ETL Developer Sn - (Spring batch, Java, SQL, ETL)

Location: Bangalore/Pune/ Kochi /Bhubaneswar

Must have Skills

1. 3+ years experience as ETL Tester, SQL & ETL Tools Knowledge
2. Validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.
3. Count check, Reconcile records with the source data, Data type check
4. Validate Transformation logic on raw data and identify any discrepancies
5. Record count check, before and after the transformation logic applied.
6. Data flow validation from the staging area to the intermediate tables, intermediate to target systems.
7. Validate all keys are getting populated correctly.
8. Ensure the key field data is not missing or Null, check aggregate values and calculated measures are loaded in the fact tables.
9. Check modeling views based on the target tables, CDC has been applied on the incremental load table, Data check in dimension table and history table check.
10. Check the BI reports based on the loaded fact and dimension table and as per the expected results.
11. Create, design, and execute the test plans and test cases.

Good to have (Knowledge)

1. Informatica or any other ETL tool
2. Understanding of AWS Services.

If you are interested in this exciting opportunity. Please share your updated resume on allanchi.chaturvedi@tcs.com along with the additional information mentioned below.

• Highest Qualification:
• University/Institute name:
• Current Organization
• Current Location:
• Preferred Location:
• Willing to relocate Bangalore/Pune/ Kochi /Bhubaneswar:
• Total Experience:
• Relevant Experience in ETL Developer Sn - (Spring batch, Java, SQL, ETL) :
• Current CTC:
• Expected CTC:
• Notice Period:
• Gap Duration:
• Gap Details:
• Attended interview with TCS in past(details):
• Please share your I begin portal EP id if already registered:

We are looking forward to hearing from you soon.