Job Description

About TredenceTredence is a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in building Scalable Big Data Solutions on Onprem/GCP/Azure cloud in a very cost effective and easily scalable manner for our clients. We also come in with some strong IP and pre-built analytics solutions in data mining, BI and Big Data.Job SummarySkills and Qualifications:\xe2\x97\x8f Bachelor\'s and/or master\'s degree in computer science or equivalent experience.\xe2\x97\x8f Must have total 5+ yrs. of IT experience and 3+ years\' experience in SQL Server, SSIS, SQL, Python/C#, ETL, Streaming.\xe2\x97\x8f Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process\xe2\x97\x8f Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM\xe2\x97\x8f Builds data transformations with SSIS including importing data from files, moving data from one database platform to another\xe2\x97\x8f Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data\xe2\x97\x8f Design, implement and maintain database objects (tables, views, indexes, ) and database security\xe2\x97\x8f Experience working with SSIS packages\xe2\x97\x8f Proficient with ETL tools such as Microsoft SSIS\xe2\x97\x8f Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations\xe2\x97\x8f Test and prepare ETL processes for deployment to production and non-production environments\xe2\x97\x8f Support system and acceptance testing including the development or refinement of test plans\xe2\x97\x8f Azure cloud knowledgeJob LocationBangalore/Gurgaon/Chennai/Pune/KolkataRoles & Responsibilities\xe2\x97\x8f Bachelor\'s and/or master\'s degree in computer science or equivalent experience.\xe2\x97\x8f Must have total 5+ yrs. of IT experience and 3+ years\' experience in SQL Server, SSIS, SQL, Python/C#, ETL, Streaming.\xe2\x97\x8f Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process\xe2\x97\x8f Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM\xe2\x97\x8f Builds data transformations with SSIS including importing data from files, moving data from one database platform to another\xe2\x97\x8f Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data\xe2\x97\x8f Design, implement and maintain database objects (tables, views, indexes, ) and database security\xe2\x97\x8f Experience working with SSIS packages\xe2\x97\x8f Proficient with ETL tools such as Microsoft SSIS\xe2\x97\x8f Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations\xe2\x97\x8f Test and prepare ETL processes for deployment to production and non-production environments\xe2\x97\x8f Support system and acceptance testing including the development or refinement of test plans \xe2\x97\x8f Azure cloud knowledgeQualification & Experience\xe2\x97\x8f Bachelor\'s and/or master\'s degree in computer science or equivalent experience.\xe2\x97\x8f Must have total 5+ yrs. of IT experience and 3+ years\' experience in SQL Server, SSIS, SQL, Python/C#, ETL, Streaming.\xe2\x97\x8f Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process\xe2\x97\x8f Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM\xe2\x97\x8f Builds data transformations with SSIS including importing data from files, moving data from one database platform to anotherWhy Join Tredence?There is a reason we are one of the fastest growing private companies in the country! You will have the opportunity to work with some of the smartest and fun-loving people in the data analytics space. You will work with the latest technologies and interface directly with the key decision stakeholders at our clients, some of the largest and most innovative businesses in the world. Our people are our greatest asset and we value every one of them. Come see why we\'re so successful in one of the most competitive and fastest growing industries in the world.

Tredence