What you'll do in the role:Morgan Stanley Services Group, Inc. is seeking an Associate, Software Engineer in Alpharetta, GA to customize and configure the Salesforce software platform, and build custom components, and features for Sales and Service team. Design, implement, and maintain end-to-end integration solutions between Salesforce and external/internal systems. Build and manage APIs, middleware, and batch jobs to support real-time and scheduled data flows. Develop customized software solutions for Salesforce platform to support critical business functions and meet project objectives, business requirements, and company goals. Develop and support ETL processes using IBM DataStage and Informatica IDMC. Ensure efficient data extraction, transformation, and loading into Salesforce from enterprise systems and data lakes. Manage large data sets and optimize data processing workflows for performance and reliability. Write and maintain Unix shell scripts and Perl scripts for system-level automation and data processing. Create and manage job schedules using Control-M and TWS ensuring timely execution of data loads and integration tasks. Automate data validation and reconciliation processes to ensure accuracy and completeness. Monitor and troubleshoot failed jobs, escalating as needed to maintain SLAs. Conduct unit, integration, and system testing for all developed interfaces. Document integration flows, data mappings, and exception handling processes. Ensure compliance with data security policies, privacy regulations, and enterprise architecture standards. Work closely with data engineers, architects, Salesforce consultants, QA teams, and business users. Provide Level 2 and 3 support for integration issues including root cause analysis and permanent fixes. Telecommuting permitted up to 2 days per week.
What you'll bring to the role:-Requires a Master's degree in Applied Computer Science, Information Technology, or a related field of study
-Requires three (3) years of experience in the position offered or three (3) years as a Developer, Software Engineer, or a closely related occupation
- Requires three (3) years of experience with the following skills:
- Oracle SQL and PL/SQL;
- Unix Shell and Perl scripting;
- Data Integration projects;
- ETL tools including IBM InfoSphere DataStage and Oracle Warehouse Builder;
- TIBCO Data Virtualization tool;
- Automation tools including Control-M and CBSS;
- Python and R.
Expected base pay rates for the role will be between $171,000 and $171,000 per year at the commencement of employment. However, base pay if hired will be determined on an individualized basis and is only part of the total compensation package, which, depending on the position, may also include commission earnings, incentive compensation, discretionary bonuses, other short and long-term incentive packages, and other Morgan Stanley sponsored benefit programs.
Telecommuting permitted up to 2 days per week.
