Job Seekers, Please send resumes to resumes@hireitpeople.com Must Have Skills: Strong experience in Data Warehousing and ETL Indepth understanding of fundamental DataWarehousing concepts such as Dimensional Modelling, Star and Snowflake Schemas, Data marts, Security and deployment, FACT and Dimensional tables, Logical and Physical data modelling. Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. Nice to have skills: Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Extensive experience in ETL design, development and maintenance using SQL Server SQL, PLSQL, SQL Loader

Detailed Job Description:

Extensively worked on data extraction, Transformation and loading data from various sources like SQL Server, KAFKA and Flat files. Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Centre

Minimum years of experience: 5

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute:

Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views Experience in database programming in PLSQL Stored Procedures, Triggers and Packages. Well versed in UNIX shell scripting.

Interview Process (Is face to face required?) Yes

Does this position require Visa independent candidates only? No