ETL BSA / Data Analyst/Data Warehouse Analyst

ACS group has an immediate need for an ETL Business Systems Analyst with experience in the IT Industry. This is a 12 month’s contract opportunity. Our client is a Leading Health Insurance provider company.Please review the job description below:

• Looking for an ETL Business Systems Analyst with min 9 years of total IT experience.
• The BSA role in Data Warehouse required minimum 5 years of relevant experience & 9 years in IT with Excellent verbal & written skills in the following:
• Strong in SQL: Hands on experience in Writing Complex SQLs using various functions like Ranking, Partition, Aggregations etc., analytical functions and UAT including critical problem-solving experience. (5 years)
• Business Analyst: Experience in Analyzing and defining end to end Business Process for Data warehouse ETL applications and support postproduction activities. Experience in creating BRD, FRD/FSR and T-Rule Mappings for Data Warehouse ETL applications and UAT. (3+ years)
• Data Analysis & Profiling: Experience in data cleansing, transformations, normalizations and discover information's from multiple sources. (2+ years)
• Data Warehouse: Experience in Slowly changing Dimension concepts, facts, dimensions, and different schemas. And modeling expertise is a plus. (3+ years)

• Ensures downstream processes are considered during system enhancement/modification efforts.
• Perform initial User Acceptance testing to ensure system changes meet defined requirements as well as providing feedback to Development/testing teams regarding test cases, scenarios and scripts.
• Collaborate with vendors, consultants, business and IT personnel to achieve solutions to identified business needs.