Job Description
Job - ETL Developer / Lead - Pune Bangalore Hyderabad
Np : Max 30 Days
ETL Developer :
Exp : 5 to 8 Years
Total Experience of 6-8 years for Sr Developer and 3-5 years of experience for Junior developer
Have experience in working on cloud platform. AWS exposure is always preferred
Building enterprise level SSIS packages that utilize package and project parameters.
Generating custom ETL scripts using SSIS
Designing and developing business intelligence solutions using SSIS and SSRS
Design, develop, test and document ETL/SSRS components
Translate business requirements into ETL designs and mapping specifications
Assist with the development of a new data warehouse
Perform SQL Server database administration tasks: SQL Server Installation and configuration, Backup and restore, taking care of database security requests, SQL code migration, Troubleshooting and monitoring of sql server database servers in dev/UAT/production environments
ETL Lead :
Exp : 8 to 12 Years
- Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.
Have experience in working on cloud platform. AWS exposure is always preferred
Identifies data sources, provides data flow diagrams and documents source to target mapping and process.
Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
Facilitate the development of data integration efforts by leading small teams of 2-3 junior developers in addition to hands on design and development of large complex ETL jobs.
Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
Establish methods and procedures for tracking data quality, completeness, redundancy and improvement
Interested Candidates Reach me on it**v@ev****r.com
Job Classification
Industry: IT-Software, Software Services
Functional Area: IT Software - Application Programming, Maintenance,
Role Category: Programming & Design
Role: Programming & Design
Employement Type: Full time
Education
Under Graduation: Any Graduate in Any Specialization
Post Graduation: Any Postgraduate in Any Specialization, Post Graduation Not Required
Doctorate: Any Doctorate in Any Specialization, Doctorate Not Required
Contact Details:
Company: Evoke HR Solutions Pvt. Ltd.
Address: 235,Second Floor,Patel Avenue,Nr. Gurudwara, S.G. , Highway,Bodakdev, , AHMEDABAD, Gujarat, India
Location(s): Pune
Keyskills:
Business Intelligence
Database Administration
ETL Developer
SSRS
Database Security
SQL Server
Data Warehousing
Business Development
SSIS
ETL
Restore