Title Business Intelligence/ Data Analyst
Start Date 2018-03-01
End Date 2018-03-31
Job Information

(To Apply Please click here)

Our company is looking for a Business Intelligence/ Data Analyst who will be performing following roles and responsibilities – Analyze business requirements, technical specifications and implement data transformations using Extract, Transform and Load (ETL) applications to deliver an efficient data warehousing solution. Driving the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling. Establish, enforce and maintain ETL(Informatica) architecture design principles, techniques, standards and best practices using Informatica PowerCenter. Develop data extraction procedures from several databases (Oracle and SQL Server) to map data between source systems, data warehouses and data marts for data analytics. Implement system analysis, performance tuning of Informatica mappings and understand the goals and risks associated with the business and technical requirements. Collaborate with Analysts, DBAs and application owners to understand and analyze data, business modelling and optimize ETL performance. Review designs, codes and test plans to ensure implementation quality and standards. Troubleshoot issues and defects raised during data quality and data integrity testing and resolve as per assigned priority to meet timelines of deliverables. Implement code migrations between different environments by creating deployment groups integrating various ETL objects tested throughout the development cycle. Create plans, PL/SQL test queries and scripts for data warehouse testing ranging from unit to integration testing of designed ETL objects and stored procedures. Develop and maintain UNIX shell scripts for Inbound/Outbound processes that include files upload/download (using sftp), gzip, archiving and sending success/failure emails. Redesign existing implementation or create new to meet changing user needs and business requirements. Document implemented code changes, fixes and validation queries for defects logged in Jira, tool used for bug tracking, issue tracking during each Sprint in Scrum. The position requires Minimum Bachelor’s degree in Computer Science/Information Systems/ Engineering/ Technology/ Business Administration/ Management. Work location: Piscataway, NJ & various unanticipated locations throughout the U.S.

Please Send Resume to Primesoft, Inc., JOB ID# BIA/DA0318-1, 15 Corporate Place South, Suite 416, Piscataway, NJ 08854.

                                                                                                                  (To Apply Please click here)