RTM SQL Server 2000 Data Warehouse TechLead (Jobs in Worcester, MA)   Requirement id 85708 Job title Tech Lead Job location in Worcester, MA Skills required ETL Development, RTM, Data Integration, SQL Server 2000 Data Warehouse Open Date 21-Nov-2018 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Tech Lead: ETL Development, RTM, Data Integration, SQL Server 2000 Data Warehouse Start Date :01/01/2019 End Date :12/31/2017 Submission Deadline :01/01/2019 Description : we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA and for the people who work here. Job Duties Provide ETL Development expertise in relational database management concepts and data warehousing best practices and tools using Informatica Version 9.5x and above. Job includes adhering to ETL design standards, procedures and best practices in Informatica; transformations, mappings, sessions, workflows, implementing business rule as per requirement, building RTM, data model documentation and data integration strategy. Development of Source-to-Target mapping design specifications, data dictionaries, review database schemas Develop and test Extract, Transformation, and Loading (ETL) modules based on design specifications using Informatica Version 9.5x and above. Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed. This could be automated using mappings to parse code and report on exceptions. Performance tuning of Informatica mappings. Support development teams with troubleshooting issues.On Call Support as required during the week ends and off hours. Scheduling jobs through scheduling tool (i.e. IBM Maestro, Tivoli or Autosys or similar tools) for monthly and daily job cycles. Root Cause analysis for ETL job failures/Data issues raised by business. End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup. Mentor and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes. Service Now (or similar tools like JIRA, Remedy) ticket handling and problem ticket analysis. Required Skills 5+ years of experience with the following:- Strong experience in Informatica and ETL Strong database analysis skill using SQL / PLSQL / Stored Procedures / Views / Materialized Views. Oracle and SQL database hands-on experience. Should be proficient in writing stored procedures, good SQL Queries using Oracle. Proficient in building staging environments, Operational Data Stores (ODS) and Data Marts. Strong Unix shell scripting. Demonstrated skill and ability in the development of data warehouse projects/applications (Oracle & SQL Server) Strong analytical skills and eagerness to learn domain and functional aspects Excellent communication skills, both verbal and written Education and Certifications Bachelors degree in Technology or Engineering or equivalent combination of education and work experience.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 85708 while calling.   Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1),    ETL Development job openings in other states Jobs List Data Warehouse Architect 3 - 120756 - SP Create date: 31-Jul-2023 start date : 08/07/2023 End date : 08/06/2024 submission deadline : 8/4 at 10AM EST. client info : EICIM Note : * Interview Process: MS Teams with integrated audio and video required. Able to share screen if requested. * Duration: 1 Year with possible extension * Loc.... (This job is for - job Jobs in MI Lansing Architect - (in Lansing, MI)) Data Warehouse Developer III - 104749 Create date: 20-May-2022 start date:7/5/2022 End date:At least 1 Years from projected start date submission deadline:5/31/2022 at 4:00PM CST. client info: ETF Note: * Interview Process: 1-2 rounds via Microsoft Teams. Interview dates will be 6/6 - 6/7. * Duration: 1 year likely to extend. * Onsite .... (This job is for - CDC Jobs in WI Madison Developer - (in Madison, WI)) Scala Developer Create date: 25-Jan-2022 start date:As soon as possible End date:6 months (expected) submission deadline:1/31/2022 Description: Scala Developer – Remote and Direct Client Opportunity Key Skills: ETL, Scala, AWS The Role: The data engineer should be a techn.... (This job is for - Scala Jobs in NY Albany Developer - (in Albany, NY)) VEC - SQL Developers (663553) Create date: 23-Sep-2021 Start Date :10/4/2021 End Date :04/01/2022 Submission Deadline :09/29/2021 Client Info : VEC Note : * Agency Interview Type: Web Cam Interview Only Description : Pls note: For now, most of the team at VEC is working remotely, HOWEVER, the expectation will .... (This job is for - SQL Jobs in VA Richmond Developer - (in Richmond, VA)) Business Intel Architect III - 90984 - SP Create date: 17-Aug-2021 start date:9/6/2021 End date:06/30/2022 submission deadline:8/24/2021 4:00PM CST. client info: DOT Note: * Interview Process: Teams with video on - one hour interview * Duration: Thru 6/30/2022 - Possibility of extension * Local candidates or willing to relocate at the candid.... (This job is for - Tuning Data Warehousing Jobs in WI Madison Architect - (in Madison, WI))    ETL Development job openings in MA Jobs List Informatica Tech Lead - NTTJP00022779 Create date: 11-Jul-2019 start date:7/15/2019 End date:01/15/2020 submission deadline:7/12/2019 Description: we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our abi.... (This job is for - Jira Jobs in MA Massachusetts TechLead - (in Massachusetts, MA)) ETL Developer - 36745 Create date: 20-Jul-2018 Job Description : Position: ETL Developer Rate: Negotiable based on experience Duration: 6+ month contract to perm Position Description: The ideal candidate will come from a highly technical environment and have hands on ETL coding experience. The candidate should have the ability to communica.... (This job is for - job Jobs in MA Boston Developer - (in Boston, MA)) SOW-Technical Project Manager Create date: 26-Jul-2016 The Client is seeking a Technical Project Manager to oversee a multi person engagement team responsible for delivering enhancements to our current State Longitudinal Data System *Assist in the definition of project scope and objectives, involving all relevant stakeholders and ensuring technical feasibility *Perform risk management to mini.... (This job is for - Data Modeler Jobs in MA Malden Manager - (in Malden, MA)) (Tech Lead: ETL Development, RTM, Data Integration, SQL Server 2000 Data Warehouse in Worcester, MA)

Featured Jobs QoS Analyst (Jobs in Dauphin County, Pennsylvania) Team Work Written Consultant (Jobs in Nashville, Tennessee) ASP.Net&C# Typescript MS SQL Server Specialist (Jobs in Raleigh, North Caro Project Manager Interpersonal Expert (Jobs in Raleigh, North Carolina) ASP.Net Typescript Web Specialist (Jobs in Raleigh, North Carolina) Tableau Consultant (Jobs in Dauphin County, Pennsylvania) Middleware C++ Expert (Jobs in Raleigh, North Carolina) BRD RTM SCRUM Analyst (Jobs in Richmond, Virginia) Documentation TechLead (Jobs in Madison, Wisconsin) ITSM Interpersonal Consultant (Jobs in Madison, Wisconsin)