Principal Database Developer

  • Lahore, Islamabad, Karachi, Pakistan
  • WFH Flexible
  • Full-time
  • Software Engineering
  • 1152

A FinTech product is experiencing explosive growth and is looking for a high caliber database and ETL developer to help build and maintain our data movement (ETL), visualization (reporting), and database development.
This role is with exciting Database Engineering team. This team of data engineers design, build, and maintain all data-related aspects of our products directly or through collaboration with other development teams. This work includes design, creation, and maintenance of Data Structures, Database Objects, ETL processes and reporting visualizations.  The primary technology runs on the Microsoft SQL Server 2022 stack.
In this role, you will collaborate with team members to design, create, and maintain Stored Procedures, ETL packages that are developed with SQL Server Integration Services. You will work independently and in small teams building SQL Server database objects and processes that support all of the FinTech products.


Qualifications:

  • Strong understanding of current Microsoft development technologies.
  • Strong English reading and writing communication skills, with an ability to express and understand complex technical concepts.
  • Strong analytical, problem-solving, and conceptual skills.
  • Ability to work in teams and strong interpersonal skills.
  • Ability to work under pressure and meet tight deadlines.
  • Possess good organizational skills.
  • Ability to anticipate potential problems and determine and implement solutions.


Education/Experience:

  • Relevant training in principles and techniques of database development and modeling.
  • Be familiar with systems concepts, design, and standards.
  • Provide expertise in software usage, functionality, performance, security, aesthetics, resilience, reuse, comprehensibility, and economic and technological trade-offs.
  • Bachelor's Degree in Software Engineering, Computer Science, or related discipline
  • A minimum of 5 years of experience as a Database Developer/Engineer
  • Experience working within an AGILE Scrum software development environment
  • Strong written and verbal interpersonal communication skills in the English language
  • Mastery of relational database concepts including but not limited to tables, keys, indexes, etc.
  • Five or more years of experience developing the full range of objects in Microsoft SQL 2016 (or better) databases using SQL and T-SQL
  • Four or more years of experience creating and maintaining ETL packages with SQL Server Integration Services (SSIS)
  • Ability to provide relevant experience with the following Microsoft data concepts:
  • SSIS: Parameters, variables, expressions, parallelism, data flow development, export and import feeds to either OLTP or OLAP systems
  • SSRS: Drill down, graphs, expressions, parameters, solution/project organization, data sets
  •  SQL/T-SQL: Can construct queries, DML and DDL statements that perform on large multi-terabyte databases.
  • Working knowledge of Snowflake cloud data warehouse and Sigma Computing the analytics platform is preferred
  • Two or more years collaborating with team members on SQL, T-SQL, SSIS, and SSRS performance tuning problems to resolution
  • Working knowledge of deployments utilizing Database Projects, MS-ISPACs and DACPACs preferred
  • Basic C# applied (non-academic) programming experience knowledge a plus
  • Familiarity or experience with Azure SQL, Azure Data Factory is a plus
  • Experience with version control, preferably GIT
  • Experience with work management tools such as Jira or Azure DevOps
  • Experienced with troubleshooting complex problems
  • Proficient in SDLC process and able to follow through the lifecycle of a process
     

We have an amazing team of 700+ individuals working on highly innovative enterprise projects & products. Our customer base includes Fortune 100 retail and CPG companies, leading store chains, fast-growth fintech, and multiple Silicon Valley startups.

What makes Confiz stand out is our focus on processes and culture. Confiz is ISO 9001:2015, 27001:2013 & 20000-1:2018 certified. We have a vibrant culture of learning via collaboration and making the workplace fun.

People who work with us work with cutting-edge technologies while contributing success to the company as well as to themselves. 

To know more about Confiz Limited, visit: https://www.linkedin.com/company/confiz-pakistan/