*Hi,* *I have an urgent requirement with one of my clients. Please find the job details below and forward me your updated resume along with your contact details at [email protected] <[email protected]>.*
*JOB TITLE- ETL Talend Developer* *LOCATION-** Bronx, NY* *DURATION-6+ Months Contract* *MODE OF INTERVIEW: Phone and Skype* *REQUIREMENT: * *Feedback from last interview:* He started well but he couldn't answer practical questions in Talend or SQL . He couldn't answer questions on Talend components. Looks like he might have dome data modeling & ETL design experience but not a hardcore ETL development. He couldn't answer general ETL scenario questions too. We three felt the same way. *JD:* Our client is looking for a Senior ETL Developer role (TALEND) will work as a member of one of the EDW sprint delivery teams. This individual is responsible for closely working with team members in analyzing data feeds received from the business partners and data vendors, helping with data flow architect and other technical solution design, developing and enhancing ETL packages in Talend, SSIS and SQL stored procedures to integrate data into systems to best support customers and analytical activities. *Job Responsibilities: * •Lead technical discussions of ETL workflow design, review, performance tuning and troubleshooting, and provide solutions to Scrum team lead and product owner •Analyze data feed requirements received from the Business/IT Units, help in translating business requirements into technical design specifications and preparing high-level documentation for the database and ETL workflow design. •Develop SQL queries or use available data profiling applications to perform data analysis based on the business requirement and created data profiling report for data discovery. •Develop ETL sessions and packages to extract, transform and load data from source to target through multiple stages defined by the system architectures and mapping documents. •Apply pattern checks, business logics and integrate with other ETL workflows to handle data anomalies in the incoming data files and ensure data quality and accuracy in the target applications. •Implement referential integrities in the ETL sessions according to the logical model and data mapping. Ensure that data validation processes, error handling and logging are part of any ETL implementations. •Perform analysis of existing data flow processes and related stored procedures with emphasis on improving performance. •Support the creation of test plans, conduct unit test of ETL mappings, stored procedures, data validation scripts, assist with regression test to ensure data integrity within the entire data application systems. •Create deployment packages, specify job dependencies, participate deployment review meetings, and assist with code deployment in both QA and production environment. Provide post release production support as needed. •Develop SQL scripts to research data and create ad-hoc reports for business partners and provide technical support for internal business users * Technical Experience and Qualification* •Expert in Extraction, Transforming and Loading (ETL) data using Talend. If the resource has experience with Talend then multiple GUI based data integration applications such as Informatica, DataStage, and SSIS •Experience of creating mappings and workflows to extract and load data from relational databases, flat file sources, specific healthcare industry standard file formats, and legacy systems. •Experience in development, implementation, administration and support of ETL processes for large-scale data warehouses. •Knowledge of multi-dimensional model, experience of implementing slowly changing dimensions (SCD) and change data capture (CDC) procedures. •Experience of using lookups and handle multiple database connections, able to merge multiple source files/types to single target location •Experience in developing SQL/stored procedure, able to write DDL for tables, views and indexes, and know how to use triggers, functions to manipulate data. . •Experience in data validation, data cleansing, mining, build matching process and large product reference tables •5 year experience with SQL Server Database or other relational databases, including writing SQL, building tables, developing stored procedures. •3+ year development experience using SSIS, Informatica, DataStage, or other data integration software. Hands on experience with Talend, SQL Server and related BI applications, AWS or cloud based systems a plus • Agile experience is highly preferred. Regards, Lucy Technical Recruiter * (W) *: +1-248.565.4747-x-194* (F)* : +1-248.254.7211 Email id / Gtalk : [email protected] <[email protected]> Tekshapers Inc. – WMBE Firm 1441 E. Maple Rd, Suite # 301, Troy, MI 48083 *E-mail is the best way to reach me* Note: We are through tier-1 vendor. P Save trees. Print Only When Necessary *Disclaimer: If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at **[email protected]* <[email protected]>* and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience.* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
