Data Science

For A Client Of Teamlease Digital

location 0 Year location 2,00,000 - 20,00,000 Per Year location Hyderabad
Apply
Posted: 23 Days ago

Job Description

Involved in all phases of SDLC (Software development life cycle).

• Experience in writing T-SQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views,

indexes, complex stored procedures, functions (UDF), cursors and triggers, BCP, common table expressions (CTEs).

• Extensive knowledge of Normalization and relational Database management systems.

• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and

maintain stored procedures triggers, and user-defined functions.

• Experience in Performance Tuning and Query optimization.

• Expertise in Distributed and MPP database systems like Greenplum.

• Excellent experience in designing, developing, documenting, and testing ETL jobs and mappings in server and parallel

jobs using DataStage to populate tables in data warehouses and data marts.

• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanisms.

• Experience in designing parallel jobs using various stages like join, merge, lookup, remove duplicates, filter, dataset,

lookup file set, complex flat file, modify, and aggregator.

• Experience in designing server jobs using various stages like sequential file, ODBC, aggregator, transformer, and sort.

• Ability to analyze, diagnose and resolve complex programming independently.

• Highly focused on delivering releases, meeting deadlines with quality development applying policies procedures and

standards relating to the ETL process development.

• Have hands-on experience in Automic job schedulers.

• Have good knowledge of Power BI.

• Developed IICS workflows to extract, transform, and load data from various sources (SQL databases, and flat files) into

Snowflake.

• Optimized query performance and data storage using partitioning, clustering, and materialized views in Snowflake.

• Developed and maintained ETL/ELT pipelines using SQL and Informatica IICS to load and transform data in Snowflake.

Job Details

Role Data Analytics

Industry Type

Employment Type Contract

Education
LLM, B.Arch, Certificate Course (ITI), Diploma, M Phil / Phd, B.Com, B.Pharm, BA, M.Arch, M.Com, M.Pham, MA, BBA/BBM, BCA, BDS, BE/B.Tech, MBA/PGDM, BEd, BHM, BSc, MCA, MD, MDS, ME/M.Tech, BVSc, CA, CS, ICWA, LLB, MBBS, MEd, MHM, MS, MSc, MSW, PG Diploma, 10th Pass (SSC), 12th Pass (HSE), No Education/Schooling, Upto 9th Std, Vocational Training, B.Design, B.FashionTech, BFA, BAMS, BHMS, MVSc, B.P.Ed, MPEd, B.F.Sc(Fisheries), M.F.Sc(Fisheries), BSW, BJMC, BTM, MTM, PR/Advertising
Job Id
1760298
State
Telangana
Country
India

About Company

TeamLease Services established in 2002, is one of India's leading human resource service companies in the organized segment. A Fortune 500 company listed on both NSE & BSE markets, with eight offices and 1400 clients across the country. The company at present has about 100,000+ live associates/ trainees spread across the country and have till date given employment to 1.5+ million people with an aim to hire millions more.

2 Similar Jobs

Senior Business Analyst

For a Client of Teamlease Digital

before save

location 0 Year location 8,00,000-28,00,000 Yearly

location Hyderabad...

Posted: 11 Days ago View & Apply

Data Engineer

For a Client of Teamlease Digital

before save

location 3 to 10 Years location 50,000-5,00,000 Monthly

location Hyderabad...

Posted: 1 Month ago View & Apply

left arrow right arrow

Jobs By Cities


View all

View Less