ETL Developer with Linux and Oracle Expertise

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!

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. as a Linux Developer, where you will leverage your expertise in SQL Server to enhance our software solutions. You will work collaboratively within a dynamic team to design and implement robust systems that meet our clients' needs.

Join Sonsoft Inc. as an ETL Informatica Developer where you will leverage your expertise in data integration and transformation to enhance our data management processes. In this role, you will be responsible for developing, maintaining, and optimizing ETL processes using Informatica, while also working with Netezza, MDM, Linux, Autosys, .NET, and Python.

Join our dynamic team at Sonsoft Inc. as a Linux Developer proficient in SQL, Informatica, and Netezza. In this role, you will be responsible for developing, maintaining, and optimizing data integration processes. Your expertise will be crucial in ensuring data accuracy and accessibility for our operational needs.

Are you an enthusiastic ETL Datastage Developer looking for an exciting opportunity to work with a dynamic team? At Sonsoft Inc., we are seeking a talented individual to join our Plano office. You will be responsible for designing, developing, and maintaining ETL processes using Datastage to support our data integration and transformation needs.

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., a leader in innovative technology solutions, as a Linux Developer. We are seeking a skilled professional with expertise in SQL Server, NAS Informatica, Netezza, and Autosys. This is an exciting opportunity to work with cutting-edge tools and contribute to impactful projects.

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 dynamic team at Sonsoft Inc. as an ETL Datastage Developer specializing in HP Vertica. In this role, you will have the opportunity to work on exciting data integration projects, utilizing your expertise in ETL processes to transform and manage large datasets effectively. Get ready to leverage your skills in a fast-paced environment where innovation and collaboration are key.

Join Sonsoft Inc. as an ETL Datastage Developer and Unix Programmer, where you will play a critical role in designing and implementing data integration solutions. Collaborate with cross-functional teams to optimize data workflows and ensure high-quality data processing.

Join our dynamic team at Sonsoft Inc. as an ETL Informatica Developer specializing in SQL! In this role, you will leverage your expertise in ETL processes to design, develop, and optimize data workflows, ensuring seamless data integration and transformation. You will work closely with cross-functional teams to gather requirements and deliver high-quality solutions that enhance our data capabilities.If you are passionate about data and possess strong analytical skills, we invite you to apply and make an impact in a collaborative environment.

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 Sonsoft Inc. as a Datastage Developer, where you will leverage your expertise in Unix and Datastage to design, develop, and maintain robust data integration solutions. You will collaborate with cross-functional teams and utilize your problem-solving skills to optimize data workflows and ensure data quality. If you thrive in a fast-paced environment and are passionate about data engineering, this is the perfect opportunity for you!

Join our dynamic team at Sonsoft Inc., where we are seeking a skilled DataStage Developer with strong UNIX knowledge. In this role, you will design, develop, and maintain data integration solutions that are crucial for our clients' data management needs. You will work with a variety of data sources, ensuring high-quality data processing and integration.As part of our collaborative environment, you will have the opportunity to contribute to innovative projects and enhance your technical skills.

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 talented and motivated ETL Informatica Developer with proficiency in SQL to join our dynamic team. In this pivotal role, you will be responsible for designing, developing, and maintaining ETL processes, ensuring that data flows smoothly from source to target systems. Your expertise in Informatica and SQL will be crucial in optimizing data integration and enhancing our analytics capabilities.

Join our dynamic team at Sonsoft Inc. as an ETL Abinitio Consultant. In this role, you will leverage your expertise in ETL processes and Abinitio tools to support data integration and management initiatives. You will work closely with cross-functional teams to ensure data accuracy, reliability, and accessibility for various business applications.

Join our dynamic team at Sonsoft Inc. as an Informatica Developer. We're looking for a skilled professional with expertise in Netezza, Master Data Management (MDM), Linux, Autosys, .NET, and Python. This is an exciting opportunity to contribute to innovative projects and enhance your career in a supportive environment.