Sr.ETL Developer Job at Atria Group LLC, Albany, NY

S0ZqalFGZTdzOEpTQ21UbjM4bzlSUEFINFE9PQ==
  • Atria Group LLC
  • Albany, NY

Job 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 Job Purpose: Work in our fast-paced investments and risk technology team with minimal oversight over the investments data warehouse. Principal Responsibilities: Participate in all aspects of the system development life cycle with specific focus on the design, estimation, construction, and testing of both Service and ETL components. Take ownership of the full life cycle for the solution, from analysis and design through testing and delivery. Perform hands on development on medium to large data warehouses (15 to 25 Terabytes) using data modeling, dimensional data structures and complex hierarchies. Perform expert level ETL design, development, and performance tuning using Informatica PowerCenter & Java. Perform expert-level complex SQL coding/querying/tuning skills in SQL Server. Design and develop existing codebase and grasp the functionality, design, and refactoring opportunities of the code in Java. Design and develop solutions using service-oriented architecture. Use BI reporting tools to improve the team's implementation and development discipline. Qualifications 7 years- experience with Data Mart/Data Warehouse projects 7 years- experience with ETL development 5 years- experience designing and implementing ETL solutions with IBM DataStage in a Unix/Linux environment. This includes installation, configuration, and performance tuning 4 years- experience with database programming in a large enterprise environment 3 years- experiencein source data analysis defining data granularity, data element mapping, data warehouse design and data aggregation 3 years- experience with data conversions 2 years- experience in data quality and data governance #J-18808-Ljbffr Atria Group LLC

Job Tags

Similar Jobs

Marvin

Appointment Setter Job at Marvin

 ...window and door solutions Generate qualified leads for our in-home consultation team by converting customer interactions into appointments Set up and maintain attractive, professional displays Why This Role Stands Out Earn Big, Work Smart : Top... 

Vituity

Medical Recruiter - Remote - Nationwide Job at Vituity

 ...Remote, Nationwide - Seeking Medical Recruiter Everybody Has A Role To Play In Transforming Healthcare If you want to be part of changing healthcare to better serve patients, you are in the right place. With Vituity you will join a team of individuals dedicated... 

camfer

Founding Research Engineer Job at camfer

 ...s o1 hackathon . We've raised $4.8M, our investors include Y Combinator, Next47, Bloomberg Beta, Octave Fund, and the founders of Dropbox and Airtable.We're in-person in SF. We have an espresso machine, meals provided every day, a fully stocked fridge, and lots of natural... 

University Health

Learning Management System Administrator Job at University Health

 ...LMS structure, and reporting. Provides technical/customer support and customer education on course enrollment, assignment, learning...  ...'s degree in education technology, instructional technology, software development, or a related field is required; Three to five... 

Home Depot

Sr. Manager - Cyber Incident Support & Insider Risk Job at Home Depot

 ...Senior Manager Cybersecurity Incident Support And Insider Risk With a career at The Home Depot, you can be yourself and also be part of something bigger. Position Purpose: The Senior Manager Cybersecurity Incident Support and Insider Risk is responsible for leading...