ETL Developer with Python

Infosys•Saint Louis, MO

About The Position

Infosys is seeking a highly experienced Technology Lead with expertise in AWS, Python, ETL, Performance engineering, automation and archestration. The ideal candidate will have a strong background in Python, data warehousing, migration, ETL, Numphy, Pandas, etc. 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 Information Technology experience The candidate must be located within commuting distance of St Louis, MO or willing to relocate to the area. This position may require travel to project locations. 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 Minimum of 4 years of experience in Information Technology and ETL development. Familiarity with Restful APIs, Python requests, and HTTP modules. Proficient with packages Pandas, Numphy and other DB related packages Proficiency in SQL and experience with databases like Oracle DB and MongoDB. 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. 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. Strong skills in data cleaning, transformation, and manipulation. 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 Information Technology experience
The candidate must be located within commuting distance of St Louis, MO or willing to relocate to the area.
This position may require travel to project locations.
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
Minimum of 4 years of experience in Information Technology and ETL development.
Familiarity with Restful APIs, Python requests, and HTTP modules.
Proficient with packages Pandas, Numphy and other DB related packages
Proficiency in SQL and experience with databases like Oracle DB and MongoDB.
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.

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.
Strong skills in data cleaning, transformation, and manipulation.
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