Role: Senior Data Engineer.

Experience Level: 4 to 7 Years.

Work location: Mumbai, Bangalore, Trivandrum (Hybrid).

Role & Responsibilities :

- Work with business users and other stakeholders to understand business processes.

- Ability to design and implement Dimensional and Fact tables.

- Identify and implement data transformation/cleansing requirements.

- Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse.

- Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions.

- Design, develop and maintain ETL workflows and mappings using the appropriate data load technique.

- Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.

- Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.

- Analyze and resolve problems and provides technical assistance as necessary.

- Partner with the BI team to evaluate, design, and develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.

- Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

- Leverage transactional information, and data from ERP, CRM, and HRIS applications to model, extract and transform into reporting & analytics.

- Define and document the use of BI through user experience/use cases, prototypes, tests, and deploy BI solutions.

- Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, and quality issues, and continuously validate reports, and dashboards and suggest improvements.

- Train business end-users, IT analysts, and developers.

Required Skills:

- Bachelors degree in Computer Science or similar field or equivalent work experience.

- 4+ years of experience with Informatica Power Center on Data Warehousing or Data Integration projects.

- Expert with data warehousing standards, strategies, and tools.

- Expert with SDLC processes.

- Experience in Informatica Power exchange for Mainframe, Salesforce, and other new-age data sources.

- Experience in Informatica Webservices, XML, Java Transformations, etc.

- Strong knowledge of relational databases.

- Strong SQL background.

- Strong experience in GCP & Google BigQuery.

- Strong problem-solving, multi-tasking, and organizational skills.

- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework, and data-warehousing.

- Knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) is a must.

- Knowledge of the AWS data lake is a plus.

- Highly proficient in working with large volumes of business data and strong understanding of database design and implementation.

- Good written and verbal communication skills.

- Demonstrated experience in leading a team spread across multiple locations.