Lead Database Engineer

K&K Global Talent Solutions Inc is an International recruiting agency that has been providing technical resources in the USA region since 1993. This position is with one of our clients in The USA, who is actively hiring candidates to expand their teams. Role: Lead Database Engineer (SQL/PLSQL) Employment type: Contract (Only for W2) Technology: SQL/PLSQL, IDMC, Location: Dallas, TX Job Description- Must Have • Expertise in database design and programming skills using SQL/PLSQL • Knowledge and experience of data modeling and data warehouse concepts • Minimum 5 years of hands-on development experience using any reporting tool which reads from very large data sets • Skilled in data analysis and data modeling • Working knowledge of software design patterns and architecture Nice To Have • Alation • IDMC (Informatica Cloud) Roles and Responsibilities • Analyze business and regulatory requirements and translate them into effective data models, SQL/PL/SQL logic, and reporting solutions • Design, propose, and implement scalable software solutions to support complex regulatory and business requirements • Develop and enhance database processes and functionalities that are prerequisites for regulatory reporting • Manage data housekeeping activities and data catalog maintenance using Alation • Drive continuous improvement of data lineage and metadata management through IDMC • Collaborate with ETL/Axiom developers and Testing team to drive solutions from development to prod deployment Must Have Technical Skills • Minimum 5 years of hands-on development experience using any reporting tool which reads from very large data sets • Expertise in database design and programming skills using SQL/PLSQL • Skilled in data analysis and data modeling • Knowledge and experience of data modeling and data warehouse concepts • Working knowledge of software design patterns and architecture Flex Skills / Nice to Have • Alation • IDMC Screening Questions • Please describe the largest volume of data that you have worked with • Please explain how you would address product or process performance issues Note: Applicants for employment in The USA should possess work authorization which does not require sponsorship by the employer for a visa.