Conduct thorough study and analysis of client’s business processes to gather, identify and ascertain the needs and requirements in Business Intelligence (BI) data. Gather, analyze, transform and model data and ensure the data quality is in accordance with client’s organizational policies, procedures and other business requirements. Work on data analysis, data quality, data organization, metadata, and data profiling. Detect, analyzes define and document data problems. Migrate business data from on-premise databases into cloud environment. Identify and migrate all commercial Teradata database tables to Snowflake using either by lift and shift method or by refining the data and transfer to snowflake. Refine the data elements in Big Data and add these new metrics to the new or existing tables in Snowflake. Modify current SQL scripts to get the data elements (Metrics) from cloud environment data tables. Develop Unix Shell Scripts and Python Scripts for developing Ad-hoc and BAU reports. Develop complex SQL scripts by conducting various joins and applying filters to get the business requested data from existing databases. Develop dashboards and reports using Business Intelligence tools, like Tableau, Birst and Crystal Reports. Train end-users to connect to cloud database through secured SSH tunnel by providing them RDS end-point to various databases to enable they to run some standard scripts using SQL Developer. Use Oracle, Teradata, My SQL, SQL Express, SQL Server, UNIX Shell scripts, SSRS, Crystal Reports, Tableau, BIRST, SQL scripts, SQL Developer, Weblogic, iPlanet, Perl, BOBJ, Python, Unix Korn, Hadoop, and other suitable databases and technologies.
Bachelor or its foreign equivalent degree in Computer Science, Computer Engineering, Data Science, Electronics Engineering, or Information Technology, and 2 years of work experience in the job offered or in a related occupation as a Software Engineer, Programmer Analyst, Business Systems Analyst, DBA, Business Intelligence (BI) Analyst, Database Analyst, Lead Business Systems Data Analyst, or Business Systems Data Analysis Tech Lead). Any suitable combination of education, training or experience is acceptable. Alternatively, the petitioner accepts 4 years of work experience in the job offered or in a related occupation, in lieu of the requirements of Bachelor’s degree and 2 years of work experience. The work experience must include 24 months of work experience using Teradata, SQL Server, SSRS, Tableau and BOBJ. Any suitable combination of education, training or experience is acceptable.
Various unanticipated client sites throughout the U.S., thus, travel and/or relocation to the client site is required.