Database ETL Developer
Visit us: https://www.etechtechnologysolutions.com/
WHAT WE OFFER:
- Transportation allowance
- Canteen Subsidy
- Night Shift allowance as per process
- Health Insurance
- Tuition Reimbursement
- Incentive components campaign wise
- Work-Life Balance Initiatives
- Rewards & Recognition
WHAT YOU’LL BE DOING
- Design and develop reports for addressing program recurring reporting needs by using SQL scripts/stored procedures with SQL Server Reporting Services (SSRS).
- Data profiling
- Dimensional model design
- Cube design and development using SSAS,
- Obtain and interpret information from large volume of reports.
- Analyze and interpret complex data and translate complex systems information between computer programmers/database administrators, program staff
- Write and administer ETL jobs to extract data from multiple datasources and load into datamarts.
- Integrate data for batch, near-real-time, and real-time latencies. Create complex data transformation logic.
WHAT WE EXPECT YOU TO HAVE:
- 3+ years of experience in Writing SQL queries and stored procedures for combining, analyzing and reporting data.
- Designing, developing and implementing SQL Server Reporting Services (SSRS) reports
- Having experience with MSSQL development
- Ability to Create Store Procedure
- Ability to create dynamic queries
- Ability to create functions
- Ability to Optimize Query
- Having experience in NoSQL like Mongodb
- Experience working with JSon and XML files in SQL
- Knowledge of ETL tools such as Talend is required
- Shift time: 5:30 PM to 2:30 AM