Hi, Hope you are doing well.
I would like to check your interest & availability for below mention position. If you are interested kindly reply me back with your updated resume, contact details & best time to reach you. ETL Developer *USC or GC/EAD GC only* *Must do onsite interview* Bronx, NY 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. *Waiting for your response…* Unfeigned Regards, *Ravi Nigam* 978-558-4666 Ext. 101 r...@teknavigators.com *TekNavigators LLC* 100 Cummings Center, Suite 207 P, Beverly, MA 01915 DISCLAIMER: This message and any attachments are solely for the use of the individual or entity to which it is addressed and may contain information that is privileged or confidential. If you are not the intended recipient, any disclosure, use or distribution of the information contained herein is prohibited. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. You may reply and send an email with "Remove" in the subject line in order to discontinue communication. -- You received this message because you are subscribed to the Google Groups "SAP-UK" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-uk+unsubscr...@googlegroups.com. To post to this group, send email to sap-uk@googlegroups.com. Visit this group at https://groups.google.com/group/sap-uk. For more options, visit https://groups.google.com/d/optout.
