Salary
💰 $96,200 - $144,560 per year
Tech Stack
ETLInformaticaJavaOracleSQLSSIS
About the role
- Administration and Monitoring : Administers data integration applications to ensure high availability of services. Monitors application capacity and executes growth plans.
- Development and Testing : Designs and implements ETL processes, including data capture, data quality, cleansing, testing and validation methods. Develops standards, policies, and procedures for data integration related activities.
- Upgrades : Provides technical support, performs testing, and implements upgrades for data integration applications.
- Support : Provides level 2 support for business questions related to data integration applications. Investigates critical production ETL issues/ problems.
- Team player : Works closely with other functional areas and overseas resources to accomplish team objectives.
- Technical leadership : Provides assistance and technical support to junior level developers. Participates in design and code reviews. Contributes to the technical, architectural and organizational improvements of the team.
Requirements
- Bachelor's Degree (or higher) in Computer Science or a related field
- 5+ years ETL experience with ETL tools ( Talend, Informatica, DataStage, Ab Initio, SSIS, Data Services)
- Experience in Talend data integration development & all basic Talend components ( Jobs, Joblets, Connections, Inputs, Outputs, Contexts, tMap, tSort, tDie, tWarn etc.)
- Experience with various mapping scenarios (database to database, file to database, database to file, rest services and web services etc.) & FTP usage
- Experience combining data from multiple sources into a single target destination system
- Experience creating complex data transformations and validations incorporating business logic
- Experience incorporating robust logging into Talend job development
- 3+ years of Java experience is a plus
- Excellent knowledge of Oracle SQL and MSSQL statements & corresponding Talend Components
- Knowledge in migration of Talend jobs across various environments ( DEV/TST/PRD)
- Strong verbal and written communication skills
- Demonstrated collaborative skills and ability to work well within a team
- Self-starter with the ability to manage larger projects without direct supervision.
- Able to balance multiple tasks and priorities within a fast-paced work environment
- Proficient in MS Office suite (Word, Excel, PowerPoint, Access, Visio) software
- Experience in HANA SQL statements & corresponding Talend Components is preferred
- Experience with source control ( Git ) is preferred
- Experience with generating & deploying jobs in Talend Administration Center
- Experience in Parameterization/Parallelization and performance optimization