Informatica ETL Developer - Hybrid
Perform Data analysis, collect business requirements and identify business rules. Analyze, develop and support Data Integration, EDW and Data Management using Informatica, SQL, Oracle etc. platforms and tools. Collaborate with data modelling team to define data integration logic. Build and test new ETL programs to fulfill the service requests. Automate the ETL processes and pipelines using scripting and Schedulers. Participate in Unit Testing, assist QA team in Integration Testing, and support Business team for UAT. Participate in code deployment and coordinate with different infrastructure teams during go-live, post-production, and continued support of end product. Work closely work with DBAs to fix performance bottlenecks. Recent experience and clear responsibilities in an ETL / Extracts / Data Engineering developer capacity. 6 plus years of experience in data integration (ETL) with 5 or more in solution development using Informatica suite. 4 or more years of experience in RDBMS / Data Warehousing platforms on Oracle. Must be an expert in Linux shell scripting to introduce automation as part of solution delivery. Strong SQL knowledge and ability to write most complex queries. Conceptual understanding of logical and physical data modelling is a must, and a working experience is a plus. Ability to develop and maintain data integration/ETL specifications that states integration rules and mappings. Ability to use documentation tools such as MS Visio and MS PowerPoint to diagram integration data flows. Ability to communicate effectively with business and technical staff members. Certifications in ETL and Data Warehouse platforms. Domain experience in Healthcare. Data profiling and implementation of automated solutions for data quality checks. Bachelor's degree in Computer Engineering, Computer Science, Engineering, or related field of study
Recommended Jobs
Controls Project Manager
Controls Project Manager Controls Project Engineer Location: Stoughton, MA Position Overview The Controls Project Manager is responsible for designing, implementing, and maintain…
Payroll and HR assistant
: Experience the SYNERGY HomeCare difference, where we are united under one purpose, to bring wholehearted, life-energizing care to as many people as possible - on their own terms, in their own home…
Recruiting Assistant
✨ Now Hiring: Recruiting Assistant ✨ Location: Marlborough, MA Company: Guardian Angel Senior Services Are you an organized, people-focused individual who enjoys helping others succeed? Join…
Director, Corporate Counsel - Privacy / Transactions
Regeneron Pharmaceuticals is seeking a highly experienced transactions attorney for a pivotal role to serve as the liaison to the Regeneron Data Privacy Office. This position will act as a privacy ex…
Dental Assistant
About Us: At The Smilist, we aim to provide high quality dental care in a warm, welcoming, and professional environment. Our team is dedicated to making lives better one smile at a time. We are cu…
Seasonal Trail Maintenance and Stewardship Assistant
Organization Overview The Nantucket Conservation Foundation (NCF) owns, protects, and stewards over 9,000 acres of land and coastal shoreline on Nantucket Island, MA, conserves the island’s rare a…
Correction Officer
The Middlesex Sheriff’s Office (MSO) is seeking qualified professionals to work as a Correction Officers at the Middlesex Jail and House of Correction in Billerica, MA. This is a full-time, non-e…
Junior DevOps Engineer
About SimpliSafe We’re a high-tech home security company that’s passionate about protecting the life you’ve built and our mission of keeping Every Home Secure. And we’ve created a culture here that…
Travel Speech Language Pathologist Job
Step into a pivotal role as a Speech Language Pathologist in the beautiful Berkshire region of Massachusetts, where your expertise will unlock communication, empower independence, and transform lives …
RESEARCH STUDY ASSISTANT, School of Medicine, Framingham Heart Study
The primary purpose of the position is to ensure the Framingham Heart program. Study Endpoint Review process is conducted following standard protocols to assure the integrity of the Framingham Heart …