Previous Job
Previous
BI Developer/ Data Analyst
Ref No.: 18-63469
Location: Philadelphia, Pennsylvania
Position Type:Full Time/Contract
Start Date: 08/30/2018
 
Position : BI Developer/ Data Analyst
Location : Philadelphia, PA
Duration : Full Time-Only Green Card OR US CITIZEN 

Experience Required

- Experience in data integration tools like SSIS, Informatica
- Strong Experience in data RDBMS SQL Server, Oracle, Teradata
- Strong Experience in BI tools/servers like Tableau, SSRS
- Experience in Hadoop, Hive 
- Unix , UC4 
- Experience in AWS Analytical services, S3, RDS

Roles & Responsibilities

7+ years of development experience as BI developer with expertise in the below points
- String experience in writing complex queries.
- Strong Experience in SQL / PL SQL development, DB design, performance tuning 
- Good knowledge of development of Informatica workflows
- Experience with Hadoop Hive, Scoop
- Experience in Shell Scripting with ETL code automation with Unix Shell Scripts
- Experience in SQL Server Integration Services , Development of SSIS packages, 
- Automating and scheduling SQL server jobs
- Experience in Tableau dashboard development, scheduling and monitoring
- Experience in SSRS report development, subscriptions etc 
- Data migration experience from RDBMS standalone instances to AWS RDS instances
- Experience in AWS Analytical services, S3, RDS
- Perform extensive functionality, integration, regression and end-to-end system testing when necessary
- Work closely with development and QA teams to establish test methodologies and best practices across the groups, including test case creation, regression suite creation and functional code verification 
- Support ongoing feature development from testing perspective by creating and executing automation suites 
- Troubleshoot, analyze test failures, defects and report them to a bug tracking database (JIRA)
- Ability to prioritize test activities and testing tasks 
- Excellent written and verbal communication skills