Sr.ETL Developer
Atria Group · Albany, NY, us ·
- Seniority
- Senior
- Category
- Data engineering
- Experience
- 2+ years
- Visa sponsorship
- Yes
- Company size
- 501-1000
Atria Group · Albany, NY, us ·
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.
GOOD COMMUNICATION SKILLS
C2C
H1B, USC, GC
DURATION: 6 + MONTHS