Data Engineer
Sutherland4 days ago
Hyderābād, IndiaMid Level
Responsibilities
- Design and implement data stores, ETL/ELT data flows, and data pipelines for business intelligence and analytics systems.
- Build and maintain data products using feeds from multiple systems and different storage technologies and access methods.
- Develop complex SQL queries, optimize SQL, and create or maintain stored procedures and other data solutions.
- Gather business requirements, perform data sourcing and reconciliation, and create functional and technical specifications.
- Design and maintain data models, including star and snowflake schemas and other multidimensional data warehouse models.
- Manage production deployments, automation, monitoring, job control, and production support.
- Investigate application and data issues, coordinate with software vendors, develop corrective scripts, test fixes, and apply changes to production.
- Identify and resolve data quality, integrity, and application defects while considering security, compliance, and data standards.
- Document data pipeline processes, mappings, architectures, and development work.
- Support testing across development and quality environments, user training, data literacy initiatives, and continuous improvement.
- Collaborate with business users, DBAs, data scientists, architects, and other IT teams to meet requirements.
Requirements
- Minimum of 4 years of experience as a Data Engineer.
- Experience developing, maintaining, and enhancing ETL/ELT data pipelines and processes.
- Thorough knowledge of star and snowflake schemas, data warehousing concepts, data modeling, and ETL logic.
- Experience with full lifecycle business intelligence or data warehousing development, including requirements gathering, data sourcing, testing, data reconciliation, and deployment.
- Experience developing complex SQL queries and performing SQL optimization; stored procedure development is desirable.
- Knowledge of data architecture, ETL and data engineering standards, and data pipeline design best practices.
- Ability to design, build, and test data products using data from multiple systems and varied storage technologies or access methods.
- Ability to reverse-engineer data models from live systems and maintain models for specific business needs.
- Proficiency in data analysis, defect identification, troubleshooting, and issue resolution.
- Strong professional verbal and written communication skills and the ability to work with limited supervision amid changing priorities.
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
Benefits
- Hybrid work model with in-office work on Monday, Wednesday, and Friday.
- Work location is Pune.
- Working hours are 2:00 PM IST to 11:00 PM IST.
Tech Stack
InformaticaSQL
Categories
Data Engineering
About Sutherland
Sutherland provides IT services and business process outsourcing that design, run, and automate customer experience and back-office operations for enterprises in healthcare, financial services, telecom, retail, and travel. Its offerings include managed contact-center platforms (e.g., Cisco UCCE/CUCM), cloud and analytics solutions, and process consulting delivered through global service centers. Founded in 1986 and headquartered in Pittsford (Rochester), NY, it is privately held.