Roles and Responsibilities
JOB DESCRIPTION:
Skills : ETL + SSIS + SSRS+ SQL
Designation: Senior Software Engineer
No. of Positions: 3
Total yrs.of experience: 4+ years
Mandatory Skills: ETL with SSIS , SQL , ETL Performance Tuning, Data Modelling,
Datawarehouse Concepts
Employment Type: C2H OR Permanent (Any)
Salary : Based on Exp & Current CTC (Max 10 LPA)
Interview Process: L1 & L2
Work Criteria:
- For Contract - WFH but resource should be flexible to visit office maybe once in a month Or 2 months depending on project requirement
- For Perm Role – Need from Mumbai Or Kolkata (Hybrid Mode BUT Mandatory to visit office once in a week)
Note: Need Immediate Joiners Or within 15 Days
Client : LearningMate (https://learningmate.com)
Qualifications:
- BE/ BCS or Equivalent CSE/ IT
- Highly motivated with excellent verbal and written communication, presentation, facilitation, negotiation and problem-solving skills
- Self-starter with strong organizational and time management skills, self-directed
Job Responsibilities:
- Must have 4+ years of very strong experience in ETL- SSIS (SQL Server Integration Services), T-SQL, Stored Procedures, Database Views and Functions.
- Excellent ETL Development skills using SSIS
- Excellent SQL/T-SQL and PL-SQL Development skills
- Experience working with MS SQL Server and Oracle Databases
- Experience with Database and ETL Performance Tuning
- Experience in Data Modelling
- Strong understanding of Datawarehouse Concepts
- Designing the workflow/framework of the ETL processes.
- Data Cleansing, Data Scrubbing and Data Integration to SQL Databases for Initial and Incremental Loads.
- Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
- Design Dimension and Fact ETL for daily updates of records in OLAP Systems.
- Work on identifying performance bottlenecks and optimization of code.
- Translate requirements from the business and transform the same into technical code.
- Design stable, reliable and effective databases
- Optimize and maintain legacy systems
- Modify databases according to requests and perform tests
- Solve database usage issues and malfunctions
- Liaise with developers to improve applications and establish best practices
- Gather user requirements and identify new features
- Develop technical and training manuals
- Provide data management support to users
- Ensure all database programs meet company and performance requirements
- Research and suggest new database products, services and protocols
Requirements:
- Proven work experience as a Database developer
- In-depth understanding of data management (e.g., permissions, recovery, security and monitoring)
- Knowledge of software development and user interface web applications
- Hands on experience with SQL
- Familiarity working with .Net Framework, JavaScript, HTML and Oracle
- Excellent analytical and organization skills
- An ability to understand front-end users requirements and a problem-solving attitude
- Excellent verbal and written communication skills
If you are available & interested then send your updated resume immediately in word format along with below details:
# Full Name (As per passport) :
# Contact No:
# Email Address:
# Education:
# Total Years of Exp.in ETL using SSIS:
# Years of Exp. in SQL/T-SQL:
# Years of Exp. in ETL Performance Tuning:
# Years of Exp. in Stored Procedures:
# Years of Exp. in Data Modelling:
#Years of Exp. in Datawarehouse Concepts:
# Are You Working currently: YES/NO
# IF Yes Name of the company:
# Residing at :
# Are U looking out for Permanent Role Or C2H:
# Preferred Work Location: Mumbai Or Kolkata
# Current CTC :
# Notice Period :
# Are you Serving Notice Period: YES/NO
# If YES then what is your LWD:
# Reason for looking a new job:
# Start Date if gets selected:
Perks and Benefits
Salary : Based on Exp & Current CTC