Data Warehouse Specialist
Apply NowCompany: Tata Consultancy Services
Location: Dallas, TX 75217
Description:
Data Warehouse Specialist
Must-Have
1. Hand on experience on Informatica designs, builds, and maintains software applications that use the Informatica platform
2. Writing Store procedure, complex queries, error handling,
3. Debugging Stored Procedures, Triggers, Cursors and SQL coding
4. Strong T-SQL programming skills, including performance tuning. 5+ years DB Development w/Microsoft SQL Serverincluding stored procedures in T-SQL
5. Hand on experience job scheduler platforms such Control-M
6. Must be proficient in complex SQL, Unix Shell Scripting, performance tuning and troubleshooting.
7. Experience in Data Migration from any On-prem RDBMS system to Snowflake/AWS Cloud Datawarehouse.
8. hands-on expertise in Data Modeling, Store procedure reverse engineering, Informatica Map analysis
9. Should have very good written and verbal communication skills.
Salary Range- $100,000-$120,000 a year
#LI-CO1
#LI-SN1
Must-Have
1. Hand on experience on Informatica designs, builds, and maintains software applications that use the Informatica platform
2. Writing Store procedure, complex queries, error handling,
3. Debugging Stored Procedures, Triggers, Cursors and SQL coding
4. Strong T-SQL programming skills, including performance tuning. 5+ years DB Development w/Microsoft SQL Serverincluding stored procedures in T-SQL
5. Hand on experience job scheduler platforms such Control-M
6. Must be proficient in complex SQL, Unix Shell Scripting, performance tuning and troubleshooting.
7. Experience in Data Migration from any On-prem RDBMS system to Snowflake/AWS Cloud Datawarehouse.
8. hands-on expertise in Data Modeling, Store procedure reverse engineering, Informatica Map analysis
9. Should have very good written and verbal communication skills.
Salary Range- $100,000-$120,000 a year
#LI-CO1
#LI-SN1