Must Have Technical/Functional Skills * Extensive familiarity with data management principles including o Have lead multiple projects, simultaneously. o Worked as Data Architect in OLTP & Datawarehouse systems. o Highly Proficient in SQL Server, Informatica, Oracle, Performance Tuning. o Design & Implemented Data Integrations and Service integrations. o Worked in multilayer/capability environments. o Worked with Multiple Scrum Teams simultaneously, providing solutions & organizing work. o Worked with Enterprise Architects and provide strategic solutions aligning with organizational road map. o Able to work with ASM & address any production issues that may come. o Should be able to design & code. o Work closely with Quality Engineering Teams & Provide solutions. o Worked closely with offshore & nearshore teams. o Implement Industry standard patterns. o Suggest and drive, implement best practices. o Focus on Data Driven Development. o Analyze Database models and Requirement o Understand basic concepts and functions of Informatica o Export, Import objects and manage schema objects o Design build Mapping, sessions workflows and schedule their run o Identify performance issues and recommend performance tuning approach o Identify failures in workflows due to data quality or constraint failures and suggest solution o Strong SQL knowledge, which include read, understand queries and write new queries * Development and QA Support - o Worked in SDLC phase and high demand environment o Work closely with Quality Engineering Teams & Provide solutions. o Code version management and code synch process. Roles & Responsibilities 1. Overall Tech lead for data services for the digital area 2. Help with design for data/service integration 3. Help with writing SQL queries, code version management and sync process, 4. Design build mapping, session workflows 5. QA/UAT/Implementation support 6. Performance tuning 7. Help with providing overall technical solution based on the requirement Generi c Managerial Skills, If any * Problem-solving skills - Strong problem solving skill, creative and technical problem-solvers, able to isolate and resolve database issues in real time to maintain access and data integrity * Communication skills o Respond to issues in timely manner, clearly elaborate problem and propose solution o Communicate with application teams, listen and respond to their queries and concerns Salary Range: $100,000 to $119,000 per year