Hi, I have an urgent requirement with one of my clients, details given below.
If you find yourself suitable for the position, please send me your latest updated resume along with contact details. Please include your employer details as well if any. * Job Title* - ETL Developer *Location* - NY-New York/Bronx *Duration* - 6 Months *MOI * - *Telephonic followed by Skype/Face-to-Face.* This 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, Ritesh Kumar Recruiter *RG Talent Inc* *39120 Argonaut way* *Suite # 157, Fremont CA 94538* Phone : 510-443-0757 x 111 Email : rit...@rgtalent.com URL : www.rgtalent.com *Disclaimer: The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not interested in receiving mails from us then please forward this mail with remove in the subject to rem...@rgtalent.com <rem...@rgtalent.com> .Sorry for any inconvenience. E-mails sent from or to RG Talent Inc may be subject to our monitoring and recording procedures.* Click To Unsubscribe <http://rtl.rgtalent.com/RTL-INTIME/vendorAction.po?mailType=CO&compId=2&common_email=rit...@rgtalent.com&requestFor=R> -- You received this message because you are subscribed to the Google Groups "International SAP Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to international-sap-projects+unsubscr...@googlegroups.com. To post to this group, send email to international-sap-projects@googlegroups.com. Visit this group at https://groups.google.com/group/international-sap-projects. For more options, visit https://groups.google.com/d/optout.
