**38465BR** **Requisition ID:** 38465BR **Business Unit:** COR **Job Description:** Designs, develops and implements basic to moderately complex IT architecture projects. Executes project tasks against an established project schedule, and reviews ongoing project status with IT management identifying unexpected key events. Maintains client relationships. Under general supervision, performs basic to moderately complex business analysis, process mapping, and/or develops work products/artifacts under moderate supervision. Performs requirements gathering, system design, prototyping, system integration testing, system installation and deployment of business system(s). Specializes in a large specific program/system or provide general support for a wide variety of programs/systems, as required. Consults with other IT groups, provides business system knowledge and expertise as required. Provides user and application support for escalated IT issues. Performs other duties as required. **Job Title:** Intermediate IT Business Analyst **Group:** COR **Employment Type:** Regular **Minimum Qualifications:** Bachelor’s Degree. 3 years of related experience. Domestic and/or international travel may be required. The frequency of travel is contingent on specific duties, responsibilities, and the essential functions of the position, which may vary depending on workload and project demands. Equivalent additional directly related experience will be considered in lieu of a degree. **Preferred Qualifications:** • Candidate with good understanding of ETL processes, Data warehousing and their significance in data integration. • Experience and understanding and extracting and analysing data from various sources such as databases and flat files, applying business logic and data validation techniques to ensure data accuracy and integrity. • Experience in analysing database schemas using tools like Oracle Toad and scripting knowledge. • Functional knowledge of Interpreting data and their relevance with source systems (like Oracle R12, SFDC) • Experience with Informatica PowerCenter or Talend Tool including mapping design, workflow development, session configuration, and transformations for data cleansing, aggregation, and loading. • Experience in planning, testing for upgrades, preparation of test plans, test scripts, and developing test cases. • Provides user and application support of escalated IT issues as defined by the group’s ITIL processes. Consults with other ITS groups, provides business system knowledge and expertise as required. • Executes project tasks against an established project schedule, reviews ongoing project **Why CDM Smith?:** Check out this video and find out why our team loves to work here! (https://www.cdmsmith.com/en/Video/Meet-CDM-Smith) **Join Us! CDM Smith – where amazing career journeys unfold.** Imagine a place committed to offering an unmatched employee experience. Where you work on projects that are meaningful to you. Where you play an active part in shaping your career journey. Where your co-workers are invested in you and your success. Where you are encouraged and supported to do your very best and given the tools and resources to do so. Where it’s a priority that the company takes good care of you and your family. Our employees are the heart of our company. As an employer of choice, our goal is to provide a challenging, progressive and inclusive work environment which fosters personal leadership, career growth and development for every employee. We value passionate individuals who challenge the norm, deliver world-class solutions and bring diverse perspectives. Join our team, and together we will make a difference and change the world. **Job Site Location:** India - Bangalore / Chennai / Pune **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 Inc. and its divisions and subsidiaries (hereafter collectively referred to as “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.