ETL Developer with EDW jobs in United States
cer-icon
Apply on Employer Site
company-logo

Infosys · 1 day ago

ETL Developer with EDW

Infosys is a global leader in next-generation digital services and consulting. They are seeking a highly experienced Technology Lead with expertise in Data Warehouse, Data Migration, and Business Intelligence to drive effective solutions and manage ETL processes.

ConsultingInformation ServicesInformation TechnologyIT ManagementSoftware
badNo H1Bnote

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

Qualification

Data warehousingData MigrationBusiness IntelligenceOracle PL/SQLPythonSnowflakeAWSETL processesData AnalysisAnalytical skillsSDLCProblem-solvingCommunication skillsTeam leadership

Required

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

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

Company

Infosys is a technology company that offers consulting, outsourcing, cloud infrastructure, program management, and software services.

Funding

Current Stage
Public Company
Total Funding
$200M
Key Investors
ChrysCapital
2012-12-12IPO
2008-07-10Post Ipo Equity· $200M

Leadership Team

leader-logo
Salil Parekh
Chief Executive Officer and Managing Director
linkedin
leader-logo
Anant Adya
Executive Vice President
linkedin
Company data provided by crunchbase