The Role As our ETL/SQL Developer will be responsible for end-to-end data development in our rapidly growing Business Intelligence Data Warehouse. New development will often begin using Informatica's cloud ETL product to extract critical data from a source system through a variety of methods (API/CSV extract, etc). After data is extracted it will be the responsibility of this role to transform and load into the correct location in our data warehouse, after which it may be requireddepending on the datato use advanced SQL (Microsoft SQL Server) to join and produce new reports/insight. You will assist in developing and maintaining our data warehouse.
Experience building reusable ETL components
Experience in Data Modelingespecially in transitioning data warehouse from small to large deployment
Design and architecture background is a plus to assist in providing data integration solutions using best practices
Good verbal and written communication skills
Data Warehouse design and development methodologies knowledge and experience are good to have
Experience in trouble shooting technical issues, and mentoring team members is a strong component to the team environment
Exceptional SQL and ETL skills, especially using Informatica's ETL suite and Microsoft SQL server A strategic thinker with strong skills in research, analysis and data management and an ability to solve complex problems Deep understanding of data architecture, data acquisition, data integration, and data mining Excellent communication skills, both written and verbal Excellent time management skills with demonstrated experience in managing multiple projects simultaneously Strong leadership and collaborative skills to work with different levels of business leadership Strong analytical, problem-solving skills required Capacity to understand and quickly process basic technology concepts
Minimum 1 + years of IT industry experience working with large scale database applications
1+ years of experience using and developing complex SQL scripts to manipulate large data structures
Alliance Residential Company is a fully-integrated multifamily real estate operating company focused on the development, acquisition, construction and management of residential and mixed-use communities in the United States. Headquartered in Phoenix, Alliance has 26 regional offices divided among six regions throughout the U.S. Over the past 13 years, Alliance has become one of the largest private... apartment owners and the 15th largest management company in the nation, boasting a $7.0+ billion portfolio, 59,000 units in 24 metropolitan markets and a presence in 15 states.