> Markdown version of [/jobs/ext/1995892-sr-etl-developer](https://www.wearedevelopers.com/jobs/ext/1995892-sr-etl-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr.ETL Developer - **Company:** Atria Group LLC - **Location:** Albany, NY, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Big Data, Databases, Data Conversion, Data Governance, Extract Transform Load (ETL), Data Mart, Data Normalization, Data Structures, Data Warehousing, IBM InfoSphere DataStage, Microsoft SQL Server, Performance Tuning, Systems Development Life Cycle, Standard Sql, Service-Oriented Architecture, Informatica Powercenter, Codebase, Code Restructuring - **Published:** August 8, 2026 - **Apply:** https://jobs.smartrecruiters.com/AtriaGroupLLC/115003759-sr-etl-developer ## About the Role * 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- experience in 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 ## 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Getting to Know Your Legacy (System) with AI-Driven Software Archeology](https://www.wearedevelopers.com/videos/1437-getting-to-know-your-legacy-system-with-ai-driven-software-archeology) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)