Hi , I hope you are doing well. I do have new requirement please gothrough it if you are comfortable send me updated resumes skum...@sagetl.com
Title: *Talend Developer* Location: *Bronx, NY* Duration: 6+ months contract to hire. MUST BE GC OR CITIZEN! *Interview:* Phone Screen, 1 Onsite (Face to Face) Interview.* Will consider hiring off a Skype. F2F may not be required for a great candidate.* *MUST HAVE: Talend, ETL, SSIS, and Data Warehouse experience.* 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. Thanks & Regards, Soni Kumari Technical Recruiter |Sage Group Consulting Inc 3400 Highway 35S, Suite #9 Hazlet NJ 07730 Phone : 732.767.0010 x 450 | Direct: 732-856-5824 Email : skum...@sagetl.com http://www.sageci.com -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
