All posts by Gallegasoft Gallega Software Solutions

Title : Programmer Analyst, Advertised on: August 22, 2016

Duties: Use SQL and PL/SQL on different platforms such as Windows NT/2000/XP, UNIX. SQL query tuning to improve performance. Develop classic reports, interactive reports, PL/SQL content reports using dynamic SQL, APEX components such as LOV’s, tabs, charts. Integrate JavaScript with APEX. Data Warehousing (Including Star Schema, Snowflake Schema) and Extraction Transformation Loading (ETL) and ETL process of moving data from source systems to staging tables and finally to data warehouse. Utilize tools such as SQL*Plus, TOAD, Putty and SQL*Developer. Analysis and development of PL/SQL stored procedures, functions, packages and triggers. Use Views, Synonyms, Indexes, Hints, Joins and Sub-queries. Use Cursors, Ref Cursors, Exceptions and Anonymous blocks for generating reports. Entity-Relationship model and RDBMS concepts. Create webi reports using SAP Business Objects.

Other: Full Time. Travel involved to unanticipated client locations in US.

Requirements: Master’s in Engineering (Any Field or Major) or Related + 1 year experience in job offered or related. Any suitable combination of education, training or experience accepted.

Location: Alpharetta, GA

Respond to: HR – Code RT, Gallega Software Solutions, Inc., 1005 Alderman Drive, Suite 206, Alpharetta, GA 30005

This position is eligible for our employee referral program

Systems Analyst

Advertised on: Thu Jan 12th, 2012 – JobCode: WEB0112-SA1

Provide systems analysis, design and implementation of software applications using EDI, Mercator Design Studio, HIPAA Standards, EDISIM, EDIFECS XEngine, Oracle, SQL Server, OS/400, Windows, etc; supervise system level load and stress testing; configure, interact with clients to define specification standards; develop systems/technical documents; interact with users for source data models; customize business objects reports; train users. Require: MS in Computer Science/Engineering(any branch). FT Comp Salary Travel. Resume: HR, Gallega Software Solutions, Inc., 4080 McGinnis Ferry Road, # 1208, Alpharetta, GA 30005. (kingkoduruATgallegasoft.com)

Systems Analyst/Datastage

Advertised on: Wed Feb 8th, 2012 – JobCode: WEB0212-SA

Provide systems analysis, design and implementation of data warehouse/software applications using Datastage PX, Oracle, SQL, PL/SQL, TOAD, Apache, Windows, etc; supervise installation, configuration, setup and administration of Datastage PX; configure and connect between servers and Datawarehouses; develop systems/technical documents; write complex stored procedures, triggers and functions; supervise ETL team for data marts and models; train users. Knowledge in EDI, ANSI X12, EDIFACT a huge PLUS. Require: MS in Computer Science. FT Comp Salary Travel. Resume: HR, Gallega Software Solutions, Inc., 4080 McGinnis Ferry Road, # 1208, Alpharetta, GA 30005. (kingkoduruATgallegasoft.com)

Systems Analysts

Advertised on: Thu Jan 12th, 2012 – JobCode: WEB0112-SA2

Provide systems analysis, design and implementation of software applications using ASP.Net, VB.Net, C#, Java, JSP, SQL Server, Agile methodology, SQL SRS, Oracle, Crystal Reports, Web Services, Windows, etc; supervise configuration management and quality assurance; interact with clients to define specification standards; develop systems/technical documents; write complex stored procedures, triggers and functions; supervise database design; train users. Require: MS in Computer Science/ Computer Engineering. FT Comp Salary Travel. Resume: HR, Gallega Software Solutions, Inc., 4080 McGinnis Ferry Road, # 1208, Alpharetta, GA 30005. (kingkoduruATgallegasoft.com)

Datastage Developer

Advertised on: Thu Dec 22nd, 2011 – JobCode: WEB0111-DD

Provide systems analysis, design and implementation of software applications using C, C#, PERL, .Net, HTML, XML, Oracle, SQL Server, Eclipse, Windows, Unix; gather requirements; write complex procedures, triggers, packages, functions; supervise unit and system testing; develop mapping for ETL process; review ETL documentation; lead performance tuning, production support; train users. Require: MS in Computer Science/Computer Engineering/Informatics. FT Comp Salary Travel. Resume: HR, Gallega Software Solutions, Inc., 4080 McGinnis Ferry Road, # 1208, Alpharetta, GA 30005. (kingkoduruATgallegasoft.com)