ETL Developer with EDW

gration sponsorship for this role at this time.**

• Strong knowledge of Data warehouse, Data Migration and Business Intelligence.

• Expertise in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

• Strong problem-solving skills and the ability to evaluate and advocate for effective solutions.

• Exp required - Python, Pl/SQL, Snowflake, AWS

Preferred Qualifications:

• Experience with other data warehousing and ETL tools.

• Excellent communication and team leadership skills.

• Proactive and innovative mindset with a focus on continuous improvement.

• Strong communication and Analytical skills.
  Ability to drive technical meetings and represent Infosys at client side.

• Ability to work in a team with diverse / multiple stakeholder environment.

• Experience and desire to work in a Global delivery environment.

Key Responsibilities:

• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

• Experience on ETL tool Informatica Power Center on OLAP and OLTP environment.

• Knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL and PL SQL.

• Knowledge in data modeling for OLTP relational databases and Data Warehouse applications using Ralph Kimball and Bill Inman design principles including facts and dimensions tables, Slowly Changing Dimensions (SCD), Change Data Capture (CDC) and Dimensional Modeling - Star and Snowflake Schema.

• Highly interacted with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts. Deal with Type1/Type2/Type3 loads.

• Expertise in creating databases, users, tables, views, functions, Stored Procedures, joins, indexes and Packages.

• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and Denormalization Concepts.

• Experience with software development life cycle (SDLC), Waterfall and Agile Project Management Methodologies.

• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, and constraints

The job entails sitting as well as working at a computer for extended periods of time, and should be able to communicate by telephone, email or face-to-face. Travel may be required as per the job requirements.