Impressive Communications is an IT System Integrator that delivers results-driven solutions to businesses. We work closely with
customers to understand their digitalisation needs and help them achieve their business goals through effective requirement
gathering and project delivery strategies.
What You’ll Do
Responsibilities:
ETL process management
Data modeling
Data warehouse architecture
Data pipeline (ETL tools) development ETL testing
Requirement:
Strong experience in designing and developing ETL mappings, mapplets, workflows, sessions using Informatica PowerCenter
Experience in Informatica (ETL) or any other relevant tools required by the company (Designer, Repository Manager, Workflow Manager), Job Schedulers.
Experience working with Cloudera
Must have experience in building complex SQL queries.
Strong on DW Fundamentals, concepts. Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems.
Excellent understanding of various relational database design concepts.
Extensive experience in Data Modeling & Architecture.
Experience full lifecycle data warehouse development
Error handling and Performance Improvements.
Conduct and participate in design and code walkthroughs.
Good hands on capability can independently develop good quality deliverable and guide/mentor junior team members effectively.
Participate in requirements gathering sessions with stakeholders from business and IT teams.
Communicates effectively with business partners to identify needs and evaluate options.
Help BI reporting developers with analyzing data source, designing, testing and implementing analytic reports and dashboards.
