• 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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Key Talent Solutions

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Data Engineer