Developer

Job Duties: Develop, create, modify, code, customize full system life cycle development (SDLC) of .Net Application solutions; Implement object oriented programming concepts, including encapsulation, inheritance, polymorphism ad abstraction to develop software solutions in C#.NET; Utilize Agile Methodology in software development life cycle (SDLC), including the design, development, and implemention of complex software applications using C#, ASP.NET, MVC 3, JQuery, JavaScript, Visual Studio and SQL Server; Design and implement web based user interface (UI) using HTML, CSS, JQuery and JavaScript; Use Dataset, DataTable, and DataReader objects of SQL namespace for data retrieval and manipulation; Design custom reports via SQL Reporting Services to align with requests from internal account teams and external Clients; Design and implement ETL mappings and processes as per the company standards, using Informatica PowerCenter; Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts; Manage performance and tuning of SQL queries; Write complex SQL queries PL/SQL function, procedure, packages, cursor and triggers to retrieve the data from sources system and to count and validate the data and data set; Implement Data extraction/Transformation/Cleaning/Loading using SQL Loader and PL/SQL;  Design and Develop ETL using PL/SQL packages, procedures, functions and UNIX shell scripts for the massive data loads from OLTP systems to staging database system; Perform client side validations using JQuery and JavaScript; Utilize webservices in C#.Net in a service oriented architecture (SOA) environment; Develop data access components using ADO.NET, LINQ to Entities, and C#; Perform initial and regression testing to insure compatibility in coding.

Education and Experience: Requires a bachelors degree or foreign equivalent in Computer Science or Computer Information Systems and five (5) years of experience in the job offered or five (5) years of experience designing custom reports via SQL Reporting Services to align with requests from internal account teams and external Clients.  Designing and implementing ETL mappings and processes as per the company standards, using Informatica PowerCenter.  Developing stored procedures using PL/SQL and driving scripts using Unix Shell Scripts. Managing performance and tuning of SQL queries.  Writing complex SQL queries PL/SQL function, procedure, packages, cursor and triggers to retrieve the data from sources system and to count and validate the data and data set.  Implementing data extraction /transformation /cleaning /loading using SQL Loader and PL/SQL.  Designing and developing ETL using PL/SQL packages, procedures, functions and UNIX shell scripts for the massive data loads from OLTP systems to staging database system.

Location: McKinney, Texas. 40 Hours/week. M-F. Job will require domestic travel to client sites with expenses paid by employer. Must be authorized to work in the U.S. Email resumes to hr@4ciusa.com or mail to Attn: HR, 4Consulting, Inc., 6850 TPC Drive, Suite 208, McKinney, Texas 75070. Please go to www.4ci-usa.com for more details. Please use Job ID 3011 when applying.