Atria Group LLC Logo

Atria Group LLC

Sr. Informatica ETL Consultant

Posted Yesterday
Be an Early Applicant
In-Office
Canton, MA
Senior level
In-Office
Canton, MA
Senior level
Senior Informatica ETL consultant responsible for designing and developing ETL pipelines, data modeling (Kimball), Oracle performance tuning, and using Erwin. Tasks include ETL tuning, implementing Lookup/Joiner/Hash and other transformations, SQL join types, explain plans, function-based indexes, shell scripting, and applying performance hints. Strong communication skills required. Contract role (~2+ months).
The summary above was generated by AI
Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

We are having position for Sr. Informatica ETL consultant. Candidate Should have strong working experience with Informatica, ETL, Data Modeling, Oracle, Performance Tuning, Shell Scripting, Kimbel Methodology and Erwin.

*Name at least 6 Transformations

*ETL tuning

* Lookup Transformation / Joiner

*Explain Plans

*Join Types - SQL

*Function Based Index

*Hash function in Informatica

*Hints

Additional Information

  1. Good comm skills are a big priority.
  2. Duration: 2+++ Months++ Contract. 

Similar Jobs

4 Minutes Ago
Remote or Hybrid
Boston, MA, USA
151K-236K Annually
Senior level
151K-236K Annually
Senior level
Artificial Intelligence • Big Data • Cloud • Information Technology • Machine Learning • Software
Lead global Total Rewards and HRIS transformation: own compensation framework and annual cycles, drive Workday Advanced Compensation design and data governance, manage HRIS team, build people analytics, and lead AI/automation adoption across HR operations to improve efficiency and compliance.
Top Skills: Ai (Conversational Assistants)Document IntelligencePeople AnalyticsWorkdayWorkday Advanced CompensationWorkday Hcm
8 Minutes Ago
Remote or Hybrid
US
156K-195K Annually
Senior level
156K-195K Annually
Senior level
Big Data • Fintech • Information Technology • Insurance • Software
Lead and grow a backend engineering team building communications infrastructure: document generation, PDF templating, and multi-channel notifications (email, SMS, mail). Own architecture, integrations with providers (SendGrid, Twilio, Lob), delivery reliability, observability, compliance/audit trails, and template onboarding. Act as player/coach contributing ~20% coding while driving roadmap, operations, and cross-functional collaboration.
Top Skills: Ansi SqlAsync MessagingDockerGenai Developer ToolsGoGoogle Cloud PlatformGrpcKubernetesLobMicroservicesOpenapiPdf RenderingPostgresProtocol BuffersRestSendgridSwaggerTwilio
21 Minutes Ago
Remote or Hybrid
United States
123K-204K Annually
Senior level
123K-204K Annually
Senior level
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Lead GTM strategy and execution for a defined portfolio: set positioning and messaging, coordinate cross-functional teams, build GTM infrastructure and competitive intelligence, enable sales with tools and training, measure impact against revenue goals, and partner with senior leadership to drive commercial outcomes and market presence.

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account