• SSIS Developer

Industry : IT
Location : Gurgaon
Open

Functional: IT Software-Other
Job Description
About Us :
Spectrum Talent Management is a comprehensive HR services company offering solutions spanning the entire talent life cycle including Recruitment, Onboarding, Payroll and Flexible Staffing. Founded in 2008, we are a continuously growing, yet mature service firm specializing in recruitment and staffing requirements of global organizations. Our leadership and high acceptance in the market is evident by the phenomenal growth that we have demonstrated in just few years of our inception. From Permanent recruitment to Flexi staffing, Payroll management to RPO, the orbit of the value add that we provide our customers with has always evolved, and diversified from time to time. This has enabled us to become a preferred vendor with most of our clients.
About Company :
Our Client is a specialized global technology?services provider, led by Business and Technology Consulting.Our client?s?Digitaligence work?infuses technology with domain, data, design, and differentiated delivery to significantly enhance experience and efficiency, enabling our clients to differentiate and disrupt their business.
Roles and Responsibility :

?Efficient in developing and presenting database solutions to key

stakeholders and onsite partners

?Participate in the technical design, development, testing and user

documentation and processes

?Should be able to reverse engineer SQL/SSIS code units and re write in

efficient and optimized manner ( SQL Server, Stored Procedures)

?Very good experience in writing complex SQL queries, Stored Procedures,

User Define Functions, Views, indexes and views with performance tuned

?Builds ETL processes for cleansing, staging, migrating data from various

sources(Relational, Big data) to data warehouse

?Strong proficiency in MS SQL Server and prior experience in MS SQL

Server performance tuning like Query Optimization, Indexing Strategies

?Excellent understanding of indexes, locks, execution plans and file stats

?Experience in Data Modeling, Database design and well versed with SQL

Server best practices

?Experience with hybrid data environments that leverage both distributed and

relational database  technologies to support analytics services

?Good knowledge of Big Data querying tools, such as Pig, Hive, and Impala

Is this a must have requirements along with SSIS?

a.         Knowledge of various ETL techniques and frameworks, such as Flume

 

Recruiter Name : Anmol Shreya
Recruiter Number : 7756972053
Recruiter Email Id : anmol@spectrumtalentmanagement.com
A+| A| A-