*Looking for a SQL Consultant (Python, AWS, Snowflake), Sumner, Washington* *– 6 Months.*
* Request ID* * Job Title* SQL Consultant (Python, AWS, Snowflake) * Location* Sumner, Washington * Duration* 6 Months * Job Description* Must Have Skills (Top 3 technical skills only) * • Python, AWS, SQL, Snowflake Detailed Job Description: • Requirements Gathering- understand the client and project requirements (both functional and non-functional) by studying the existing documentation and assimilating inputs from Business Analysts/SMEs and seeking clarifications, if any, to participate efficiently in the Development and Testing phases of the project • Understand the functional requirements and provide high level design solutions. • Review the Design Documents and create Design Specifications as per the high-level design, and create Unit Test Plans in order to develop / validate / maintain the application as per the requirements • Understand application architecture document and seek inputs from the architecture / design team to understand the overall architecture in order to provide deliverables that are in line with architectural requirements • Prepare impact analysis and estimation documents. • As-Is and To-Be process mapping –Understand the existing system and way the changes need to be implemented for To-be process. • Create data mapping documents by analyzing the flow of data that are spread across various applications. • Build the ETL code based on the design, validate whether client’s requirements are met and perform the unit testing. • User acceptance and system testing support planning; Status tracking and reporting; Project/Release planning and Implementation; Consulting and coordination with offshore team; Risk management; Production Defect Fixes • Architecture Review: o Understand the architectural requirements and document the understanding as Functional design documents o Review the understanding document with Architectural community o Prepare data flow analysis document for the AS-IS system and To-be system and get it reviewed by Architects o Ensure design guideline are followed for each of deliverables o Creation of data model and data mapping documents by doing various activity like Data profiling • Design Review: o Prepare Impact analysis document by analyzing the existing system and identifying the impact due to the change. o Prepare ETL design documents and Data flow document from source system to the data warehouse system and get it reviewed with Architectural community. o Identify the risks and call out the expectations during the review process. Document the key decisions made since they will drive the way the ETL code is written. • Implement relevant Software Development Life Cycle activities: o Understand the client and project requirements (both functional and non-functional) by studying the existing documentation and assimilating inputs from Business Analysts/SMEs and seeking clarifications, if any, to participate efficiently in the Development and Testing phases of the project. Participate in knowledge transfer session with development team o Create program specifications and unit test plans for software programs by studying functional and non-functional requirements and the application architecture document and converting the assigned functionalities into pseudo code/algorithms/test cases o Develop code using knowledge of relevant technology as per design specifications and document artifacts such as unit test scripts, etc. independently and support peers in identifying code defects and ensuring that the output is as per the given specifications and SLAs. · o Create the user documentation for programs assigned with guidance from supervisor using their knowledge of relevant technology, business requirements and understanding of the client application. o Perform testing - self and independent (Functional, Integration, System) - as per defined processes and guidelines to ensure accurate program output; identify and resolve defects, if any o Work on `Go Live` activities as per the Implementation plan and manage any issues related to functionalities, user interface, performance, etc. that may arise. o Participate in and prepare content for Knowledge Transfer sessions, document the understanding, take on Shadow Support. • Team co-ordination and Stakeholder Management: o Communicate interdependencies across multiple team within own area, drives convergence across these teams to ensure smooth functioning of the teams o Onsite-offshore co-ordination: Coordinate Offshore Team by providing daily updates on all Project tasks and impart knowledge thorough Documentation and Knowledge Transfer sessions. • Customer Relationship Management: o Anticipate customer needs and provide inputs for various solution o Analyze and constantly improve systems, processes and nature of service being provided to ensure customer delight o Bring unresolved issues with the client, understand stakeholder views and resolve the issues Minimum years of experience*: 7+ Interview Process (Is face to face required?): Yes (Video) Additional Sills: To work on requirements gathering and ETL solution build for various integrations using python and snowflake SQL. Coordination with client and offshore. To take up enhancement work on existing integrations. Best Wishes, Balu Garikapati | IT Recruiter| Email : [email protected]| ITBrainiac, Inc. | http://www.itbrainiac.com/ Direct : 609 353 5828|Fax: (609) 228-5321 Princeton Forrestal Village, 116 Village Blvd. Suite # 200, Princeton, NJ 08540 -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/android-developers/CACteqcOCs3MT_B5xtH3JHch8TW%2BgNytB4w1Y9%2BsXN0A5nDT6fw%40mail.gmail.com.
