TT Technologies, Inc. is looking for MSBI Data Analyst to work in Flushing, NY and various unanticipated locations throughout the U.S. Must possess a minimum of a Bachelor of Science degree in Engineering/Management/Computers/ Business Administration/ Information Systems/ Finance/Math or Foreign Equivalent.
Job duties must consist but are not limited to the following:
- Utilize ETL tool SSIS for developing the Data Warehouse Loads with Data Acquisition and Data Integration.
- Design confirmed and traditional ETL Architecture involving source databases such as DB2, SQL Server and Target databases such as SQL Server, XML, and Flat Files (fixed width and delimited)
- Design Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.
- Design and Develop Complex Mappings applying various transformations such as lookup, sequence container, aggregator, ranking, stored procedures, joins, and sort.
- Work with Entity Relationship (ER) Diagrams, star and Snowflake schemas.
- Create database objects such as Tables, Views, Stored Procedures, Triggers, etc.
- Use constrains to maintain Referential Integrity, Domain Integrity, and Column Integrity.
- Identify Primary Keys at design time and creating the same.
Position may require travel. Send resumes to support@t3incorp.com, or Fax # 347-626-2535