ETL Architect

L&T Infotech Milwaukee , WI 53201

Posted 3 months ago

" You will be a critical member of the ETL development team. You will be required to develop and/or provide Information Management related solutions to clients.

This position requires a sound knowledge of and Data warehouse, database platforms, Data Integration technologies like ETL, Informatica, TalenD, SQL,/PSQL. Responsibilities Responsible for design and development of Source to target Mappings, mapplets, sessions workflows and schedule them for data ingestion and data pipelines. Responsible for loading Fact Tables and Dimension Tables and handling Slowly Changing Dimensions in project.

Responsible for database design process, logical design, physical design, star schema, snowflake schema etc. Design connections objects and be well versed with session and workflow properties. Proficient in Big data lake implementation Preferred Background 3-5 years of progressive experience with Data Warehouse and ETL tools like Informatica / TalenD Candidate should have experience in at least 2 full life cycle implementation and support of Data Lake / DW Solutions using Informatica Power Center or similar tools Excellent expertise in SQL, PLSQL (expert level knowledge in one Database) Expertise in Performance tuning of ETL/Informatica Jobs and Error Handling and restart procedure Bachelor's degree in computer science or computer engineering "

Nearest Major Market: Milwaukee

Job Segment: Architecture, Engineer, Database, Warehouse, Computer Science, Engineering, Technology, Manufacturing

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Cloud Transformation Architect With Focus On SAP On Azure MidWest Region


Posted 2 days ago

VIEW JOBS 1/22/2020 12:00:00 AM 2020-04-21T00:00 About the role: Do you love living in the cloud? So do we! Growing our Cloud business and presence in the market is a strategic priority for Avanade. We are expanding and strengthening our Azure solutioning capability within an SAP architecture. This role focuses on cloud foundations within an SAP environment. Building on Cloud and Azure within an SAP architecture, you will create sustainable concepts for our customers, implementing technological developments of the Cloud area in close coordination with the portfolio management. In the role, you will also support customers in building modern and powerful application systems through consulting, architecture and implementation of sophisticated software applications. You will apply knowledge of Azure and SAP to create and deploy innovative solutions to our clients. You will develop relationships with key stakeholders to help them achieve their business goals. Day to day you will: * Actively shape and implement innovative Cloud and Azure solutions with Microsoft technologies for our clients in SAP environments * Define the technological standards for SAP architecture and the Cloud and Azure environment. * Work throughout the entire project cycle - from the analysis of the requirements, through the compilation of the duties, design, implementation, testing and documentation * Undertake professional and technical reviews to ensure a convincing quality * Travel to client locations as needed About you: You are serious about cloud—and serious about enabling clients to take maximum advantage of cloud services and offerings. Clients see you as a trusted adviser with extensive knowledge of the Azure platform. Ideally, you are familiar with SAP and have had some experience or exposure to SAP Landscape Architecture. You have held previous roles in large-scale enterprise transformation programs and demonstrated experience in multi-vendor, multi-tower programs, including partnering with Microsoft. You are a good communicator. * Knowledge of Microsoft Azure (Data Lakes, PowerBI, API Management, RPA, Service Bus, Logic Apps, etc) * Developing, architecting and implementing Microsoft Azure Solutions, including Azure Active Directory, Network Setup, Azure Virtual Machines, Azure Storage and more. * Knowledge of SAP Architecture (ECC, Suite on HANA, S/4HANA, BW on HANA, BW/4HANA, etc) * Knowledge of Databases used with SAP (specifically, SQL Server, SAP Sybase ASE and SAP HANA) * Experience with agile procedures (e.g. SCRUM) * Good understanding of project financials, P&Ls, etc. considered beneficial * Skills in analyzing, designing and developing client-based and/or web-based software solutions * Solid written and spoken English skills. * Travel to client locations as needed You likely have a Bachelor's of Science or equivalent degree in computer science or related field, and at least 5 years of professional experience in the IT sector. You enjoy working with global and offshore teams in a fast-paced and ever-dynamic environment. Avanade® Is An Equal Opportunity Employer. Avanade prohibits discrimination and harassment against any employee or applicant for employment because of race, color, age, religion, sex, national origin, gender identity or expression, sexual orientation, disability, veteran, military or marital status, genetic information or any other protected status. Avanade Milwaukee WI

ETL Architect

L&T Infotech