ApTask
About Client:
The client provides information technology (IT) services, including business outsourcing, infrastructure technology, and application services. The application service offered by the company includes application development, maintenance, and support. The markets served by the company are financial services and insurance, healthcare, manufacturing, government, transportation, communications, and consumer and retail industries.
Salary Range: $120K-$130K/Annum
Job Description: As a part of data modelling and entitlements team, you will use the latest technology stack and will have an opportunity to develop and implement new solutions. Being responsible and accountable for gathering and delivery of functional and non-functional requirements in accordance with the Pershing-X standards and timeframe. Review existing business requirements and ensure they contain appropriate design, and architectural components support the deployment of projects. Key Responsibilities:
Design, implement and manage the SQL queries to be consumed by multiple stakeholders. Detect and resolve data quality and integrity issues in the dataset. Enhance or create new logical and physical data model to meet business needs, applying data modelling standards and naming conventions. Apply data modelling techniques to ensure development and implementation meets performance expectations. Test and debug the deliverable code to ensure they function correctly. Develop data mapping from existing systems to the new data structures. Experience in data migration using the industry standard tools. Experience in SQL tuning and optimization using explain plan and trace files. Partitioning and indexing strategy for optimal performance Must have a good verbal and written communication skill with strong interpersonal, analytical, and problem-solving abilities. Experience in understanding complex source system data structures preferably in Financial Services Ability to work with minimal guidance in a time critical environment. Work with business stakeholders and Agile scrum teams on design, definition, documentation, and implementation of features for new applications and data structure Skills for success:
5+ years of experience working in different database technologies Strong hands-on knowledge of SQL Apply data modelling techniques to ensure development and implementation meets performance expectations. Run query plans, query tuning and schema refinement. Help with database migrations and building database scripts Work with change and release management teams Experience with CI/CD and Liquibase is a plus Experience with cloud platforms (Snowflake) is a plus Requirements:
Strong analytical and problem-solving skills. A self-starter, independent thinker with ambition and passion Excellent inter-personal, communication, collaboration, and presentation skills Takes responsibility for continuous self-learning. Takes the lead and make decisions in critical times and tough circumstances. High level of integrity and honesty. Ensure deliverables are up to a quality standard at the end of each sprint.
About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com
Applicant Consent: By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or help@aptask.com. Message frequency may vary. Msg & data rates may apply.
Salary Range: $120K-$130K/Annum
Job Description: As a part of data modelling and entitlements team, you will use the latest technology stack and will have an opportunity to develop and implement new solutions. Being responsible and accountable for gathering and delivery of functional and non-functional requirements in accordance with the Pershing-X standards and timeframe. Review existing business requirements and ensure they contain appropriate design, and architectural components support the deployment of projects. Key Responsibilities:
Design, implement and manage the SQL queries to be consumed by multiple stakeholders. Detect and resolve data quality and integrity issues in the dataset. Enhance or create new logical and physical data model to meet business needs, applying data modelling standards and naming conventions. Apply data modelling techniques to ensure development and implementation meets performance expectations. Test and debug the deliverable code to ensure they function correctly. Develop data mapping from existing systems to the new data structures. Experience in data migration using the industry standard tools. Experience in SQL tuning and optimization using explain plan and trace files. Partitioning and indexing strategy for optimal performance Must have a good verbal and written communication skill with strong interpersonal, analytical, and problem-solving abilities. Experience in understanding complex source system data structures preferably in Financial Services Ability to work with minimal guidance in a time critical environment. Work with business stakeholders and Agile scrum teams on design, definition, documentation, and implementation of features for new applications and data structure Skills for success:
5+ years of experience working in different database technologies Strong hands-on knowledge of SQL Apply data modelling techniques to ensure development and implementation meets performance expectations. Run query plans, query tuning and schema refinement. Help with database migrations and building database scripts Work with change and release management teams Experience with CI/CD and Liquibase is a plus Experience with cloud platforms (Snowflake) is a plus Requirements:
Strong analytical and problem-solving skills. A self-starter, independent thinker with ambition and passion Excellent inter-personal, communication, collaboration, and presentation skills Takes responsibility for continuous self-learning. Takes the lead and make decisions in critical times and tough circumstances. High level of integrity and honesty. Ensure deliverables are up to a quality standard at the end of each sprint.
About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com
Applicant Consent: By submitting your application, you agree to ApTask's (www.aptask.com) Terms of Use and Privacy Policy, and provide your consent to receive SMS and voice call communications regarding employment opportunities that match your resume and qualifications. You understand that your personal information will be used solely for recruitment purposes and that you can withdraw your consent at any time by contacting us at 732-355-8000 or help@aptask.com. Message frequency may vary. Msg & data rates may apply.