Job Description :
Position Title : ETL Teradata Developer/ Informatica Admin
Location: Plano TX
Duration: Long-term Contract

Job Responsibilities:
1. ETL Teradata Developers (with Informatica Plano, TX

Must Have Skills: Teradata, Informatica, Unix
Desired Skills: Hive
Job Roles / Responsibilities:
1. Experience of 8-12 years in Data warehousing ETL development projects
2. Expertise working as a Teradata developer and strong skills in SQL queries, Teradata Macros, stored procedures
3. Knowledgeable about composing lengthy and intricate SQL queries & performance tuning
4. Expert in building views macros tables joins functions stored procedures in Teradata database
5. Very good knowledge of different indexes PI SI JI PPI Join Strategies Data Protection
6. Practical experience utilizing tools to query such as Teradata SQL Assistant
7. Extensive working experience in Teradata utilities viz TPUMP BTEQ FastExport FastLoad MultiLoad TPUMP
8. Skillful with monitoring performance analysis and SQL query tuning using EXPLAIN PLAN Collect Statistics Teradata Viewpoint
9. Very familiar with the Software Development Life Cycle SDLC Proficient in analyzing and translating business requirements to technical requirements and modeling the Logical and Physical Data Model
10. Practical experience in Informatica Powercenter and performance tuning of the Workflows & Mappings
11. Basic knowledge in Unix command and building scripts
12. Excellent communication and client handling skills and ready to work in offshore-onsite model

2. Informatica Admin- Plano, TX

1. Upgrade from one version to another version in DEV, QA and PROD( Both NA and DIH ) .
a. Server building
b. Required database installation like Db2, Oracle, Teradata etc. ,
c. NAS and Other filesystem mount
d. Required userid push( One of the time consuming task)
e. Scheduling tool installation
f. Informatica installation or upgrade
g. Co-ordination with Development team to test the already existing code in each environment after upgrade
2. Migration activities from one environment to another environment
3. User creation and approving the request on time
4. Connections creation , Connection password update
5. Updating the database related variable files like odbc file, tnsnames, etc. ,
6. OS patching and restart the server
7. Regular health checks by improving the server by creating the scripts like space cleanup, repository log purge, backup , etc. ,
8. Coordination with Informatica support team to understand any new product like DIH is introduced to the environment and getting license keys with complete KT from them and play around the product
9. Monitoring the operational insights in cloud by testing step by step
10. Updating the task plan to the Pepsico Managers

Team Lead X 135| VLink Inc. | Locations: USA, India, Indonesia
LinkedIn: https://www. linkedin. com/in/shaily-sharma-ba00a596/
GTalk: ITResume11
https://www. vlinkinfo. com/