What are the responsibilities and job description for the Informatica Powercentre, Data Warehouse, Microsoft SQL Server 2019 position at ETS LLC?
Job Details
Role name: | Technical Lead |
Role Description: | Overall Data Tech lead for the digital areaInvolve in design/write SQL queries, design and implement data integrations Work with architect and provide strategic solutionsDesign build mapping, session workflows and schedule their runs |
Competencies: | Informatica Powercentre, Data Warehouse, Microsoft SQL Server 2019 |
Experience (Years): | 10 & Above |
Essential Skills: | Extensive familiarity with data management principles includingo 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 Requiremento Understand basic concepts and functions of Informaticao Export, Import objects and manage schema objectso Design build Mapping, sessions workflows and schedule their runo Identify performance issues and recommend performance tuning approacho Identify failures in workflows due to data quality or constraint failures and suggest solutiono Strong SQL knowledge, which include read, understand queries and write new queries Development and QA Support o Worked in SDLC phase and high demand environmento Work closely with Quality Engineering Teams & Provide solutions.o Code version management and code synch process. |
Desirable Skills: | o Workload automationo Service Now and Change Management Processo Worked in Azure & AWS is a plus. |
Country: | United States |
Branch | City | Location: | Minneapolis Downtown, MN |
