- Must have 6-8 years of experience in Design, Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica BDM & Power Centre
- Responsible for database schema design, integration testing and other projects that may be necessary to help the team achieve their goals.
- Work closely with Onshore and offshore Application Development Leads
- ETL Mappings, Mapplets, Workflows, Worklets using Informatica BDM
- Experience in SQL, PL/SQL, Oracle, Teradata, Hive
- Experience in the Data Warehousing using Data Extraction, Data Transformation and Data Loading.
- Good experience in Data Visualization Tool Tableau
- God understanding of Data Warehouse concepts, OLAP, Star Schema, Snowflake Schema, Extended Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Physical & Logical Data Modeling.
- Identify efficiencies and ways to improve design and development processes
- Develops, automates, and supports complex applications to extract, transform, and load data
- Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time
- Work in a fast-paced environment, under minimal supervision providing technical guidance to the team members