ETL Developer with EDW

Infosys•Saint Louis, MO

About The Position

Infosys is seeking a highly experienced Technology Lead with expertise in the field of Data warehouse, Data Migration and Business Intelligence. The ideal candidate will have a strong background in data warehousing, migration, business intelligence, Oracle PL/SQL. Basic Qualifications: Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education. At least 4 years of experience in Information Technology Candidate must be located within commuting distance of St Louis, MO or willing to relocate to this area. This position may require travel in the US. Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply. Infosys is unable to provide immigration 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. Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem. Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.

Requirements

Bachelor’s degree or foreign equivalent required from an accredited institution.
Will also consider three years of progressive experience in the specialty in lieu of every year of education.
At least 4 years of experience in Information Technology
Candidate must be located within commuting distance of St Louis, MO or willing to relocate to this area.
This position may require travel in the US.
Candidates authorized to work for any employer in the United States without employer-based visa sponsorship are welcome to apply.
Infosys is unable to provide immigration 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

Nice To Haves

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.

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