Key Talent Solutions

We are looking for Data Engineer with at least 4+ years of development experience as Data Engineer. Location: Pune (On-Site) Job Description: • Responsible for design, development, implementation, testing, documentation, and support of analytical and data solutions/projects requiring data aggregation/data pipelines/ETL/ELT from multiple sources into an efficient reporting mechanism, database/data warehouse, using appropriate tools like Informatica, Azure Data Factory, SSIS. • This includes interacting with business to gather requirements, analysis, and creation of functional and technical specs, testing, training, escalation, and follow-up. • Support of the applications would include resolving issues reported by users. Issues could be caused by bugs in the application or user errors, or programming errors. • Resolution process will include, but not be limited to, investigating known bugs on the software vendor support website, creating tickets or service requests with the software vendor, developing scripts to fix data issues, making program changes, testing fixes, and applying the changes to production. • Development, maintenance, and enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge of star/snowflake schemas Developing complex SQL queries and SQL optimization • Development experience must be full Life Cycle experience including business requirements gathering, data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture. • Knowledge of data warehousing concepts, including multi-dimensional models and ETL logic for maintaining star-schemas • Good Understanding of concepts and principles of data modelling. • Ability to produce, maintain and update relevant data models for specific needs. • SQL programming desirable (i.e., stored procedures dev.) • Proficient in data analysis, defect identifications and resolutions. • Strong professional verbal and written communication skills.