CDM Smith Jobs

34501BR

Requisition ID:

34501BR

Business Unit:

COR

Job Description:

Job Description:

• Actively participate in data integration (ETL) activities to support data communication between SQLServer and Oracle EBS.

• Develop data extract, transformations, and load routines with SSIS including importing data from files, moving data from one database platform to another

• Strong knowledge of relational databases, as well as skills in SQL query design and development.

• Conduct system tests and root cause analysis, troubleshoot business issues and correct database defects, respond quickly to bug fixes and enhancement requests.

• Write ad-hoc queries to verify ETL activities to debug one-off issues

• Take ownership of the development, unit-testing, code migration, and documentation

Job Title:

Intermediate Applications Developer

Group:

COR

Employment Type:

Regular

Minimum Qualifications:

Minimum Qualifications:

• Bachelor's Degree in Computer Science or equivalent

• 3 – 5 Years’ experience in Data Integration ETL environments

• Experience working on Business Intelligence or Data Warehousing designing, developing, Testing, and troubleshooting using SSIS packages to implement complex ETL processes

• Experience with the Microsoft Excel Macros and Pivot Tables.

• Experience with the Microsoft BI Stack, i.e., SQLServer, Sharepoint.

• Experience with scheduling jobs using SQL Agent. Setting up Alerts to proactively monitor any schedule issue

• Basic understanding of UNIX/Linux operating systems.

• Hands on experience in Oracle EBS development technologies

• Must be able to handle multiple competing priorities in a dynamic team environment.

Why CDM Smith?:

CDM Smith provides lasting and integrated solutions in water, environment, transportation, energy and facilities to public and private clients worldwide. As a full-service consulting, engineering, construction, and operations firm, we deliver exceptional client service, quality results and enduring value across the entire project life cycle.

Job Site Location:

India - Bangalore

Agency Disclaimer:

All vendors must have a signed CDM Smith Placement Agreement from the CDM Smith Recruitment Center Manager to receive payment for your placement. Verbal or written commitments from any other member of the CDM Smith staff will not be considered binding terms. All unsolicited resumes sent to CDM Smith and any resume submitted to any employee outside of CDM Smith Recruiting Center Team (RCT) will be considered property of CDM Smith. CDM Smith will not be held liable to pay a placement fee.

Amount of Travel Required:

0%

Assignment Category:

Fulltime-Regular

Background Check and Drug Testing Information:

CDM Smith reserves the right to require background checks including criminal, employment, education, licensure, etc. as well as credit and motor vehicle when applicable for certain positions. In addition, CDM Smith may conduct drug testing for designated positions. Background checks are conducted after an offer of employment has been made in the United States. The timing of when background checks will be conducted on candidates for positions outside the United States will vary based on country statutory law but in no case, will the background check precede an interview. CDM Smith will conduct interviews of qualified individuals prior to requesting a criminal background check, and no job application submitted prior to such interview shall inquire into an applicant's criminal history. If this position is subject to a background check for any convictions related to its responsibilities and requirements, employment will be contingent upon successful completion of a background investigation including criminal history. Criminal history will not automatically disqualify a candidate. In addition, during employment individuals may be required by CDM Smith or a CDM Smith client to successfully complete additional background checks, including motor vehicle record as well as drug testing.