CDM Smith SR. Application Software Developer- Redshift in Bangalore, India
The Senior Software Developer for Redshift is responsible for developing and maintaining Data warehouse
and ETL data integration solutions between Oracle Apps and several other third-party applications
and Amazon Redshift.
This individual will adhere to the organization’s formal best practices, change management and system
This individual must be self-driven, team player, and a quick learner, and possess excellent verbal and
written communication skills.
Senior Software Developer - Redshift
The candidate will participate in complete application development cycle in building Integration solutions
between Oracle EBusiness R12 & 11i application modules and several other third party applications and
•Work with Technical Leads, understand technical requirements, and develop data warehouse integration solutions.
•Perform data replication using Attunity from Application DBs into Amazon Redshift
•Take ownership of development, unit-testing and code migration
•Perform unit, Integration and System testing of the developed components
•Migrate components across development, test and production environments
•Provide Testing, Implementation and Production support
•Coordinate development and troubleshooting activities towards issue resolution in a fast-paced team environment.
•Demonstrated understanding of data warehouse design patterns such as dimensional modeling,
Logical data warehouse, data marts, data lakes, integrations and other components
SR. Application Software Developer- Redshift
CDM Smith Employment Type:
•Bachelor's Degree in computer science or equivalent.
•7 plus years of focused database development experience specifically with Amazon Redshift
•Demonstrate Knowledge of AWS architecture and experience in design, development and
performance tuning of Redshift
•Experience in successfully implementing Data Integration from on-premise databases to
•Strong hands-on experience in designing, developing and supporting Data Warehouse in Amazon
•Experience with PostgresSQL and ETL development and data mapping methodologies
•Experience with Data replication using Attunity into Amazon Redshift
•Strong understanding of database schemas and ability to interpret data models
•Experience with Java
•Basic understanding of UNIX/Linux operating systems and Shell scripting.
•Excellent analytical, troubleshooting and debugging skills
•Must be a team player
•Experience with ETL tools like Informatica or Talend or ODI is highly desirable
•Experience with data replication using Attunity a plus
•Analytics, Reporting & BigData exposure a plus
•Working experience in on-shore off-shore models in matrix organization structure
•Good to have exposure to SVN, ServieNow, release management, change management and productivity tools
•Experience and understanding of Oracle EBS R12 functionality in HRMS, Oracle Projects, Oracle Core Financials and P2P.
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
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: