SAS Reports Developer, Tampa, FL, USA

Send resumes to : am@truceaid.com

Need resources with status : EADs(H4/L2), GC, USC only

SAS Reports Developer

Tampa, FL (Non-Local, OK)

Phone then Skype

Required:

  • 5+ years SAS reporting experience
  • SQL (must be able to write queries from scratch)
  • Healthcare exp (healthcare data, members or providers side, commercial ins or medicare/Medicaid claims data) ie: BCBS/Aetna/United

Plus:

  • Other reporting tools
  • GreenPlum
  • Hadoop
  • Tableau

Experience Needed:

  • Proficient in Developing SAS Programs , Macros Including Advanced SAS Programming techniques for Data Accessing, Data cleansing, Data management, and reporting.
  • Experienced in extracting the data from Oracle , SQL Server databases , Green Plum and from SPDS efficiently using SAS/Access
  • Experienced in debugging SAS code, compiling errors, review SAS code
  • Experience in Creating Excel reports using SAS / ODS and Report automation processes
  • Experienced in SDLC methodologies
  • Production Jobs monitoring and handling the job failures to keep all the reporting processes up and running
  • Flexibility in resolving the Critical Report issues for Business/Market/State to meet the stringent deadlines

 Technical Skills :

  • Base SAS v9.3, SAS Macros, SAS/Access, SAS/ODS , strong in SQL
  • Good experience in Unix and Basic Shell Scripting
  • Knowledge in VB Scripting would be added advantage
  • SAS/SPDS experience would be plus
  • Version control tools like Team Foundation Server
  • Exposure to Autosys

Senior Actimize BA, New York, NY, USA

Any visa is fine…

Send resume to: am@truceaid.com

Job Title/Role: Senior Actimize BA

Job Location: New York, NY

Project Duration: 6 months

Interview Preference –Telephonic / Skype

Mandatory Skills: BA skills, Actimize

Desired Skills: AML, Fraud detection

Job Description:

  • Previous experience working as a Business Analyst in a financial services organisation (preferably a tier 1 investment bank / consulting) on trade surveillance program.
  • Good Equity, Fixed Income and FX product knowledge across the whole trading lifecycle, including common Equity / Fixed Income derivative products.
  • Some knowledge of the key responsibilities of an investment bank’s Compliance department (preferably including Control Room, Licensing, Front Office Registration and Outside Business Interests).
  • An in-depth understanding of business analysis (including knowledge of at least one requirements management / modelling tool) and with the ability to select the right tools / methodologies for a given task.
  • Extensive experience of business process mapping and on-boarding workflows.
  • Experience of writing test plans, scripts, and cases.
  • A good understanding of the technology project lifecycle of both Waterfall and Agile methodologies.
  • The ability to work effectively with all levels of clients and IT stakeholders up to and including director.
  • Excellent communications skills – both written and verbal, with technical and non-technical audiences.
  • Systems and data analysis skills, including SQL, Oracle and desktop data analysis tools. Any data modelling / warehousing experience would be an advantage.
  • Prior experience of Actimize case Manager (preferably 2 years)

Functional testing resources Position in Cary, NC, USA

Any visa is fine…

Please send resumes to : am@truceaid.com

Title: Functional testing resources with a basic knowledge of automation testing

Location: Cary, NC

Duration: Long Term

 Ø         Extensive experience in testing experience in all phases and stages of Software Testing Life Cycle and Software.

Ø         Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.

Ø         Exposure in both Manual & Automated testing at all levels of STLC

Ø         Extensive experience in both SIT and UAT testing.

Ø         Extensive Experience in testing with SMEs

Ø         Experience with Black box testing, white box testing, Unit, Integration, Regression, Sanity, System test, Functional testing, GUI applications testing and Database Testing having executed on both Client/Server and web based applications.

Ø         Solid Back End Testing experience by writing and executing SQL Queries.

Ø         Having experience in automated tools like Selenium, QTP, & Test Director/QC

Ø         Proficient in automating web application testing using selenium IDE, selenium Web Driver

Ø         Experience in designing and executing Automation scripts using Selenium/QTP.

Ø         Experience in Keyword, Data Driven and Hybrid Frameworks.

Ø         Proficient in Web service testing using SOAPUI tool, SOAP, XML and validating WSDL using SOAPUI tool.

Ø         Experience in preparing Test plans, Test cases, Test data & Test summary reports

Ø         Experience in preparing Test Risk Assessment and Test Evaluation report.

Ø         Expert in using the Bug tracking with Test Management Tools like ALM.

Ø         Very strong in testing concepts with good exposure in preparation and Test plan.

Ø         Expertise in working in Agile (Scrum), Waterfall, Spiral methodologies.

Ø         Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.

Ø         Expertise in designing the test scenarios and scripting the test cases in order to test the application.

Ø         Experience in using UNIX commands to perform testing in Linux server/machine using Putty.

Ø         Expertise in developing, documenting, and executing test cases manually as well as generating automated scripts using Selenium.

Ø         Experience in AGILE-SCRUM Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Ø         Experience on databases including Oracle, MS SQL Server.

Ø         Good interpersonal skills and demonstrated ability to work as individual Tester or in a team

 

Exposure to below technologies & Tools

 

Methodologies                         :           Agile, Waterfall

Programming Languages       :           C, C++, Java, SQL

Web Technologies                  :           HTML, CSS, XML, XPath, CSS Selector

RDBMS                                  :           MS SQL Server, MySQL, Oracle.

Tools                                       :           QTP, Selenium(DB framework)

Frameworks                            :           Keyword Driven, Data Driven, Hybrid

Test Management Tool           :           Test Director, HP ALM, JIRA, JAMA

Defect Management Tool       :           ClearQuest, FogBugz, HP ALM

Browsers                                 :           Internet Explorer, Mozilla Firefox, Google Chrome, Safari

Test Build & Integration Tools :           Maven

Utilities                                     :           Eclipse, GIT

BI ETL Developer for NY, USA

Send resume to : am@truceaid.com

Need EADs(H4/L2), GC, USC

BI ETL Developer 

NY,NY (Final F2F required but will consider non-local as long as they will attend F2F)

5+ months

Phone/F2F (Will skype non-local before F2F (Client will assist in cost of F2F)

Required

  • Bachelor’s degree or higher or equivalent, relevant equivalent experience.
  • Minimum of 5 years of experience in ETL development in business intelligence/data integration projects.
  • 5+ years of experience working with Informatica, GoldenGate, etc.
  • 5+ years of experience working with Relational Databases like Teradata, Vertica, Oracle, SQL Server, etc.
  • 3+ years of experience working with Unix Shell Scripts.
  • Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.
  • Strong data analysis and troubleshooting skills.
  • Experience in integrating technologies with internal and external data sources.
  • Goal oriented and creative personality with good interpersonal skills.
  • Ability to manage multiple assignments simultaneously and follow up on unfinished business.
  • Ability to work independently and in a team environment.
  • Ability to pay attention to the details and be organized.
  • Commitment to internal client and customer service principles.
  • Willingness to take initiative and to follow through on projects.
  • Excellent time management skills, with the ability to prioritize and multi-task in a fast-paced environment.
  • Excellent communication and motivation skills, and ability to interact appropriately with senior-level colleagues and business users.
  • Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment.
  • Must have legal right to work in the U.S.

Technical Skills:

  • Experience sourcing data using API calls (REST/SOAP) is a plus.
  • Experience working with sourcing and uploading data to and from cloud systems like AWS/GCP is a plus.
  • Strong Teradata desired. Oracle, MS SQL Server, Vertica, Netezza, etc. can be alternates. Comprehensive understanding of Data Warehouse design principles.
  • Ability to proactively identify, troubleshoot and resolve complex data integrity issues.
  • Subscription-based industry experience preferred.
  • Knowledge and understanding of REST/SOAP protocols desirable.
  • Understanding of data integration between on-premise and cloud-based data systems.
  • Understanding of Big Data technologies and tools like Hadoop, HDFS, Hive, Spark, Flink, Kafka, Scoop.
  • Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint, Access).

Position Summary:

The ETL Developer will work closely with the Product Owner, Scrum Master, ETL Developers and various business stakeholders to support and provide quality of delivery for clients’s data extraction, transformation and load needs through the development of new and/or enhancement of existing routines, or the management of contractor-sourced resources. Also implement quality control and audit practices to ensure continuous improvement of client’s assets.

Duties and Responsibilities:

  • Work with various business stakeholders to identify their information needs.
  • Work with data architecture team to understand the source and target data models.
  • Work closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs.
  • Develop and be a proponent for Data Warehouse development standards, including ETL standards and best practices.
  • Provide documentation for all developed ETL processes, including process flow and source and target mapping.
  • Conduct ETL performance tuning and troubleshooting.
  • Work with business intelligence operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures.
  • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data.

Supervisory Responsibilities:

  • None .

Lead Business Analyst, NY, USA

Send resumes to : am@truceaid.com

Need EADs(H4/L2), GC and USC only

Lead Business Analyst

NY,NY (Final F2F required but will consider non-local as long as they will attend F2F)

9+ months

Phone/F2F (Will skype non-local before F2F (Client will assist in cost of F2F)

Required

  • Bachelor’s degree in information technology, related field, or equivalent, relevant experience.
  • At least 8 years of experience in a variety of technical roles within information technology.
  • 5+ years of experience in business analysis or data analysis roles in a BI environment.
  • Strong interpersonal skills.
  • Ability to interpret, analyze and solve business problems with information technology solutions.
  • Strong analytical and quantitative problem solving skills.
  • Excellent verbal and written communication skills.
  • Ability to advocate for the needs of business partners.
  • Commitment to “internal client” and customer service principles.
  • Willingness to take initiative and to follow through on projects.
  • Spelling, grammar, proofreading and editing skills.
  • Creative writing ability.
  • Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment.
  • Must have legal right to work in the U.S. Technical Skills:
  • Ability to understand complex sets of business requirements, including inter-relationships, dependencies and priorities.
  • Experience authoring technical documents such as business requirements, functional requirements, database design representations, data and systems flow diagrams.
  • Experience using data warehouses and analytical tools for business purposes; experience with Cognos and Qlikview highly desirable.
  • Knowledge of data warehouse architectures and processes.
  • Understanding of the features and capabilities of one more DBMS’s commonly used in data warehousing such as Oracle, Teradata, SQL Server.
  • Proven record of managing the delivery of ongoing enhancements to business intelligence capabilities.
  • Expertise developing and applying relational and dimensional data models.
  • Understanding of ETL architectures and experience deploying ETL solutions in a data warehousing environment.
  • Ability to conceptualize and communicate reporting strategies that address a wide range of information needs.
  • Development experience with at least one business intelligence tool

The Lead Business Analyst will be responsible for gathering and refining business information requirements that enhance client business intelligence capabilities. Will be required to have in depth knowledge of specific business processes and corresponding information needs. The analyst will interview users in order establish reporting needs, define key performance indicators and their attributes, assess needs for training, and determine user acceptance criteria for development projects.

 Duties and Responsibilities:

  • Assist business staff in the development of business requirements documents, author business requirements when called for.
  • Be a resource for other BI solutions team members for projects with complex requirements.
  • Help identify and assess potential data sources and flows, and analyze existing Enterprise Data Warehouse structures to determine relevance to business needs.
  • Participate in generating high-level solution concepts in consultation with development and quality assurance teams.
  • Write functional requirements documents, participate in document reviews with business users and development and quality assurance teams.
  • Document test strategies for primary project deliverables, and review test results.
  • Maintain in-depth knowledge of evolving Client data warehouse and BI capabilities, as well as relevant operational, transactional, and financial systems; understand full clients IT application portfolio.
  • Maintain an understanding of how the data in the Enterprise Data Warehouse and the business layers built on it relate to important business entities, events and measurements.
  • Work cooperatively with analysts and developers during the development life cycle to ensure that business requirements guide the development life cycle.

Supervisory Responsibilities:

  • None.

Need Solution Architect, FL, USA

Need EADs(H4/L2), GC, USC

Please send your resume to : am@truceaid.com

Need Solution Architect with below skills

Solution Architect (1open)-  For use with the following Technology Skill Sets Java, Angular, UI/UX, HTML, CSS ASP, .NET, SQL Server, MySQL Windows, Linux, Oracle, JS, UNIX, Sharepoint, BI tools, Informatica, ETL, Flash, Docker Puppet, Bamboo, Jenkins, Tomcat, Tcserver, Apache, IIS, Nginx, Hadoop