RDBMS Database Migration Specialist

Preferred Qualifications• A minimum of 2 years of hands-on experience in back-end RDBMS, particularly with Oracle and DB2, focusing on data modeling and database design.• Over 2 years of experience in the design, development, and implementation of ETL projects using IBM Datastage (version 8.5 or later).• Proficient in the software development life cycle with at least 2 years of experience.• A strong background in data warehousing (DW) and business intelligence (BI) technologies and tools is essential.• Experience through all phases of project life cycle activities related to DW/BI development and maintenance, with a minimum of 2 years.• At least 2 years spent in design and architecture reviews.• Familiarity with IBM Datastage architecture, including stages and transformations, ETL flow design, and advanced SQL queries.• Proven skills in data loading techniques using Datastage.• Development of Datastage Parallel Extender jobs utilizing various stages such as Aggregator, Join, Merge, Lookup, External Filter, and more.• Proficient with Datastage Director for job execution and monitoring.• Experience in creating Datastage sequences for batch job execution.• Knowledge of best practices in Datastage, performance enhancements, and implementing Change Data Capture (CDC) and User Defined Functions (UDFs).• Understanding of Unix/Linux systems, file systems, and shell scripting.• Strong familiarity with scheduling tools such as Autosys, Control-M, and Tivoli.• Solid knowledge of mainframe file structures alongside RDBMS.• Expertise in determining strategic technical direction and system architecture for various initiatives.• A hands-on development approach, with a readiness to troubleshoot and resolve complex issues.• Extensive experience in Oracle SQL and PL/SQL.• Proficient with database development tools including Oracle and Toad.• Good understanding of partitioning, indexing techniques, bitmap indexes, triggers, and materialized views.• Experience in query tuning and analyzing execution plans.• Background in the financial domain is a plus.• Ability to work effectively in a team-oriented environment with strong client interfacing skills.• Excellent analytical skills and a desire to operate in a global delivery context.This position may require extended periods of sitting and working at a computer. Strong communication skills are essential, whether by phone, email, or face-to-face interactions. Travel may be necessary based on job requirements.

Join Sonsoft Inc., a dynamic technology solutions provider based in Plano, Texas, as an RDBMS/PL SQL Developer. We are seeking a passionate individual who possesses strong skills in Java, JSP, and JavaScript. In this role, you will collaborate with our team to develop and maintain robust database solutions that enhance our clients' operations.

Join our dynamic team at Sonsoft Inc. as an Oracle DRM Developer. In this role, you will leverage your expertise in Oracle Data Relationship Management (DRM) to design, implement, and enhance data management solutions. Your contributions will ensure that our clients enjoy seamless data governance and compliance.

Join Sonsoft Inc. as an Oracle DRM Developer where you will play a crucial role in enhancing and optimizing our Oracle Data Relationship Management solutions. You will work closely with cross-functional teams to design, implement, and maintain solutions that meet our client’s needs. Your expertise will help drive innovation and efficiency in our projects.

Join our innovative team at Sonsoft Inc. as an Oracle Data Relationship Management (DRM) Developer. In this dynamic role, you will leverage your expertise in Oracle DRM to design, develop, and implement solutions that enhance data management processes and support strategic business initiatives.Your contributions will play a critical role in optimizing our clients' data strategies and ensuring seamless integration across systems.

Join our dynamic team at E*Pro Inc. as an Oracle PL/SQL Developer. This full-time, permanent position is based in Plano, TX. You will leverage your skills in Oracle, PL/SQL, SQL, and various Oracle concepts to contribute to innovative projects in the banking and financial sector. Your responsibilities will include:• Demonstrating your expertise in Oracle 10g and 11g, including indexes, partitions, SQR, and iXp.• Managing batch scheduling using Autosys.• Performing coding, unit testing, and component integration testing while collaborating with business partners for testing sign-off.• Engaging in the Software Development Life Cycle (SDLC) processes.• Implementing unit testing methodologies and upholding code quality through defined coding standards.If you are qualified and ready for a new opportunity, we would love to connect with you!

Join our dynamic team at Sonsoft Inc. as an Oracle Hyperion DRM Developer. In this role, you'll leverage your expertise to design and implement solutions that enhance our Hyperion Data Relationship Management capabilities. You’ll collaborate with cross-functional teams to deliver projects that are vital to our client's success.

We are seeking a skilled ETL Developer with a strong background in Linux and Oracle to join our dynamic team at Sonsoft Inc. As an ETL Developer, you will be responsible for designing, developing, and optimizing our data integration processes, ensuring seamless data flow and integrity.If you are passionate about data engineering and ready to take on exciting challenges, we want to hear from you!

Join our dynamic team at Sonsoft Inc. as an Oracle ATG Analyst! In this pivotal role, you will leverage your expertise to enhance our clients’ e-commerce platforms using Oracle ATG technology. You will be responsible for analyzing business requirements, implementing solutions, and offering ongoing support to ensure optimal performance of our applications.We are looking for a proactive individual who thrives in a fast-paced environment and is eager to contribute to innovative projects. If you are passionate about technology and customer satisfaction, we want to hear from you!

As a Lead Oracle Consultant at Sonsoft Inc., you will spearhead transformative projects that leverage Oracle solutions to enhance our clients' operational efficiency. This role requires a strategic thinker with a deep understanding of Oracle technologies, capable of leading teams and delivering high-quality solutions.

Join Sonsoft Inc. as an Oracle ATG Analyst and play a vital role in shaping the future of e-commerce solutions. We are looking for a detail-oriented professional who is passionate about Oracle ATG technology and eager to contribute to innovative projects. In this full-time position, you will work collaboratively with cross-functional teams to enhance our clients' online platforms and deliver exceptional customer experiences.

Join our dynamic team at Sonsoft Inc. as an Oracle IDAM Security Specialist. In this role, you will play a crucial part in managing identity and access management solutions, ensuring the security and integrity of our clients' digital assets. You will collaborate with cross-functional teams to implement best practices in security, providing support and guidance on identity management processes.

Join the dynamic team at Sonsoft Inc. as an EMC xPressions and Oracle Publisher Consultant. In this role, you will leverage your skills to help clients optimize their publishing processes and enhance their content management strategies.

Join our dynamic team at stemxpert1 as a Principal Consultant specializing in Oracle WAM. In this pivotal role, you will leverage your extensive functional expertise to guide clients through complex implementations and optimizations of the Oracle Work and Asset Management system. Your contributions will be vital in ensuring our clients achieve operational excellence and maximize value from their investments.

Join Sonsoft Inc. as a talented Hadoop Developer with expertise in J2EE development. In this role, you will leverage your skills to build robust data solutions and applications. You will work closely with cross-functional teams to design and implement scalable data architectures that meet our clients' needs.

Join our dynamic team at Sonsoft Inc. as a .NET Developer, where you will be an integral part of designing and developing innovative software solutions. Collaborate with cross-functional teams to enhance applications and deliver high-quality code.

Join our dynamic team at Sonsoft Inc. as a .NET Developer, where you will play a crucial role in designing, developing, and maintaining innovative software solutions. Your expertise in .NET technologies will contribute to our mission of delivering top-quality applications that meet our clients' needs.

Join our dynamic team at Sonsoft Inc. as a UNIX Developer. In this pivotal role, you will have the opportunity to design, develop, and maintain UNIX-based applications that support our cutting-edge projects. Your expertise in UNIX environments will be essential in solving complex technical challenges and optimizing system performance.

Join our dynamic team at Sonsoft Inc., where we are looking for a skilled .NET Developer. In this role, you will be responsible for designing, developing, and maintaining applications using the .NET framework. You will collaborate with cross-functional teams to deliver high-quality software solutions that meet our clients' needs. Your expertise in .NET technologies will help drive our projects forward, ensuring scalability and performance.